From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | another ? lock freezing |
Date: | 2000-07-30 01:35:47 |
Message-ID: | EKEJJICOHDIEMGPNIFIJOEDECDAA.Inoue@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
I found another(??) lock freezing phenomenon.
Seems I'm guilty for the bug.
session-1
begin;
lock table a in share mode;
session-2
begin;
lock table a;
[blocked]
session-3
begin;
lock table a in share mode;
[blocked]
session-2
^C
Cancel request sent
ERROR: Query cancel requested while waiting lock
abort;
session-1
commit;
Unfortunately LockReleaseAll() doesn't wake up session-3
and so session-3 is still blocked.
Either the cancel of session-2 or commit of session-1 must
wake up session-3. I would change the cancel request stuff
so that it can wake up sleeping processes.
Comments ?
Regards.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2000-07-30 01:38:33 | Off topic 'C' question |
Previous Message | Philip Warner | 2000-07-30 00:08:03 | Re: pg_dump + function/table hierarchy |