\copy: unexpected response (4)

From: Neil Best <nbest(at)ci(dot)uchicago(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: \copy: unexpected response (4)
Date: 2009-08-07 14:37:00
Message-ID: 24866027.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


I have set up a batch job that pipes a couple hundred of \copy commands to
psql. It starts out well enough, sprinkled with a few error messages that I
intend to circle back and clean up after batching all of the ALTER commands
that I need, but then:

\copy gm1 from export/month1-88/13m/GM1.dat csv
psql:copy.sql:6328161: ERROR: invalid input syntax for integer: "743.5"
CONTEXT: COPY gm1, line 415306, column gm1c: "743.5"
\copy gm2a from export/month1-88/13m/GM2A.dat csv
\copy gm2e from export/month1-88/13m/GM2E.dat csv
\copy gm3 from export/month1-88/13m/GM3.dat csv
\copy gm4 from export/month1-88/13m/GM4.dat csv
psql:copy.sql:8059525: \copy: unexpected response (4)
psql:copy.sql:8059525: \copy: unexpected response (4)
psql:copy.sql:8059525: \copy: unexpected response (4)
psql:copy.sql:8059525: \copy: unexpected response (4)
psql:copy.sql:8059525: \copy: unexpected response (4)
psql:copy.sql:8059525: \copy: unexpected response (4)
psql:copy.sql:8059525: \copy: unexpected response (4)
psql:copy.sql:8059525: \copy: unexpected response (4)
. . .

(I am echoing everything and interleaving stderr into a log file.)

That last message is repeated literally ad inifinitum -- I mean I found 300G
of them after leaving my job running overnight!

I tried a \copy on that last file by hand and simply got another 'invalid
input syntax' message.

Can anyone speculate on what might lead to this condition? At first I
thought it was a networking problem but doing what I could to minimize that
possibility had no effect. Maybe I need to use separate connections?

The only reference I could find to that error message was
http://doxygen.postgresql.org/bin_2psql_2copy_8h.html but I know absolutely
nil about the source code.

Thanks.

Neil

--
View this message in context: http://www.nabble.com/%5Ccopy%3A-unexpected-response-%284%29-tp24866027p24866027.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-08-07 15:49:53 Re: \copy: unexpected response (4)
Previous Message John 2009-08-07 14:36:32 Re: using the schema in postbooks

Browse pgsql-hackers by date

  From Date Subject
Next Message Kenneth Marshall 2009-08-07 14:49:41 Re: Fixing geometic calculation
Previous Message Tom Lane 2009-08-07 14:36:32 Re: include/commands/version.h is not used