Re: SSL connection lost after long-lasting copy command

On Tue, Feb 9, 2010 at 10:03 AM, Seb <spluque(at)gmail(dot)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.