Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011044 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-10-20 03:11 | 2009-11-19 00:00 | |||
| Reporter | carbonete | View Status | public | |||||
| Assigned To | mtaal | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | ebff7c542c97 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.50MP3 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011044: Java out off memory in REST Query | |||||||
| Description | When executing in Openbravo Vmware appliance Openbravo 2.50 MP3 Version number: 2.50.14398 Revision ID: b3688248897f+ this query http://10.0.0.3/openbravo/ws/dal/Invoice?where=client.id=%271000000%27%20and%20organization.id%20=%20%271000000%27&l=xxxx&p=xxxxx [^] I receive this error <ob:error xmlns:ob="http://www.openbravo.com"><message>Java [^] heap space</message></ob:error> I sizeup tomcat to 1024M and virtual machine size to 1700M but don´t work I think that´s have a provlem in REST. thanks in advance Carbonete | |||||||
| Steps To Reproduce | Execute any query that´s return many lines. Like http://10.0.0.3/openbravo/ws/dal/BusinessPartner [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0021193) rafaroda (viewer) 2009-10-20 04:05 |
Happens also in http://demo4.openbravo.com/openbravo/ws/dal/BusinessPartner [^] which has many partner records and is a fine tuned machine. |
|
(0021701) hgbot (developer) 2009-11-10 23:39 |
Repository: erp/devel/pi Changeset: ebff7c542c9755c1d15458fcf16e3cf2e5ddea21 Author: Martin Taal <martin.taal <at> openbravo.com> Date: Tue Nov 10 23:39:23 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/ebff7c542c9755c1d15458fcf16e3cf2e5ddea21 [^] fixes issue 11044: Java out off memory in REST Query --- M src/org/openbravo/base/session/SessionFactoryController.java M src/org/openbravo/dal/service/OBQuery.java M src/org/openbravo/dal/xml/EntityXMLConverter.java M src/org/openbravo/service/rest/DalWebService.java --- |
|
(0021702) mtaal (viewer) 2009-11-10 23:50 |
Fyi, I made changes to use a stream based approach. So the objects are read from the database and directly streamed to the writer which writes the bytes to the browser. I tested and exporting 5000 business partners with invoice lines etc. never exceeds memory usage of 130mb and most of the time it is less than 100mb. I will also add a parameter includeChildren to make it possible to only export objects itself and not the child objects. gr. Martin |
|
(0021976) shuehner (administrator) 2009-11-18 16:27 |
Tested as failing in older pi and tested as server did not report any error on request for /<context>/ws/dal/Product with 25k products. Not verified that result load fine in a browser as 25k product xml does not load fine in browser and result will be loaded into some custom application in real cases. In current pi heapsize is stable and low will doing the rest query. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-10-20 03:11 | carbonete | New Issue | |
| 2009-10-20 03:11 | carbonete | Assigned To | => rafaroda |
| 2009-10-20 04:05 | rafaroda | OBNetwork customer | => No |
| 2009-10-20 04:05 | rafaroda | Note Added: 0021193 | |
| 2009-10-20 04:05 | rafaroda | Assigned To | rafaroda => mtaal |
| 2009-10-20 04:05 | rafaroda | Priority | normal => urgent |
| 2009-10-20 04:05 | rafaroda | Severity | critical => major |
| 2009-10-20 04:05 | rafaroda | Status | new => scheduled |
| 2009-11-10 23:39 | hgbot | Checkin | |
| 2009-11-10 23:39 | hgbot | Note Added: 0021701 | |
| 2009-11-10 23:39 | hgbot | Status | scheduled => resolved |
| 2009-11-10 23:39 | hgbot | Resolution | open => fixed |
| 2009-11-10 23:39 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ebff7c542c9755c1d15458fcf16e3cf2e5ddea21 [^] |
| 2009-11-10 23:50 | mtaal | Note Added: 0021702 | |
| 2009-11-18 16:27 | shuehner | Note Added: 0021976 | |
| 2009-11-18 16:27 | shuehner | Status | resolved => closed |
| 2009-11-19 00:00 | anonymous | sf_bug_id | 0 => 2900148 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |