On Tue, Feb 9, 2010 at 10:03 AM, Seb <spluque@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
