Tridion Error – Stored Procedure Deadlock

Posted on Posted in Error Series, SDL Web (SDL Tridion)

[alert]I use the Error Series to track the solution to common issues that are easy to forget. They are as much for my memory as public consumption.[/alert]

Error:

A database error occurred while executing Stored Procedure “EDA_PUB_TRAN_UPDATE _PUBLISH_TRANSACTION”.
Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Cause:

The number of deployer/publisher processes specified in the Tridion Snap-in exceeds the number of CPU cores.

Solution:

Update Publisher Settings, deployer and rendering threads to be less than or equal to the number of processors available.

Leave a Reply

Your email address will not be published. Required fields are marked *