In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
771 [In-Portal CMS] Data Management bug report always 2010-06-10 14:12 2010-11-30 12:48
Reporter: alex Platform:  
Assigned To: alex OS:  
Priority: normal OS Version:  
Status: closed Product Version: 5.0.2  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.1.1-B1  
Reference: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/f9b46b692ff68bf2
Change Log Message:
Estimate Points: 0
Summary: 0000771: Script eats up all memory during sub-item list printing
Description: I've recently discovered, that when we have sub-item (e.g. phrase, order items) list on the template with per_page="-1" parameter set, then it prints all records related to particular main item (e.g. language, order). This is not a problem, when we have main item ID somehow available on the page or in the url.

When main item ID is missing, then all data from the table is printed. When we have thousands of records in database, then printing them on one page will probably eat up all available memory. This is exactly what I've noticed.

To verify that try to set per_page="-1" for phrase list (under "regional" folder in administrative console) and then just visit phrase listing template from browser.
Steps To Reproduce:
Additional Information:
Relationships
parent of 0000915closed  (5.1.1)alex Link Comments are not Showing up in Admin 
Attached Files: patch always_set_sub_item_list_parent_filter.patch (3,132) 2010-06-10 14:12
http://tracker.in-portal.org/file_download.php?file_id=629&type=bug
patch always_set_sub_item_list_parent_filter_v2_(for_510).patch (1,447) 2010-07-31 09:03
http://tracker.in-portal.org/file_download.php?file_id=694&type=bug
Issue History
Date Modified Username Field Change
2010-11-30 12:48 Dmitry Note Added: 0003070
2010-11-30 12:48 Dmitry Status resolved => closed
2010-11-02 11:18 Dmitry Relationship added parent of 0000915
2010-08-28 16:14 alex Note Added: 0002714
2010-08-28 16:14 alex Status reviewed and tested => resolved
2010-08-28 16:14 alex Fixed in Version => 5.1.1-B1
2010-08-28 16:14 alex Resolution open => fixed
2010-08-28 16:14 alex Assigned To !COMMUNITY => alex
2010-08-28 16:14 alex Changeset attached 5.1.x r13882
2010-08-02 10:56 Dmitry Note Added: 0002641
2010-08-02 10:56 Dmitry Status needs testing => reviewed and tested
2010-07-31 13:19 Dmitry Target Version Icebox => 5.1.1
2010-07-31 09:03 alex Note Added: 0002633
2010-07-31 09:03 alex Assigned To alex => !COMMUNITY
2010-07-31 09:03 alex Status needs work => needs testing
2010-07-31 09:03 alex File Added: always_set_sub_item_list_parent_filter_v2_(for_510).patch
2010-07-30 18:57 Dmitry Note Added: 0002626
2010-07-30 18:57 Dmitry Assigned To !COMMUNITY => alex
2010-07-30 18:57 Dmitry Status needs testing => needs work
2010-06-10 14:12 alex Assigned To => !COMMUNITY
2010-06-10 14:12 alex Developer => alex
2010-06-10 14:12 alex Status active => needs testing
2010-06-10 14:12 alex New Issue
2010-06-10 14:12 alex File Added: always_set_sub_item_list_parent_filter.patch
2010-06-10 14:12 alex Reference => http://groups.google.com/group/in-portal-bugs/browse_thread/thread/f9b46b692ff68bf2

Notes
(0002626)
Dmitry   
2010-07-30 18:57   
Please re-assemble the patch for 5.1.0.
(0002633)
alex   
2010-07-31 09:03   
Re-assembled.
(0002641)
Dmitry   
2010-08-02 10:56   
2nd patch tested good, please commit into 5.1.1
(0002714)
alex   
2010-08-28 16:14   
Fix committed to 5.1.x branch. Commit Message:

Fixes 0000771: Script eats up all memory during sub-item list printing
(0003070)
Dmitry   
2010-11-30 12:48   
Closing released 5.1.1 task.