Problem after changing database server

[jlperan]

Using cacti 0.8.6h on a redhat 9. I had the database on the same server but I´ve changed it to a MySQL cluster on a couple of servers. I´ve changed config.php
After this I don´t see graphs updated and that´s what I see on log file:

03/30/2006 01:54:54 PM - SYSTEM STATS: Time:293.2678 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 01:55:09 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 01:55:09 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 01:59:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 01:59:55 PM - SYSTEM STATS: Time:293.1426 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 02:00:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:00:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:05:09 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:05:09 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:09:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 02:09:55 PM - SYSTEM STATS: Time:293.3289 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 02:10:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:10:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:14:53 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 02:14:53 PM - SYSTEM STATS: Time:292.1465 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 02:15:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:15:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:19:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 02:19:54 PM - SYSTEM STATS: Time:293.1131 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 02:20:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:20:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:24:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 02:24:54 PM - SYSTEM STATS: Time:293.1259 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 02:25:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:25:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:29:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 02:29:54 PM - SYSTEM STATS: Time:293.1232 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 02:30:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:30:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:34:53 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 02:34:53 PM - SYSTEM STATS: Time:293.1414 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 02:35:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 02:35:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...

Before the database migration I didn´t have this problem and poller runtime was 10 seconds. MySQL server is on the same network so I don´t think it could be an update time problem.

There´s activity on the MySQL server and other software is working ok :

mysql> show full processlist;
+------+-----------+---------------------+-------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------+---------------------+-------+---------+------+-------+-----------------------+
| 6050 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
| 6337 | hawk | 10.46.164.179:45052 | hawk | Sleep | 3585 | | NULL |
| 8044 | cactiuser | 10.46.164.179:38674 | cacti | Sleep | 1650 | | NULL |
| 8227 | cactiuser | 10.46.164.179:33081 | cacti | Sleep | 285 | | NULL |
| 8228 | cactiuser | 10.46.164.179:33082 | cacti | Sleep | 798 | | NULL |
| 8233 | cactiuser | 10.46.164.179:33096 | cacti | Sleep | 793 | | NULL |
| 8244 | cactiuser | 10.46.164.179:33122 | cacti | Sleep | 1436 | | NULL |
| 8245 | cactiuser | 10.46.164.179:33125 | cacti | Sleep | 491 | | NULL |
| 8279 | cactiuser | 10.46.164.179:33213 | cacti | Sleep | 307 | | NULL |
| 9325 | cactiuser | 10.46.164.179:37080 | cacti | Sleep | 1 | | NULL |
| 9507 | hawk | 10.46.164.179:37712 | hawk | Sleep | 2 | | NULL |
+------+-----------+---------------------+-------+---------+------+-------+-----------------------+


Help please!!

Thanks all.

[jlperan]

More info:

I have connected and executed select and insert sql commands using the new connection to the cluster from the cacti server withouth problems so it´s not a grant problem.
Set debug log mode and got this info:


03/30/2006 03:04:53 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:04:53 PM - SYSTEM STATS: Time:292.2713 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:05:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:05:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:09:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:09:54 PM - SYSTEM STATS: Time:293.1610 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:10:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:10:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:14:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:14:54 PM - SYSTEM STATS: Time:293.2037 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:15:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:15:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:19:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:19:54 PM - SYSTEM STATS: Time:293.1826 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:20:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:20:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:24:53 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:24:53 PM - SYSTEM STATS: Time:293.1756 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:25:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:25:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:29:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:29:54 PM - SYSTEM STATS: Time:293.2266 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:30:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:30:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:34:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:34:54 PM - SYSTEM STATS: Time:293.2975 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:35:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:35:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:39:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:39:54 PM - SYSTEM STATS: Time:293.1489 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:40:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:40:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:44:53 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:44:53 PM - SYSTEM STATS: Time:293.1672 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:45:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:45:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:49:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:49:54 PM - SYSTEM STATS: Time:293.1673 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:50:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:50:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:54:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:54:54 PM - SYSTEM STATS: Time:293.3700 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 03:55:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:55:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 03:59:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 03:59:54 PM - SYSTEM STATS: Time:293.2560 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:00:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:00:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:04:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:04:54 PM - SYSTEM STATS: Time:293.1823 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:05:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...

03/30/2006 04:05:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:09:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:09:54 PM - SYSTEM STATS: Time:293.1817 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:10:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:10:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:14:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:14:54 PM - SYSTEM STATS: Time:293.1185 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:15:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:15:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:19:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:19:54 PM - SYSTEM STATS: Time:293.3037 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:20:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:20:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:24:53 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:24:53 PM - SYSTEM STATS: Time:292.1414 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:25:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:25:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:26:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:29:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:29:54 PM - SYSTEM STATS: Time:293.1598 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:30:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:30:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:34:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:34:54 PM - SYSTEM STATS: Time:293.2457 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:35:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:35:08 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:39:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:39:54 PM - SYSTEM STATS: Time:293.1166 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:40:07 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:40:07 PM - CACTID: Poller[0] Host[64] DS[115] WARNING: Result from SNMP not valid. Partial Result: ...
03/30/2006 04:44:53 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:44:53 PM - SYSTEM STATS: Time:293.2067 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:0
03/30/2006 04:45:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
03/30/2006 04:45:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
03/30/2006 04:45:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/var/www/cacti')"
03/30/2006 04:45:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
03/30/2006 04:45:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/cactid, ARGS: 0 32]
03/30/2006 04:45:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/cactid, ARGS: 33 65]
03/30/2006 04:45:03 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/cactid, ARGS: 66 96]
03/30/2006 04:45:04 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
03/30/2006 04:45:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:45:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"

03/30/2006 04:54:49 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:54:49 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"
03/30/2006 04:54:50 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:54:50 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"
03/30/2006 04:54:51 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:54:51 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"
03/30/2006 04:54:52 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:54:52 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"
03/30/2006 04:54:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:54:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"
03/30/2006 04:54:54 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:54:54 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"
03/30/2006 04:54:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/30/2006 04:54:54 PM - SYSTEM STATS: Time:293.7296 Method:cactid Processes:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:4
03/30/2006 04:54:54 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:293.7296 Method:cactid Proc\
esses:3 Threads:5 Hosts:92 HostsPerProcess:31 DataSources:215 RRDsProcessed:4')"
03/30/2006 04:54:54 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
03/30/2006 04:55:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
03/30/2006 04:55:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
03/30/2006 04:55:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/var/www/cacti')"
03/30/2006 04:55:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
03/30/2006 04:55:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/cactid, ARGS: 0 32]
03/30/2006 04:55:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/cactid, ARGS: 33 65]
03/30/2006 04:55:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/cactid, ARGS: 66 96]
03/30/2006 04:55:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
03/30/2006 04:55:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:55:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"
03/30/2006 04:55:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/30/2006 04:55:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_i\
tem.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_i\
d and poller_output.rrd_name=poller_item.rrd_name)"

[gandalf]

Please switch Settings-> Logging Level to DEBUG to get more info
Reinhard

[jlperan]

My last post info was with debug loggin level enabled.

Thanks.

[gandalf]

This is either incomplete (to a great extend) or something's wrong with your 92 Hosts...
Please
- switch again to DEBUG mode
- clear log file
- await one completed polling cycle
- reset debugging level
- gzip and post cacti.log as a whole
It would be nice, if NO graphs would be recycled during this time, cause this will mess up the log with unwanted lines
Reinhard

[jlperan]

- Cleared log file
- set to debug mode
- wait 5 minutes of logging
- compressed file
- and sent

Thanks.

[jlperan]

Incredible, I´ve changed the poll method to cmd.php and all is working again.