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

From: RoopaHC <roopa(dot)chandrasekharaiah(at)hp(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
Date: 2012-06-20 19:04:43
Message-ID: 1340219083220-5713647.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Hi all I am getting an error as following in my client application

org.postgresql.util.PSQLException: An I/O error occured while sending to the
backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)
at
com.hp.bto.bsmr.common.util.HibernateUtil.getManagementDBSession(HibernateUtil.java:152)
com.hp.bto.bsmr.collection.utils.PostCollectionJobListener.jobWasExecuted(PostCollectionJobListener.java:84)
at
org.quartz.core.QuartzScheduler.notifyJobListenersWasExecuted(QuartzScheduler.java:1881)
at
org.quartz.core.JobRunShell.notifyJobListenersComplete(JobRunShell.java:355)
at org.quartz.core.JobRunShell.run(JobRunShell.java:226)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.net.SocketException: Connection reset by peer: socket write
error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at org.postgresql.core.PGStream.flush(PGStream.java:508)
at
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1107)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:256)
... 14 more

I have the following C3P0 settings:

cpds = new ComboPooledDataSource();
cpds.setDriverClass(BSMRCommonConstant.POSTGRES_DRIVER);
cpds.setAcquireIncrement(5);
cpds.setBreakAfterAcquireFailure(true);
cpds.setAcquireRetryAttempts(20);
cpds.setMaxPoolSize(20);
cpds.setMaxIdleTime(60 * 10);
cpds.setTestConnectionOnCheckout(true);
cpds.setAcquireRetryDelay(3000);
cpds.setIdleConnectionTestPeriod(300);
cpds.setTestConnectionOnCheckout(true);

And in my postgres.conf file I havent modified any tcp parameters. . It is
all 0 ther.

Please let me know whats going wrong here. I am not able to see any errors
in postgress.log as well

--
View this message in context: http://postgresql.1045698.n5.nabble.com/org-postgresql-util-PSQLException-An-I-O-error-occured-while-sending-to-the-backend-tp5713647.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kevin Grittner 2012-06-20 19:25:10 Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
Previous Message njohny 2012-06-19 08:49:01 Re: OUT Parameter of type used defined object array obtained as null