| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "sergey" <opium(at)ydk(dot)com(dot)ua> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4758: deadlock.c:944 |
| Date: | 2009-04-16 14:17:08 |
| Message-ID: | 16828.1239891428@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"sergey" <opium(at)ydk(dot)com(dot)ua> writes:
> ERROR: 40P01: deadlock detected
> DETAIL: Process 10237 waits for ShareLock on transaction 165664; blocked by
> process 10242.
> Process 10242 waits for ShareLock on transaction 165691; blocked by
> process 10237.
> Process 10237: UPDATE test SET y=1;
> Process 10242: UPDATE test SET y=1;
> HINT: See server log for query details.
> LOCATION: DeadLockReport, deadlock.c:944
This is not a bug. Your code is trying to update the same rows in
conflicting orders.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-04-16 14:22:34 | Re: BUG #4759: RETURNS TABLE not supported in pgAdmin |
| Previous Message | Tom Lane | 2009-04-16 13:54:29 | Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?) |