On 06/02/2012 06:06 AM, idmuser wrote:
>
> Hi,
> In my User Application's Jboss server log I could see the following
> exception repeatedly. Despite of these exceptions end users are using
> the Self-service function without any issues. However I could often see
> thatj boss is losing its connection with mysql during heavy load. Hence
> I will restart the jboss which solves the issue. My jboss is clustered.
>
> com.mysql.jdbc.CommunicationsException: Communications link failure due
> to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Connection reset
>
> STACKTRACE:
>
> java.net.SocketException: Connection reset
> at
> java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 1 ms ago.
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 09:53:27,621 WARN
> [org.jboss.resource.connectionmanager.TxConnectionM anager] (Thread-46)
> Connection error occured:
> org.jboss.resource.connectionmanager.TxConnectionM anager$TxConnectionEventListener@15996b0[state=NORMAL
> mc=org.jboss.resource.adapter.jdbc.local.LocalMana gedConnection@11e0011
> handles=0 lastUse=1338594387562 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossMana gedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.Inter nalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.Tx ConnectionManager$LocalXAResource@965eb6
> txSync=null]
> com.mysql.jdbc.CommunicationsException: Communications link failure due
> to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Connection reset
>
> STACKTRACE:
>
> java.net.SocketException: Connection reset
> at
> java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 1 ms ago.
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 09:53:27,621 WARN
> [org.jboss.resource.connectionmanager.JBossManagedC onnectionPool]
> (Thread-46) Destroying connection that could not be successfully
> matched:
> org.jboss.resource.connectionmanager.TxConnectionM anager$TxConnectionEventListener@15996b0[state=DESTROYED
> mc=org.jboss.resource.adapter.jdbc.local.LocalMana gedConnection@11e0011
> handles=0 lastUse=1338594387562 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossMana gedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.Inter nalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.Tx ConnectionManager$LocalXAResource@965eb6
> txSync=null]
> 2012-06-02 10:08:27,754 WARN
> [org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory]
> (Thread-46) Destroying connection that is not valid, due to the
> following exception: com.mysql.jdbc.Connection@3069e9
> com.mysql.jdbc.CommunicationsException: Communications link failure due
> to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Connection reset
>
> STACKTRACE:
>
> java.net.SocketException: Connection reset
> at
> java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 1 ms ago.
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 10:08:27,755 WARN
> [org.jboss.resource.connectionmanager.TxConnectionM anager] (Thread-46)
> Connection error occured:
> org.jboss.resource.connectionmanager.TxConnectionM anager$TxConnectionEventListener@1ad287[state=NORMAL
> mc=org.jboss.resource.adapter.jdbc.local.LocalMana gedConnection@79463f
> handles=0 lastUse=1338594807624 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossMana gedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.Inter nalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.Tx ConnectionManager$LocalXAResource@1f2f224
> txSync=null]
> com.mysql.jdbc.CommunicationsException: Communications link failure due
> to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Connection reset
>
> STACKTRACE:
>
> java.net.SocketException: Connection reset
> at
> java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 1 ms ago.
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnecti onSQL.isValidConnection(CheckValidConnectionSQL.ja va:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged ConnectionFactory.isValidConnection(BaseWrapperMan agedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkValid(BaseWrapperManagedConnection .java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.matchManagedConnections(LocalMan agedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvi der.getConnection(DatasourceConnectionProvider.jav a:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unkn own Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$Tr ansactionProtectionWrapper.invoke(ThreadLocalSessi onContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(Hiberna teUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(Hibernat eDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.upda teHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTi mer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 10:08:27,755 WARN
> [org.jboss.resource.connectionmanager.JBossManagedC onnectionPool]
> (Thread-46) Destroying connection that could not be successfully
> matched:
> org.jboss.resource.connectionmanager.TxConnectionM anager$TxConnectionEventListener@1ad287[state=DESTROYED
> mc=org.jboss.resource.adapter.jdbc.local.LocalMana gedConnection@79463f
> handles=0 lastUse=1338594807624 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossMana gedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.Inter nalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.Tx ConnectionManager$LocalXAResource@1f2f224
> txSync=null]
> 2012-06-02 10:20:42,415 INFO [com.novell.pwdmgt.util.PasswordHelper]
> (http-0.0.0.0-8080-39) [Login_Success]
> CN=UO0000100074,OU=Users,OU=Sydney,O=COMMUNITIES successfully logged
> in.
> 2012-06-02 10:26:27,928 WARN
> [org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory]
> (Thread-46) Destroying connection that is not valid, due to the
> following exception: com.mysql.jdbc.Connection@f73616
> com.mysql.jdbc.CommunicationsException: Communications link failure due
> to underlying exception:
>
>

Greetings,

1) Is there a firewall between the JBoss and MySQL?

2) Have to you updated the connection pool file for JBoss to
automatically re-connect to the MySQL server?

--
Sincerely,
Steven Williams
Lead Software Engineer
NetIQ