topic Constant deadlock with Oracle in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/constant-deadlock-with-oracle/m-p/248465#M201595 <HTML><HEAD></HEAD><BODY><SPAN>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 deadlocks. It is the only error in the log. </SPAN><BR /><BR /><SPAN>I've tried to find information in the forum but all the posts related to deadlocks that I've found do not apply here.</SPAN><BR /><BR /><SPAN>Can anyone throw a little bit of light?</SPAN><BR /><BR /><BR /><SPAN>The application is using Alfresco 3.2.0 r2 (2440). We have a known problem that the frontend accepts several name characters that are not accepted by Alfresco. After the document is uploaded to the server a process scheduled to run every few minutes sends the documents to a system and then uploads them to Alfresco. The process continues to upload the document with the invalid name until we find that an incorrect document name is used and manually correct it. </SPAN><BR /><BR /><SPAN>The most recent deadlock problem happened after trying to upload the document with the incorrect name repeatedly. This is the partial log </SPAN><A href="http://pastebin.com/8YBXtW7w" rel="nofollow noopener noreferrer">http://pastebin.com/8YBXtW7w</A><SPAN>.</SPAN><BR /><BR /><SPAN>Right before Alfresco stopped working the log showed the line:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>21:33:22,323 WARN&nbsp; [org.alfresco.repo.activities.feed.AbstractFeedGenerator] Still busy …<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>After that we restarted Alfresco and deadlocks popped everywhere. Here is the log </SPAN><A href="http://pastebin.com/5ZgzXtL6" rel="nofollow noopener noreferrer">http://pastebin.com/5ZgzXtL6</A><SPAN>.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Thu, 08 Nov 2012 15:52:36 GMT anxtr 2012-11-08T15:52:36Z 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