Thread: Need help with org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
Need help with org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
From
Håkan Jacobsson
Date:
Hi, I´ve written a small JDBC-application. I´m quering a large table in a postgreSQL database (version 8.08 and I´m using the postgresql-8.1-407.jdbc3 driver). I need to update a lot of the rows in the table and I try to do this 'on-the-fly' - that is, I use one statement to select the rows and while looping over the ResultSet I use another one to update the row if needed. The updates are executing very slowly, which is due to the fact that the database server is slow. I keep getting this exception: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347) at se.puzzled.ip.InsertIPCountryToDatabase.updateCountryCodesInUclickUsingVector(InsertIPCountryToDatabase.java:239) at se.puzzled.updater.CountryDriver.main(CountryDriver.java:30) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source) at java.io.BufferedInputStream.read(Unknown Source) at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:256) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1163) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) ... 5 more Some updates execute correctly, but then the application crashes with the exception. I´ve seen other posts concerning this exception, but what I´d like is a way to prohibit the exception within my Java code - haven´t found any such solution in the posts that I´ve read. Any help would be very much appreciated!
Re: Need help with org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
From
Dave Cramer
Date:
The problem is that the connection is being dropped, or lost, or broken. Is there a firewall involved ? Dave On 9-Nov-06, at 8:12 AM, Håkan Jacobsson wrote: > Hi, > > I´ve written a small JDBC-application. > I´m quering a large table in a postgreSQL database (version 8.08 > and I´m using the postgresql-8.1-407.jdbc3 driver). I need to > update a lot of the rows in the table and I try to do this 'on-the- > fly' - that is, I use one statement to select the rows and while > looping over the ResultSet I use another one to update the row if > needed. > > The updates are executing very slowly, which is due to the fact > that the database server is slow. > I keep getting this exception: > > org.postgresql.util.PSQLException: An I/O error occured while > sending to the backend. > at org.postgresql.core.v3.QueryExecutorImpl.execute > (QueryExecutorImpl.java:214) > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute > (AbstractJdbc2Statement.java:452) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags > (AbstractJdbc2Statement.java:354) > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute > (AbstractJdbc2Statement.java:347) > at > se.puzzled.ip.InsertIPCountryToDatabase.updateCountryCodesInUclickUsin > gVector(InsertIPCountryToDatabase.java:239) > at se.puzzled.updater.CountryDriver.main(CountryDriver.java:30) > Caused by: java.net.SocketException: Connection reset > at java.net.SocketInputStream.read(Unknown Source) > at java.io.BufferedInputStream.fill(Unknown Source) > at java.io.BufferedInputStream.read(Unknown Source) > at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:256) > at org.postgresql.core.v3.QueryExecutorImpl.processResults > (QueryExecutorImpl.java:1163) > at org.postgresql.core.v3.QueryExecutorImpl.execute > (QueryExecutorImpl.java:188) > ... 5 more > > Some updates execute correctly, but then the application crashes > with the exception. > > I´ve seen other posts concerning this exception, but what I´d like > is a way to prohibit the > exception within my Java code - haven´t found any such solution in > the posts that I´ve read. > > Any help would be very much appreciated! > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >