Anonymous_User Absent Member.
Absent Member.
181 views

Re: User Application 3.6.1- Issues in Jboss server

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(SocketOutputStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.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:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 09:53:27,621 WARN
> [org.jboss.resource.connectionmanager.TxConnectionManager] (Thread-46)
> Connection error occured:
> org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@15996b0[state=NORMAL
> mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@11e0011
> handles=0 lastUse=1338594387562 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$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(SocketOutputStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.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:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 09:53:27,621 WARN
> [org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
> (Thread-46) Destroying connection that could not be successfully
> matched:
> org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@15996b0[state=DESTROYED
> mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@11e0011
> handles=0 lastUse=1338594387562 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@965eb6
> txSync=null]
> 2012-06-02 10:08:27,754 WARN
> [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
> (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(SocketOutputStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.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:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 10:08:27,755 WARN
> [org.jboss.resource.connectionmanager.TxConnectionManager] (Thread-46)
> Connection error occured:
> org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1ad287[state=NORMAL
> mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@79463f
> handles=0 lastUse=1338594807624 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$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(SocketOutputStream.java:96)
> at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
> at
> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
> at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.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:1612)
> 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:727)
> at
> org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:559)
> at
> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:321)
> at
> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:402)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
> at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
> at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
> at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
> at sun.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
> at $Proxy183.beginTransaction(Unknown Source)
> at com.novell.soa.persist.HibernateUtil.begin(HibernateUtil.java:119)
> at com.novell.soa.persist.HibernateDAO.begin(HibernateDAO.java:350)
> at
> com.novell.soa.af.impl.persist.EngineStateDAO.updateHeartbeat(EngineStateDAO.java:133)
> at
> com.novell.soa.af.impl.core.EngineImpl$HeartbeatTimer.run(EngineImpl.java:1250)
> at java.lang.Thread.run(Thread.java:619)
> 2012-06-02 10:08:27,755 WARN
> [org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
> (Thread-46) Destroying connection that could not be successfully
> matched:
> org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1ad287[state=DESTROYED
> mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@79463f
> handles=0 lastUse=1338594807624 permit=false trackByTx=false
> mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubject@554195
> context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@144a179
> xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$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.LocalManagedConnectionFactory]
> (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
Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.