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?