all graphs became NAN

[chemichon]

Hi there,

I was having some performance issue on my server, and I had to disable cacti on the crontab for a couple of days.

When I turned it back on, my graphs would not update, but display nan.

Is this a common pitfall?

What can I look for?

Thank you for willing to help!

[gandalf]

Please refer to second link of my signature for a start
Reinhard

[chemichon]

Gandalf,

Tnx for willing to help, but where is your signature?

[gandalf]

Please login to find it underneath each of my posts
Reinhard

[LwiG]

Hi Gandalf! The "NaN Debugging" how to, does not work, for me...
everythings is OK... I do not know what to do... Please, help! My cacti server is away for 3 days! My boss is almost killing me... hehehe
The cacti mysql database (table settings) was corrupted and I loose all RRD files after our no-break fail.

Thanks for help!

LwiG

[gandalf]

Oh, is there no statement on "repair tables" in my HowTo? Should I update?
Reinhard

[LwiG]

The tables was repaired, but it do not work...
Well... I think I found what is happening. My Apache log is full of errors... It can't find the rrd files. I'll look it later and if I found an solution, will post it here.

Thank you very much for your help!

[jzondor]

Just wanted to say that I also noticed that my rrd files were not being updated. Once I did the mysql query against cacti db:

Code: Select all

select count(*) from poller_output;

It returned:

Code: Select all

+----------+
| count(*) |
+----------+
|  115607 |
+----------+
1 row in set (0.00 sec)

I then ran:

Code: Select all

truncate table poller_output;

And it started to update the rrds.
So I went and checked the memory setting in my php.ini file and sure enough, it was set to 8M. I increased it and now we will see if this issue returns.

Thanks!!!

[gandalf]

That's why I mentioned this issue in my NaN Debugging Howto, sigh!
Reinhard

[jzondor]

That's why I mentioned this issue in my NaN Debugging Howto, sigh!
Reinhard

Sorry, thought I'd post it here for the lazy ones... I'll keep to myself next time...

[gandalf]

Sorry, thought I'd post it here for the lazy ones... I'll keep to myself next time...

No, no! Not wanting to insult you. But if you want me to improve my HowTo to find stuff easier, I'd appreciate to hear from you.
Reinhard

[jzondor]

Sorry, thought I'd post it here for the lazy ones... I'll keep to myself next time...

No, no! Not wanting to insult you. But if you want me to improve my HowTo to find stuff easier, I'd appreciate to hear from you.
Reinhard

No insult here... sorry sometimes my sarcasm fails to come through in text. It was very easy to find for me at least... Thank you very much....