CACTI2RRD not updates all the RRD files

[NetVicious]

Hi!

I upgraded from 0.8.6 to 0.8.6d directly. I run the installer and it did the upgrade correctly. I edited some personal scripts and now the cmd.php runs ok and gets all the data correctly

But when I run the poller the CACTIRRD only updates one rrd file

Someone could tell me where I need to look ?

Code: Select all

06/08/2005 06:15:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/cmd.php 0 4]
06/08/2005 06:15:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/cmd.php 5 14]
06/08/2005 06:15:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/cmd.php 15 18]
Waiting on 3/3 pollers.
Waiting on 1/3 pollers.
06/08/2005 06:15:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/ping_114.rrd --template ping 1118247301:246.9
06/08/2005 06:15:03 PM - SYSTEM STATS: Time: 2.2741 s, Method: cmd.php, Processes: 3, Threads: N/A, Hosts: 14, Hosts/Process: 5
OK u:0.00 s:0.00 r:2.02

[NetVicious]

Someone could help me?
I will post more info if it's needed.

[rony]

As the user that runs the poller.php, run "php poller.php" and watch the STDOUT. If you have permission problems, they will show up here. Please make sure that you run it as the user that it runs as from cron, otherwise, this will not be a true test.

[NetVicious]

/etc/cron.d/cacti

*/5 * * * * www-data php4 /usr/share/cacti/poller.php > /dev/null 2>&1

-------------------------------------------------

All the rrds have correct user/group and rights:
-rw-r--r-- 1 www-data www-data 71580 Jun 21 10:00 ping_114.rrd
-rw-r--r-- 1 www-data www-data 47836 Jun 8 18:05 localhost_proc_7.rrd

-------------------------------------------------

The directory has correct rights and the user www-data could enter without any problem to the directory.
lrwxrwxrwx 1 root root

-------------------------------------------------

[www-data:/usr/share/cacti]$ php poller.php
06/21/2005 10:04:27 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/cmd.php 0 6]
06/21/2005 10:04:27 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/cmd.php 12 18]
Waiting on 2/2 pollers.
06/21/2005 10:04:28 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/ping_114.rrd --template ping 1119341067:242.8
06/21/2005 10:04:28 AM - SYSTEM STATS: Time: 1.0464 s, Method: cmd.php, Processes: 2, Threads: N/A, Hosts: 14, Hosts/Process: 7
OK u:0.00 s:0.00 r:1.01

-------------------------------------------------

System Utilities / View Poller Cache shows [49 Items] correctly

Now I'm updating the rrds manually in other script, and the graphs in cacti are correctly displayed.

If you need more info please ask for it.

[NetVicious]

Updated to 0.8.6e without problems. But the bug it is not resolved.

[TheWitness]

Please perform the following and post the results:

mysql -u root -p cacti
> select count(*) from poller_output;

Then if you get several records:
> truncate table poller_output;
> quit

TheWitness

[NetVicious]

It seems it's not a poller_output table problem. The table has 0 records. I posted you the definition of the table.

Code: Select all

mysql> select count(*) from poller_output;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> describe poller_output;
+---------------+-----------------------+------+-----+---------------------+-------+
| Field         | Type                  | Null | Key | Default             | Extra |
+---------------+-----------------------+------+-----+---------------------+-------+
| local_data_id | mediumint(8) unsigned |      | PRI | 0                   |       |
| rrd_name      | varchar(19)           |      | PRI |                     |       |
| time          | datetime              |      | PRI | 0000-00-00 00:00:00 |       |
| output        | text                  |      |     |                     |       |
+---------------+-----------------------+------+-----+---------------------+-------+
4 rows in set (0.00 sec)

Thanks for answer.

[mvam]

i've run into this as well. yesterday half my rrd files stopped updating. when watching the output in the log it seems as if cacti doesnt even try them. this is happening with "get snmp data" and "script/command" on these hosts. also any new data sources/graphs added fail to get created for these specific hosts, all of which respond to snmp just fine on the command line. updating to 0.8.6e didnt fix.

i checked my poller_output table

mysql> select count(*) from poller_output;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)

UPDATE: my snmp polls seem to be updating now, however my script based polls dont seem to be picking back up.

[rony]

Please try to "Clear Poller Cache" in the Utilties section. It doesn't accually clear it, it rebuilds it.

[mvam]

Please try to "Clear Poller Cache" in the Utilties section. It doesn't accually clear it, it rebuilds it.

yeah, tried that. didnt work.

[mvam]

ok, i think i found my script problem. somehow all the data sources got changed from script to snmp. what could have changed that?

[rony]

All of them?

Um, bug?

[mvam]

yep, all of them.
the only thing i did around the time it happened was to disable 3 hosts that had been added the day before but were not responding to snmp.

[TheWitness]

Please dump your database and send to Tony and myself.

mysqldump -u root -p cacti > cactidump.sql

TheWitness

[NetVicious]

I don't have the problem with the snmp/scripts change.

All my Data Input Methods are ok.

TheWitness, could I send you my DB?