Re: [BUGS] Error in backend/storage/lmgr/proc.c: ProcSleep()

2001-09-05 Thread Tomasz Zielonka
On Mon, Sep 03, 2001 at 07:56:08PM -0400, Tom Lane wrote: > Tomasz Zielonka <[EMAIL PROTECTED]> writes: > > Platform: PostgreSQL 7.1.3, Linux 2.4.8, egcs 2.91.66 > > PostgreSQL forgets to release lock until shutdown in this scenario: > > This seems to be a real bug, but I don't like your proposed

Re: [BUGS] Error in backend/storage/lmgr/proc.c: ProcSleep()

2001-09-03 Thread Tom Lane
Tomasz Zielonka <[EMAIL PROTECTED]> writes: > Platform: PostgreSQL 7.1.3, Linux 2.4.8, egcs 2.91.66 > PostgreSQL forgets to release lock until shutdown in this scenario: Good catch! This has been broken since 7.1 ... surprising that no one discovered the problem sooner. I think that rather than

Re: [BUGS] Error in backend/storage/lmgr/proc.c: ProcSleep()

2001-09-03 Thread Tom Lane
Tomasz Zielonka <[EMAIL PROTECTED]> writes: > Platform: PostgreSQL 7.1.3, Linux 2.4.8, egcs 2.91.66 > PostgreSQL forgets to release lock until shutdown in this scenario: This seems to be a real bug, but I don't like your proposed fix... the problem evidently is that some lock structure is not bei

[BUGS] Error in backend/storage/lmgr/proc.c: ProcSleep()

2001-09-03 Thread Tomasz Zielonka
Hi! Platform: PostgreSQL 7.1.3, Linux 2.4.8, egcs 2.91.66 PostgreSQL forgets to release lock until shutdown in this scenario: CREATE TABLE dummy (X integer); session1 session2 BEGIN; |