Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0038614
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2018-05-24 11:162018-05-25 09:13
ReportercaristuView Statuspublic 
Assigned Tocaristu 
PriorityhighResolutionfixedFixed in Version3.0PR18Q3
StatusclosedFix in branchFixed in SCM revision75b987d87e2d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038614: HeartbeatProcess can lead to database connection leaks under some circumstances

DescriptionHeartbeatProcess can lead to database connection leaks if when executing the process it happens one of the following:

a) The heartbeat is not yet active
b) Internet is not available
Steps To Reproduce0) Log-in in an Openbravo instance with the heartbeat not active.
1) Schedule the HeartbeatProcess to be executed every minute
2) Wait a couple of minutes
3) In the database, launch:

select count(*) from pg_stat_activity where state ilike '%in transaction%'

The query will return 2 (one dangling connection per process execution)
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0104669)
hgbot (developer)
2018-05-24 11:27

 Repository: erp/devel/pi
Changeset: 75b987d87e2d4bd081135d29d6ef2eb3d492277b
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu May 24 11:20:34 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/75b987d87e2d4bd081135d29d6ef2eb3d492277b [^]

fixes issue 38614: HeartbeatProcess can lead to database connection leaks

  The connection retrieved through OBDal was not being returned to the pool in the cases where the process can not complete its execution:

  - When the heartbeat is not active
  - When Internet is not available

---
M src/org/openbravo/erpCommon/ad_process/HeartbeatProcess.java
---
(0104675)
hudsonbot (viewer)
2018-05-24 15:49

 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/35639a647532 [^]
Maturity status: Test
(0104693)
alostale (viewer)
2018-05-25 09:13

 reviewed

- Issue History
Date Modified Username Field Change
2018-05-24 11:16 caristu New Issue
2018-05-24 11:16 caristu Assigned To => platform
2018-05-24 11:16 caristu OBNetwork customer => No
2018-05-24 11:16 caristu Modules => Core
2018-05-24 11:16 caristu Triggers an Emergency Pack => No
2018-05-24 11:27 hgbot Checkin
2018-05-24 11:27 hgbot Note Added: 0104669
2018-05-24 11:27 hgbot Status new => resolved
2018-05-24 11:27 hgbot Resolution open => fixed
2018-05-24 11:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/75b987d87e2d4bd081135d29d6ef2eb3d492277b [^]
2018-05-24 11:27 caristu Assigned To platform => caristu
2018-05-24 11:28 caristu Tag Attached: Performance
2018-05-24 11:28 caristu Review Assigned To => alostale
2018-05-24 15:49 hudsonbot Checkin
2018-05-24 15:49 hudsonbot Note Added: 0104675
2018-05-25 09:13 alostale Note Added: 0104693
2018-05-25 09:13 alostale Status resolved => closed
2018-05-25 09:13 alostale Fixed in Version => 3.0PR18Q3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker