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

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

0029203: 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-
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0029433RR15Q3 closedmalsasua new process to process all records in "errors while importing data" window 
related to defect 0029202RR15Q3 closedmarvintm Deadlocks have been detected in m_update_inventory function using OrderLoader 

-  Notes
(0076295)
mtaal (viewer)
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 (viewer)
2015-04-01 10:58

 See previous remark
(0076556)
adrianromero (viewer)
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 (viewer)
2015-04-15 18:11

 Solved upgrading to Posgresql 9.3

- Issue History
Date Modified Username Field Change
2015-03-09 13:20 jecharri New Issue
2015-03-09 13:20 jecharri Assigned To => marvintm
2015-03-09 13:20 jecharri OBNetwork customer => Yes
2015-03-09 13:20 jecharri Support ticket => 33435
2015-03-09 13:20 jecharri Resolution time => 1427065200
2015-03-09 13:20 jecharri Triggers an Emergency Pack => No
2015-03-09 13:20 jecharri Issue generated from 0029202
2015-03-09 13:22 jecharri Relationship added related to 0029202
2015-03-26 19:17 malsasua Relationship added related to 0029433
2015-04-01 10:24 mtaal Description Updated View Revisions
2015-04-01 10:56 mtaal Note Added: 0076295
2015-04-01 10:57 mtaal Note Added: 0076297
2015-04-01 10:58 mtaal Note Deleted: 0076297
2015-04-01 10:58 mtaal Note Added: 0076299
2015-04-01 10:58 mtaal Status new => feedback
2015-04-15 17:34 adrianromero Note Added: 0076556
2015-04-15 18:11 adrianromero Review Assigned To => adrianromero
2015-04-15 18:11 adrianromero Note Added: 0076564
2015-04-15 18:11 adrianromero Status feedback => closed
2015-04-15 18:11 adrianromero Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker