topic Re: Constant deadlock with Oracle in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/constant-deadlock-with-oracle/m-p/248466#M201596 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>since I was similarily affected by this way back when one of our customers was still using 3.2.something, I know that there were a couple of indices missing in Oracle, which resulted in too many rows to be locked ending up in a deadlock. See </SPAN><A href="https://issues.alfresco.com/jira/browse/ALF-5165" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ALF-5165</A><SPAN> which is based on one of our ACTs at the time.</SPAN><BR /><BR /><SPAN>Consider upgrading to an up-to-date Alfresco release since 3.2 was quite a while ago and a lot of fixes have been included since then (e.g. another deadlock possibility </SPAN><A href="https://issues.alfresco.com/jira/browse/ALF-5663" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ALF-5663</A><SPAN>).</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Fri, 09 Nov 2012 16:43:02 GMT afaust 2012-11-09T16:43:02Z Constant deadlock with Oracle https://connect.hyland.com/t5/alfresco-archive/constant-deadlock-with-oracle/m-p/248465#M201595 We have an application that uses Alfresco Web Service CMIS API. At first we did not have many problems but currently every other day the production system's Alfresco stops working (does not check in documents, does not retrieve documents, etc) when we check the log we have a recurrent problem with d Thu, 08 Nov 2012 15:52:36 GMT https://connect.hyland.com/t5/alfresco-archive/constant-deadlock-with-oracle/m-p/248465#M201595 anxtr 2012-11-08T15:52:36Z Re: Constant deadlock with Oracle https://connect.hyland.com/t5/alfresco-archive/constant-deadlock-with-oracle/m-p/248466#M201596 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>since I was similarily affected by this way back when one of our customers was still using 3.2.something, I know that there were a couple of indices missing in Oracle, which resulted in too many rows to be locked ending up in a deadlock. See </SPAN><A href="https://issues.alfresco.com/jira/browse/ALF-5165" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ALF-5165</A><SPAN> which is based on one of our ACTs at the time.</SPAN><BR /><BR /><SPAN>Consider upgrading to an up-to-date Alfresco release since 3.2 was quite a while ago and a lot of fixes have been included since then (e.g. another deadlock possibility </SPAN><A href="https://issues.alfresco.com/jira/browse/ALF-5663" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ALF-5663</A><SPAN>).</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Fri, 09 Nov 2012 16:43:02 GMT https://connect.hyland.com/t5/alfresco-archive/constant-deadlock-with-oracle/m-p/248466#M201596 afaust 2012-11-09T16:43:02Z