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