Graphs not updating, been working fine for 4 years

[vaiojunkie]

Hi Guys

I hope you can help.

Since 02:25am On Tuesday the 8th of May my graphs have stopped updating. This is the second time this has happened.

The first time this happened was just after I upgraded to cacti-0.8.6j. The fix for this was simple, Flush the poller cache.

This time however flushing the cache does not help.

Specs
cacti-0.8.6j
Cactid
Debian Sarge
PHP4
Mysql 4

No errors appear in the logs, the permissions are also correct in the rra and other folders. Even when I run the poller as root nothing is updated.

I've been running Cacti on this server for about 4 years now, each update has gone smoothly. Version j has been running since the release.

The ntp server also stopped around this time, however the machine still had the correct time and ntp has since been restarted.

[rony]

Run the poller in debug from the command line. See if you get anymore information.

[vaiojunkie]

How do I do that ?

[rony]

In the web interface Settings -> General -> Poller Logging Level

Then run the poller manually as the user that runs the poller.

[vaiojunkie]

Sorry I thought you meant there was a way to add the debug flag on the poller manually.

Anyway I've been running with Debug and there are no errors at all.
Output below

Control:~/cacti$ php poller.php
05/08/2007 02:37:59 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/bin/cactid, ARGS: 0 133]
Waiting on 1/1 pollers.
Usage: ping [-LRUbdfnqrvVaA] [-c count] [-i interval] [-w deadline]
[-p pattern] [-s packetsize] [-t ttl] [-I interface or address]
[-M mtu discovery hint] [-S sndbuf]
[ -T timestamp option ] [ -Q tos ] [hop1 ...] destination


I have patched vJ with all latest patches.

Log file attached (IP's and hostnames changed)

[vaiojunkie]

Ok

I've just found a error in the latest log

05/08/2007 03:40:11 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '0-1-106:1' for key 1
05/08/2007 03:40:11 PM - CACTID: Poller[0] ASSERT: 'SNMP ERROR

[vaiojunkie]

Also I've noticed that in the debug output the log is coming from CMDPHP but I have Cactid enabled.

Does cacti use CMDPHP in debug mode and cactid in normal mode (if selected). I ask this because I have now turned off debug and cacti log reports from cactid


???

Wayne

[vaiojunkie]

I've fixed it


I reverted to a backup of version h (web files and DB). This worked as normal. The next step was to upgrade back up to version j.

So far its working a treat. and I've only lost 20 hours of data.


Wayne