Poller not exiting properly? log files filling up with SQL

[corch]

I've noticed that poller.php does not appear to be exiting properly... after it runs and does all its normal thing, the log file keeps filling up with stuff like this:

Code: Select all

10/28/2008 01:01:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
10/28/2008 01:01:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.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_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
10/28/2008 01:01:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
10/28/2008 01:01:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.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_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
10/28/2008 01:01:05 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
10/28/2008 01:01:05 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.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_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
10/28/2008 01:01:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
10/28/2008 01:01:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.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_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
10/28/2008 01:01:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
10/28/2008 01:01:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.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_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
10/28/2008 01:01:08 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
10/28/2008 01:01:08 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.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_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"

Its putting that in every second, so as you can guess its taking up quite a lot of disk space. I have the logging set to debug at the moment because im working on a separate issue, but that still does not look right to me... anyone seen this before?

OH... this is with 0.8.7b on RHEL5, RRDtool 1.2.23, netsnmp Version: 5.3.1

[TheWitness]

Those messages are completely normal for DEBUG level. We should add a SQL_DEBUG level for future reference.

TheWitness

[valleed]

I'm having the EXACT same problem. And the graphs are not being updated when this happens. It does not happen on every polling though.

Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.9-5.ELsmp
Web Server - Apache/2.0.52 (Red Hat)
PHP - 5.2.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, pcre, SimpleXML, sockets, SPL, shmop, standard, Reflection, pspell, posix, iconv, hash, gmp, gettext, ftp, filter, exif, date, curl, ctype, calendar, bz2, zlib, openssl, apache2handler, dbase, gd, json, mbstring, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, zip
MySQL - 5.0.51a-community
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins

• Global Plugin Settings (settings - v0.5)
  Syslog Monitoring (syslog - v0.5.2)
  Read-only Devices Tab (devices - v0.4)
  Host Info (hostinfo - v0.2)
  Network Tools (tools - v0.3)

[gandalf]

This is a hint only for cacti, that it is actively querying whether the polling has finished. The root cause might be a script with an inappropriate timeout (that happend to me last week, to be honest, on a wget script with a -T40 timeout. I discoverd it using "ps -ef" and seeing always the same host being queried 'til eternity).
Reinhard

[valleed]

Thank you very much Gandalf.

I think I fixed it.

I switched from spine to cmd.php for the night, and this morning I put back spine and it fixed it.

This problem started when I deleted a couple of DS and Graphs.