0035378: The ServerStateBackground process pings store server sequentially - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Retail Modules

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0035378

Retail Modules

StoreServer

public

2017-02-28 12:40

2017-07-03 11:16

Reporter

AugustoMauch

Assigned To

mtaal

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

AugustoMauch

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0035378: The ServerStateBackground process pings store server sequentially

Description

To determine the status of the store servers, the central servers pings them and requests their status.

The store servers are pinged sequentially, and it could be improved by pinging several servers in parallel.

Steps To Reproduce

-

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0035113		closed	mtaal	The ServerStateBackground server ping unregistered servers
has duplicate	feature request	0036147		closed	AugustoMauch	Use multhread to ping the status of the store servers
related to	defect	0036384		closed	AugustoMauch	Connection leak in ServerStateBackground is there are no servers to ping

Attached Files

Issue History

Date Modified

Username

Field

Change

2017-02-28 12:40

New Issue

2017-02-28 12:40

Assigned To

=> StoreServer

2017-02-28 12:40

Triggers an Emergency Pack

=> No

2017-02-28 12:41

Relationship added

related to 0035113

2017-03-16 19:24

Assigned To

StoreServer => AugustoMauch

2017-05-08 11:51

Assigned To

AugustoMauch => mtaal

2017-06-08 09:34

Review Assigned To

=> AugustoMauch

2017-06-08 09:34

Checkin

2017-06-08 09:34

Note Added: 0097200

2017-06-08 09:34

Status

new => resolved

2017-06-08 09:34

Resolution

open => fixed

2017-06-08 09:34

Fixed in SCM revision

=> http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5b9d05b616c97890bac563e72fcc415931f75f89 [^]

2017-06-08 09:43

Relationship added

has duplicate 0036147

2017-06-14 15:15

Note Added: 0097390

2017-06-14 15:15

Status

resolved => new

2017-06-14 15:15

Resolution

fixed => open

2017-06-19 13:05

Checkin

2017-06-19 13:05

Note Added: 0097477

2017-06-19 13:05

Status

new => resolved

2017-06-19 13:05

Resolution

open => fixed

2017-06-19 13:05

Fixed in SCM revision

http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5b9d05b616c97890bac563e72fcc415931f75f89 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/7edfb4a12cd4eec4d8a87c3a394b4c6ebd92ceae [^]

2017-06-23 11:07

Note Added: 0097604

2017-06-23 11:07

Status

resolved => closed

2017-07-03 11:05

Relationship added

related to 0036384

2017-07-03 11:16

Regression level

=> Packaging and release

2017-07-03 11:16

Regression date

=> 2017-06-08

2017-07-03 11:16

Regression introduced in release

=> RR17Q2

2017-07-03 11:16

Regression introduced by commit

=> https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5b9d05b616c97890bac563e72fcc415931f75f89 [^]

2017-07-03 11:16

Regression level

Packaging and release =>

2017-07-03 11:16

Regression date

2017-06-08 =>

2017-07-03 11:16

Regression introduced in release

RR17Q2 =>

2017-07-03 11:16

Regression introduced by commit

https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5b9d05b616c97890bac563e72fcc415931f75f89 [^] =>

Notes

Reopened due to a connection leak. A new connection is leaked each time the ping background process runs:

jun 14, 2017 3:12:32 PM org.apache.tomcat.jdbc.pool.ConnectionPool suspect
ADVERTENCIA: Connection has been marked suspect, possibly abandoned PooledConnection[org.postgresql.jdbc.PgConnection@50894650][30179 ms.]:java.lang.Exception
    at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1075)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:781)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:632)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:189)
    at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
    at org.openbravo.apachejdbcconnectionpool.JdbcExternalConnectionPool.getConnectionFromDS(JdbcExternalConnectionPool.java:130)
    at org.openbravo.apachejdbcconnectionpool.JdbcExternalConnectionPool.getConnection(JdbcExternalConnectionPool.java:110)
    at org.openbravo.dal.core.SessionHandler.getNewConnection(SessionHandler.java:300)
    at org.openbravo.dal.core.SessionHandler.createSession(SessionHandler.java:235)
    at org.openbravo.dal.core.SessionHandler.begin(SessionHandler.java:561)
    at org.openbravo.dal.core.SessionHandler.getSession(SessionHandler.java:183)
    at org.openbravo.dal.core.SessionHandler.find(SessionHandler.java:534)
    at org.openbravo.dal.core.SessionHandler.find(SessionHandler.java:500)
    at org.openbravo.dal.service.OBDal.get(OBDal.java:353)
    at org.openbravo.mobile.core.authenticate.MobileAuthenticationKeyUtils.getKey(MobileAuthenticationKeyUtils.java:133)
    at org.openbravo.mobile.core.authenticate.MobileAuthenticationKeyUtils.encrypt(MobileAuthenticationKeyUtils.java:88)
    at org.openbravo.mobile.core.authenticate.MobileAuthenticationKeyUtils.getEncryptedAuthenticationToken(MobileAuthenticationKeyUtils.java:77)
    at org.openbravo.mobile.core.servercontroller.MobileServerUtils.getAuthenticationQueryParams(MobileServerUtils.java:192)
    at org.openbravo.mobile.core.servercontroller.ServerStateBackground$PingRunnable.run(ServerStateBackground.java:414)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)