Horton

deadlock detected

AI Rumman <rummandba@gmail.com>

View thread View on postgr.es
From: AI Rumman <rummandba@gmail.com>
To: pgsql-general General <pgsql-general@postgresql.org>
Date: 2012-11-05T18:39:36Z
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.