Tags: appears, application, database, deadlock, deadlocks, fromtime, locking, mysql, oracle, postgres, postgresql, pretty, record, sql, time
Record locking in deadlock
I have an application that uses Postgres 7.2.3. It appears to deadlock fromtime to time. I'm not absolutely sure that it deadlocks, but I'm pretty sure because all of a sudden all my updates block, and my postgres processes are all idle.
The strange thing is that my application never concurrently modifies any row (although it does modify multiple rows in the same table within a given transaction), so I don't know how this could happen, unless perhaps locking occurs on pages rather than rows. Can someone explain to me how/why my application could be deadlocking?
Thanks in advance.
Leave a comment...
- 0 Comments