Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Mike MascariDate: 2000-07-30 01:38:33
Subject: Off topic 'C' question
Previous:From: Philip WarnerDate: 2000-07-30 00:08:03
Subject: Re: pg_dump + function/table hierarchy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group