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

View Revisions: Issue #29203 [ All Revisions ] [ Back to Issue ]
Summary 0029203: Deadlocks have been detected when updating c_bpartner table OrderLoader
Revision 2015-04-01 10:24 by mtaal
Description Deadlocks 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
Revision 2015-03-26 19:17 by mtaal
Description Deadlocks have been detected in m_update_inventory 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker