Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026030Openbravo ERPA. Platformpublic2014-03-18 15:452014-03-21 11:32
Reporteralostale 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2014-03-03
Regression introduced in release
Regression introduced by commithttp://code.openbravo.com/erp/devel/pi/rev/8845de885b879c0f2b58210ed144196a315969ac [^]
Triggers an Emergency PackNo
Summary0026030: OOM Error in Oracle due to prepared statements
DescriptionOOM in Oracle due to prepared statements stored in memory.

The problem is Oracle's JDBC allocates memory for prepared statements based on fetch size * row size. Big rows with big fetch sized consume lots of memory.
Steps To ReproduceAfter a while running the application with Oracle the memory usage is huge.

Checking a memory dump many prepared statements are present.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0024405 closed dmiguelez It is not possible to calculate warehouse transactions under some circunstancies 
related to design defect 0012418 acknowledged Triage Platform Base Cached prepared statements consumes tons of memory 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-03-18 15:45alostaleNew Issue
2014-03-18 15:45alostaleAssigned To => alostale
2014-03-18 15:45alostaleModules => Core
2014-03-18 15:45alostaleOBNetwork customer => No
2014-03-18 15:45alostaleTriggers an Emergency Pack => No
2014-03-18 15:46alostaleRegression level => Pre packaging ( pi )
2014-03-18 15:46alostaleRegression date => 2014-03-03
2014-03-18 15:46alostaleRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/8845de885b879c0f2b58210ed144196a315969ac [^]
2014-03-18 15:46alostalePrioritynormal => immediate
2014-03-18 15:48alostaleDescription Updatedbug_revision_view_page.php?rev_id=5589#r5589
2014-03-18 15:48alostaleRelationship addedrelated to 0024405
2014-03-18 15:48alostaleReview Assigned To => AugustoMauch
2014-03-18 15:50hgbotCheckin
2014-03-18 15:50hgbotNote Added: 0065265
2014-03-18 15:50hgbotStatusnew => resolved
2014-03-18 15:50hgbotResolutionopen => fixed
2014-03-18 15:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3f37631fbc2c47ab45051d20b1634914b9934b70 [^]
2014-03-18 15:51alostaleRelationship addedrelated to 0012418
2014-03-19 02:42hudsonbotCheckin
2014-03-19 02:42hudsonbotNote Added: 0065287
2014-03-21 11:32AugustoMauchNote Added: 0065354
2014-03-21 11:32AugustoMauchStatusresolved => closed
2014-03-21 11:32AugustoMauchFixed in Version => PR14Q2

Notes
(0065265)
hgbot   
2014-03-18 15:50   
Repository: erp/devel/pi
Changeset: 3f37631fbc2c47ab45051d20b1634914b9934b70
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Mar 18 15:49:50 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3f37631fbc2c47ab45051d20b1634914b9934b70 [^]

fixed bug 26030: OOM Error in Oracle due to prepared statements
  Reduced fetch size not to use so much memory

---
M src/org/openbravo/costing/CostingBackground.java
---
(0065287)
hudsonbot   
2014-03-19 02:42   
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/9b8682dba110 [^]
Maturity status: Test
(0065354)
AugustoMauch   
2014-03-21 11:32   
Code reviewed and verified in pi@617ac4497332. Check with the Financial team that this change does not interfere with this fix: https://code.openbravo.com/erp/devel/pi/rev/8845de885b879c0f2b58210ed144196a315969ac [^]