Rahul Khandelwal wrote:
> I am facing 'org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend'
> error while performing jdbc batch insert in postgre sql database using proxool connection pool. This
> error is random, but once it starts to come, it comes very frequently.
> Both my database server and my jetty server are on same linux machine and the batch size is 1000, but
> changing batch size doesn't eliminate the error.
> I don't have much idea about firewall but I don't think it should be an issue on same machine.
>
> Setup details:-
> pgsql 9.3
> pg-jdbc driver - 9.3
> proxool for jdbc connection pooling
>
> Stack trace:-
[...]
> org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
[...]
> Caused by: java.net.SocketException: Socket closed
Could you look into the database server log to see if there is anything relevant?
Are you using SSL?
Yours,
Laurenz Albe