Re: Problems with 8.3

From: "Alex Turner" <armtuk(at)gmail(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problems with 8.3
Date: 2008-03-07 17:17:23
Message-ID: 33c6269f0803070917v4fceb7d1o4ed4968b048a9ec@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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(at)archonet(dot)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
> >
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-03-07 18:48:59 Re: Ask ctid
Previous Message Alex Turner 2008-03-07 16:50:41 Re: Problems with 8.3