Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029203Retail ModulesWeb POSpublic2015-03-09 13:202015-04-15 18:11
Reporterjecharri 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029203: Deadlocks have been detected when updating c_bpartner table OrderLoader
DescriptionDeadlocks have been detected in c_bpartner function using OrderLoader

-Postgres log
2015-03-09 11:25:28 UTC LOG: process 2192 detected deadlock while waiting for ShareLock on transaction 10826215 after 1000.058 ms
2015-03-09 11:25:28 UTC STATEMENT: update C_BPartner set Updated=$1, SO_CreditUsed=$2 where C_BPartner_ID=$3
2015-03-09 11:25:28 UTC ERROR: deadlock detected
2015-03-09 11:25:28 UTC DETAIL: Process 2192 waits for ShareLock on transaction 10826215; blocked by process 2191.
        Process 2191 waits for ExclusiveLock on tuple (1194,12) of relation 1182366 of database 1126881; blocked by process 2192.
        Process 2192: update C_BPartner set Updated=$1, SO_CreditUsed=$2 where C_BPartner_ID=$3
        Process 2191: update C_BPartner set Updated=$1, UpdatedBy=$2, SO_CreditUsed=$3 where C_BPartner_ID=$4
2015-03-09 11:25:28 UTC HINT: See server log for query details.
2015-03-09 11:25:28 UTC STATEMENT: update C_BPartner set Updated=$1, SO_CreditUsed=$2 where C_BPartner_ID=$3
2015-03-09 11:25:28 UTC ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-03-09 11:25:28 UTC STATEMENT: DELETE FROM AD_SESSION_STATUS


-openbravo log

d2f0c3a5 2015-03-09 11:25:11,290 [TP-Processor1] INFO org.openbravo.mobile.core.process.DataSynchronizationProcess - Total process org.openbravo.retail.posterminal.OrderLoader time: 1703
d2f0c3a5 2015-03-09 11:25:11,305 [TP-Processor1] INFO org.openbravo.mobile.core.process.DataSynchronizationProcess - Final total time: 1718
d2f0c3a5 2015-03-09 11:25:11,321 [TP-Processor1] INFO org.openbravo.mobile.core.process.SecuredJSONProcess - Process org.openbravo.retail.posterminal.OrderLoader took:1734ms params: {"data":[{"hasbeenpaid":"Y","isbeingprocessed":"Y","id":"3C9B1CD89D0FEBE2B9853AB15D2C697D","client":"4D4719F95EF1408D935D33F554A29E16","organization":"E08F9B7C927E43C39CEE99BD7D8062C9","createdBy":"10659378E37740FCAFB4559E08F6CB3F","updatedBy":"10659378E37740FCAFB4559E08F6CB3F","documentType":"C0038D25B6E946CCA3CF3187D9174CDA","orderType":0,"generateInvoice":true,"isQuotation":false,"oldId":null,"priceList":"0C88B756441F4A3D904BCC762DF4E2CC","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"BB16A2208A6D856545AE42FB21699ACA","warehouse":"6043DBA0DF7B49C98FF6EA5E59BE34BA","salesRepresentative":"10659378E37740FCAFB4559E08F6CB3F","salesRepresentative$_identifier":"Diego González","posTerminal":"F2F91083FB6B469D97078CB4EF1FB536","posTerminal$_identifier":"TPV - Obelisco - Diego González","orderDate":"2015-03-09T10:38:02.337Z","documentnoPrefix":"OBEDIEGON","quotationnoPrefix":-1,"documentnoSuffix":10129,"quotationnoSuffix":-1,"documentNo":"OBEDIEGON\/0010129","bp":{"id":"E56BB121DFDA43A4B022F46CEDC3C7DC","organization":"E08F9B7C927E43C39CEE99BD7D8062C9","searchKey":"TPV_OBELISCO","_identifier":"Obelisco - Venta contado","name":"Obelisco - Venta contado","description":null,"taxID":null,"taxCategory":null,"paymentMethod":"45A202BF44884F05B8A1BF741E2063B6","paymentTerms":"AB48BC05F7AC45F5AF1261A88212992D","priceList ":"undefined","invoiceTerms":"I","locId":"206EFF4074304A678FB6FE4496DE8CBB","locName":null,"postalCode":null,"cityName":null,"countryName":"Spain","contactId":null,"phone":null,"email":null,"businessPartnerCategory":"66B4C5952169447ABC1B0E261347998F","businessPartnerCategory_name":"Tiendas - Clientes Menor","creditLimit":0,"creditUsed":0,"taxExempt":false,"undefined":"Obelisco - Venta contado###null###null###null###","_idx":37},"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":"4D33E7D8075C448BAE4DAFE27CD3E84D","warehousename":"Almacén Jaime Pérez"},"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-09T10:38:07.109Z","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":1425897487819,"obposCreatedabsolute":"2015-03-09 10:38:07.819","obposAppCashup":"E30A01FA00AFA7EDFAAA857C8ADE20E8"}],"client":"4D4719F95EF1408D935D33F554A29E16","organization":"E08F9B7C927E43C39CEE99BD7D8062C9","pos":"F2F91083FB6B469D97078CB4EF1FB536","terminalName":"Obelisco-diegon","appName":"WebPOS"}
d2f0c3a5 2015-03-09 11:25:28,454 [TP-Processor1] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 update C_BPartner set Updated='2015-03-09 11:25:27.439000 +00:00:00', SO_CreditUsed='8.50' where C_BPartner_ID='8C3E780788664FCA802A03E524D51A0B' was aborted. Call getNextException to see the cause.
d2f0c3a5 2015-03-09 11:25:28,454 [TP-Processor1] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: deadlock detected
  Detail: Process 2192 waits for ShareLock on transaction 10826215; blocked by process 2191.
Process 2191 waits for ExclusiveLock on tuple (1194,12) of relation 1182366 of database 1126881; blocked by process 2192.
  Hint: See server log for query details.
d2f0c3a5 2015-03-09 11:25:28,459 [TP-Processor1] ERROR org.openbravo.dal.core.TriggerHandler - Couldn't enable triggers:
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
        at org.openbravo.dal.core.TriggerHandler.enable(TriggerHandler.java:107)
        at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:278)
        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 11:25:28,468 [TP-Processor1] 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.engine.ActionQueue.executeActions(ActionQueue.java:268)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
        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.createInvoice(OrderLoader.java:706)
        at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:234)
        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 update C_BPartner set Updated='2015-03-09 11:25:27.439000 +00:00:00', SO_CreditUsed='8.50' where C_BPartner_ID='8C3E780788664FCA802A03E524D51A0B' 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)
        ... 61 more
