Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029202
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2015-03-09 13:152015-04-15 18:11
ReporterjecharriView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget VersionRR15Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customerOBPS
Support ticket33435
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029202: Deadlocks have been detected in m_update_inventory function using OrderLoader

DescriptionDeadlocks have been detected in m_update_inventory function using OrderLoader

-Postgres log
2015-03-09 12:05:20 UTC LOG: unexpected EOF on client connection
2015-03-09 12:22:11 UTC LOG: process 2174 detected deadlock while waiting for ShareLock on transaction 10831754 after 1000.068 ms
2015-03-09 12:22:11 UTC CONTEXT: SQL statement "UPDATE M_STORAGE_DETAIL
              SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
              QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
              DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
              PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
              PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
              AD_CLIENT_ID=p_client,
              AD_ORG_ID=p_org,
              UPDATED=TO_DATE(NOW()),
              UPDATEDBY=p_user
            WHERE M_PRODUCT_ID=p_product
              AND M_LOCATOR_ID=p_locator
              AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
              AND C_UOM_ID=p_uom
              AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
        PL/pgSQL function "m_update_inventory" line 65 at SQL statement
2015-03-09 12:22:11 UTC STATEMENT: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
2015-03-09 12:22:11 UTC ERROR: deadlock detected
2015-03-09 12:22:11 UTC DETAIL: Process 2174 waits for ShareLock on transaction 10831754; blocked by process 2175.
        Process 2175 waits for ShareLock on transaction 10831748; blocked by process 2174.
        Process 2174: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
        Process 2175: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
2015-03-09 12:22:11 UTC HINT: See server log for query details.
2015-03-09 12:22:11 UTC CONTEXT: SQL statement "UPDATE M_STORAGE_DETAIL
              SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
              QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
              DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
              PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
              PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
              AD_CLIENT_ID=p_client,
              AD_ORG_ID=p_org,
              UPDATED=TO_DATE(NOW()),
              UPDATEDBY=p_user
            WHERE M_PRODUCT_ID=p_product
              AND M_LOCATOR_ID=p_locator
              AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
              AND C_UOM_ID=p_uom
              AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
        PL/pgSQL function "m_update_inventory" line 65 at SQL statement
2015-03-09 12:22:11 UTC STATEMENT: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
2015-03-09 12:22:11 UTC ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-03-09 12:22:11 UTC STATEMENT: insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50)
2015-03-09 12:22:23 UTC LOG: could not receive data from client: Connection reset by peer


-openbravo log

d2f0c3a5 2015-03-09 12:22:11,980 [TP-Processor16] ERROR org.openbravo.base.exception.OBException - ERROR: deadlock detected
  Detail: Process 2174 waits for ShareLock on transaction 10831754; blocked by process 2175.
Process 2175 waits for ShareLock on transaction 10831748; blocked by process 2174.
  Hint: See server log for query details.
  Where: SQL statement "UPDATE M_STORAGE_DETAIL
      SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
      QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
      DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
      PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
      PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
      AD_CLIENT_ID=p_client,
      AD_ORG_ID=p_org,
      UPDATED=TO_DATE(NOW()),
      UPDATEDBY=p_user
    WHERE M_PRODUCT_ID=p_product
      AND M_LOCATOR_ID=p_locator
      AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
      AND C_UOM_ID=p_uom
      AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
PL/pgSQL function "m_update_inventory" line 65 at SQL statement
org.openbravo.base.exception.OBException: ERROR: deadlock detected
  Detail: Process 2174 waits for ShareLock on transaction 10831754; blocked by process 2175.
Process 2175 waits for ShareLock on transaction 10831748; blocked by process 2174.
  Hint: See server log for query details.
  Where: SQL statement "UPDATE M_STORAGE_DETAIL
      SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
      QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
      DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
      PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
      PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
      AD_CLIENT_ID=p_client,
      AD_ORG_ID=p_org,
      UPDATED=TO_DATE(NOW()),
      UPDATEDBY=p_user
    WHERE M_PRODUCT_ID=p_product
      AND M_LOCATOR_ID=p_locator
      AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
      AND C_UOM_ID=p_uom
      AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
PL/pgSQL function "m_update_inventory" line 65 at SQL statement
        at org.openbravo.retail.posterminal.OrderLoader.updateInventory(OrderLoader.java:1224)
        at org.openbravo.retail.posterminal.OrderLoader.handleStock(OrderLoader.java:1174)
        at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:253)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:117)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:87)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:51)
        at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:25)
        at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:39)
        at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154)
        at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77)
        at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:48)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
 at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:446)
        at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87)
        at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:701)
