Skip site navigation (1) Skip section navigation (2)

Re: BUG #5804: Connection aborted after many queries.

From: Paul Davis <paul(dot)joseph(dot)davis(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5804: Connection aborted after many queries.
Date: 2010-12-29 16:06:07
Message-ID: AANLkTinTL909UdO8BqmcerOtSDC5K5R4cU-a39vJ0mqX@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Dec 29, 2010 at 10:58 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> "Paul J. Davis" <paul(dot)joseph(dot)davis(at)gmail(dot)com> wrote:
>
>> After running many queries (millions) a connection will report an
>> error that the server has unexpectedly closed the connection.
>
> What message are you getting?  (Copy/paste is a good thing.)
>
> What do you see in the server log at the time of failure?
>
> Are you using a connection pool?
>
> -Kevin
>

Doh, that was on my list of things to add but managed to forget.

The error message reported by the client:

DECLARE CURSOR failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

And this intriguing error in the server logs from around that time:

2010-12-28 18:40:02 EST LOG:  SSL renegotiation failure
2010-12-28 18:40:02 EST LOG:  SSL failed to send renegotiation request
2010-12-28 18:40:02 EST LOG:  SSL renegotiation failure
2010-12-28 18:40:02 EST LOG:  SSL error: unsafe legacy renegotiation disabled
2010-12-28 18:40:02 EST LOG:  could not send data to client:
Connection reset by peer
2010-12-28 18:40:02 EST LOG:  SSL error: unsafe legacy renegotiation disabled
2010-12-28 18:40:02 EST LOG:  could not receive data from client:
Connection reset by peer
2010-12-28 18:40:02 EST LOG:  unexpected EOF on client connection

Googling, I see something that suggests turning off SSL renegotiation
which I'll try next.

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-12-29 16:27:56
Subject: Re: BUG #5804: Connection aborted after many queries.
Previous:From: Maxim TurchinDate: 2010-12-29 16:00:59
Subject: BUG #5805: "not determine data type" for params in comments

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group