d2f0c3a5 2015-03-09 11:25:28,502 [TP-Processor1] 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.engine.ActionQueue.executeActions(ActionQueue.java:268)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
        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.createInvoice(OrderLoader.java:706)
        at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:234)
        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 update C_BPartner set Updated='2015-03-09 11:25:27.439000 +00:00:00', SO_CreditUsed='8.50' where C_BPartner_ID='8C3E780788664FCA802A03E524D51A0B' 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)
        ... 61 more
d2f0c3a5 2015-03-09 11:25:28,523 [TP-Processor1] INFO org.openbravo.mobile.core.process.DataSynchronizationProcess - Final total time: 2802
d2f0c3a5 2015-03-09 11:25:28,539 [TP-Processor1] INFO org.openbravo.mobile.core.process.SecuredJSONProcess - Process org.openbravo.retail.posterminal.OrderLoader took:2818ms params: {"data":[{"hasbeenpaid":"Y","isbeingprocessed":"Y","id":"D3D0930F815DEB188F0FA4234C7847BA","client":"4D4719F95EF1408D935D33F554A29E16","organization":"C25713CF3A4D4A61AF753B305208CC96","createdBy":"CCF95B0EE57A4C67A63C6E2CBD400BA7","updatedBy":"CCF95B0EE57A4C67A63C6E2CBD400BA7","documentType":"6D28F9A6D21E4B7CAEE835248660D9C6","orderType":0,"generateInvoice":true,"isQuotation":false,"oldId":null,"priceList":"0C88B756441F4A3D904BCC762DF4E2CC","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"8F3BBC46839BEE58C8D70EA9F9ABED65","warehouse":"9FA3BD5640CE401C90C8CD6841A48CA8","salesRepresentative":"CCF95B0EE57A4C67A63C6E2CBD400BA7","salesRepresentative$_identifier":"Mariangel Caraballo","posTerminal":"39AD903290A8441995950DE4258D2E09","posTerminal$_identifier":"TPV - Santa Catalina - Mariangel Caraballo","orderDate":"2015-03-09T10:38:08.370Z","documentnoPrefix":"SANMARCAR","quotationnoPrefix":-1,"documentnoSuffix":8692,"quotationnoSuffix":-1,"documentNo":"SANMARCAR\/0008692","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":14},"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,"pricene
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0029433RR15Q3 closed malsasua new process to process all records in "errors while importing data" window 
related to defect 0029202RR15Q3 closed marvintm Deadlocks have been detected in m_update_inventory function using OrderLoader 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-09 13:20jecharriNew Issue
2015-03-09 13:20jecharriAssigned To => marvintm
2015-03-09 13:20jecharriResolution time => 1427065200
2015-03-09 13:20jecharriTriggers an Emergency Pack => No
2015-03-09 13:20jecharriIssue generated from0029202
2015-03-09 13:22jecharriRelationship addedrelated to 0029202
2015-03-26 19:17malsasuaRelationship addedrelated to 0029433
2015-04-01 10:24mtaalDescription Updatedbug_revision_view_page.php?rev_id=8164#r8164
2015-04-01 10:56mtaalNote Added: 0076295
2015-04-01 10:57mtaalNote Added: 0076297
2015-04-01 10:58mtaalNote Deleted: 0076297
2015-04-01 10:58mtaalNote Added: 0076299
2015-04-01 10:58mtaalStatusnew => feedback
2015-04-15 17:34adrianromeroNote Added: 0076556
2015-04-15 18:11adrianromeroReview Assigned To => adrianromero
2015-04-15 18:11adrianromeroNote Added: 0076564
2015-04-15 18:11adrianromeroStatusfeedback => closed
2015-04-15 18:11adrianromeroResolutionopen => no change required

Notes
(0076295)
mtaal   
2015-04-01 10:56   
The status: customer will upgrade to postgres 9.3 which gives benefits in locking. This could solve this issue.

In addition we will research if updating credit makes sense to be done in the orderloader. Currently this is done always while it only could make sense if paying (partially) on credit.

gr. Martin
(0076299)
mtaal   
2015-04-01 10:58   
See previous remark
(0076556)
adrianromero   
2015-04-15 17:34   
Customer has upgraded to Posgresql 9.3 several days ago and database locks did not appear since then.
(0076564)
adrianromero   
2015-04-15 18:11   
Solved upgrading to Posgresql 9.3