topic Re: [Solved] Deadlocks when adding files in Alfresco Archive

[Solved] Deadlocks when adding files

dranakan — Mon, 10 Aug 2009 08:10:52 GMT

Hello,An action is able to add some files in Alfresco. All works good with MySql but I have some problems using Ingres DB 9.2. Sometimes Ingres find Deadlocks.The action try add add some files (it get some local PDF (in the alfresco temp), add some metadata and create in Alfresco). It can add 300 fi

Re: [Solved] Deadlocks when adding files

kazirahul — Mon, 10 Aug 2009 09:49:08 GMT

The code is in a transaction and a rollback is done if problem appears

Re: [Solved] Deadlocks when adding files

mrogers — Mon, 10 Aug 2009 11:23:49 GMT

Do you know the "database isolation level" being used for ingress?

Re: [Solved] Deadlocks when adding files

dranakan — Mon, 10 Aug 2009 14:31:13 GMT

Thanks for your reply mrogers,

The level specified in the config.dat of ingres is :


ii.localhost_localdomain.dbms.*.system_isolation: serializable‍‍

For the configuration of Ingres, I have used script configuration gived by Ingres : http://wiki.alfresco.com/wiki/Installing_Alfresco_Labs_3b_and_Ingres

Re: [Solved] Deadlocks when adding files

dranakan — Thu, 20 Aug 2009 09:29:20 GMT

Hello,

The Ingres support saved me…

A few tables of the Alfresco schema have the Hash storage structure. You have to reporganize it from time to time (depends on the grow rate) to eliminate overflow pages. Such overflow page chains may cause your locking problems. You can reorganize a hash table by using the MODIFY command. Further information can be found in the Ingres documentation.

Using this command (often) to do the reorganisation of all tables :


su - ingres
usermod alfresco
‍‍‍‍

(Perhaps doing it just for tables with Hash, and after doing optimizedb and sysmod)
You need some space to do this…