Graphs not updating after upgrade to 0.8.7a

Neilbo · Joined: 23 Mar 2007 Posts: 36

Here is what is in the log file:

01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:22:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:22:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:22:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:22:57 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:22:57 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:22:57 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:22:17 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"

I have tried the NAN debug guide but have not found an answer.

gandalf · Posted: Tue Jan 29, 2008 11:34 am Post subject:

That'S only GUI logging. Nothing shown from the poller. Crontab is ok? Which is your poller (cmd.php or spine?). What happens, if running

Neilbo · Joined: 23 Mar 2007 Posts: 36

[root@localhost html]# php -q poller.php --force --debug
01/29/2008 11:07:06 AM - SYSTEM STATS: Time:14.2344 Method:cmd.php Processes:10 Threads:N/A Hosts:59 HostsPerProcess:6 DataSources:600 RRDsProcessed:0
[root@localhost html]# PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/plugins/syslog/syslog_process.php on line 196

Here is the Crontab

SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/

# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly

gandalf · Posted: Wed Jan 30, 2008 4:13 am Post subject:

Please make sure to setup cacti as given by http://docs.cacti.net/node/441, e.g. crontab. Second, the error message stems from the syslog plugin. For the moment, please deactivate it and retry the command above
Reinhard

Neilbo · Joined: 23 Mar 2007 Posts: 36

php -q poller.php --force --debug
01/30/2008 08:53:59 AM - SYSTEM STATS: Time:14.2556 Method:cmd.php Processes:10 Threads:N/A Hosts:59 HostsPerProcess:6 DataSources:600 RRDsProcessed:0

gandalf · Posted: Wed Jan 30, 2008 11:43 am Post subject:

That's all? Or did you suppress the first lines that I expected to appear? In this case, please use cacti debug mode as given by second link of my signature to get more information
Reinhard

Neilbo · Joined: 23 Mar 2007 Posts: 36

01/31/2008 02:01:52 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '3 00', Time Since Last: '111', Max Runtime '298', Poller Runs: '1'
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 0 15]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 17 27]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 28 34]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 35 42]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 43 48]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 49 65]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 66 73]
01/31/2008 02:01:53 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 76 82]
01/31/2008 02:01:53 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 83 90]
01/31/2008 02:01:53 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 91 95]
Waiting on 10/10 pollers.
Waiting on 8/10 pollers.
Waiting on 6/10 pollers.
Waiting on 5/10 pollers.
Waiting on 4/10 pollers.
Waiting on 3/10 pollers.
Waiting on 2/10 pollers.
Waiting on 1/10 pollers.
01/31/2008 02:02:01 PM - SYSTEM STATS: Time:9.2393 Method:cmd.php Processes:10 T hreads:N/A Hosts:59 HostsPerProcess:6 DataSources:600 RRDsProcessed:0
Loop Time is: 9.2477400302887
Sleep Time is: 290.74878001213
Total Time is: 9.2512199878693
01/31/2008 02:02:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/plugins/discovery/findhosts.php]

Neilbo · Joined: 23 Mar 2007 Posts: 36

Here is what I get when running
php -q cmd.php 47 47

01/31/2008 02:15:21 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1017', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (421, 'hdd_used', '2008-01-31 14:15:21', '0')'
01/31/2008 02:15:21 PM - PHPSVR: Poller[0] DEBUG:

gandalf · Posted: Fri Feb 01, 2008 7:13 am Post subject:

Please run this SQL manually from mysql cli and post results. Surely, your filesysstem is not filled up and the database is not broken?
Reinhard

lion_han · Joined: 04 Oct 2006 Posts: 19

After a upgrade to 0.8.7a, schedules of loading of channels are not drawn. In a file cacti-error.log the mistake:
[Fri Feb 8 17:46:14 2008] [error] PHP Warning: Division by zero in /etc/httpd/htdocs/sites/cacti/lib/api_poller.php on line 119
is given. Somebody can help me?

nevrax · Joined: 11 Feb 2008 Posts: 1

I had the same problem Poller[0] ERROR: A DB Exec Failed!, Error:'1017', SQL blablab.a.

I tried to run the same SQL as in log file into mysql client but the poller_ouput table was missing. I checked my filesystem and it was true

A normal cacti installation should have 145 files in /var/lib/mysql/cacti. On the broken cacti server I had only 143 files, two of them were missing and guess what... poller_output was the problem.

My lazy solution was to copy pooler_output.* from another server then run an delete all from poller_output SQL query... and it worked.

Recently I found that this problem was caused by an forced reset of my cacti machine.

Neilbo · Joined: 23 Mar 2007 Posts: 36

I found I had a time sync issue. This fixed my hard drive space graphing but the network graphing is still spotty.

botchat · Joined: 26 Mar 2008 Posts: 1

[quote="nevrax"]

My lazy solution was to copy pooler_output.* from another server then run an [i]delete all from poller_output[/i] SQL query... and it worked.

[/quote]

Perfect solution for me as well

thx!

Pali · Joined: 08 Jul 2008 Posts: 5

gandalf · Posted: Tue Sep 16, 2008 12:39 pm Post subject:

Cacti does not deal with the MySQL files itself. It requires the table poller_output. If anything goes wrong, a "repair table" is the first solution. This turns out to be a more MySQL related issue, then
Reinhard