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

From: Kiran Kulkarni <kkiran_kulkarni(at)yahoo(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend
Date: 2012-06-27 22:15:52
Message-ID: 1340835352.64379.YahooMailNeo@web161405.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I am getting this error couple of time in a day. How do I avoid it?

Before making the call, I am checking these below things.
session.isDirty: false
session.isOpen: true
session.isConnected: true
session.getStatistics: SessionStatistics[entity count=0collection count=0]

connManager.isCurrentlyConnected(): true
connManager.hasBorrowedConnection(): false

But even after this check i am getting this error. Pls help.

---------------------------------------------------------------

2012-06-27 12:48:17,957 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) session.isDirty: false
2012-06-27 12:48:17,957 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) session.isOpen: true
2012-06-27 12:48:17,957 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) session.isConnected: true
2012-06-27 12:48:17,957 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) session.getStatistics: SessionStatistics[entity count=0collection count=0]
2012-06-27 12:48:17,957 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) 
2012-06-27 12:48:17,957 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) connManager.isCurrentlyConnected(): true
2012-06-27 12:48:17,957 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) connManager.hasBorrowedConnection(): false
2012-06-27 12:48:17,957 DEBUG [org.hibernate.jdbc.ConnectionManager] (TimerForFileReading) opening JDBC connection
2012-06-27 12:48:17,957 DEBUG [org.hibernate.jdbc.ConnectionManager] (TimerForFileReading) opening JDBC connection
2012-06-27 12:48:17,957 TRACE [org.hibernate.connection.DriverManagerConnectionProvider] (TimerForFileReading) total checked-out connections: 0
2012-06-27 12:48:17,957 TRACE [org.hibernate.connection.DriverManagerConnectionProvider] (TimerForFileReading) total checked-out connections: 0
2012-06-27 12:48:17,958 TRACE [org.hibernate.connection.DriverManagerConnectionProvider] (TimerForFileReading) using pooled JDBC connection, pool size: 0
2012-06-27 12:48:17,958 TRACE [org.hibernate.connection.DriverManagerConnectionProvider] (TimerForFileReading) using pooled JDBC connection, pool size: 0
2012-06-27 12:48:17,958 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) connManager.getConnection(): org(dot)postgresql(dot)jdbc3(dot)Jdbc3Connection(at)57005f31
2012-06-27 12:48:17,958 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) conn.isClosed(): false
2012-06-27 12:48:17,958 DEBUG [org.hibernate.transaction.JDBCTransaction] (TimerForFileReading) begin
2012-06-27 12:48:17,958 DEBUG [org.hibernate.transaction.JDBCTransaction] (TimerForFileReading) begin
2012-06-27 12:48:17,958 DEBUG [org.hibernate.transaction.JDBCTransaction] (TimerForFileReading) current autocommit status: false
2012-06-27 12:48:17,958 DEBUG [org.hibernate.transaction.JDBCTransaction] (TimerForFileReading) current autocommit status: false
2012-06-27 12:48:17,958 TRACE [org.hibernate.jdbc.JDBCContext] (TimerForFileReading) after transaction begin
2012-06-27 12:48:17,958 TRACE [org.hibernate.jdbc.JDBCContext] (TimerForFileReading) after transaction begin
2012-06-27 12:48:17,958 TRACE [org.hibernate.engine.query.QueryPlanCache] (TimerForFileReading) located native-sql query plan in cache (select count(*) from bbbb_deployment_location)
2012-06-27 12:48:17,958 TRACE [org.hibernate.engine.query.QueryPlanCache] (TimerForFileReading) located native-sql query plan in cache (select count(*) from bbbb_deployment_location)
2012-06-27 12:48:17,958 TRACE [org.hibernate.impl.SessionImpl] (TimerForFileReading) SQL query: select count(*) from bbbb_deployment_location
2012-06-27 12:48:17,958 TRACE [org.hibernate.impl.SessionImpl] (TimerForFileReading) SQL query: select count(*) from bbbb_deployment_location
2012-06-27 12:48:17,958 DEBUG [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2012-06-27 12:48:17,958 DEBUG [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2012-06-27 12:48:17,958 DEBUG [org.hibernate.SQL] (TimerForFileReading) select count(*) from bbbb_deployment_location
2012-06-27 12:48:17,958 DEBUG [org.hibernate.SQL] (TimerForFileReading) select count(*) from bbbb_deployment_location
2012-06-27 12:48:17,958 TRACE [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) preparing statement
2012-06-27 12:48:17,958 TRACE [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) preparing statement
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.958 (2) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)6b443d9, maxRows=0, fetchSize=0, flags=1
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.959 (2)  FE=> Bind(stmt=S_1,portal=null)
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.959 (2)  FE=> Execute(portal=null,limit=0)
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.959 (2)  FE=> Parse(stmt=null,query="select count(*) from bbbb_deployment_location",oids={})
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.959 (2)  FE=> Bind(stmt=null,portal=null)
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.959 (2)  FE=> Describe(portal=null)
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.959 (2)  FE=> Execute(portal=null,limit=0)
2012-06-27 12:48:17,959 INFO  [STDOUT] (TimerForFileReading) 12:48:17.959 (2)  FE=> Sync
2012-06-27 13:03:43,626 INFO  [STDOUT] (TimerForFileReading) 13:03:43.626 (2)  FE=> Terminate
2012-06-27 13:03:43,626 INFO  [STDOUT] (TimerForFileReading) 13:03:43.626 (2) Discarding IOException on close:
2012-06-27 13:03:43,626 INFO  [STDOUT] (TimerForFileReading) java.net.SocketException: Broken pipe
2012-06-27 13:03:43,626 INFO  [STDOUT] (TimerForFileReading) at java.net.SocketOutputStream.socketWrite0(Native Method)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.core.PGStream.flush(PGStream.java:508)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.core.v3.ProtocolConnectionImpl.close(ProtocolConnectionImpl.java:137)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:282)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:209)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.getResultSet(Loader.java:1811)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.doQuery(Loader.java:696)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.doList(Loader.java:2233)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2130)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.list(Loader.java:2125)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1724)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.testSession(RdbConnectionFactory.java:153)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.getSession(RdbConnectionFactory.java:100)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.scheduler.TimerForFileReading.updateDB(TimerForFileReading.java:103)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.scheduler.TimerForFileReading$1.run(TimerForFileReading.java:91)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at java.util.TimerThread.mainLoop(Timer.java:512)
2012-06-27 13:03:43,627 INFO  [STDOUT] (TimerForFileReading) at java.util.TimerThread.run(Timer.java:462)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:209)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.getResultSet(Loader.java:1811)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.doQuery(Loader.java:696)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.doList(Loader.java:2233)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2130)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.Loader.list(Loader.java:2125)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1724)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.testSession(RdbConnectionFactory.java:153)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.getSession(RdbConnectionFactory.java:100)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.scheduler.TimerForFileReading.updateDB(TimerForFileReading.java:103)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at com.aaaa.bbbb.scheduler.TimerForFileReading$1.run(TimerForFileReading.java:91)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at java.util.TimerThread.mainLoop(Timer.java:512)
2012-06-27 13:03:43,628 INFO  [STDOUT] (TimerForFileReading) at java.util.TimerThread.run(Timer.java:462)
2012-06-27 13:03:43,629 INFO  [STDOUT] (TimerForFileReading) SQLException: SQLState(08006)
2012-06-27 13:03:43,629 DEBUG [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2012-06-27 13:03:43,629 DEBUG [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2012-06-27 13:03:43,629 TRACE [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) closing statement
2012-06-27 13:03:43,629 TRACE [org.hibernate.jdbc.AbstractBatcher] (TimerForFileReading) closing statement
2012-06-27 13:03:43,629 DEBUG [org.hibernate.util.JDBCExceptionReporter] (TimerForFileReading) could not execute query [select count(*) from bbbb_deployment_location]
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:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:209)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1811)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
at org.hibernate.loader.Loader.doList(Loader.java:2233)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2130)
at org.hibernate.loader.Loader.list(Loader.java:2125)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1724)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.testSession(RdbConnectionFactory.java:153)
at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.getSession(RdbConnectionFactory.java:100)
at com.aaaa.bbbb.scheduler.TimerForFileReading.updateDB(TimerForFileReading.java:103)
at com.aaaa.bbbb.scheduler.TimerForFileReading$1.run(TimerForFileReading.java:91)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: java.net.SocketException: Connection timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:135)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:104)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:259)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1620)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
... 20 more
2012-06-27 13:03:43,629 DEBUG [org.hibernate.util.JDBCExceptionReporter] (TimerForFileReading) could not execute query [select count(*) from bbbb_deployment_location]
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:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:209)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1811)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
at org.hibernate.loader.Loader.doList(Loader.java:2233)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2130)
at org.hibernate.loader.Loader.list(Loader.java:2125)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1724)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.testSession(RdbConnectionFactory.java:153)
at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.getSession(RdbConnectionFactory.java:100)
at com.aaaa.bbbb.scheduler.TimerForFileReading.updateDB(TimerForFileReading.java:103)
at com.aaaa.bbbb.scheduler.TimerForFileReading$1.run(TimerForFileReading.java:91)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: java.net.SocketException: Connection timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:135)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:104)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:259)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1620)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
... 20 more
2012-06-27 13:03:43,629 WARN  [org.hibernate.util.JDBCExceptionReporter] (TimerForFileReading) SQL Error: 0, SQLState: 08006
2012-06-27 13:03:43,629 WARN  [org.hibernate.util.JDBCExceptionReporter] (TimerForFileReading) SQL Error: 0, SQLState: 08006
2012-06-27 13:03:43,629 ERROR [org.hibernate.util.JDBCExceptionReporter] (TimerForFileReading) An I/O error occured while sending to the backend.
2012-06-27 13:03:43,629 ERROR [org.hibernate.util.JDBCExceptionReporter] (TimerForFileReading) An I/O error occured while sending to the backend.
2012-06-27 13:03:43,629 TRACE [com.aaaa.bbbb.dbconnection.RdbConnectionFactory] (TimerForFileReading) 
org.hibernate.exception.JDBCConnectionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2236)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2130)
at org.hibernate.loader.Loader.list(Loader.java:2125)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1724)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.testSession(RdbConnectionFactory.java:153)
at com.aaaa.bbbb.dbconnection.RdbConnectionFactory.getSession(RdbConnectionFactory.java:100)
at com.aaaa.bbbb.scheduler.TimerForFileReading.updateDB(TimerForFileReading.java:103)
at com.aaaa.bbbb.scheduler.TimerForFileReading$1.run(TimerForFileReading.java:91)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: 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:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:209)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1811)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
at org.hibernate.loader.Loader.doList(Loader.java:2233)
... 12 more
Caused by: java.net.SocketException: Connection timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:135)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:104)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:259)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1620)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
... 20 more

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2012-06-28 10:08:47 Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend
Previous Message Dave Cramer 2012-06-27 21:54:54 Re: Question About End of Life