cannot remove lock from HTAB

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема cannot remove lock from HTAB
Дата
Msg-id 410FC893.7080902@bigfoot.com
обсуждение исходный текст
Список 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-----



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jonathan Gardner
Дата:
Сообщение: Re: Open items
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Open items