| From: | AI Rumman <rummandba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | deadlock detected |
| Date: | 2012-11-05 18:39:36 |
| Message-ID: | CAGoODpffdgOf3vwOTKWCOeP370tzoJP+MY3zyCEGx8k+SZeHvw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2012-11-05 18:43:14 | Re: [GENERAL] Error registering at postgresql.org |
| Previous Message | Magnus Hagander | 2012-11-05 18:20:47 | Re: [GENERAL] Error registering at postgresql.org |