Neil Best <nbest@ci.uchicago.edu> 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