deadlock detected

ERROR: deadlock detected

This error is popping up in my PostgreSQL database server logs. It’s supposed to be pretty hard to get a deadlock, so we must have some good code out there. We have a routine that’s been hanging up lately that is the prime suspect, but it would be a job to find exactly why and where it’s deadlocking. The author has taken a stab at making it better, so maybe the error will go away and we won’t have to. Will I ever truly solve an error?

Get new posts in your inbox

One thought on “deadlock detected

  1. The code update seems to have fixed. Probably the prior code was trying to lock things that conflicted when run simultaneously, but I can only guess.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.