Serious problem with my postgres

Started by Christopher Kings-Lynneover 23 years ago2 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

Hi guys,

After a crash and several restarts this morning, my postgres 7.2.1 is
running very oddly.

Every time you execute a query it basially takes forever. Some of them
actually do take forever. eg: "select * from users" just hangs forever. As
people use the site all available postgres slots are taken up by various
random queries until the max backends is reached. The requests cannot be
cancelled within psql, etc.

The processes are hanging in semwait or sbwait or biord states, but mostly
sbwait. Restarts don't help. Reboots don't help. There's nothing in the
logs. What the heck is going on?

Chris

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#1)
Re: Serious problem with my postgres

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:

After a crash and several restarts this morning, my postgres 7.2.1 is
running very oddly.
The processes are hanging in semwait or sbwait or biord states, but mostly
sbwait.

Some random poking around in google says that sbwait state is "waiting
for data to arrive at/drain from a socket buffer". Network problems,
perhaps?

regards, tom lane