Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020498Openbravo ERPA. Platformpublic2012-05-14 18:452012-05-25 12:12
Reportershuehner 
Assigned Toalostale 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020498: With big number of rows in ad_session SqlC somtimes fail with OOM regarding heap-space
DescriptionWith a sufficiently high number of rows in ad_session sometimes compilation fails with an OOM error regarding heap-space when processing the SessionLogin_data.xsql file.

Checking it shows that the first method in that file does 'select * from ad_session' without any filters but is never ever called from the erp.

As the xsql-file is not public that dummy method should be fixed or just be removed.
Steps To Reproducei.e. compile on butler
Proposed SolutionReorder SqlMethods in that file not require an unused dummy method.

Attached patch implements that (only compile tested)

Additional Information
TagsPerformance
Relationships
Attached Filesdiff xsql-oom-ad_session.diff (1,503) 2012-05-14 18:45
https://issues.openbravo.com/file_download.php?file_id=5219&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-05-14 18:45shuehnerNew Issue
2012-05-14 18:45shuehnerAssigned To => alostale
2012-05-14 18:45shuehnerFile Added: xsql-oom-ad_session.diff
2012-05-14 18:45shuehnerModules => Core
2012-05-16 08:23alostaleTag Attached: Performance
2012-05-16 08:25hgbotCheckin
2012-05-16 08:25hgbotNote Added: 0048669
2012-05-16 08:25hgbotStatusnew => resolved
2012-05-16 08:25hgbotResolutionopen => fixed
2012-05-16 08:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d4ef642f1e2aea82ef2afa8619f971f00f82272a [^]
2012-05-16 08:25alostaleNote Added: 0048670
2012-05-16 08:25alostaleStatusresolved => closed
2012-05-16 08:25alostaleFixed in Version => 3.0MP12
2012-05-25 12:12hudsonbotCheckin
2012-05-25 12:12hudsonbotNote Added: 0049142

Notes
(0048669)
hgbot   
2012-05-16 08:25   
Repository: erp/devel/pi
Changeset: d4ef642f1e2aea82ef2afa8619f971f00f82272a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed May 16 08:24:37 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d4ef642f1e2aea82ef2afa8619f971f00f82272a [^]

fixed bug 20498: Heap space error in SqlC with big number of rows in ad_session

---
M src/org/openbravo/erpCommon/security/SessionLogin_data.xsql
---
(0048670)
alostale   
2012-05-16 08:25   
Code reviewed and tested on pi@d4ef642f1e2a
(0049142)
hudsonbot   
2012-05-25 12:12   
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/5401e185a8b0 [^]

Maturity status: Test