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”
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.