ERROR-org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.

From: Rahul Khandelwal <rahulnewai(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: ERROR-org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
Date: 2015-06-01 10:05:40
Message-ID: CAGveQru6MhVECDXQq0OsSqMz3ctVvqWgC8t12KoNMEcmq1h3fA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
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:-
unknown-ERROR-[JdbcExporter] Error while executing batch : Batch entry 0
insert into ldev
(array_serial,date_time,ldev,read_iops,write_iops,rand_iops,seq_iops,read_xfer,write_xfer,read_hit_pct,write_hit_pct,read_resp,write_resp,total_resp,rand_xfer,seq_xfer)
values (cast(get_SerialNo('48015') as integer),'2015-04-28 00:00:00.000000
+00:00:00',get_funcNameFromSignature('48015-00:00:CD'),3.1166666666666667,0.3833333333333333,(COALESCE(2.1166666666666667,0)+COALESCE(0.3833333333333333,0)),(COALESCE(1.0,0)+COALESCE(0.0,0)),convert_KBToMB(3078.483333333333),convert_KBToMB(6.383333333333334),100.0,NULL,convert_MiliSecToMicroSec(3.105),convert_MiliSecToMicroSec(0.2816666666666666),convert_MiliSecToMicroSec(3.386666666666666),convert_KBToMB(0.0),convert_KBToMB(0.0))
was aborted. Call getNextException to see the cause.
2015-06-01 06:06:37,436 [48015_vsp_LdevPerf_12387041536606161 9364]
unknown-ERROR-Batch Execute failed while inserting in database.
2015-06-01 06:06:37,436 [48015_vsp_LdevPerf_12387041536606161 9364]
unknown-ERROR-org.postgresql.util.PSQLException: An I/O error occurred
while sending to the backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:411)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2889)
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
at
org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$44f8dff2.executeBatch(<generated>)
at com.cs.core.tasks.export.JdbcExporter.a(JdbcExporter.java:393)
at com.cs.core.tasks.export.JdbcExporter.e(JdbcExporter.java:345)
at Aaaa_bf.c(BaseDataProcessor.java:137)
at Aaaa_bi.a(DataProcessManager.java:114)
at Aaaa_bi.b(DataProcessManager.java:29)
at Aaaa_op.b(TaskScheduler.java:255)
at Aaaa_ok.tj(TaskProcessInitiator.java:25)
at Aaaa_ok.call(TaskProcessInitiator.java:11)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.SocketException: Socket closed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:143)
at
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112)
at
org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71)
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:269)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1704)
at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1093)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
... 20 more

Please help me with this.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Albe Laurenz 2015-06-01 10:21:19 Re: ERROR-org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
Previous Message dmp 2015-05-30 19:50:15 Re: CallableStatement.getParameterMetaData() throws exception for valid {call ...} statement