Re: Serious problem with my postgres - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Serious problem with my postgres
Date
Msg-id 7004.1030588573@sss.pgh.pa.us
Whole thread Raw
In response to Serious problem with my postgres  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: MemoryContextAlloc: invalid request size 1934906735