d2f0c3a5 2015-03-09 12:22:11,985 [TP-Processor16] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ('4D4719F95EF1408D935D33F554A29E16', 'C25713CF3A4D4A61AF753B305208CC96', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 12:22:10.864000 +00:00:00', 'F652F1FE9D6A421197F0B255B533569E', 'Y', 'DOCNO1425903730828', 'CO', 'RE', 'N', 'Y', 'N', '40EE9B1CD3B345FABEFDA62B407B407F', '40EE9B1CD3B345FABEFDA62B407B407F', 'BE96C6A434F30ABC473DE348654A326F', 'Relacionado con el pedido: SANJAIPER/0013004', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 00:00:00.000000 +00:00:00', '2015-03-09 00:00:00.000000 +00:00:00', '8C3E780788664FCA802A03E524D51A0B', '9B830D4D434B42F3BD0FDA35294EFF05', 'N', '2015-03-09 00:00:00.000000 +00:00:00', '102', 'P', 'AB48BC05F7
AC45F5AF1261A88212992D', '8.25', '8.50', '0C88B756441F4A3D904BCC762DF4E2CC', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', '8.50', '0', '8.50', 'N', '45A202BF44884F05B8A1BF741E2063B6', 'Y', 'N', 'RE', 'N', '71C2BFA7DEE446AD9F655CC1E6C698A4') was aborted. Call getNextException to see the cause.
d2f0c3a5 2015-03-09 12:22:11,986 [TP-Processor16] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is aborted, commands ignored until end of transaction block
d2f0c3a5 2015-03-09 12:22:11,994 [TP-Processor16] ERROR org.openbravo.mobile.core.process.DataSynchronizationProcess - An error happened when processing a record:
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2868)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.openbravo.dal.service.OBDal.flush(OBDal.java:205)
        at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:277)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:117)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:87)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:51)
        at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:25)
        at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:39)
        at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154)
        at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77)
        at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:48)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:446)
        at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87)
        at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:701)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ('4D4719F95EF1408D935D33F554A29E16', 'C25713CF3A4D4A61AF753B305208CC96', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 12:22:10.864000 +00:00:00', 'F652F1FE9D6A421197F0B255B533569E', 'Y', 'DOCNO1425903730828', 'CO', 'RE', 'N', 'Y', 'N', '40EE9B1CD3B345FABEFDA62B407B407F', '40EE9B1CD3B345FABEFDA62B407B407F', 'BE96C6A434F30ABC473DE348654A326F', 'Relacionado con el pedido: SANJAIPER/0013004', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 00:00:00.000000 +00:00:00', '2015-03-09 00:00:00.000000 +00:00:00', '8C3E780788664FCA802A03E524D51A0B', '9B830D4D434B42F3BD0FDA35294EFF05', 'N', '2015-03-09 00:00:00.000000 +00:00:00', '102', 'P', 'AB48BC05F7AC45F5AF1261A88212992D', '8.25', '8.50', '0C88B756441F4A3D904BCC762DF4E2CC', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', '8.50', '0', '8.50', 'N', '45A202BF44884F05B8A1BF741E2063B6', 'Y', 'N', 'RE', 'N', '71C2BFA7DEE446AD9F655CC1E6C698A4') was aborted. Call getNextException to see the cause.
        at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 67 more
d2f0c3a5 2015-03-09 12:22:12,010 [TP-Processor16] ERROR org.openbravo.mobile.core.process.DataSynchronizationProcess - Error while loading order
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2868)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.openbravo.dal.service.OBDal.flush(OBDal.java:205)
        at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:277)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:117)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:87)
        at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:51)
        at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:25)
        at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:39)
        at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154)
        at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77)
        at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:48)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:446)
        at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87)
        at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:701)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction,
 Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ('4D4719F95EF1408D935D33F554A29E16', 'C25713CF3A4D4A61AF753B305208CC96', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 12:22:10.864000 +00:00:00', 'F652F1FE9D6A421197F0B255B533569E', 'Y', 'DOCNO1425903730828', 'CO', 'RE', 'N', 'Y', 'N', '40EE9B1CD3B345FABEFDA62B407B407F', '40EE9B1CD3B345FABEFDA62B407B407F', 'BE96C6A434F30ABC473DE348654A326F', 'Relacionado con el pedido: SANJAIPER/0013004', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 00:00:00.000000 +00:00:00', '2015-03-09 00:00:00.000000 +00:00:00', '8C3E780788664FCA802A03E524D51A0B', '9B830D4D434B42F3BD0FDA35294EFF05', 'N', '2015-03-09 00:00:00.000000 +00:00:00', '102', 'P', 'AB48BC05F7AC45F5AF1261A88212992D', '8.25', '8.50', '0C88B756441F4A3D904BCC762DF4E2CC', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', '8.50', '0', '8.50', 'N', '45A202BF44884F05B8A1BF741E2063B6', 'Y', 'N', 'RE', 'N', '71C2BFA7DEE446AD9F655CC1E6C698A4') was aborted. Call getNextException to see the cause.
        at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 67 more
d2f0c3a5 2015-03-09 12:22:12,034 [TP-Processor16] INFO org.openbravo.mobile.core.process.DataSynchronizationProcess - Final total time: 2760
d2f0c3a5 2015-03-09 12:22:12,049 [TP-Processor16] INFO org.openbravo.mobile.core.process.SecuredJSONProcess - Process org.openbravo.retail.posterminal.OrderLoader took:2775ms params: {"data":[{"hasbeenpaid":"Y","isbeingprocessed":"Y","id":"BE96C6A434F30ABC473DE348654A326F","client":"4D4719F95EF1408D935D33F554A29E16","organization":"C25713CF3A4D4A61AF753B305208CC96","createdBy":"F652F1FE9D6A421197F0B255B533569E","updatedBy":"F652F1FE9D6A421197F0B255B533569E","documentType":"6D28F9A6D21E4B7CAEE835248660D9C6","orderType":0,"generateInvoice":true,"isQuotation":false,"oldId":null,"priceList":"0C88B756441F4A3D904BCC762DF4E2CC","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"5E4EEA6C9292D05AF4D5C6CB5ED8C684","warehouse":"4D33E7D8075C448BAE4DAFE27CD3E84D","salesRepresentative":"F652F1FE9D6A421197F0B255B533569E","salesRepresentative$_identifier":"Jaime Pérez","posTerminal":"69DBEDD2955349C4BAF04BA33FC95F24","posTerminal$_identifier":"TPV - Santa Catalina - Jaime Pérez","orderDate":"2015-03-09T11:34:16.041Z","documentnoPrefix":"SANJAIPER","quotationnoPrefix":-1,"documentnoSuffix":13004,"quotationnoSuffix":-1,"documentNo":"SANJAIPER\/0013004","bp":{"id":"8C3E780788664FCA802A03E524D51A0B","organization":"C25713CF3A4D4A61AF753B305208CC96","searchKey":"TPV_SANTA_CATALINA","_identifier":"Santa Catalina - Venta Contado","name":"Santa Catalina - Venta Contado","description":null,"taxID":null,"taxCategory":null,"paymentMethod":"45A202BF44884F05B8A1BF741E2063B6","paymentTerms":"AB48BC05F7AC45F5AF1261A88212992D","priceList ":"undefined","invoiceTerms":"I","locId":"9B830D4D434B42F3BD0FDA35294EFF05","locName":null,"postalCode":"35008","cityName":"","countryName":"Spain","contactId":null,"phone":null,"email":null,"businessPartnerCategory":"66B4C5952169447ABC1B0E261347998F","businessPartnerCategory_name":"Tiendas - Clientes Menor","creditLimit":0,"creditUsed":0,"taxExempt":false,"undefined":"Santa Catalina - Venta Contado###null###null###null###","_idx":10},"lines":[{"product":{"id":"2121FB5F80094EEF8F87EDD7F6E5DA54","searchkey":"24275","uPCEAN":null,"uOM":"100","uOMsymbol":"Ud ","productCategory":"DD46CBE77D2E49A08E6E4EBA1BDEB0C3","taxCategory":"98330D5715B748CCBA8386604586ACA9","description":"BONO 10 VIAJES DISEÑO 2013","obposScale":false,"groupProduct":true,"stocked":true,"showstock":false,"isGeneric":false,"generic_product_id":null,"brand":null,"characteristicDescription":null,"showchdesc":true,"bestseller":false,"ispack":false,"listPrice":8.5,"standardPrice":8.5,"priceLimit":0,"cost":0,"algorithm":"S","_identifier":"BONO GUAGUA 10 VIAJES","undefined":"24275###null###BONO GUAGUA 10 VIAJES###","_idx":2,"originalStandardPrice":8.5},"productidentifier":null,"uOM":"100","qty":1,"price":8.5,"priceList":8.5,"gross":8.5,"net":8.25242718,"description":"","priceIncludesTax":true,"warehouse":{"id":"92F5FCB0843A4F7B8CB405BB0B74C7E8","warehousename":"Almacén Carmen Santana"},"promotions":null,"discountedLinePrice":null,"promotionCandidates":null,"linerate":{"ind":1,"form":0,"mant":[1,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"exp":-20},"tax":"0F9D478DF69C4A03BB3CD83C49567009","taxAmount":0.24757282,"pricenet":8.25242718,"discountedNet":8.25242718,"taxLines":{"0F9D478DF69C4A03BB3CD83C49567009":{"name":"Servicios prestados en Canarias 3%","rate":3,"net":8.25242718,"amount":0.24757282}},"discountPercentage":0,"listPrice":8.25242718,"standardPrice":8.25242718,"grossListPrice":8.5,"grossUnitPrice":8.5,"lineGrossAmount":8.5}],"payments":[{"amount":8.5,"origAmount":8.5,"paid":8.5,"date":"2015-03-09T11:34:29.627Z","kind":"OBPOS_payment.cash","name":"Al contado","rate":"1","mulrate":"1.000000000000","isocode":"EUR","allowOpenDrawer":true,"isCash":true,"openDrawer":false,"printtwice":false}],"payment":8.5,"change":0,"qty":1,"gross":8.5,"net":8.25242718,"taxes":{"0F9D478DF69C4A03BB3CD83C49567009":{"name":"Servicios prestados en Canarias 3%","rate":3,"net":8.25242718,"amount":0.24757282}},"description":"","print":true,"sendEmail":false,"isPaid":false,"paidOnCredit":false,"isLayaway":false,"isEditable":true,"openDrawer":false,"totalamount":null,"approvals":[],"isNewReceipt":false,"cloningReceipt":false,"timezoneOffset":0,"created":1425900870078,"obposCreatedabsolute":"2015-03-09 11:34:30.078","obposAppCashup":"BD9B349BDBD361F394002CE17F3B066E","bpLocId":null,"businessPartner$_identifier":null,"totalNetAmount":null,"orderid":null,"receiptLines":null,"receiptPayments":null,"receiptTaxes":null}],"client":"4D4719F95EF1408D935D33F554A29E16","organization":"C25713CF3A4D4A61AF753B305208CC96","pos":"69DBEDD2955349C4BAF04BA33FC95F24","terminalName":"SCatalina-Jaiper","appName":"WebPOS"}
d2f0c3a5 2015-03-09 12:22:12,188 [TP-Processor20] INFO org.openbravo.retail.posterminal.OrderLoader - Order with docno: TEAMILMON/0000834 (uuid: CF48531D267AB2FCF014A368AD3233B0) saved correctly. Initial flush: 0; Generate bobs:1379; Save bobs:0; First flush:0; Second flush: 1047; Process Payments:118 Final flush: 3
Steps To Reproduce-
TagsNo tags attached.
Attached Filesgz file icon logs.tar.gz [^] (307,194 bytes) 2015-03-09 13:23

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0029203 closedmarvintm Deadlocks have been detected when updating c_bpartner table OrderLoader 

-  Notes
(0076294)
mtaal (viewer)
2015-04-01 10:55

 The status: customer will upgrade to postgres 9.3 which gives benefits in locking.

Locking on the inventory will be solved in WebPOS through what is called the Openbravo High Volume Environment developments.

gr. Martin
(0076296)
mtaal (viewer)
2015-04-01 10:57

 see previous remark
(0076557)
adrianromero (viewer)
2015-04-15 17:36

 Customer has upgraded to Posgresql 9.3 several days ago and database locks did not appear since then.
(0076565)
adrianromero (viewer)
2015-04-15 18:11

 Solved upgrading to Posgresql 9.3

- Issue History
Date Modified Username Field Change
2015-03-09 13:15 jecharri New Issue
2015-03-09 13:15 jecharri Assigned To => marvintm
2015-03-09 13:15 jecharri OBNetwork customer => Yes
2015-03-09 13:15 jecharri Support ticket => 33435
2015-03-09 13:15 jecharri Resolution time => 1427065200
2015-03-09 13:15 jecharri Triggers an Emergency Pack => No
2015-03-09 13:20 jecharri Issue cloned 0029203
2015-03-09 13:22 jecharri Relationship added related to 0029203
2015-03-09 13:23 jecharri File Added: logs.tar.gz
2015-03-30 14:01 jonalegriaesarte Target Version RR15Q2 => RR15Q3
2015-04-01 10:55 mtaal Note Added: 0076294
2015-04-01 10:57 mtaal Note Added: 0076296
2015-04-01 10:57 mtaal Status new => feedback
2015-04-15 17:36 adrianromero Note Added: 0076557
2015-04-15 18:11 adrianromero Review Assigned To => adrianromero
2015-04-15 18:11 adrianromero Note Added: 0076565
2015-04-15 18:11 adrianromero Status feedback => closed
2015-04-15 18:11 adrianromero Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker