Hi all,
I found another(??) lock freezing phenomenon.
Seems I'm guilty for the bug.
session-1begin;lock table a in share mode;
session-2begin;lock table a;[blocked]
session-3begin;lock table a in share mode;[blocked]
session-2^CCancel request sentERROR: Query cancel requested while waiting lockabort;
session-1commit;
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