Re: [GENERAL] Deadlock on the same select for update

2011-02-23 Thread Merlin Moncure
On Mon, Feb 21, 2011 at 7:16 AM, Roman wrote: > Hi, > I have problem with deadlocks and don't know why it happens. Below is > the log (postgres 9.0, debian): > > [11882]DETAIL:  Process 11882 waits for ShareLock on transaction > 44324308; blocked by process 11884. >        Process 11884 waits for

Re: [GENERAL] Deadlock on the same select for update

2011-02-21 Thread Bill Moran
In response to Roman : > Hi, > I have problem with deadlocks and don't know why it happens. Below is > the log (postgres 9.0, debian): > > [11882]DETAIL: Process 11882 waits for ShareLock on transaction > 44324308; blocked by process 11884. > Process 11884 waits for ShareLock on transact

[GENERAL] Deadlock on the same select for update

2011-02-21 Thread Roman
Hi, I have problem with deadlocks and don't know why it happens. Below is the log (postgres 9.0, debian): [11882]DETAIL: Process 11882 waits for ShareLock on transaction 44324308; blocked by process 11884. Process 11884 waits for ShareLock on transaction 44324307; blocked by process 11882