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

[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; |

Re: [BUGS] Re: Strange deadlock problem on simple concurrent SELECT/LOCK TABLE transactions

2001-08-25 Thread Tomasz Zielonka
On Fri, Aug 24, 2001 at 04:00:59PM -0400, Tom Lane wrote: > Tomasz Zielonka <[EMAIL PROTECTED]> writes: > > It DOESN'T happen in PostgreSQL 7.1beta3 > > It DOEShappen in PostgreSQL 7.1beta4 (but on a different machine) > > You shouldn't be using *any* be

[BUGS] Re: Strange deadlock problem on simple concurrent SELECT/LOCK TABLE transactions

2001-08-24 Thread Tomasz Zielonka
Hi! I forgot to add: It DOESN'T happen in PostgreSQL 7.1beta3 It DOEShappen in PostgreSQL 7.1beta4 (but on a different machine) Greetings, tom -- .signature: Too many levels of symbolic links ---(end of broadcast)--- TIP 3: if posting/readi

[BUGS] Strange deadlock problem on simple concurrent SELECT/LOCK TABLE transactions

2001-08-24 Thread Tomasz Zielonka
Hi! I'm using PostgreSQL 7.1.3 on Intel PIII, Linux 2.4.8, Slackware 8.0, compiled with egcs 2.91.66 (the same on 7.1.2 / 2.95.3). I'm encountering very strange deadlock situation. Strange, because after this deadlock occurs, even with no active postgres processes (postmaster only), when I conne