Neil Best <nbest@xxxxxxxxxxxxxxx> writes: > Tom Lane-2 wrote: >> Hmm. It looks like psql could get into an infinite loop if the server >> failed to exit COPY IN mode for some reason, but it's not at all clear >> how that could happen (or what to do about it). What server version >> and what psql version is this? What does the server's log show? >> Can you provide a reproducible test case? > Maybe it is a networking issue after all. I also thought to check the > server logs and found this: > 2009-08-06 16:53:20 CDTERROR: invalid input syntax for integer: "68.84" > 2009-08-06 16:53:20 CDTCONTEXT: COPY gm4, line 411272, column gm4c: "68.84" > 2009-08-06 16:53:20 CDTSTATEMENT: COPY gm4 FROM STDIN CSV > 2009-08-06 16:53:20 CDTLOG: SSL renegotiation failure > 2009-08-06 16:53:20 CDTSTATEMENT: COPY gm4 FROM STDIN CSV > 2009-08-06 16:53:20 CDTLOG: SSL error: unexpected record > 2009-08-06 16:53:20 CDTSTATEMENT: COPY gm4 FROM STDIN CSV > 2009-08-06 16:53:20 CDTLOG: could not send data to client: Connection reset > by peer Hmm, so it looks like the connection dropped and libpq failed to recognize that, or maybe libpq was okay but psql needs to check a bit more carefully here. I'll take a look. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
