cancel
Showing results for 
Search instead for 
Did you mean: 

Constant deadlock with Oracle

anxtr
Champ in-the-making
Champ in-the-making
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.

I've tried to find information in the forum but all the posts related to deadlocks that I've found do not apply here.

Can anyone throw a little bit of light?


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.

The most recent deadlock problem happened after trying to upload the document with the incorrect name repeatedly. This is the partial log http://pastebin.com/8YBXtW7w.

Right before Alfresco stopped working the log showed the line:

21:33:22,323 WARN  [org.alfresco.repo.activities.feed.AbstractFeedGenerator] Still busy …

After that we restarted Alfresco and deadlocks popped everywhere. Here is the log http://pastebin.com/5ZgzXtL6.

Thanks.
1 REPLY 1

afaust
Legendary Innovator
Legendary Innovator
Hello,

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 https://issues.alfresco.com/jira/browse/ALF-5165 which is based on one of our ACTs at the time.

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 https://issues.alfresco.com/jira/browse/ALF-5663).

Regards
Axel
Getting started

Tags


Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.