cannot remove lock from HTAB

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-----

Browse pgsql-hackers by date

  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