Re: An I/O error occured while sending to the backend.

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