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?

One response to “deadlock detected”

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.