Re: SSL connection lost after long-lasting copy command - Mailing list pgsql-general

From Scott Marlowe
Subject Re: SSL connection lost after long-lasting copy command
Date
Msg-id dcc563d11002090928p42bcf685ofc1f7d5a5555f46e@mail.gmail.com
Whole thread Raw
In response to SSL connection lost after long-lasting copy command  (Seb <spluque@gmail.com>)
List pgsql-general
On Tue, Feb 9, 2010 at 10:03 AM, Seb <spluque@gmail.com> wrote:
> Hi,
>
> While copying a large'ish file (~ 7.6 million rows) into a table with:
>
> \copy [tablename] ([columns]) FROM '/path/to/large/file' NULL AS ''
>
> The command stopped running after a few minutes with the message:
>
> ---<--------------------cut here---------------start------------------->---
> server closed the connection unexpectedly
>        This probably means the server terminated abnormally
>        before or while processing the request.
> ---<--------------------cut here---------------end--------------------->---
>
> Checking /var/log/postgresql/postgresql-8.4-main.log, there's a long
> series of checkpoint_segments (only the last 2 shown) and an SSL error:
>
> ---<--------------------cut here---------------start------------------->---
> 2010-02-09 10:47:03 CST LOG:  checkpoints are occurring too frequently (6 seconds apart)
> 2010-02-09 10:47:03 CST HINT:  Consider increasing the configuration parameter "checkpoint_segments".
> 2010-02-09 10:47:10 CST LOG:  checkpoints are occurring too frequently (7 seconds apart)
> 2010-02-09 10:47:10 CST HINT:  Consider increasing the configuration parameter "checkpoint_segments".
> 2010-02-09 10:47:17 CST LOG:  SSL renegotiation failure
> 2010-02-09 10:47:17 CST LOG:  SSL renegotiation failure
> 2010-02-09 10:47:17 CST LOG:  SSL error: internal error
> 2010-02-09 10:47:17 CST LOG:  could not send data to client: Connection reset by peer
> 2010-02-09 10:47:17 CST LOG:  SSL error: internal error
> 2010-02-09 10:47:17 CST LOG:  could not receive data from client: Connection reset by peer
> 2010-02-09 10:47:17 CST LOG:  unexpected EOF on client connection
> ---<--------------------cut here---------------end--------------------->---
>
> Any pointers appreciated.  Thanks.

Are there any PANICs in the log before this?  Doesn't seem likely from
your description, but just wanted to be sure.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: viewing large queries in pg_stat_activity
Next
From: Seb
Date:
Subject: Re: SSL connection lost after long-lasting copy command