Re: An I/O error occured while sending to the backend. - Mailing list pgsql-jdbc

From Breno BF
Subject Re: An I/O error occured while sending to the backend.
Date
Msg-id k2qa21be61a1004060801y7cd3db8m3dc666bd39dca8b7@mail.gmail.com
Whole thread Raw
In response to Re: An I/O error occured while sending to the backend.  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: An I/O error occured while sending to the backend.  (Breno BF <brenobfernandes@bsd.com.br>)
Re: An I/O error occured while sending to the backend.  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-jdbc
Hi,

Craig, since I changed it to info, I could not see nothing in postgres logs when the problem occurs.

log_min_messages = info        
log_min_error_statement = info

should I change it to debug?

-B

2010/4/6 Craig Ringer <craig@postnewspapers.com.au>
Breno BF wrote:

> I am getting this error using glassfish and postgresql: " Caused by:
> org.postgresql.util.PSQLException: An I/O error occured while sending to
> the backend."

Further in the exception log, you'll see:

Caused by: java.net.SocketException: Socket closed

In other words, the pgsql backend has "hung up" on the client.  Most
likely the Pg backend terminated for some reason, which you should see
in the PostgreSQL logs.

> log_min_messages = error
> log_min_error_statement = error

Turn these down to at least 'info', restart PostgreSQL, and see if you
get anything informative in the logs.

--
Craig Ringer



--
- breno bf

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Statement.cancel() doesn't seem to work
Next
From: Breno BF
Date:
Subject: Re: An I/O error occured while sending to the backend.