Confluence Database Deadlock

[Leo B]

Hello, I have some users complaining because sometimes they are working on Confluence and they receive a message saying "service unavailable". Serching on the Confluence log, i notice that the users are having this exception: "Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim"

Does anyone knows if this may be the problem and how to resolve it?

Thanks in advance...

[Jeremy Largman · Accepted solution]

Check out the knowledge base articles:

http://confluence.atlassian.com/display/CONFKB/Troubleshooting+Deadlocks+in+Confluence

http://confluence.atlassian.com/label/CONFKB/deadlock

If it's hard to diagnose or none of those solutions work, comment back about what you find, or open a support ticket. Sometimes you have to hunt through logs and configuration files.