AnsweredAssumed Answered

Incoming email Concurrency Issue

Question asked by hardik1512 on Jul 10, 2017
Latest reply on Aug 17, 2017 by hardik1512

We are on Alfresco Enterprise version 4.2.4. We have one folder email alias for incoming emails to alfresco. We have lots of emails that comes this way into system.
Now the problem is that for some random case, email processing fails and produces below error. This only happens when at a same time there are many incoming emails from mail server to alfresco. So this seems to be some concurrency issue.

com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_alf_cass_cnode". The conflict occurred in database "alfresco424", table "dbo.alf_node", column 'id.

 

After analysis, it is been found this error occurs while creating child node.

After checking Alfresco code, they have written this operation in RetryingTransactionHelper. So why does not it retry?

 

How to check whether RetryingTransactionHelper is retrying or not?

 

Attaching full stack trace. Kindly assist.

Outcomes