|
Home > Archive > WebSphere Commerce suite > March 2006 > More Info about this problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
More Info about this problem
|
|
|
| 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
On Wed, 18 May 2005 10:07:49 -0400, John <johnmg@owls.com> wrote:
>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. EJSJDBCPersisterCMPOrderItemAdjustmentBe
an. findByOrderItemIds(EJSJDBCPersisterCMPOr
derItemAdjustmentBean.java(Compiled Code))
> at com.ibm.commerce.order.objects.EJSCMPOrderItemAdjustmentHomeBean. findByOrderItemIds(EJSCMPOrderItemAdjust
mentHomeBean.java(Inlined Compiled Code))
> at com.ibm.commerce.order.objects.EJSRemoteCMPOrderItemAdjustmentHome. findByOrderItemIds(EJSRemoteCMPOrderItem
AdjustmentHome.java(Compiled Code))
> at com.ibm.commerce.order.objects._OrderItemAdjustmentHome_Stub. findByOrderItemIds(_OrderItemAdjustmentH
ome_Stub.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationHelper. getTaxableAdjustmentTotals(CalculationHe
lper.java(Compiled Code))
> at com.ibm.commerce.order.calculation. TaxableNetPriceCalculationScaleLookupCmd
Impl. performExecute(TaxableNetPriceCalculatio
nScaleLookupCmdImpl.java(Compiled Code))
> at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl. callScaleLookup(CalculationRuleCalculate
CmdImpl.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl. scaleCalculate(CalculationRuleCalculateC
mdImpl.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl. performExecute(CalculationRuleCalculateC
mdImpl.java(Compiled Code))
> at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl. callRuleCalculate(CalculationRuleCombine
CmdImpl.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl. performExecute(CalculationRuleCombineCmd
Impl.java(Compiled Code))
> at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl. callRuleCombine(CalculationCodeCalculate
CmdImpl.java(Compiled Code))
> at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl. performExecute(CalculationCodeCalculateC
mdImpl.java(Compiled Code))
> at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
> at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl. callCodeCalculate(ApplyCalculationUsageC
mdImpl.java(Compiled Code))
> at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl. performExecute(ApplyCalculationUsageCmdI
mpl.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(OrderProc
essingHelper.java(Compiled Code))
> at com.ibm.commerce.order.commands.OrderProcessingHelper. calculateShippingTaxAndTotals(OrderProce
ssingHelper.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(WebAppRequestDispat
cher.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
| |
|
| I believe that I have solved the problem. Please disregard my 2 posts on this subject.
Thanks,
John
On Wed, 18 May 2005 10:26:38 -0400, John <johnmg@owls.com> wrote:
[vbcol=seagreen]
>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
>
>On Wed, 18 May 2005 10:07:49 -0400, John <johnmg@owls.com> wrote:
>
| |
|
| Hi John,
I have similar problem. Do you mind to share how you solve the problem.
Thanks in advance
Alice
|
|
|
|
|