Transaction error. Unabled to enlist ressource.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Transaction error. Unabled to enlist ressource.

maburger
Hi,

sometime we get an exception (see below) thrwon by the transaction manager. It seems like one connection is shared with different transactions. How could this happend? The error always occurs within the service engine while job execution.

Does anybody know the source of this error?

Best regards
M.B.


2008-08-13 00:24:33,658 [default-invoker-Thread-8010] ERROR org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl - attempt to inactive start resource with existing xid; current xid: [globalId=ffffff8fffffff800000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=300000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000], new xid: [globalId=ffffffe4ffffff810000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=200000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000]
2008-08-13 00:24:33,658 [default-invoker-Thread-8010] WARN  Transaction - Unable to enlist XAResource org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl@42ad27, errorCode: -4
javax.transaction.xa.XAException
        at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.throwXAException(XAResourceImpl.java:334)
        at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.start(XAResourceImpl.java:319)
        at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:173)
        at org.apache.geronimo.transaction.context.InheritableTransactionContext.enlistResource(InheritableTransactionContext.java:92)
        at org.apache.geronimo.transaction.context.GeronimoTransactionDelegate.enlistResource(GeronimoTransactionDelegate.java:59)
        at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:390)
        at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:649)
        at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:363)
        at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:122)
        at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:91)
        at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:92)
        at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:69)
        at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:256)
        at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:362)
        at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
        at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:541)
        at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:512)
        at org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:77)
        at org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1248)
        at org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1304)
Reply | Threaded
Open this post in threaded view
|

Re: Transaction error. Unabled to enlist ressource.

Jacques Le Roux
Administrator
You are using an old version. Minerva has ben replaced by Apache DBCP. Some have migrated to it using an old version, so you should
be able to do it. It seems that DBCP is more stable...

Jacques

From: "maburger" <[hidden email]>

>
> Hi,
>
> sometime we get an exception (see below) thrwon by the transaction manager.
> It seems like one connection is shared with different transactions. How
> could this happend? The error always occurs within the service engine while
> job execution.
>
> Does anybody know the source of this error?
>
> Best regards
> M.B.
>
>
> 2008-08-13 00:24:33,658 [default-invoker-Thread-8010] ERROR
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl - attempt to inactive
> start resource with existing xid; current xid:
> [globalId=ffffff8fffffff800000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=300000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000],
> new xid:
> [globalId=ffffffe4ffffff810000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=200000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000]
> 2008-08-13 00:24:33,658 [default-invoker-Thread-8010] WARN  Transaction -
> Unable to enlist XAResource
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl@42ad27, errorCode: -4
> javax.transaction.xa.XAException
> at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.throwXAException(XAResourceImpl.java:334)
> at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.start(XAResourceImpl.java:319)
> at
> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:173)
> at
> org.apache.geronimo.transaction.context.InheritableTransactionContext.enlistResource(InheritableTransactionContext.java:92)
> at
> org.apache.geronimo.transaction.context.GeronimoTransactionDelegate.enlistResource(GeronimoTransactionDelegate.java:59)
> at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:390)
> at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:649)
> at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:363)
> at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:122)
> at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:91)
> at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:92)
> at
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:69)
> at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:256)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:362)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
> at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:541)
> at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:512)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:77)
> at
> org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1248)
> at
> org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1304)
> --
> View this message in context: http://www.nabble.com/Transaction-error.-Unabled-to-enlist-ressource.-tp18962691p18962691.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Reply | Threaded
Open this post in threaded view
|

Re: Transaction error. Unabled to enlist ressource.

maburger
Has anybody migrated the OFbiz 3.2 code to DBCP? We have to be JAVA 1.4 compatible, so we can not take the current code from the trunk version where the DBCP is already integrated as the default pool.

jacques.le.roux wrote
You are using an old version. Minerva has ben replaced by Apache DBCP. Some have migrated to it using an old version, so you should
be able to do it. It seems that DBCP is more stable...

Jacques

From: "maburger" <marius.burger@bertelsmann.de>
>
> Hi,
>
> sometime we get an exception (see below) thrwon by the transaction manager.
> It seems like one connection is shared with different transactions. How
> could this happend? The error always occurs within the service engine while
> job execution.
>
> Does anybody know the source of this error?
>
> Best regards
> M.B.
>
>
> 2008-08-13 00:24:33,658 [default-invoker-Thread-8010] ERROR
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl - attempt to inactive
> start resource with existing xid; current xid:
> [globalId=ffffff8fffffff800000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=300000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000],
> new xid:
> [globalId=ffffffe4ffffff810000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=200000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000]
> 2008-08-13 00:24:33,658 [default-invoker-Thread-8010] WARN  Transaction -
> Unable to enlist XAResource
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl@42ad27, errorCode: -4
> javax.transaction.xa.XAException
> at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.throwXAException(XAResourceImpl.java:334)
> at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.start(XAResourceImpl.java:319)
> at
> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:173)
> at
> org.apache.geronimo.transaction.context.InheritableTransactionContext.enlistResource(InheritableTransactionContext.java:92)
> at
> org.apache.geronimo.transaction.context.GeronimoTransactionDelegate.enlistResource(GeronimoTransactionDelegate.java:59)
> at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:390)
> at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:649)
> at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:363)
> at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:122)
> at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:91)
> at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:92)
> at
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:69)
> at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:256)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:362)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
> at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:541)
> at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:512)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:77)
> at
> org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1248)
> at
> org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1304)
> --
> View this message in context: http://www.nabble.com/Transaction-error.-Unabled-to-enlist-ressource.-tp18962691p18962691.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: Transaction error. Unabled to enlist ressource.

BJ Freeman
the release ver 4.0 is the last 1.4 code.

maburger sent the following on 8/13/2008 9:38 PM:

> Has anybody migrated the OFbiz 3.2 code to DBCP? We have to be JAVA 1.4
> compatible, so we can not take the current code from the trunk version where
> the DBCP is already integrated as the default pool.
>
>
> jacques.le.roux wrote:
>> You are using an old version. Minerva has ben replaced by Apache DBCP.
>> Some have migrated to it using an old version, so you should
>> be able to do it. It seems that DBCP is more stable...
>>
>> Jacques
>>
>> From: "maburger" <[hidden email]>
>>> Hi,
>>>
>>> sometime we get an exception (see below) thrwon by the transaction
>>> manager.
>>> It seems like one connection is shared with different transactions. How
>>> could this happend? The error always occurs within the service engine
>>> while
>>> job execution.
>>>
>>> Does anybody know the source of this error?
>>>
>>> Best regards
>>> M.B.
>>>
>>>
>>> 2008-08-13 00:24:33,658 [default-invoker-Thread-8010] ERROR
>>> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl - attempt to
>>> inactive
>>> start resource with existing xid; current xid:
>>> [globalId=ffffff8fffffff800000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=300000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000],
>>> new xid:
>>> [globalId=ffffffe4ffffff810000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000,branchId=200000005748415420444f2057452043414c4c2049543f0000000000000000000000000000000000000]
>>> 2008-08-13 00:24:33,658 [default-invoker-Thread-8010] WARN  Transaction -
>>> Unable to enlist XAResource
>>> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl@42ad27, errorCode:
>>> -4
>>> javax.transaction.xa.XAException
>>> at
>>> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.throwXAException(XAResourceImpl.java:334)
>>> at
>>> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAResourceImpl.start(XAResourceImpl.java:319)
>>> at
>>> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:173)
>>> at
>>> org.apache.geronimo.transaction.context.InheritableTransactionContext.enlistResource(InheritableTransactionContext.java:92)
>>> at
>>> org.apache.geronimo.transaction.context.GeronimoTransactionDelegate.enlistResource(GeronimoTransactionDelegate.java:59)
>>> at
>>> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:390)
>>> at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:649)
>>> at
>>> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:363)
>>> at
>>> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:122)
>>> at
>>> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:91)
>>> at
>>> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:92)
>>> at
>>> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:69)
>>> at
>>> org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:256)
>>> at
>>> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:362)
>>> at
>>> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
>>> at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:541)
>>> at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:512)
>>> at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:77)
>>> at
>>> org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1248)
>>> at
>>> org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1304)
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Transaction-error.-Unabled-to-enlist-ressource.-tp18962691p18962691.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>