Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035704Openbravo ERPA. Platformpublic2017-04-05 16:032020-09-01 13:16
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q3Fixed in Version3.0PR17Q3 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035704: add support to log abandoned pool connections
DescriptionTomcat JCDB pool supports to log abandoned connections, this is, connections that were borrowed from pool but not returned for a configurable period of time.

This is configured with logAbandoned and suspectTimeout properties [1] which are not currently supported in Openbravo.

---
[1] https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html [^]
Steps To Reproduce-
Proposed Solution* Add support for these properties
* Update to a recent pool version as current one (7.0.62) has some bugs that prevent this feature to work properly
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0044949 closed caristu Update Tomcat JDBC pool library 
blocks defect 0036261 closed alostale connections logged as abandoned in translate task 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-04-05 16:03alostaleNew Issue
2017-04-05 16:03alostaleAssigned To => alostale
2017-04-05 16:03alostaleModules => Core
2017-04-05 16:03alostaleTriggers an Emergency Pack => No
2017-04-05 16:03alostaleStatusnew => scheduled
2017-04-05 16:15alostaleNote Added: 0095848
2017-04-06 07:54alostaleReview Assigned To => caristu
2017-04-06 07:55hgbotCheckin
2017-04-06 07:55hgbotNote Added: 0095856
2017-04-06 07:55hgbotStatusscheduled => resolved
2017-04-06 07:55hgbotResolutionopen => fixed
2017-04-06 07:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0f2b56e1c053b9761764086c74d889e5539a7b94 [^]
2017-04-07 09:26caristuNote Added: 0095888
2017-04-07 09:26caristuStatusresolved => closed
2017-04-07 09:26caristuFixed in Version => 3.0PR17Q3
2017-05-29 17:43hudsonbotCheckin
2017-05-29 17:43hudsonbotNote Added: 0096865
2017-06-16 10:58alostaleRelationship addedblocks 0036261
2020-09-01 13:16caristuIssue cloned0044949
2020-09-01 13:16caristuRelationship addedrelated to 0044949

Notes
(0095848)
alostale   
2017-04-05 16:15   
Documented in http://wiki.openbravo.com/wiki/Modules:Apache_JDBC_Connection_Pool#Pool_Configuration [^]
(0095856)
hgbot   
2017-04-06 07:55   
Repository: erp/devel/pi
Changeset: 0f2b56e1c053b9761764086c74d889e5539a7b94
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Apr 04 07:44:44 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0f2b56e1c053b9761764086c74d889e5539a7b94 [^]

fixed issue 35704: add support to log abandoned pool connections

  Now it is possible to configure jdbc pool to log abandoned connections.

    * Added support for db.pool.logAbandoned and db.pool.suspectTimeout properties
      to configure this feature.
    * Updated pool to version 7.0.77 which fixes some bugs related with this topic
      that previous version had.

---
M modules/org.openbravo.apachejdbcconnectionpool/lib/runtime/tomcat-jdbc.jar
M modules/org.openbravo.apachejdbcconnectionpool/src/org/openbravo/apachejdbcconnectionpool/JdbcExternalConnectionPool.java
---
(0095888)
caristu   
2017-04-07 09:26   
Verified
(0096865)
hudsonbot   
2017-05-29 17:43   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/1ee70113bdc4 [^]
Maturity status: Test