determine database and tables from deadlock

From: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: determine database and tables from deadlock
Date: 2011-05-30 07:45:30
Message-ID: 1306741530.2788.18.camel@machielr-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Everyone

Some of our databases have been experiencing a sudden spike in
deadlocks being detected.

as far as our knowledge is concerned, there have not been any new
code taken live and no changes from what are aware off.

The databases are running postgresql 8.1

From the log files I am able to get the following information:

2011-05-30 00:19:05 SAST ERROR: deadlock detected
2011-05-30 00:19:05 SAST DETAIL: Process 534 waits for ShareLock on
transaction 20417220; blocked by process 29184.
Process 29184 waits for ExclusiveLock on tuple (127,56) of
relation 1502070 of database 1502000; blocked by process 534.
2011-05-30 00:19:05 SAST STATEMENT: update Organisation set name=$1
where id=$2
2011-05-30 00:19:06 SAST ERROR: deadlock detected
2011-05-30 00:19:06 SAST DETAIL: Process 29389 waits for ShareLock on
transaction 20417220; blocked by process 29184.
Process 29184 waits for ExclusiveLock on tuple (127,56) of
relation 1502070 of database 1502000; blocked by process 29389.
2011-05-30 00:19:06 SAST STATEMENT: update Organisation set name=$1
where id=$2

I am however not sure how to trace these back to a database, table,
and maybe even a query to determine where things are going wrong.

I tried to look through the system tables however I can't seem to
find the database (1502000) or the relation mentioned here, however, I
am sure I am not looking in the right places as I do not know Postgresql
that well.

I would really appreciate help on this as allt he deadlocks seems to
be happening on the same database and relation, just different tuples
and process id's.

Regards
Machiel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Asia 2011-05-30 07:58:20 Universal certificate for verify-full ssl connection
Previous Message Enrico Weigelt 2011-05-30 07:39:50 Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way?