Skip site navigation (1) Skip section navigation (2)

More about deadlock

From: "Vit Timchishin" <tivv(at)gtech-ua(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: More about deadlock
Date: 2005-12-06 12:20:50
Message-ID: 200512061420.000000EL@dev-null (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hello.

I've now got more details on my deadlock. Here is what I have at the time it occurs:
umh=# select * from pg_locks where transaction=1119237;
 relation | database | transaction |  pid  |     mode      | granted
----------+----------+-------------+-------+---------------+---------
          |          |     1119237 | 18880 | ShareLock     | f
          |          |     1119237 | 18404 | ExclusiveLock | t
(2 rows)

Can anyone tell me what are this "transaction" locks, when they are taken and why do I have a deadlock 
here.

С уважением,
Виталий Валериевич Тимчишин,
Технический Директор
ООО "Голден Технолоджис"
http://www.gtech-ua.com




Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2005-12-06 12:52:54
Subject: Re: Problem with 8.1 driver
Previous:From: Tea YuDate: 2005-12-06 10:45:21
Subject: Re: JDBC executeUpdate returns 0 for table partitioning rule insertion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group