Backend hanging..

From: "Mitch Vincent" <mvincent(at)cablespeed(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Backend hanging..
Date: 2001-08-17 16:59:00
Message-ID: 00e901c1273d$ebe2eb50$1251000a@mitch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello guys, I was workin on a project today when I noticed something really
strange starting to happen...

I see backends hanging in mid-query, never to return.. I've upped the debug
level to it's max and get nothing in the logs that indicate a problem. If I
stop and restart the postmaster then the problem goes away for a few
minutes, only to return...

Some other queries seem to go through fine, it seems to be centered around
the table 'customers' as it *seems* like an update against that table will
trigger the problem..

Here is what the processes look like -- what is it "waiting" on?

61795 p2 S 0:00.38 /usr/local/pgsql/bin/postmaster -o -F -D
/usr/local/pgsql/data -i (postgres)

61812 p2 S 0:00.58 postmaster: postgres brw [local] VACUUM waiting
(postgres)
61823 p2 I 0:01.18 postmaster: postgres brw 127.0.0.1 idle in
transaction (postgres)
61836 p2 S 0:01.03 postmaster: postgres brw 127.0.0.1 UPDATE waiting
(postgres)
61860 p2 S 0:00.99 postmaster: postgres brw 127.0.0.1 idle in
transaction waiting (postgres)
61880 p2 S 0:00.99 postmaster: postgres brw 127.0.0.1 idle in
transaction waiting (postgres)

I'm running this on a Dual PII400 and a Dual PII333 one with FreeBSD 4.2 and
one with 4.3 - Both running PG 7.1.2

Any ideas? Thanks!!

-Mitch

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2001-08-17 17:05:01 Re: Configuration of ODBC-driver
Previous Message Chris Mulcahy 2001-08-17 16:27:47 Postmaster not stopping