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@tpf.co.jp

Sun, 30 Jul 2000 10:35:47 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
another ? lock freezing