0000962: php runs out of memory when using filters on a large database - PacketFence - BTS

Bug Tracking System

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

0000962

PacketFence

web admin

public

2010-04-16 14:23

2015-02-13 15:26

Reporter

obilodeau

Assigned To

obilodeau

Priority

low

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

open

Platform

OS

OS Version

Product Version

Target Version

Fixed in Version

Summary

0000962: php runs out of memory when using filters on a large database

Description

The -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

Tags

No tags attached.

fixed in git revision

fixed in mtn revision

Relationships

has duplicate	0000791	closed	obilodeau	filter causes memory exhaustion when there is a lot of data in packetfence
related to	0001480	closed		web admin doesn't show accounting infromation when there are 100000 accounting rows in database.

Notes
(0002083) obilodeau (reporter) 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 (reporter) 2012-08-06 14:49	Luckily this will vanish with our revamped admin web interface that should be coming soon.

(0003701) lmunro (administrator) 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.

Issue History
Date Modified	Username	Field	Change
2010-04-16 14:23	obilodeau	New Issue
2010-04-16 14:23	obilodeau	Status	new => assigned
2010-04-16 14:23	obilodeau	Assigned To	=> obilodeau
2011-01-18 11:41	obilodeau	Target Version	=> 2.1.0
2011-03-03 15:15	obilodeau	Target Version	2.1.0 => +1
2011-03-03 15:18	obilodeau	Target Version	+1 => +2
2011-06-01 13:31	obilodeau	Relationship added	has duplicate 0000791
2011-06-02 10:42	obilodeau	Note Added: 0002083
2012-08-06 14:47	obilodeau	Relationship added	related to 0001480
2012-08-06 14:49	obilodeau	Note Added: 0002875
2015-02-13 15:26	lmunro	Note Added: 0003701
2015-02-13 15:26	lmunro	Status	assigned => closed

Copyright © 2000 - 2012 MantisBT Group