|
Home > Archive > PostgreSQL JDBC > December 2005 > More about deadlock
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
More about deadlock
|
|
| Vit Timchishin 2005-12-06, 9:24 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Tom Lane 2005-12-06, 11:24 am |
| "Vit Timchishin" <tivv@gtech-ua.com> writes:
> Can anyone tell me what are this "transaction" locks, when they are taken and why do I have a deadlock
> here.
Foreign-key update deadlock maybe? If so, updating to 8.1 is probably
a good solution. Previous versions took exclusive row locks on
referenced rows, and so you could easily get a deadlock on those row
locks.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|