From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | cannot remove lock from HTAB |
Date: | 2004-08-03 17:17:07 |
Message-ID: | 410FC893.7080902@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all,
I'm not able to reproduce it anymore but I seen this after a
deadlock detection involving a subtransaction:
ERROR: deadlock detected
DETAIL: Process 31330 waits for ShareLock on transaction 570; blocked by process 31328.
Process 31328 waits for ShareLock on transaction 572; blocked by process 31330.
regression=# abort;
WARNING: cannot remove lock from HTAB
ROLLBACK
I don't have any HTAB around!!
Basically this is what I did:
begin; begin;
update record 1; savepoint a;
~ update record 2;
update record 2;
~ update record 1;
~ <dead lock detected>
I hope that looking at the code is possible understand what the problem is
( if exists ).
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBD8iS7UpzwH2SGd4RAgjxAJ9Gv2vkTjsdVaMSL2+b3yAcJlR5EgCgzwOD
Owmr5zCfrhFE9eee0764p80=
=jstJ
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Gardner | 2004-08-03 17:18:50 | Re: Open items |
Previous Message | Joe Conway | 2004-08-03 16:51:40 | RFC: arrays with other than 1 as a dimension lower bound |