AnsweredAssumed Answered

HELP!: Repeated error messages 'Incorrect number of rows affected for updateLock'

Question asked by cheeven.tsai on May 28, 2015
Latest reply on May 31, 2015 by cheeven.tsai

I am setting up a few new Linux-based Alfresco CE servers, and this "Incorrect number of rows affected for updateLock" message pops up every few seconds in the server log (catalina.out).

May 28, 2015 9:56:00 AM org.alfresco.repo.transaction.RetryingTransactionHelper doInTransaction
INFO: Retrying DefaultScheduler_Worker-9: count  0; wait: 0.0s; msg: "Incorrect number of rows affected for updateLock: LockEntity[ ID=21, sharedResourceId=21, exclusiveResourceId=21]: expected 1, actual 0"; exception: (org.springframework.dao.ConcurrencyFailureException)

The server is set up on
* CentOS Linux
* Oracle JDK 8
* Apache Tomcat 7.0.59
* MySQL 5.6
* Alfresco CE 5.0.d

I have the following in /etc/my.cnf

innodb_locks_unsafe_for_binlog = 1

The server seems to work, and I can login to Share and upload files without a problem. However, the repeated error messages are making me mad because I don't know what they are and their impact to my servers.

Is there anything I need to update for Alfresco CE 5.0.d with MySQL?

Many thanks.

Cheeven Tsai