Skip site navigation (1) Skip section navigation (2)

Strange deadlock problem on simple concurrent SELECT/LOCK TABLE transactions

From: Tomasz Zielonka <tomek(at)mult(dot)i(dot)pl>
To: PostgreSQL bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Strange deadlock problem on simple concurrent SELECT/LOCK TABLE transactions
Date: 2001-08-24 16:19:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

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:

    id      INTEGER NOT NULL,
    amount  FLOAT   NOT NULL,
    PRIMARY KEY (id)

-- amount field is probably no longer necessary, but I haven't tested without
-- it

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'.
Freeze again.

What do you think?

Have a nice weekend :)

.signature: Too many levels of symbolic links


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-08-24 17:20:00
Subject: Bug #428: Another security issue with the JDBC driver.
Previous:From: Bruce MomjianDate: 2001-08-24 16:02:30
Subject: Re: Bug #424: JDBC driver security issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group