OrderPrepare Causes TransactionRolledbackException

Discussion:

(too old to reply)

John

2005-05-18 14:07:49 UTC

Hi,

I am calling OrderPrepare from within a controller command that executes after OrderItemAdd is called. The URL parameter provided to OrderItemAdd is set to the name of the controller command. I am
seeing several entries per day in my ecmsg file with "The current transaction has been rolled back because of a deadlock or timeout." I am including the error message below. Any ideas on what is
causing this problem and any possible solutions would be greatly appreciated.

Thanks,
John

Thread ID: <Servlet.Engine.Transports:17756>
Class: com.ibm.commerce.order.calculation.CalculationHelper
Method: getTaxableAdjustmentTotals
Severity: 1
Message Text: CMN0412E The following Remote Exception occurred during processing: "javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: com.ibm.websphere.csi.CSITransactionRolledbackException: null; nested exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:269)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(Inlined Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java(Compiled Code))
at com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java(Compiled Code))
at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(Compiled Code))
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java(Compiled Code))
at com.ibm.commerce.order.objects.EJSJDBCPersisterCMPOrderItemAdjustmentBean.findByOrderItemIds(EJSJDBCPersisterCMPOrderItemAdjustmentBean.java(Compiled Code))
at com.ibm.commerce.order.objects.EJSCMPOrderItemAdjustmentHomeBean.findByOrderItemIds(EJSCMPOrderItemAdjustmentHomeBean.java(Inlined Compiled Code))
at com.ibm.commerce.order.objects.EJSRemoteCMPOrderItemAdjustmentHome.findByOrderItemIds(EJSRemoteCMPOrderItemAdjustmentHome.java(Compiled Code))
at com.ibm.commerce.order.objects._OrderItemAdjustmentHome_Stub.findByOrderItemIds(_OrderItemAdjustmentHome_Stub.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationHelper.getTaxableAdjustmentTotals(CalculationHelper.java(Compiled Code))
at com.ibm.commerce.order.calculation.TaxableNetPriceCalculationScaleLookupCmdImpl.performExecute(TaxableNetPriceCalculationScaleLookupCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl.callScaleLookup(CalculationRuleCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl.scaleCalculate(CalculationRuleCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl.performExecute(CalculationRuleCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl.callRuleCalculate(CalculationRuleCombineCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl.performExecute(CalculationRuleCombineCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl.callRuleCombine(CalculationCodeCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl.performExecute(CalculationCodeCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl.callCodeCalculate(ApplyCalculationUsageCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl.performExecute(ApplyCalculationUsageCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationHelper.applyCalculationUsages(CalculationHelper.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.calculateShippingAndTaxCharges(OrderProcessingHelper.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.calculateShippingTaxAndTotals(OrderProcessingHelper.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.updateOrderPricing(OrderProcessingHelper.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.updateOrderPricing(OrderProcessingHelper.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.PrepareOrderCmdImpl.doProcess(PrepareOrderCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.commands.PrepareOrderCmdImpl.performExecute(PrepareOrderCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderPrepareCmdImpl.performExecute(OrderPrepareCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java(Compiled Code))
at com.ibm.sfc.cmd.TargetableCommandImpl.execute(TargetableCommandImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java(Compiled Code))
at com.owls.wcs.command.MyControllerCmdImpl.performExecute(MyControllerCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java(Compiled Code))
at com.ibm.sfc.cmd.TargetableCommandImpl.execute(TargetableCommandImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java(Compiled Code))
at com.ibm.commerce.webcontroller.ControllerCmdExecUnit.execute(ControllerCmdExecUnit.java(Compiled Code))
at com.ibm.commerce.webcontroller.WebController.executeTransaction(WebController.java(Compiled Code))
at com.ibm.commerce.webcontroller.WebController.processRequest(WebController.java(Compiled Code))
at com.ibm.commerce.adapter.AbstractHttpAdapter.processRequest(AbstractHttpAdapter.java(Compiled Code))
at com.ibm.commerce.server.RequestServlet.service(RequestServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java(Inlined Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code))
:javax.transaction.TransactionRolledbackException: com.ibm.websphere.csi.CSITransactionRolledbackException: null; nested exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001

John

2005-05-18 14:26:38 UTC

Permalink

The reason code of 2 indicates that the transaction was rolled back due to a deadlock. How do people avoid deadlocks? I'll admit that I am running on some low end hardware but I am not sure how much
of an impact that has on deadlocks. The error code explanation says that deadlocks are normal when certain SQL statements are run. It also recommends designing applications to avoid deadlocks. Is
there a way to tweak DB2 to avoid deadlocks? A point in the right direction would be helpful. How are people handling deadlocks in their WebSphere Commerce environments? I know that this is
semething that I need to research more but any guidance from people on this newsgroup would be appreciated.

Thanks,
John

Post by John
Hi,
I am calling OrderPrepare from within a controller command that executes after OrderItemAdd is called. The URL parameter provided to OrderItemAdd is set to the name of the controller command. I am
seeing several entries per day in my ecmsg file with "The current transaction has been rolled back because of a deadlock or timeout." I am including the error message below. Any ideas on what is
causing this problem and any possible solutions would be greatly appreciated.
Thanks,
John
Thread ID: <Servlet.Engine.Transports:17756>
Class: com.ibm.commerce.order.calculation.CalculationHelper
Method: getTaxableAdjustmentTotals
Severity: 1
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:269)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(Inlined Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java(Compiled Code))
at com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java(Compiled Code))
at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(Compiled Code))
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java(Compiled Code))
at com.ibm.commerce.order.objects.EJSJDBCPersisterCMPOrderItemAdjustmentBean.findByOrderItemIds(EJSJDBCPersisterCMPOrderItemAdjustmentBean.java(Compiled Code))
at com.ibm.commerce.order.objects.EJSCMPOrderItemAdjustmentHomeBean.findByOrderItemIds(EJSCMPOrderItemAdjustmentHomeBean.java(Inlined Compiled Code))
at com.ibm.commerce.order.objects.EJSRemoteCMPOrderItemAdjustmentHome.findByOrderItemIds(EJSRemoteCMPOrderItemAdjustmentHome.java(Compiled Code))
at com.ibm.commerce.order.objects._OrderItemAdjustmentHome_Stub.findByOrderItemIds(_OrderItemAdjustmentHome_Stub.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationHelper.getTaxableAdjustmentTotals(CalculationHelper.java(Compiled Code))
at com.ibm.commerce.order.calculation.TaxableNetPriceCalculationScaleLookupCmdImpl.performExecute(TaxableNetPriceCalculationScaleLookupCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl.callScaleLookup(CalculationRuleCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl.scaleCalculate(CalculationRuleCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl.performExecute(CalculationRuleCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl.callRuleCalculate(CalculationRuleCombineCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl.performExecute(CalculationRuleCombineCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl.callRuleCombine(CalculationCodeCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl.performExecute(CalculationCodeCalculateCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl.callCodeCalculate(ApplyCalculationUsageCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl.performExecute(ApplyCalculationUsageCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationHelper.applyCalculationUsages(CalculationHelper.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.calculateShippingAndTaxCharges(OrderProcessingHelper.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.calculateShippingTaxAndTotals(OrderProcessingHelper.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.updateOrderPricing(OrderProcessingHelper.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper.updateOrderPricing(OrderProcessingHelper.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.PrepareOrderCmdImpl.doProcess(PrepareOrderCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.commands.PrepareOrderCmdImpl.performExecute(PrepareOrderCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderPrepareCmdImpl.performExecute(OrderPrepareCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java(Compiled Code))
at com.ibm.sfc.cmd.TargetableCommandImpl.execute(TargetableCommandImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java(Compiled Code))
at com.owls.wcs.command.MyControllerCmdImpl.performExecute(MyControllerCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java(Compiled Code))
at com.ibm.sfc.cmd.TargetableCommandImpl.execute(TargetableCommandImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java(Compiled Code))
at com.ibm.commerce.webcontroller.ControllerCmdExecUnit.execute(ControllerCmdExecUnit.java(Compiled Code))
at com.ibm.commerce.webcontroller.WebController.executeTransaction(WebController.java(Compiled Code))
at com.ibm.commerce.webcontroller.WebController.processRequest(WebController.java(Compiled Code))
at com.ibm.commerce.adapter.AbstractHttpAdapter.processRequest(AbstractHttpAdapter.java(Compiled Code))
at com.ibm.commerce.server.RequestServlet.service(RequestServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java(Inlined Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code))
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001

John

2005-05-18 18:06:53 UTC

Permalink

I believe that I have solved the problem. Please disregard my 2 posts on this subject.

Thanks,
John

Post by John
The reason code of 2 indicates that the transaction was rolled back due to a deadlock. How do people avoid deadlocks? I'll admit that I am running on some low end hardware but I am not sure how much
of an impact that has on deadlocks. The error code explanation says that deadlocks are normal when certain SQL statements are run. It also recommends designing applications to avoid deadlocks. Is
there a way to tweak DB2 to avoid deadlocks? A point in the right direction would be helpful. How are people handling deadlocks in their WebSphere Commerce environments? I know that this is
semething that I need to research more but any guidance from people on this newsgroup would be appreciated.
Thanks,
John

t***@yahoo.com

2006-03-13 18:05:47 UTC

Permalink

Hi John,
I have similar problem. Do you mind to share how you solve the problem.

Thanks in advance
Alice

VijayaR

2006-11-16 15:40:46 UTC

Permalink

Hi Alice,

I am wondering whether you got through this deadlock issue. Our client is having the similar problem.

-thanks,
Vijaya