Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016987 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] C. Security | minor | always | 2011-05-03 18:57 | 2011-07-13 13:15 | |||
| Reporter | aguilarc | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | high | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | 2.50MP9 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0016987: Synch ERP - POS | |||||||
| Description | When I try to synch to shops (POS) at the same time, we have this error and a POS fails. It's the log 21:19:04 [http-8080-Processor16] INFO org.openbravo.pos.sync.rest.POSWebService - POS Import process found: Attribute 21:19:04 [http-8080-Processor10] ERROR org.openbravo.base.secureApp.SeguridadData - Exception in query: SELECT AD_USER_ID FROM AD_USER WHERE ISACTIVE = 'Y' AND USERNAME = ? AND PASSWORD = ?Exception:java.lang.IllegalStateException: org.postgresql.util.PSQLException: ERROR: tuple concurrently updated 21:19:04 [http-8080-Processor10] ERROR org.openbravo.base.exception.OBException - @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.base.secureApp.SeguridadData.valido(SeguridadData.java:163) at org.openbravo.base.secureApp.LoginUtils.getValidUserId(LoginUtils.java:53) at org.openbravo.service.web.BaseWebServiceServlet.isLoggedIn(BaseWebServiceServlet.java:117) at org.openbravo.service.web.BaseWebServiceServlet.service(BaseWebServiceServlet.java:65) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:93) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 21:19:04 [http-8080-Processor10] ERROR org.openbravo.dal.core.ThreadHandler - javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated org.openbravo.base.exception.OBException: javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.base.secureApp.LoginUtils.getValidUserId(LoginUtils.java:59) at org.openbravo.service.web.BaseWebServiceServlet.isLoggedIn(BaseWebServiceServlet.java:117) at org.openbravo.service.web.BaseWebServiceServlet.service(BaseWebServiceServlet.java:65) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:93) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Caused by: javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.base.secureApp.SeguridadData.valido(SeguridadData.java:163) at org.openbravo.base.secureApp.LoginUtils.getValidUserId(LoginUtils.java:53) ... 28 more 21:19:04 [http-8080-Processor10] ERROR org.openbravo.base.exception.OBException - Exception thrown javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated org.openbravo.base.exception.OBException: javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.base.secureApp.LoginUtils.getValidUserId(LoginUtils.java:59) at org.openbravo.service.web.BaseWebServiceServlet.isLoggedIn(BaseWebServiceServlet.java:117) at org.openbravo.service.web.BaseWebServiceServlet.service(BaseWebServiceServlet.java:65) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:93) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Caused by: javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.base.secureApp.SeguridadData.valido(SeguridadData.java:163) at org.openbravo.base.secureApp.LoginUtils.getValidUserId(LoginUtils.java:53) ... 28 more 21:19:04 [http-8080-Processor10] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OB250].[M8B7776CB913C4AA691B099647862D191] - Servlet.service() para servlet M8B7776CB913C4AA691B099647862D191 lanzó excepción org.openbravo.base.exception.OBException: Exception thrown javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:63) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:93) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Caused by: org.openbravo.base.exception.OBException: javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.base.secureApp.LoginUtils.getValidUserId(LoginUtils.java:59) at org.openbravo.service.web.BaseWebServiceServlet.isLoggedIn(BaseWebServiceServlet.java:117) at org.openbravo.service.web.BaseWebServiceServlet.service(BaseWebServiceServlet.java:65) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) ... 15 more Caused by: javax.servlet.ServletException: @CODE=@org.postgresql.util.PSQLException: ERROR: tuple concurrently updated at org.openbravo.base.secureApp.SeguridadData.valido(SeguridadData.java:163) at org.openbravo.base.secureApp.LoginUtils.getValidUserId(LoginUtils.java:53) ... 28 more | |||||||
| Steps To Reproduce | Sincronize two POS at the same time using OB Synch Module | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0039036) emartinez (viewer) 2011-07-13 13:06 |
We proceed to close this issue since it is duplicated: https://issues.openbravo.com/view.php?id=17975 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-05-03 18:57 | aguilarc | New Issue | |
| 2011-05-03 18:57 | aguilarc | Assigned To | => alostale |
| 2011-05-03 18:57 | aguilarc | Modules | => Core |
| 2011-05-05 09:09 | alostale | Assigned To | alostale => adrianromero |
| 2011-05-21 00:07 | aguilarc | Issue Monitored: aguilarc | |
| 2011-06-03 10:57 | dalsasua | Assigned To | adrianromero => dalsasua |
| 2011-07-13 13:06 | emartinez | Note Added: 0039036 | |
| 2011-07-13 13:15 | adrianromero | Relationship added | duplicate of 0017975 |
| 2011-07-13 13:15 | adrianromero | Status | new => closed |
| 2011-07-13 13:15 | adrianromero | Resolution | open => duplicate |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |