You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by maburger <ma...@bertelsmann.de> on 2008/08/13 15:08:06 UTC

Transaction error. Unabled to enlist ressource.

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.


Re: Transaction error. Unabled to enlist ressource.

Posted by BJ Freeman <bj...@free-man.net>.
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" <ma...@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.
>>>
>>
>>
> 


Re: Transaction error. Unabled to enlist ressource.

Posted by maburger <ma...@bertelsmann.de>.
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" <ma...@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.
>> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Transaction-error.-Unabled-to-enlist-ressource.-tp18962691p18975602.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: Transaction error. Unabled to enlist ressource.

Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ma...@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.
>