6 Replies Latest reply on Sep 13, 2012 2:11 PM by Steven Hawkins

    Getting Exception "ARJUNA016074: no transaction !" while fetching data from VDB

    Manoj Agarwal Newbie

      Hi,

       

      I am deploying my VDB in Teiid 8.1.0 Beta2 and its getting deployed without any error but when i fire a SQL query i get below mentioned error.

       

      java.lang.IllegalStateException: BaseTransaction.commit - ARJUNA016074: no transaction!

          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:113)

          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

          at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:387) [teiid-engine-8.1.0.Beta2.jar:8.1.0.Beta2]

          at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:480) [teiid-engine-8.1.0.Beta2.jar:8.1.0.Beta2]

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_02]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_02]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_02]

          at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_02]

          at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.1.0.Beta2.jar:8.1.0.Beta2]

          at $Proxy21.commit(Unknown Source)    at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:400) [teiid-engine-8.1.0.Beta2.jar:8.1.0.Beta2]

          at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:290) [teiid-engine-8.1.0.Beta2.jar:8.1.0.Beta2]

       

      In the server logs, i see TransactionManager related Excpetion which actully printed as DEBUG statements rather than ERROR. Not sure if it impacts above error anyhow.

       

      17:55:38,985 DEBUG [org.jboss.tm.TransactionManagerLocator] (MSC service thread 1-3) Unable to lookup: java:/TransactionManager: javax.naming.NameNotFoundException: Error looking up TransactionManager, service service jboss.naming.context.java.TransactionManager is not started

          at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:126) [jboss-as-naming-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:74) [jboss-as-naming-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:178) [jboss-as-naming-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.naming.InitialContext.lookup(InitialContext.java:113) [jboss-as-naming-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:214) [jboss-as-naming-7.1.1.Final.jar:7.1.1.Final]

          at javax.naming.InitialContext.lookup(InitialContext.java:411) [rt.jar:1.7.0_02]

          at org.jboss.tm.TransactionManagerLocator.tryJNDI(TransactionManagerLocator.java:150) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.TransactionManagerLocator.locate(TransactionManagerLocator.java:131) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.TransactionManagerLocator.locateTransactionManager(TransactionManagerLocator.java:94) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.<init>(ServerVMClientUserTransaction.java:93) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.<clinit>(ServerVMClientUserTransaction.java:60) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.as.txn.service.ArjunaTransactionManagerService.start(ArjunaTransactionManagerService.java:115) [jboss-as-transactions-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_02]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_02]

          at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_02]

         

      17:55:39,063 DEBUG [org.jboss.tm.TransactionManagerLocator] (MSC service thread 1-3) Unable to instantiate legacy transaction manager: java.lang.ClassNotFoundException: org.jboss.tm.TxManager from [Module "org.jboss.jboss-transaction-spi:main" from local module loader @1c0fc25 (roots: C:\Users\agama05\Documents\My Received Files\TEIID 8.0\New folder\jboss-as-7.1.1.Final\modules)]

          at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190)

          at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468)

          at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456)

          at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)

          at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120)

          at java.lang.Class.forName0(Native Method) [rt.jar:1.7.0_02]

          at java.lang.Class.forName(Class.java:186) [rt.jar:1.7.0_02]

          at org.jboss.tm.TransactionManagerLocator.usePrivateAPI(TransactionManagerLocator.java:172) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.TransactionManagerLocator.locate(TransactionManagerLocator.java:133) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.TransactionManagerLocator.locateTransactionManager(TransactionManagerLocator.java:94) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.<init>(ServerVMClientUserTransaction.java:93) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.<clinit>(ServerVMClientUserTransaction.java:60) [jboss-transaction-spi-7.0.0.Final.jar:7.0.0.Final]

          at org.jboss.as.txn.service.ArjunaTransactionManagerService.start(ArjunaTransactionManagerService.java:115) [jboss-as-transactions-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_02]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_02]

      at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_02]

        • 1. Re: Getting Exception "ARJUNA016074: no transaction !" while fetching data from VDB
          Manoj Agarwal Newbie

          Please find Execution plan for the failing query

           

          ============================================================================

          USER COMMAND:

          SELECT * FROM chorus_metadata.chorus_role

           

          ----------------------------------------------------------------------------

          OPTIMIZE:

          SELECT * FROM chorus_metadata.chorus_role

           

          ----------------------------------------------------------------------------

          GENERATE CANONICAL:

          SELECT * FROM chorus_metadata.chorus_role

           

          CANONICAL PLAN:

          Project(groups=[chorus_metadata.chorus_role], props={PROJECT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME]})

            Source(groups=[chorus_metadata.chorus_role])

           

           

          ============================================================================

          EXECUTING PlaceAccess

           

          AFTER:

          Project(groups=[chorus_metadata.chorus_role], props={PROJECT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME]})

            Access(groups=[chorus_metadata.chorus_role])

              Source(groups=[chorus_metadata.chorus_role])

           

           

          ============================================================================

          EXECUTING RaiseAccess

           

          AFTER:

          Access(groups=[chorus_metadata.chorus_role], props={MODEL_ID=Schema name=chorus_metadata, nameInSource=null, uuid=tid:8d825ab1a54d-0df5a5a8-00000000})

            Project(groups=[chorus_metadata.chorus_role], props={PROJECT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME]})

              Source(groups=[chorus_metadata.chorus_role])

           

           

          ============================================================================

          EXECUTING AssignOutputElements

           

          AFTER:

          Access(groups=[chorus_metadata.chorus_role], props={MODEL_ID=Schema name=chorus_metadata, nameInSource=null, uuid=tid:8d825ab1a54d-0df5a5a8-00000000, OUTPUT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME]})

            Project(groups=[chorus_metadata.chorus_role], props={PROJECT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME], OUTPUT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME]})

              Source(groups=[chorus_metadata.chorus_role], props={OUTPUT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME]})

           

           

          ============================================================================

          EXECUTING CalculateCost

           

          AFTER:

          Access(groups=[chorus_metadata.chorus_role], props={MODEL_ID=Schema name=chorus_metadata, nameInSource=null, uuid=tid:8d825ab1a54d-0df5a5a8-00000000, OUTPUT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME], EST_CARDINALITY=-1.0})

            Project(groups=[chorus_metadata.chorus_role], props={PROJECT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME], OUTPUT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME], EST_CARDINALITY=-1.0})

              Source(groups=[chorus_metadata.chorus_role], props={OUTPUT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME], EST_COL_STATS={chorus_metadata.chorus_role.INSTALL_STATUS=[-1.0, -1.0], chorus_metadata.chorus_role.USER_ACCESS=[-1.0, -1.0], chorus_metadata.chorus_role.ROLE_NAME=[-1.0, -1.0], chorus_metadata.chorus_role.LICENSE_STATUS=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})

           

           

          ============================================================================

          EXECUTING PlanSorts

           

          AFTER:

          Access(groups=[chorus_metadata.chorus_role])

            Project(groups=[chorus_metadata.chorus_role])

              Source(groups=[chorus_metadata.chorus_role])

           

           

          ============================================================================

          EXECUTING CollapseSource

           

          AFTER:

          Access(groups=[chorus_metadata.chorus_role], props={MODEL_ID=Schema name=chorus_metadata, nameInSource=null, uuid=tid:8d825ab1a54d-0df5a5a8-00000000, OUTPUT_COLS=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME FROM chorus_metadata.chorus_role})

           

           

          ============================================================================

          CONVERTING PLAN TREE TO PROCESS TREE

           

          PROCESS PLAN =

          AccessNode(0) output=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME] SELECT g_0.INSTALL_STATUS, g_0.USER_ACCESS, g_0.ROLE_NAME, g_0.LICENSE_STATUS, g_0.SCHEMA_NAME FROM chorus_metadata.chorus_role AS g_0

           

          ============================================================================

           

          ----------------------------------------------------------------------------

          OPTIMIZATION COMPLETE:

          PROCESSOR PLAN:

          AccessNode(0) output=[chorus_metadata.chorus_role.INSTALL_STATUS, chorus_metadata.chorus_role.USER_ACCESS, chorus_metadata.chorus_role.ROLE_NAME, chorus_metadata.chorus_role.LICENSE_STATUS, chorus_metadata.chorus_role.SCHEMA_NAME] SELECT g_0.INSTALL_STATUS, g_0.USER_ACCESS, g_0.ROLE_NAME, g_0.LICENSE_STATUS, g_0.SCHEMA_NAME FROM chorus_metadata.chorus_role AS g_0

           

          ============================================================================

          • 2. Re: Getting Exception "ARJUNA016074: no transaction !" while fetching data from VDB
            Ramesh Reddy Master

            Did u ever post to the AS7 forums about the transaction DEBUG errors?

            • 3. Re: Getting Exception "ARJUNA016074: no transaction !" while fetching data from VDB
              Manoj Agarwal Newbie

              Hi Ramesh,

               

              I had posted these debug errors to Teiid forum(at that time i thought its teiid related) couple of weeks back: https://community.jboss.org/thread/203436

               

              Unfortunately i couldn't follow up that thread becuase it was not blocking me anyhow but i saw something unusual and reported the same.

               

              Today only i saw your reply in that thread. My apology for not following that thread.

               

              Shell i post a new discussion in AS7 or do i need to raise a JIRA ?

               

              Thanks !

              MAnoj

              • 4. Re: Getting Exception "ARJUNA016074: no transaction !" while fetching data from VDB
                Ramesh Reddy Master

                Post in their forums first, then they will advise further steps hopefully.

                 

                Ramesh..

                • 6. Re: Getting Exception "ARJUNA016074: no transaction !" while fetching data from VDB
                  Steven Hawkins Master

                  https://issues.jboss.org/browse/TEIID-2205 has fixes that cover the "no transaction" exception.  We were causing that to happen in some circumstances with local connections that use the calling thread and start a local or request scoped transaction.  This will be resolved in 8.2

                   

                  Steve