The following bug has been logged on the website: Bug reference: 6313 Logged by: Daniel Migowski Email address: dmigow...@ikoffice.de PostgreSQL version: 8.3.16 Operating system: Linux Description:
In my application I receive deadlocks from time to time, reported by an error message like this: ERROR: deadlock detected SQL Status:40P01 Detail:Process 30812 waits for ShareLock on transaction 278158200; blocked by process 2852. Process 2852 waits for ShareLock on transaction 278158159; blocked by process 30812. This is absolutely useless for me for the following reasons. I know which processes have participated in the deadlock, and one of them returns an error, abd I know which statement does the deadlock, but my "statement" contains of 20 single sql statements and I don't know which lock the processes where fighting over. Could you please add information about which lock could not be granted, and what other locks have already been in place (or at least, what other locks have participated in this deadlock detection)? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs