0039724: Starting tomcat in a store server leaves an open connection

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0039724

Retail Modules

StoreServer

public

2018-11-30 13:50

2018-12-01 18:49

Reporter

ioritzCia

Assigned To

mtaal

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

duplicate

Platform

OS Version

CentOS 6.9

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0039724: Starting tomcat in a store server leaves an open connection

Description

Starting tomcat in a store server leaves an open connection

Steps To Reproduce

Start tomcat in a store server
See the catalina.out file:

28-Nov-2018 21:42:35.804 WARNING [Tomcat JDBC Pool Cleaner[1641154899:1543522235798]] org.apache.tomcat.jdbc.pool.ConnectionPool.suspect Connection has been marked suspect, possibly abandoned PooledConnection[org.postgresql.jdbc.PgConnection@6ccf2461][638737 ms.]:java.lang.Exception
        at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1096)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:799)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:648)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:200)
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
        at org.openbravo.apachejdbcconnectionpool.JdbcExternalConnectionPool.getConnectionFromDS(JdbcExternalConnectionPool.java:134)
        at org.openbravo.apachejdbcconnectionpool.JdbcExternalConnectionPool.getConnection(JdbcExternalConnectionPool.java:114)
        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.servercontroller.MobileServerController.getThisServerDefinition(MobileServerController.java:407)
        at org.openbravo.mobile.core.servercontroller.MobileServerController.getThisMobileServerState(MobileServerController.java:381)
        at org.openbravo.mobile.core.servercontroller.MobileServerController.transitionToOnline(MobileServerController.java:583)
        at org.openbravo.replication.symmetricds.SetupSymmetricListener.startTransitionToOnline(SetupSymmetricListener.java:168)
        at org.openbravo.replication.symmetricds.SetupSymmetricListener.access$200(SetupSymmetricListener.java:69)
        at org.openbravo.replication.symmetricds.SetupSymmetricListener$CheckReloadStatus.run(SetupSymmetricListener.java:499)
        at java.lang.Thread.run(Thread.java:745)

Proposed Solution

Additional Information