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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-12-29 16:27:56 | Re: BUG #5804: Connection aborted after many queries. |
Previous Message | Maxim Turchin | 2010-12-29 16:00:59 | BUG #5805: "not determine data type" for params in comments |