connection reset and I/O error

From: "mpr" <mpruefer(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: connection reset and I/O error
Date: 2005-09-14 19:12:42
Message-ID: 1126725162.925594.45080@g14g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I'm working on an application using PostgreSQL 8.0.3 via Hibernate
2.1.6 in a JBoss 4.0.1 Appserver, with both appserver and
postgres db running on the same machine with Windows XP SP2.

I get the following errors in JBoss' log, does anyone know the problem
and a solution? And yes, I already googled a lot for this problem.
I use the postgresql-8.0-311.jdbc3.jar jdbc driver.

Thanks a lot!

--snip from the stacktrace--
20:38:40,335 WARN [JBossManagedConnectionPool] Unable to fill pool
org.jboss.resource.JBossResourceException: Could not create connection;
- nested throwable: (org.postgresql.util.PSQLExc
eption: Der Verbindungsversuch schlug fehl.)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConne
ctionFactory.java:161)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalMana
gedConnectionPool.java:508)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.ja
va:455)
at
org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:70)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.postgresql.util.PSQLException: Der Verbindungsversuch
schlug fehl.
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:117)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.connect(Driver.java:235)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConne
ctionFactory.java:151)
... 4 more
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at
java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
at
java.io.BufferedInputStream.read(BufferedInputStream.java:201)
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:241)
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:253)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
... 10 more
20:38:56,909 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
08006
20:38:56,909 ERROR [JDBCExceptionReporter] Eingabe/Ausgabe-Fehler {0}
beim Senden an das Backend.
20:38:56,940 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
08006
20:38:56,940 ERROR [JDBCExceptionReporter] Eingabe/Ausgabe-Fehler {0}
beim Senden an das Backend.
20:38:56,940 ERROR [JDBCExceptionReporter] Could not execute query
org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim
Senden an das Backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:201)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296)
at
net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
[...]
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:66)
at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
at org.postgresql.core.PGStream.flush(PGStream.java:494)
at
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:631)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:174)
... 56 more
20:38:57,643 ERROR [HibernateQuery] Could not execute query
net.sf.hibernate.JDBCException: Could not execute query
at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1547)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
[...]
Caused by: org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler
{0} beim Senden an das Backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:201)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296)
at
net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
... 44 more
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:66)
at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
at org.postgresql.core.PGStream.flush(PGStream.java:494)
at
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:631)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:174)
... 56 more
20:38:57,643 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
08006
--snip from the stacktrace--

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rob Kirkbride 2005-09-14 19:37:55 Re: connection reset and I/O error
Previous Message Kris Jurka 2005-09-14 02:27:33 Re: Getting vacuum results