Cacti 0.8.6 eating diskspace

[rosch]

Hi...

I made a strange observation after upgrading my cacti from 0.8.5 to 0.8.6b. I already browsed this forum but couldn't find anything solving my problem.

From the beginning. I have a machine which sole purpose is to watch the network with cacti. I installed cacti 0.8.5 on it mid of may. Everything was fine. End of september I updated to 0.8.6b. From that day the system started to constantly eat diskspace. In 2 months about 1.2GB.

In the not so far future I will run out of diskspace. I waited some weeks hoping that this will maybe stop once but this will obviously not be the case. I looked at the system and what I have seen is that the database started to grow.

Is this a known issue? How can this be stopped? Or do I have to switch back to 0.8.5?

Attached you will find the diskspace graph of my cacti machine illustrating the situation.

Thanks for any help,

Roland

PS: the 2 spikes in the graph resulted from powerlosses. One lasted for 4 days

[egarnel]

what are you logging under cacti settings? Also, have you added cacti.log to logrotate? (assuming linux/unix server)

[rosch]

what are you logging under cacti settings? Also, have you added cacti.log to logrotate? (assuming linux/unix server)

I already checked that. I have selected LOW as logging level. My logfile is 6megabyte small. That does not eat my space...

I did some additional checkins today. My Mysql database grew from about ~300MB (as far as I can remember) to now ~1500MB... But still no plan to stop this.

[TheWitness]

Have you checked your apache log file? What is it's size? Also, Cacti is not a 1.5gbyte database.

TheWitness

[rosch]

Have you checked your apache log file? What is it's size? Also, Cacti is not a 1.5gbyte database.
TheWitness

Thanks for your reply.

Apache log gets rotated and is very small
du -m /usr/local/apache2/logs
returns a 6.

/var/lib/mysql is ~1.6GB big and growing
There is a cacti subfolder relatively small ~2MB, but i do have some
<myhostname>-bin.<xxx>
where <xxx> are number starting from 001 going to 007 at present. They eat all the space. (<myhostname> is here sahm).

All mysqld.log files in there does not show anything critical. Just a few startup and shutdown messages.

Roland.

[TheWitness]

Post a "ls -l -R" to the web site, let's see what file is growing.

TheWitness

[Guest]

in my case it seems to be the mysql logfile that grows.

-from around 4-5 megs to now 1.8 GB and counting. approx 250 megs per day...

-what is happening?

[Guest]

OMG!!!

My production server went berserk!

Today when i was gonna log in cacti, it just said it could not connect to the mysql server.. I logged into the linux shell, and was shocked. No more diskspace.. I checked the datadirectory, and the data files suddenly took 29 GIGABYTES! Cheeses

Wtf should i do?
I poll like 110 devices.. and the diskspace has beed quite stable before
Any known issues?

[Guest]

I dumped the cacti-database, and it took only like 10 megs..
In panic I deleted the mrtg-bin.* files, and it worked after a restart of the mysql daemon..

But Why did the mrtg-bin files grow like that?

[TheWitness]

What are the mrtg-bin files?

TheWitness

[Guest]

I actualy don't know. I thought you guys might know.. I guess it might be some logfiles from changes/updates in the cacti database... but that whould be a wild guess


-Sigurd

[Wernicke]

Forgot to login.. i wrote from the OMG string..
-Sigurd

[Guest]

any known fixes for this issue?

[Wernicke]

it looks like the mrtg name is taken from the hostname on the server.. so it has nothing to do with MRTG

-Sigurd

[Wernicke]

Here's a picture of my disk usage.. i guess i should have activated some alarm on the disk usage here:)
-Sigurd