Re: \copy: unexpected response (4) - Mailing list pgsql-general

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.