Thanks Vince for posting this and David for your suggestion, I'll look
at it soon and try to find the scope where I can optimize the code and
try my best to fix it.
--
Thanks And Regards
Sumit Pandit
On 26-Aug-09, at 9:14 PM, David E Jones wrote:
This looks like a good old case of taking too long to run. Your main
options are:
1. change the code or related things to run faster (optimize the
code, optimize queries, add indexes, etc)
2. increase the timeout on whatever service begins the transaction,
and any other long-running services it calls
-David
On Aug 26, 2009, at 9:32 AM, Vince Clark wrote:
I updated code yesterday to r807673. Now when I try to complete a
reconciliation by pressing the "Reconcile" button I get the
following error.
The Following Errors Occurred:
Error calling event: org.ofbiz.webapp.event.EventHandlerException:
Commit multi-service global transaction failed
Stack from error.log
---------------
2009-08-26 11:27:46,556 (http-0.0.0.0-8443-1)
[ServiceMultiEventHandler.java:387:ERROR]
---- exception report
----------------------------------------------------------
Could not commit multi-service global transaction
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
.webapp
.event
.ServiceMultiEventHandler.invoke(ServiceMultiEventHandler.java:385)
org
.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:
611)
org
.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:
375)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:
215)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:
81)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org
.apache
.catalina
.core
.ApplicationFilterChain
.internalDoFilter(ApplicationFilterChain.java:290)
org
.apache
.catalina
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
265)
org
.apache
.catalina
.core
.ApplicationFilterChain
.internalDoFilter(ApplicationFilterChain.java:235)
org
.apache
.catalina
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
206)
org
.apache
.catalina
.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org
.apache
.catalina
.core.StandardContextValve.invoke(StandardContextValve.java:175)
org
.apache
.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org
.apache
.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org
.apache
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
109)
org
.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
568)
org
.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
286)
org
.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
844)
org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
447)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2009-08-26 11:27:46,588 (http-0.0.0.0-8443-1) [ RequestHandler.java:
412:ERROR] Request callReconcileFinAccountTrans caused an error
with the following message: Error calling event:
org.ofbiz.webapp.event.EventHandlerException: Commit multi-service
global transaction failed
Vince Clark
www.globalera.com
vcl...@globalera.com
(303) 493-6723 office
(303) 523-4843 cell