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

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
>