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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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