In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
827 [In-Portal CMS] Data Management bug report always 2010-08-14 03:24 2010-11-30 12:48
phil  
alex  
normal  
closed 5.1.0  
fixed  
 
none 5.1.1-B1  
http://groups.google.com/group/in-portal-bugs/browse_thread/thread/55054c2742eda579
0
0000827: Debugger eats up all memory on index page
Got this error (in web.log) while visiting index page of the site.

Fatal error: Allowed memory size of 52428800 bytes exhausted (tried to allocate 146 bytes) in .../core/kernel/utility/debugger.php on line 678
Using PHP 4.3.9
related to 0000869closed  (5.1.1)alex First opening of Admin Console takes 5 seconds with Memory Caching enabled 
patch php4_and_cached_menu_eating_memory_fix.patch (528) 2010-08-14 03:24
http://tracker.in-portal.org/file_download.php?file_id=714&type=bug
patch performance_improvement_to_menu_cache_builder.patch (2,766) 2010-08-14 09:07
http://tracker.in-portal.org/file_download.php?file_id=716&type=bug
Issue History
2010-11-30 12:48 Dmitry Note Added: 0003071
2010-11-30 12:48 Dmitry Status resolved => closed
2010-09-18 06:23 alex Relationship added related to 0000869
2010-08-28 16:09 alex Note Added: 0002713
2010-08-28 16:09 alex Status reviewed and tested => resolved
2010-08-28 16:09 alex Fixed in Version => 5.1.1-B1
2010-08-28 16:09 alex Resolution open => fixed
2010-08-28 16:09 alex Assigned To !COMMUNITY => alex
2010-08-28 16:09 alex Changeset attached 5.1.x r13881
2010-08-26 17:21 Dmitry Target Version 5.1.1-B1 => 5.1.1
2010-08-26 17:10 Dmitry Note Added: 0002667
2010-08-26 17:10 Dmitry Status needs testing => reviewed and tested
2010-08-14 09:11 alex Note Added: 0002658
2010-08-14 09:07 alex File Added: performance_improvement_to_menu_cache_builder.patch
2010-08-14 03:27 alex Note Added: 0002656
2010-08-14 03:27 alex Assigned To => !COMMUNITY
2010-08-14 03:27 alex Developer => alex
2010-08-14 03:27 alex Status active => needs testing
2010-08-14 03:24 alex File Added: php4_and_cached_menu_eating_memory_fix.patch
2010-08-14 03:24 alex Reporter alex => phil
2010-08-14 03:24 alex New Issue
2010-08-14 03:24 alex Reference => http://groups.google.com/group/in-portal-bugs/browse_thread/thread/55054c2742eda579

Notes
(0002656)
alex   
2010-08-14 03:27   
On site, that has such a problem there was 1500 categories (that's templates from 4 enabled themes) and during menu cache building stage cache wasn't properly saved.

So attempt to build cache was made on each page resulting 1500 sqls at least and out of memory error at most.

Only can be tested on PHP4
(0002658)
alex   
2010-08-14 09:11   
Patch "performance_improvement_to_menu_cache_builder.patch" queries all categories with one sql, instead of performing one sql to get children of each category during menu cache building.
(0002667)
Dmitry   
2010-08-26 17:10   
Tested good. Very good improvement - please commit!
(0002713)
alex   
2010-08-28 16:09   
Fix committed to 5.1.x branch. Commit Message:

Fixes 0000827: Debugger eats up all memory on index page
(0003071)
Dmitry   
2010-11-30 12:48   
Closing released 5.1.1 task.