SSL connection lost after long-lasting copy command

Поиск
Список
Период
Сортировка
От Seb
Тема SSL connection lost after long-lasting copy command
Дата
Msg-id 87pr4e735h.fsf@kolob.sebmags.homelinux.org
обсуждение исходный текст
Ответы Re: SSL connection lost after long-lasting copy command  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: SSL connection lost after long-lasting copy command  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: LIKE a set of pattern generated from a table
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: SSL connection lost after long-lasting copy command