Re: \copy: unexpected response (4)

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:52:16 CDTCONTEXT: COPY gm1, line 415306, column gm1c: "743.5"
2009-08-06 16:52:16 CDTSTATEMENT: COPY gm1 FROM STDIN CSV
2009-08-06 16:52:51 CDTLOG: checkpoints are occurring too frequently (7
seconds apart)
2009-08-06 16:52:51 CDTHINT: Consider increasing the configuration
parameter "checkpoint_segments".
2009-08-06 16:53:02 CDTLOG: checkpoints are occurring too frequently (11
seconds apart)
2009-08-06 16:53:02 CDTHINT: Consider increasing the configuration
parameter "checkpoint_segments".
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
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 CDTLOG: could not receive data from client: Connection
reset by peer
2009-08-06 16:53:20 CDTLOG: incomplete message from client
2009-08-06 17:38:21 CDTLOG: could not receive data from client: Operation
timed out
2009-08-06 17:38:21 CDTLOG: unexpected EOF on client connection
(END)

As for the versions:

monthly=> select version();
version
--------------------------------------------------------------
PostgreSQL 8.3.7 on i386-apple-darwin9.6.0, compiled by GCC

$ psql --version
psql (PostgreSQL) 8.1.11

Could this mismatch cause the problem? I will find out if it's feasible to
copy my data to the server to rule out these client and network vagaries.
Should I be concerned abou the checkpoint messages? I haven't looked up
what those are all about yet.

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