In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
658 [In-Portal CMS] Optimization task N/A 2010-03-27 17:18 2012-07-25 05:33
Dmitry  
alex  
normal  
closed 5.0.3-B1  
fixed  
 
none 5.2.0-B1  
http://groups.google.com/group/in-portal-bugs/browse_thread/thread/1c1fa549bcbb59b2
1
0000658: Extremely Long Priority numbers stored in Cache for "Parsed Sections"
Hi all,


I think we have a little bug/issue in parsed_sections serialized array
that is stored in Cache table.

Some records have super long Priority numbers. I know we don't use/put
this long digits so it must something auto-calculated or something.
here is an example:

s:1:"r";s:15:"no_pass_through";i:1;}s:11:"permissions";a:2:{i:0;s:
4:"view";i:1;s:4:"edit";}s:8:"priority";d:
4.29999999999999982236431605997495353221893310546875;s:4:"type";i:1;s:
13:"SectionPrefix

There not too many of this, but I thin k we should bring it to the
human read format and safe a bit of DB space ;)
Plan:
1. convert all priorities to strings before storing them in database
2. attach sections_parsed cache size before and after the fix
patch long_priority_658.patch (528) 2011-10-17 07:40
http://tracker.in-portal.org/file_download.php?file_id=1244&type=bug
Issue History
2012-07-25 05:33 alex Note Added: 0005114
2012-07-25 05:33 alex Status resolved => closed
2011-10-22 05:27 alex Estimate Points => 1
2011-10-17 09:26 alex Changeset attached 5.2.x r14668
2011-10-17 09:26 alex Note Added: 0004058
2011-10-17 09:26 alex Status reviewed and tested => resolved
2011-10-17 09:26 alex Fixed in Version => 5.2.0-B1
2011-10-17 09:26 alex Resolution open => fixed
2011-10-17 09:26 alex Assigned To !COMMUNITY => alex
2011-10-17 09:26 alex Assigned To alex => !COMMUNITY
2011-10-17 09:26 alex Status needs testing => reviewed and tested
2011-10-17 07:41 erik Time Estimate Removed 1 =>
2011-10-17 07:41 erik Note Added: 0004057
2011-10-17 07:41 erik Assigned To erik => alex
2011-10-17 07:41 erik Developer => erik
2011-10-17 07:41 erik Status needs work => needs testing
2011-10-17 07:40 erik File Added: long_priority_658.patch
2011-10-17 07:34 erik File Deleted: long_priority_658.patch
2011-10-17 07:17 erik File Added: long_priority_658.patch
2011-10-14 02:43 alex Reporter erik => Dmitry
2011-10-14 02:43 alex Assigned To => erik
2011-10-14 02:43 alex Status active => needs work
2011-10-14 02:37 alex Reporter Dmitry => erik
2011-10-14 02:37 alex Additional Information Updated bug_revision_view_page.php?rev_id=882#r882
2011-09-27 06:22 alex Time Estimate Added 1
2011-09-23 21:49 Dmitry Target Version Icebox => 5.2.0
2010-05-10 14:50 alex Target Version 5.0.4 => Icebox
2010-03-27 17:18 alex Reporter alex => Dmitry
2010-03-27 17:18 alex New Issue
2010-03-27 17:18 alex Reference => http://groups.google.com/group/in-portal-bugs/browse_thread/thread/1c1fa549bcbb59b2

Notes
(0004057)
erik   
2011-10-17 07:41   
patch attached - needs testing

Tested on all modules enabled, excepting In-Auction
size before patch - 59132 characters
size after patch - 58886 characters
(0004058)
alex   
2011-10-17 09:26   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0000658: Extremely Long Priority numbers stored in Cache for "Parsed Sections"
Commit on behalf of Erik
(0005114)
alex   
2012-07-25 05:33   
Since 5.2.0 version was released.