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
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 |