Graphs aren't updating anymore

[cactirocks]

Hello

Sorry to bother you guys but I have a big problem. After installing the pluginpatch the graphs don't work anymore. If tail the log I see that the SNMP/CMD traps go well.

For example:

06/24/2006 01:31:55 PM - CMDPHP: Poller[0] Host[78] DS[1714] SNMP: v1: 10.10.10.23, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.18, output: 111542027

If I look into the MySQL database I see the new entry's, but rrdtool is showing nothing anymore (only the last value's before the update) . I replaced my folder with the backup files...but same problem so I guess this is database related?

I cleared the cache and did a reindex of hosts(all) . Can someone give me a hint? Because all my graphs are offline now.

Thank you for your time.

[cactirocks]

Sorry, update after logging into debug mode I saw this ERROR:

06/24/2006 01:17:02 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_command (poller_id,time,action,command) values (0,NOW(),1,'99:1')"
06/24/2006 01:17:03 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_command (poller_id,time,action,command) values (0,NOW(),1,'99:2')"

If I try to run this manual:

#1062 - Duplicate entry '0-1-99:1' for key 1

I guess database is fucked up or something like that...?

[rony]

Seems you crashed or something....

Run the following queries on the cacti database, but make sure that the poller isn't currently running.

Code: Select all

truncate poller_output;
truncate poller_command;

Then if Rebuild "Clear" the poller cache. This can be done from the web interface under system utitilies or you can use the command line script (if you are running 0.8.6h or higher), rebuild_poller_cache.php.

[cactirocks]

Rony, legato saved my ass. Everything is working fine now. But I now want to migrate from cmd.php to cactid.

I am running debian sarge.
Latest version of cacti (x.h)
Latest version of cactid

I made a replication to my testmachine and when I run cactid with the readonly option I works fine:

CACTID: Time: 90.6056 s, Threads: 5, Hosts: 87

When I run cacti without -R

CACTID: Host[48] DS[937] SNMP: v1: 172.9.82.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.27, value: 0
Segmentation fault

Any idea why? It is not this datasource if I disable host 48 I get the error on a other host. I runned also a mysqlcheck on the database (because of the copy) . I cleared also the cache.

[cactirocks]

Very strange....


CACTID: DEBUG: MySQL Insert ID '21': OK
CACTID: DEBUG: Thread Cleanup Complete
CACTID: DEBUG: PHP Script Server Pipes Closed
CACTID: DEBUG: Allocated Variable Memory Freed
CACTID: CACTID: Net-SNMP API Shutdown Completed
CACTID: DEBUG: MYSQL Free & Close Completed
CACTID: Time: 2.8927 s, Threads: 5, Hosts: 6

Program exited normally.

(gdb) backtrace
No stack.

Any suggestions?

[cactirocks]

It seem that I get a Segmentation fault if the host has many DS'es is that possible? Time out or something like that?

[gandalf]

I don't suppose this to be a problem related to many DSs. Please pm the author (TheWitness) referencing this thread
Reinhard