From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | AI Rumman <rummandba(at)gmail(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: deadlock detected |
Date: | 2012-11-05 19:03:34 |
Message-ID: | 50980D86.7040203@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 05/11/12 18:39, AI Rumman wrote:
> Hi all,
>
> I am using Postrgesql 9.1
>
> I got a message in my log:
> ERROR: deadlock detected
> DETAIL: Process 20265 waits for ShareLock on transaction 27774015;
> blocked by process 20262.
> Process 20262 waits for ShareLock on transaction 27774018;
> blocked by process 20265.
> Process 20265: UPDATE t1 SET product_id = 1017966 WHERE
> ticketid = '2170501'
> Process 20262: UPDATE c1 SET deleted=1 WHERE id='2170501'
> HINT: See server log for query details.
> STATEMENT: UPDATE t1 SET product_id = 1017966 WHERE ticketid = '2170501'
>
> How may I get more information about this deadlock like which queries
> created it.
>
The error message shows which queries - your two UPDATEs. I'm guessing
either t1 or c1 are views and so refer to the same row with id "2710501".
--
Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Marti Raudsepp | 2012-11-05 19:31:34 | Re: [GENERAL] Error registering at postgresql.org |
Previous Message | Daniel Serodio (lists) | 2012-11-05 18:46:30 | Re: [GENERAL] Error registering at postgresql.org |