transaction timeout !

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

transaction timeout !

prashant punekar
Hi,

I am trying to sync the inventory items from the third party inventory system.
As the number of items increase I get the following error messages:

Can someone please throw some light on this transaction time out issue. I have updated the debug messages to error message.

I also tried with the increasing the transaction-timeout to 3 mins i.e. 180 sec but of no use.

Regards,
Prashant

2010-01-23 16:45:29,169 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:29,169 (default-invoker-Thread-544) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:29,716 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:29,716 (default-invoker-Thread-544) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:30,372 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:30,372 (default-invoker-Thread-544) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:30,387 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:30,528 (default-invoker-Thread-544) [  ServiceDispatcher.java:543:ERROR]
---- exception report ----------------------------------------------------------
Could not commit transaction for service [syncInventoryItem] call
Exception: org.ofbiz.entity.transaction.GenericTransactionException
Message: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout)
---- cause ---------------------------------------------------------------------
Exception: javax.transaction.RollbackException
Message: Transaction timeout
---- stack trace ---------------------------------------------------------------
javax.transaction.RollbackException: Transaction timeout
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269)
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:209)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:195)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:539)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2010-01-23 16:45:30,528 (default-invoker-Thread-544) [  GenericServiceJob.java:116:ERROR]
---- exception report ----------------------------------------------------------
Async-Service failed.
Exception: org.ofbiz.service.GenericServiceException
Message: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout)
---- stack trace ---------------------------------------------------------------
org.ofbiz.service.GenericServiceException: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:547)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2010-01-23 16:45:31,012 (default-invoker-Thread-10) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,012 (default-invoker-Thread-10) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:31,575 (default-invoker-Thread-10) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,606 (default-invoker-Thread-10) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:31,669 (ActiveMQ Session Task) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,669 (ActiveMQ Session Task) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:31,684 (default-invoker-Thread-10) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,700 (default-invoker-Thread-10) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed+

________________________________
http://www.mindtree.com/email/disclaimer.html
Reply | Threaded
Open this post in threaded view
|

RE: transaction timeout !

prashant punekar
Hi,

Please note that this service is invoked asynchronuously.

Regards,
Prashant
________________________________
From: Prashant Punekar
Sent: Saturday, January 23, 2010 4:51 PM
To: [hidden email]
Subject: transaction timeout !

Hi,

I am trying to sync the inventory items from the third party inventory system.
As the number of items increase I get the following error messages:

Can someone please throw some light on this transaction time out issue. I have updated the debug messages to error message.

I also tried with the increasing the transaction-timeout to 3 mins i.e. 180 sec but of no use.

Regards,
Prashant

2010-01-23 16:45:29,169 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:29,169 (default-invoker-Thread-544) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:29,716 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:29,716 (default-invoker-Thread-544) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:30,372 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:30,372 (default-invoker-Thread-544) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:30,387 (default-invoker-Thread-544) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:30,528 (default-invoker-Thread-544) [  ServiceDispatcher.java:543:ERROR]
---- exception report ----------------------------------------------------------
Could not commit transaction for service [syncInventoryItem] call
Exception: org.ofbiz.entity.transaction.GenericTransactionException
Message: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout)
---- cause ---------------------------------------------------------------------
Exception: javax.transaction.RollbackException
Message: Transaction timeout
---- stack trace ---------------------------------------------------------------
javax.transaction.RollbackException: Transaction timeout
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269)
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:209)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:195)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:539)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2010-01-23 16:45:30,528 (default-invoker-Thread-544) [  GenericServiceJob.java:116:ERROR]
---- exception report ----------------------------------------------------------
Async-Service failed.
Exception: org.ofbiz.service.GenericServiceException
Message: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout)
---- stack trace ---------------------------------------------------------------
org.ofbiz.service.GenericServiceException: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:547)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2010-01-23 16:45:31,012 (default-invoker-Thread-10) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,012 (default-invoker-Thread-10) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:31,575 (default-invoker-Thread-10) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,606 (default-invoker-Thread-10) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:31,669 (ActiveMQ Session Task) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,669 (ActiveMQ Session Task) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed
2010-01-23 16:45:31,684 (default-invoker-Thread-10) [    TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0)
2010-01-23 16:45:31,700 (default-invoker-Thread-10) [    TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed+

________________________________
http://www.mindtree.com/email/disclaimer.html