AnsweredAssumed Answered

clustering database table locks

Question asked by vinhqchu on Aug 13, 2009
Latest reply on Aug 14, 2009 by vinhqchu
Hello All,

I recently migrated to a cluster environment, and I've noticed my secondary server seems to lock tables causing the primary server to fail because it cannot process any transactions. Once I stop the secondary, everything is fine again. Below is the error I get:

09:15:10,552 ERROR [org.alfresco.smb.protocol] Closing session due to exception
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Caused by:
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

Any ideas how to fix this?

Thank you.

Outcomes