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 :( Alex On Fri, Mar 7, 2008 at 3:00 AM, Richard Huxton <dev@xxxxxxxxxxxx> wrote: > Alex Turner wrote: > > I had stored procs in C on 8.2 for months, and I moved them over to > > 8.3 when we upgraded. > > And re-compiled them, yes? > > > > The thing is that it's happening on a database > > that doesn't have the stored procs. It seems to be happening worst on > > a system that keeps connections open between requests. It's failing > > about half the time. > > Hmm - if it's individual backends dying, and not those with the C > functions then that should rule them out. I think that core dump will be > your quickest way of figuring this out. > > -- > 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
