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.