Re: Problems with 8.3 - Mailing list pgsql-general

From Alex Turner
Subject Re: Problems with 8.3
Date
Msg-id 33c6269f0803070917v4fceb7d1o4ed4968b048a9ec@mail.gmail.com
Whole thread Raw
In response to Re: Problems with 8.3  ("Alex Turner" <armtuk@gmail.com>)
Responses Re: Problems with 8.3  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
I didn't.  And after the reboot, I still see 8 new sockets stuck in
CLOSE_WAIT - I'm wondering if this is a hardware/kernel problem...

Alex

On Fri, Mar 7, 2008 at 11:50 AM, Alex Turner <armtuk@gmail.com> wrote:
> Nothin worth mentioning in /var/log/messages
>
>  The wierd thing I do see is there are a number of sockets in
>  CLOSE_WAIT when doing a netstat -an | grep 5432
>
>  I think maybe I'll just reboot and see if that fixes it.
>
>  Alex
>
>
>
>  On Fri, Mar 7, 2008 at 11:47 AM, Richard Huxton <dev@archonet.com> wrote:
>  > Alex Turner wrote:
>  >  > It was core dumping on the 5th of March, but it hasn't since.  It's
>  >  > just failing with the connection closed problem.  It seems to happen
>  >  > worst with queries that are going to do updates and with connections
>  >  > that are persistent between http requests...
>  >  >
>  >  > I downgraded to 8.2, but it hasn't made any difference :(
>  >
>  >  It seems odd that nothing is being logged.
>  >
>  >  Is there nothing in the system logs for the machine as a whole? You're
>  >  not running out of memory and PG is being killed? Even then, you'd
>  >  expect something to pop up in the logs.
>  >
>  >  --
>  >    Richard Huxton
>  >    Archonet Ltd
>  >
>

pgsql-general by date:

Previous
From: "Alex Turner"
Date:
Subject: Re: Problems with 8.3
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Ask ctid