PacketFence - BTS - PacketFence
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000962PacketFenceweb adminpublic2010-04-16 14:232015-02-13 15:26
Reporterobilodeau 
Assigned Toobilodeau 
PrioritylowSeveritymajorReproducibilityhave not tried
StatusclosedResolutionopen 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
fixed in git revision
fixed in mtn revision
Summary0000962: php runs out of memory when using filters on a large database
DescriptionThe -filter- code pulls in all the database in order to do it's magic all fields search. On large node tables, this exhausts memory.

[error] [client xxx] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted
(tried to allocate 35 bytes) in /usr/local/pf/html/admin/common.php on line 138, referer: https://bleh:1443/node/view.php?filter=aa%3Abb [^]

Workaround: allow more memory
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
has duplicate 0000791closed obilodeau filter causes memory exhaustion when there is a lot of data in packetfence 
related to 0001480closed  web admin doesn't show accounting infromation when there are 100000 accounting rows in database. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-16 14:23obilodeauNew Issue
2010-04-16 14:23obilodeauStatusnew => assigned
2010-04-16 14:23obilodeauAssigned To => obilodeau
2011-01-18 11:41obilodeauTarget Version => 2.1.0
2011-03-03 15:15obilodeauTarget Version2.1.0 => +1
2011-03-03 15:18obilodeauTarget Version+1 => +2
2011-06-01 13:31obilodeauRelationship addedhas duplicate 0000791
2011-06-02 10:42obilodeauNote Added: 0002083
2012-08-06 14:47obilodeauRelationship addedrelated to 0001480
2012-08-06 14:49obilodeauNote Added: 0002875
2015-02-13 15:26lmunroNote Added: 0003701
2015-02-13 15:26lmunroStatusassigned => closed

Notes
(0002083)
obilodeau   
2011-06-02 10:42   
We bumped php's memory limit to 128M (php default) in 2.2 stable branch. It mitigates the issue.

Will probably be released as 2.2.1.
(0002875)
obilodeau   
2012-08-06 14:49   
Luckily this will vanish with our revamped admin web interface that should be coming soon.
(0003701)
lmunro   
2015-02-13 15:26   
Old issues.
Most are not relevant to PF 4 and up.

Let's reopen the ones that matter when we move to github.