Please help with this SQL error!!

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
User avatar
tgriep
Madmin
Posts: 9177
Joined: Thu Oct 30, 2014 9:02 am

Re: Please help with this SQL error!!

Post by tgriep »

What I think the problem was at one time the systems time was incorrectly set to a time in the future and the graphs were updated.
Then the time on the server was put back to the correct time, all of the rrd files timestamp were in the future so the RRD will not update because the current time is less than the file timestamp.
You could reset the timestamp recursively for all of the files/folders by changing to the following folder

Code: Select all

/usr/local/pnp4nagios/var/perfdata/
And running the command below

Code: Select all

find ./ -exec touch {} \;
Try that and see if the graphs start to populate again.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked