I have installed the discover plugin and since that has been running I have been getting quite a lot of errors in the log.
I am running cacti 0.8.7e and the plugin architecture 2.5
Discovery plugin version 0.8.5
I have hunted around but I'm struggling to find any useful information. I found the following reference http://cactiusers.org/forums/viewtopic. ... 09&start=0
This looks very similar to my problem, however:
- that problem appears to only get logged every hour (when discover runs), although my problem occurs much more regularly than that
- the report of a duplicate line
apeears to have been fixed already as it doesn't appear in my findhosts.php. sql_sanitize($device['snmp_sysName']) . "', '"
- the report of a missing line
also appears to have been fixed and this line exists in my findhosts.php. sql_sanitize($device['os']) . "', "
Finally, both posts I have mentioned that suggest changing code in findhosts.php have different lines of code at the end of the block that required changes.
The first post shows:
The second shows:. ",'0','1','" .time() . "')");
And finally mine shows:. "'0','1','" .time() . "')");
Could this be an issue? Or can anyone explain to me what the differences are?. "1, 1,".time() . ')' );
The following is the output of 1 hour's worth of standard logging.
Does anyone have any idea what may be going on? Or how I can resolve it?08/06/2009 08:05:04 PM - SYSTEM STATS: Time:3.1403 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 08:00:04 PM - SYSTEM STATS: Time:3.1375 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:55:04 PM - SYSTEM STATS: Time:3.1374 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:50:05 PM - SYSTEM STATS: Time:3.1819 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:45:04 PM - SYSTEM STATS: Time:3.1434 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:40:36 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.128', '176383104', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249584036)'
08/06/2009 07:40:04 PM - SYSTEM STATS: Time:3.1933 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:35:05 PM - SYSTEM STATS: Time:3.1710 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:30:04 PM - SYSTEM STATS: Time:3.1794 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:25:27 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.91', '176383067', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249583127)'
08/06/2009 07:25:04 PM - SYSTEM STATS: Time:3.2052 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:20:05 PM - SYSTEM STATS: Time:3.1380 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:17:12 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.63', '176383039', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582632)'
08/06/2009 07:16:48 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.62', '176383038', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582608)'
08/06/2009 07:16:23 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.61', '176383037', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582583)'
08/06/2009 07:15:04 PM - SYSTEM STATS: Time:3.1656 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:14:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.56', '176383032', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582460)'
08/06/2009 07:13:56 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.55', '176383031', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582436)'
08/06/2009 07:13:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.54', '176383030', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582411)'
08/06/2009 07:13:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.53', '176383029', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582387)'
08/06/2009 07:12:42 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.52', '176383028', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582362)'
08/06/2009 07:12:18 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.51', '176383027', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582338)'
08/06/2009 07:11:04 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.46', '176383022', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582264)'
08/06/2009 07:10:04 PM - SYSTEM STATS: Time:3.1396 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:09:50 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.43', '176383019', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582190)'
08/06/2009 07:09:26 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.42', '176383018', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582166)'
08/06/2009 07:09:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.41', '176383017', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582141)'
08/06/2009 07:08:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.40', '176383016', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582117)'
08/06/2009 07:06:34 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.35', '176383011', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249581994)'
08/06/2009 07:05:04 PM - SYSTEM STATS: Time:3.1730 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:00:29 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.1', '176382977', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249581629)'
08/06/2009 07:00:05 PM - POLLER: Poller[0] Network Discover is now running