Re: Problems with 8.3 - Mailing list pgsql-general

From Alex Turner
Subject Re: Problems with 8.3
Date
Msg-id 33c6269f0803070842t45a82f9di4add08410ea3e08c@mail.gmail.com
Whole thread Raw
In response to Re: Problems with 8.3  (Richard Huxton <dev@archonet.com>)
Responses Re: Problems with 8.3  (Richard Huxton <dev@archonet.com>)
List 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@archonet.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
>

pgsql-general by date:

Previous
From: "Anton Melser"
Date:
Subject: Re: shared_buffers and shmmax what are the max recommended values?
Next
From: Richard Huxton
Date:
Subject: Re: Problems with 8.3