Documenting Problems That Were Difficult To Find The Answer To

Cacti Running Out Of Memory In

I upgraded Debian to Wheezy testing and suddenly Cacti stopped working.

In my Apache logs I found the following error:

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 65484 bytes) in /var/www/html/cacti/cacti-0.8.7g/lib/adodb/ on line 833

I patched to dump the SQL it was trying to run, and I cut and paste one of the statements into a mysql session:

MariaDB [cacti]> select value from `cacti`.`settings` where name='log_verbosity';
ERROR 126 (HY000): Incorrect key file for table './cacti/settings.MYI'; try to repair it
MariaDB [cacti]> quit

So – it looked liked the tables needed repairing (maybe the upgrade from MySQL to MariaDB broke the tables). From the command line I ran the following command to repair all my tables in all my databases:

mysqlcheck -u root -p --auto-repair --all-databases

This solved the problem. Cacti works again for me.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: