memory allocation error

[melchandra]

I've recently upgraded to 8.6j. Everything was working fine till around 12:50 this afternoon. No recent changes to Cacti that I know about

Started getting this error when running the poller
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 9 bytes) in /var/www/cacti/lib/database.php on line 154
Allowed memory size of 134217728 bytes exhausted (tried to allocate 10 bytes)


As you can see, I've already tried upping the PHP memory limit to 128M, that didn't fix it. It was previously at 64M.

I'm not really sure what output is needed to debug this, so just let me know what you need and I"ll get it right away

mysql 4.1.20
cacti 8.6j
cactid 8.6g (using cactid)
php 4.3.9
httpd 2.0.52
RHEL 4

[melchandra]

clarification: Data stopped showing up in Cacti (RRD's not being updated?) The above error shows when I manually run "php /var/www/cacti/poller.php". This paticular error doesn't show in the logs.

Attached is a debug run of the poller. I cut it short cause all it does is repeat the last SQL call forever.

[phizer]

Read this and check your poller_output table as you may just need to drop and re-create it to purge stale data.

http://forums.cacti.net/viewtopic.php?t=19227

[melchandra]

Ah, thanks - that was the trick. 1.9M records in my poller table. Just logged into phpMyAdmin, and emptied (not drop, just empty) the table, graphs got updated next cycle around.