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:


--
idmuser
------------------------------------------------------------------------
idmuser's Profile: http://forums.novell.com/member.php?userid=85990
View this thread: http://forums.novell.com/showthread.php?t=456478