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 16:42:35
Message-ID: 33c6269f0803070842t45a82f9di4add08410ea3e08c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)archonet(dot)com> 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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-03-07 16:47:52 Re: Problems with 8.3
Previous Message Tyler Erickson 2008-03-07 16:32:41 Re: request feature: alter view add column (or something like)