On our tridion server, we see publish failures occur randomly. The error is always something like this
Phase: Deployment Prepare Commit Phase failed,
Unable to prepare transaction: tcm:0-822659-66560, org.hibernate.exception.LockAcquisitionException:
could not load an entity:
[com.tridion.storage.ComponentMeta#component[publicationId,itemId]{publicationId=39, itemId=93357}],
org.hibernate.exception.LockAcquisitionException:
could not load an entity:
[com.tridion.storage.ComponentMeta#component[publicationId,itemId]{publicationId=39, itemId=93357}],
Unable to prepare transaction: tcm:0-822659-66560,
...
This error appears randomly - this means that at some point, we can publish a component or page, and get the error, and a few minutes after, we can publish the same component or page successfully.
Anyone has any ideas or pointers where to look to fix this issue ?
The broker database is an sql server 2008 db, tridion version is 2011 HR1 SP1