Tags: appears, application, database, deadlock, deadlocks, fromtime, locking, mysql, oracle, postgres, postgresql, pretty, record, sql, time

Record locking in deadlock

On Database » PostgreSQL

620 words with 0 Comments; publish: Sun, 30 Dec 2007 23:30:00 GMT; (25046.88, « »)

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.

Robert Wille

All Comments

Leave a comment...