another ? lock freezing

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

Browse pgsql-hackers by date

  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