Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0020533 | Openbravo ERP | A. Platform | public | 2012-04-13 09:29 | 2015-02-12 14:42 |
|
| Reporter | alostale | |
| Assigned To | alostale | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | out of date | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0020533: SessionInfo PreparedStatement is not closed |
| Description | When there is at least one table fully audited, on each request a temporary table (ad_context_info) is populated with context information. The PreparedStatement used for this population is never closed.
This causes a memory leak in JVM as well as DB not releasing resources (open cursors in Oracle) making the application to degrade over time.
See attached a screenshot of memory consumption just after GC having 6 concurrent sessions during ~10min with a session ping of 500ms to simulate long usage. Second screenshot is taken in the same conditions after applying the fix. Both are taken in an instance using Oracle. |
| Steps To Reproduce | -In a professional instance, set at last one table to be fully audited
-Follow steps defined in issue 0020146 |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | blocks | defect | 0020261 | 3.0MP11 | closed | alostale | SessionInfo PreparedStatement is not closed |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-05-17 09:20 | alostale | Type | defect => backport |
| 2012-05-17 09:20 | alostale | fix_in_branch | => 2.50 |
| 2012-05-17 09:21 | alostale | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/5dd00d37616387fda77cdc81862a423de3d8bce3 [^] => |
| 2012-05-17 09:21 | alostale | Target Version | 3.0MP11 => |
| 2012-05-17 11:28 | alostale | Priority | immediate => urgent |
| 2012-05-24 13:47 | egoitz | Issue Monitored: egoitz | |
| 2012-12-12 09:22 | ioritzCia | Triggers an Emergency Pack | => No |
| 2012-12-12 09:22 | ioritzCia | Severity | critical => major |
| 2015-02-12 14:42 | plujan | Note Added: 0074427 | |
| 2015-02-12 14:42 | plujan | Status | scheduled => closed |
| 2015-02-12 14:42 | plujan | Resolution | open => out of date |