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@xxxxxxxxx> 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@xxxxxxxxxxxx> 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 > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
