1 Reply Latest reply on Apr 22, 2012 5:01 AM by sfcoy

    Urgent problem:  jboss as 5.1 offten happened time out exception

    aquila_bj

      helllo every one, I have some urgent problem about JBOSS db pool with mysql database(5.1.41). I offen found my sql exception from jboss as server. Does anybody find the same error problem before, how to fix this problem.

       

      Can anybody help to find what's root cause about this?

       

       

      2012-04-20 11:29:17,189 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Unable to fill pool

      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

       

      The last packet successfully received from the server was 6,128 milliseconds ago.  The last packet sent successfully to the server was 6,127 milliseconds ago.)

              at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:465)

              at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:409)

              at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)

              at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:541)

              at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)

              at java.lang.Thread.run(Thread.java:619)

      Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

       

      The last packet successfully received from the server was 6,128 milliseconds ago.  The last packet sent successfully to the server was 6,127 milliseconds ago.

              at sun.reflect.GeneratedConstructorAccessor219.newInstance(Unknown Source)

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

              at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

              at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3591)

              at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3480)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4021)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951)

              at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4602)

              at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1328)

              at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2389)

              at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2422)

              at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2207)

              at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797)

              at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

              at sun.reflect.GeneratedConstructorAccessor125.newInstance(Unknown Source)

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

              at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)

              at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

              at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:440)

              at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:138)

              at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:108)

              at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:48)

              at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:449)

              ... 5 more

      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

              at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3041)

              at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3491)

              ... 26 more