SSL connection lost after long-lasting copy command

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SSL connection lost after long-lasting copy command
Date: 2010-02-09 17:03:06
Message-ID: 87pr4e735h.fsf@kolob.sebmags.homelinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Seb

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-02-09 17:18:01 Re: SSL connection lost after long-lasting copy command
Previous Message Ivan Sergio Borgonovo 2010-02-09 17:01:25 LIKE a set of pattern generated from a table