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

Поиск
Список
Период
Сортировка
От RoopaHC
Тема org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
Дата
Msg-id 1340219083220-5713647.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
Список 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.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: njohny
Дата:
Сообщение: Re: OUT Parameter of type used defined object array obtained as null
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.