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 connect with psql I can't select anything from affected table.
Here is a (almost) minimal test:
CREATE TABLE items (
id INTEGER NOT NULL,
amount FLOAT NOT NULL,
PRIMARY KEY (id)
-- amount field is probably no longer necessary, but I haven't tested without
And run this in TWO concurrent sessions:
$ yes 'begin; select * from items; lock table items; commit;' | psql
I get deadlock here quite fast.
Both processes freeze on next select.
Stop them (ctrl-c).
ps xa shows only postmaster process, no postgres ones.
Now connect which psql and try to 'SELECT * FROM items'.
What do you think?
Have a nice weekend :)
.signature: Too many levels of symbolic links
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2001-08-24 17:20:00|
|Subject: Bug #428: Another security issue with the JDBC driver.|
|Previous:||From: Bruce Momjian||Date: 2001-08-24 16:02:30|
|Subject: Re: Bug #424: JDBC driver security issue.|