Re: invalid message format and I/O error while comunicating with backend - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: invalid message format and I/O error while comunicating with backend
Date
Msg-id 47FCBA0C.9050407@postnewspapers.com.au
Whole thread Raw
In response to invalid message format and I/O error while comunicating with backend  (Sergi Vera <svera@emovilia.com>)
Responses Re: invalid message format and I/O error while comunicating with backend  (Sergi Vera <svera@emovilia.com>)
List pgsql-jdbc
Sergi Vera wrote:

> Everything is working ok and fast, but at some moment (sometimes sooner,
> sometimes later) the server starts to fail with the following messages
>
> org.postgresql.util.PSQLException: invalid message format (for the first
> failure)
> org.postgresql.util.PSQLException: A I/O error has happened while
> sending to backend (at every following jdbc call)

I suggest having a look in the server logs to see if there is any error
being reported by the backend.

You might also find it helpful to enable log_statement and
log_connection in postgresql.conf while you're trying to track the issue
down. Your logs might get quite big if your load is high, though.

--
Craig Ringer

pgsql-jdbc by date:

Previous
From: Sergi Vera
Date:
Subject: invalid message format and I/O error while comunicating with backend
Next
From: Art Gramlich
Date:
Subject: Patch to add a socketTimeout property.