5 Replies Latest reply on Oct 30, 2013 8:30 AM by abbassabidi

    SocketException from JBoss JDBCPool

    abbassabidi

      Hi guys,

       

      In our prod env, we get the following exception in JBoss logs. To prove that there is no network issue, we created a standalone utility to connect and query the very same DBs after every minute. That utility never reports these exceptions but in JBoss it's we get a lot of them. Any help would be much appreciated.

       

      WARN  [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@7e291bea[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@2333bf6d handles=0 lastUse=1383037944602 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@3f71d740 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@4aeacb4a xaResource=org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper@1a5c9f29 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:2637)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)

        at com.mysql.jdbc.Statement.execute(Statement.java:695)

        at com.mysql.jdbc.jdbc2.optional.StatementWrapper.execute(StatementWrapper.java:658)

        at org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)

        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435)

        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231)

        at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.matchManagedConnections(XAManagedConnectionFactory.java:171)

        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:211)

        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:538)

        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)

        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)

        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)

        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)

        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)

        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)

        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)

        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)

        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)

        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)

        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)

        at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)

        at com.mycompany.readAll()

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)

        at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)

        at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)

        at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)

        at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:106)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:214)

        at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:184)

        at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:81)

        at $Proxy154.getBusinessFunction(Unknown Source)

        at com.mycompany.readAll()

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)

        at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)

        at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)

        at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)

        at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:106)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:214)

        at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:184)

        at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:81)

        at $Proxy194.readCustomizedWithoutImages(Unknown Source)

        at com.mycompany.readAll()

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)2013-10-29 09:20:54,886 WARN  [org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory] Destroying connection that is not valid, due to the following exception: com.mysql.jdbc.jdbc2.optional.ConnectionWrapper@36d54a44

        • 1. Re: SocketException from JBoss JDBCPool
          tomjenkinson

          I guess something has closed your connection, but I think Jesper will need more details than you have provided. Have you replicated this on WildFly, do you have some version numbers of the components you are using? Do you have more logging?

          • 2. Re: SocketException from JBoss JDBCPool
            abbassabidi

            Thanks for looking into Tom. We use an old JBoss, it's 4.2.1. MySQL driver is 5.0.5 that connects with Mysql 5. Following is the latest SocketException we got in our logs.

             

            2013-10-30 04:02:32,715 DEBUG [org.jboss.ejb.txtimer.TimerImpl] setTimerState: created

            2013-10-30 04:02:32,717 ERROR [org.jboss.ejb.txtimer.TimerServiceImpl] Cannot create txtimer

            java.lang.IllegalStateException: Unable to persist timer

              at org.jboss.ejb.txtimer.DatabasePersistencePolicy.insertTimer(DatabasePersistencePolicy.java:124)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:585)

              at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

              at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

              at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

              at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

              at $Proxy30.insertTimer(Unknown Source)

              at org.jboss.ejb.txtimer.TimerServiceImpl.createTimer(TimerServiceImpl.java:256)

              at org.jboss.ejb.txtimer.TimerServiceImpl.createTimer(TimerServiceImpl.java:171)

              at org.jboss.ejb3.timerservice.jboss.TimerServiceFacade.createTimer(TimerServiceFacade.java:71)

              at com.mycompany.EventEJBTimer.regenerateEvent(EventEJBTimer.java:122)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:585)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)

              at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)

              at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)

              at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)

              at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:106)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.stateless.StatelessContainer.callTimeout(StatelessContainer.java:151)

              at org.jboss.ejb.txtimer.TimerImpl$TimerTaskImpl.run(TimerImpl.java:561)

              at java.util.TimerThread.mainLoop(Timer.java:512)

              at java.util.TimerThread.run(Timer.java:462)

            Caused by: 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:2637)

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

              at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)

              at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5273)

              at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:429)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:525)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:184)

              at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.insertTimer(GeneralPurposeDatabasePersistencePlugin.java:204)

              at org.jboss.ejb.txtimer.DatabasePersistencePolicy.insertTimer(DatabasePersistencePolicy.java:120)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:585)

              at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

              at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

              at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

              at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

              at $Proxy30.insertTimer(Unknown Source)

              at org.jboss.ejb.txtimer.TimerServiceImpl.createTimer(TimerServiceImpl.java:256)

              at org.jboss.ejb.txtimer.TimerServiceImpl.createTimer(TimerServiceImpl.java:171)

              at org.jboss.ejb3.timerservice.jboss.TimerServiceFacade.createTimer(TimerServiceFacade.java:71)

              at com.mycompany.EventEJBTimer.regenerateEvent(EventEJBTimer.java:122)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:585)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)

              at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)

              at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)

              at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)

              at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:106)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)

              at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

              at org.jboss.ejb3.stateless.StatelessContainer.callTimeout(StatelessContainer.java:151)

              at org.jboss.ejb.txtimer.TimerImpl$TimerTaskImpl.run(TimerImpl.java:561)

              at java.util.TimerThread.mainLoop(Timer.java:512)

              at java.util.TimerThread.run(Timer.java:462)

             

            ** END NESTED EXCEPTION **

            Last packet sent to the server was 1 ms ago.

              at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2652)

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

              at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)

              at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5273)

              at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:429)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:525)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:184)

              at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.insertTimer(GeneralPurposeDatabasePersistencePlugin.java:204)

              at org.jboss.ejb.txtimer.DatabasePersistencePolicy.insertTimer(DatabasePersistencePolicy.java:120)

              ... 45 more

            • 3. Re: SocketException from JBoss JDBCPool
              tomjenkinson

              Hi Muhammad,

               

              I won't be able to help too much as its more on the JDBC side of things, something has closed your JDBC connection I think.


              Also JBoss 4 is ancient, any chance that you can try this with WildFly?

               

              Do you have logging from _before_ this happened that you can look at? For example, look for the word close in your logs. Are there any other warnings/errors/info in your logs?

               

              Tom

              • 4. Re: SocketException from JBoss JDBCPool
                ak_mwadmin

                Hi Abbas,

                 

                     This issue seems to be due to low entropy just make sure ur running with /dev/urandom and add this start up parameter to ur JVM -Djava.security.egd=file:///dev/urandom and restart the instance.

                • 5. Re: SocketException from JBoss JDBCPool
                  abbassabidi

                  Thanks again Tom. Unfortunately, we can't use WildFly. I think mainly because we are not sure if migration is going to be smooth. If you have some links/docs for migration that would be helpful.

                   

                  I'll look into "close" bit. If I find something informative, I'll update the thread.