From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'Rahul Khandelwal *EXTERN*'" <rahulnewai(at)gmail(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: ERROR-org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend. |
Date: | 2015-06-01 10:21:19 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B36618DC1@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alexis Meneses | 2015-06-01 21:18:44 | Re: BUG on postgresql-9.4-1201-jdbc41 ... |
Previous Message | Rahul Khandelwal | 2015-06-01 10:05:40 | ERROR-org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend. |