Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006342Openbravo ERPA. Platformpublic2008-12-03 10:102009-02-20 10:58
mtaal 
alostale 
normalminorrandom
closedunable to reproduce 
5
2.50alpha-r2 
 
Core
No
0006342: Strange exception trace in console: ERROR: tuple concurrently updated
On postgresql I see a strange exception trace appearing at various times. It is thrown when a connection is created and the default sql is executed. In Openbravo.properties the default sql setting for me:
bbdd.sessionConfig=select update_dateFormat('DD-MM-YYYY')

The application works fine, so the exception does not seem to influence the working of the application.

Dec 3, 2008 9:17:59 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 25839 ms
org.postgresql.util.PSQLException: ERROR: tuple concurrently updated
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236)
    at org.openbravo.database.OpenbravoDriverManagerConnectionFactory.executeDefaultSQL(OpenbravoDriverManagerConnectionFactory.java:67)
    at org.openbravo.database.OpenbravoDriverManagerConnectionFactory.createConnection(OpenbravoDriverManagerConnectionFactory.java:56)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
    at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:207)
    at org.openbravo.database.ConnectionProviderImpl.getConnection(ConnectionProviderImpl.java:210)
    at org.openbravo.database.ConnectionProviderImpl.getPreparedStatement(ConnectionProviderImpl.java:274)
    at org.openbravo.database.ConnectionProviderImpl.getPreparedStatement(ConnectionProviderImpl.java:264)
    at org.openbravo.database.CPStandAlone.getPreparedStatement(CPStandAlone.java:75)
    at org.openbravo.uiTranslation.TextInterfacesData.selectText(TextInterfacesData.java:267)
    at org.openbravo.uiTranslation.TextInterfacesData.selectText(TextInterfacesData.java:58)
    at org.openbravo.uiTranslation.TranslationUtils.retrieveLabelData(TranslationUtils.java:185)
    at org.openbravo.uiTranslation.TranslationUtils.processFormLabels(TranslationUtils.java:33)
    at org.openbravo.uiTranslation.TranslationHandler.processTranslations(TranslationHandler.java:212)
    at org.openbravo.uiTranslation.TranslationHandler.generateTranslations(TranslationHandler.java:114)
    at org.openbravo.xmlEngine.XmlDocument.print(XmlDocument.java:305)
    at org.openbravo.xmlEngine.XmlDocument.print(XmlDocument.java:251)
    at org.openbravo.erpCommon.security.Login.printPageWelcome(Login.java:112)
    at org.openbravo.erpCommon.security.Login.doPost(Login.java:54)
    at org.openbravo.base.HttpBaseServlet.doGet(HttpBaseServlet.java:275)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at org.openbravo.base.HttpBaseServlet.service(HttpBaseServlet.java:239)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:52)
    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:27)
    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:83)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:48)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:89)
    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:230)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:619)
platform1_sprint1
Issue History
2008-12-03 10:10mtaalNew Issue
2008-12-03 10:10mtaalAssigned To => rafaroda
2008-12-03 10:10mtaalsf_bug_id0 => 2381654
2008-12-03 10:10mtaalRegression testing => No
2008-12-16 17:38rafarodaStatusnew => scheduled
2008-12-16 17:38rafarodaAssigned Torafaroda => alostale
2008-12-16 17:38rafarodafix_in_branch => trunk
2008-12-17 11:02alostaleTag Attached: platform1_sprint1
2009-02-20 10:58alostaleStatusscheduled => closed
2009-02-20 10:58alostaleNote Added: 0013810
2009-02-20 10:58alostaleResolutionopen => unable to reproduce

Notes
(0013810)
alostale   
2009-02-20 10:58   
With the current trunk revision (13444) I don't see this error, does it still happen to you?