Thread: Serious problem with my postgres

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

"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