Обсуждение: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
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.
Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
От
"Kevin Grittner"
Дата:
RoopaHC <roopa.chandrasekharaiah@hp.com> wrote: > An I/O error occured while sending to the backend. > Caused by: Connection reset by peer: socket write error > I am not able to see any errors in postgress.log as well If there is nothing in the log, it is likely to be a network or firewall problem. -Kevin
Or as someone pointed out a gentoo specific problem Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Wed, Jun 20, 2012 at 3:25 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote: > RoopaHC <roopa.chandrasekharaiah@hp.com> wrote: > >> An I/O error occured while sending to the backend. > >> Caused by: Connection reset by peer: socket write error > >> I am not able to see any errors in postgress.log as well > > If there is nothing in the log, it is likely to be a network or > firewall problem. > > -Kevin > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc
Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
От
"Chandrasekharaiah, Roopa Hiremath"
Дата:
Thanks Dave Cramer and Kevin. I am using windows OS. firewall is on. What setting I should be doing in firewall to avoidthis? Please reply -----Original Message----- From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer Sent: Thursday, June 21, 2012 2:07 AM To: Kevin Grittner Cc: Chandrasekharaiah, Roopa Hiremath; pgsql-jdbc@postgresql.org Subject: Re: [JDBC] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. Or as someone pointed out a gentoo specific problem Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Wed, Jun 20, 2012 at 3:25 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote: > RoopaHC <roopa.chandrasekharaiah@hp.com> wrote: > >> An I/O error occured while sending to the backend. > >> Caused by: Connection reset by peer: socket write error > >> I am not able to see any errors in postgress.log as well > > If there is nothing in the log, it is likely to be a network or > firewall problem. > > -Kevin > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc
Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
От
"Chandrasekharaiah, Roopa Hiremath"
Дата:
And also PostgreSQL is installed in the same machine in which I am running my application -----Original Message----- From: Chandrasekharaiah, Roopa Hiremath Sent: Thursday, June 21, 2012 9:32 AM To: 'Dave Cramer'; Kevin Grittner Cc: pgsql-jdbc@postgresql.org Subject: RE: [JDBC] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. Thanks Dave Cramer and Kevin. I am using windows OS. firewall is on. What setting I should be doing in firewall to avoidthis? Please reply -----Original Message----- From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer Sent: Thursday, June 21, 2012 2:07 AM To: Kevin Grittner Cc: Chandrasekharaiah, Roopa Hiremath; pgsql-jdbc@postgresql.org Subject: Re: [JDBC] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. Or as someone pointed out a gentoo specific problem Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Wed, Jun 20, 2012 at 3:25 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote: > RoopaHC <roopa.chandrasekharaiah@hp.com> wrote: > >> An I/O error occured while sending to the backend. > >> Caused by: Connection reset by peer: socket write error > >> I am not able to see any errors in postgress.log as well > > If there is nothing in the log, it is likely to be a network or > firewall problem. > > -Kevin > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc
Well .... I'm hopelessly lost on windows, but as a first attempt can you turn it off and see if the problem goes away ? If it does then I'd suggest making sure port 5432 is completely open. But again remember I have no clue how a firewall on windows works. FWIW, deploying postgresql on windows is not really recommended. Yes postgresql works on windows but the full potential is not realized . Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Thu, Jun 21, 2012 at 12:18 AM, Chandrasekharaiah, Roopa Hiremath <roopa.chandrasekharaiah@hp.com> wrote: > And also PostgreSQL is installed in the same machine in which I am running my application > > -----Original Message----- > From: Chandrasekharaiah, Roopa Hiremath > Sent: Thursday, June 21, 2012 9:32 AM > To: 'Dave Cramer'; Kevin Grittner > Cc: pgsql-jdbc@postgresql.org > Subject: RE: [JDBC] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. > > Thanks Dave Cramer and Kevin. I am using windows OS. firewall is on. What setting I should be doing in firewall to avoidthis? Please reply > > -----Original Message----- > From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer > Sent: Thursday, June 21, 2012 2:07 AM > To: Kevin Grittner > Cc: Chandrasekharaiah, Roopa Hiremath; pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. > > Or as someone pointed out a gentoo specific problem > > Dave Cramer > > dave.cramer(at)credativ(dot)ca > http://www.credativ.ca > > > On Wed, Jun 20, 2012 at 3:25 PM, Kevin Grittner > <Kevin.Grittner@wicourts.gov> wrote: >> RoopaHC <roopa.chandrasekharaiah@hp.com> wrote: >> >>> An I/O error occured while sending to the backend. >> >>> Caused by: Connection reset by peer: socket write error >> >>> I am not able to see any errors in postgress.log as well >> >> If there is nothing in the log, it is likely to be a network or >> firewall problem. >> >> -Kevin >> >> -- >> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-jdbc