1 Reply Latest reply on Feb 19, 2008 3:25 AM by Doni Gonzalez

    Transaction is not active error

    Doni Gonzalez Newbie

      Hi,

      i`m new with JBoss and recently our customer install an application that works with JBoss and the logs shows the follow behaviour:

      The JBoss starts and load the aplication. 30 minutes after, and during 20 minutes aprox. starts to throught only the following message in the log (all the time and a lot of time):

      <N,02/19/08 08:06:06 UTC,JDBCExceptionReporter> SQL Error: 0, SQLState: null
      <R,02/19/08 08:06:06 UTC,JDBCExceptionReporter> Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=spgis001/69305, BranchQual=, loc
      alId=69305]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=spgis001/693
      05, BranchQual=, localId=69305])
      <O,02/19/08 08:06:06 UTC,DefaultLoadEventListener> Error performing load command
      org.hibernate.exception.GenericJDBCException: Cannot open connection
      at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
      at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:301)
      at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
      at org.hibernate.loader.Loader.doQuery(Loader.java:390)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
      at org.hibernate.loader.Loader.loadEntityBatch(Loader.java:1395)
      at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:69)
      at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2471)
      at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:351)
      at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:332)
      at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:113)
      at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:167)
      at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:621)
      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:614)
      at com.bmc.patrol.portal.services.AbstractDAO.get(AbstractDAO.java:118)
      at com.bmc.patrol.portal.services.element.dao.hibernate.PortalElementDaoImpl.read(PortalElementDaoImpl.java:132)
      at com.bmc.patrol.portal.services.objectstore.CmdbEntryServiceImpl.getParentGuids(CmdbEntryServiceImpl.java:813)
      at com.bmc.patrol.portal.services.objectstore.CmdbEntryServiceImpl.scanForNullAuxGuidsAndSet(CmdbEntryServiceImpl.java:778)
      at com.bmc.patrol.portal.services.objectstore.CmdbEntryServiceImpl.scanCmdbStagingTable(CmdbEntryServiceImpl.java:701)
      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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy145.scanCmdbStagingTable(Unknown Source)
      at com.bmc.patrol.portal.tasks.objectstore.ObjectStoreTableScanImpl.scanCmdbStagingTable(ObjectStoreTableScanImpl.java:21)
      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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy183.scanCmdbStagingTable(Unknown Source)
      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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:248)
      at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java
      :165)
      at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:66)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
      Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=spgis001/69305, BranchQual=, local
      Id=69305]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=spgis001/69305
      , BranchQual=, localId=69305])
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
      at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
      ... 52 more
      Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=spgis001/69305, BranchQual=, localI
      d=69305]
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:290)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:379)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:812)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
      ... 54 more
      <N,02/19/08 08:06:06 UTC,JDBCExceptionReporter> SQL Error: 0, SQLState: null
      <R,02/19/08 08:06:06 UTC,JDBCExceptionReporter> Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=spgis001/69305, BranchQual=, loc
      alId=69305]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=spgis001/693
      05, BranchQual=, localId=69305])

      After the 20 minutes stops during 30 minutes and then starts again.

      Could anyone help us?

      Regards,

      Doni.