the poller does not working properly

[randymendes]

Hi All,

I need your help, I´ve the last CACTI Version 1.1.35 but the poller is very unstable using cmd.php see the logs below

22/02/2018 14:25:02 - SYSTEM STATS: Time:1.2433 Method:cmd.php Processes:1 Threads:N/A Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
22/02/2018 14:25:02 - POLLER: Poller[Main Poller] Parsed MULTI output field '10min:0.05' [map 10min->load_15min]
22/02/2018 14:25:02 - POLLER: Poller[Main Poller] Parsed MULTI output field '5min:0.01' [map 5min->load_5min]
22/02/2018 14:25:02 - POLLER: Poller[Main Poller] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
22/02/2018 14:25:01 - POLLER: Poller[Main Poller] Time: 0.1001 s, Poller: , Theads: N/A, Devices: 1
22/02/2018 14:25:01 - POLLER: Poller[Main Poller] NOTE: There are no items in your poller for this polling cycle!
22/02/2018 14:25:01 - POLLER: Poller[Main Poller] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '300.47', Max Runtime '298', Poller Runs: '1'
22/02/2018 14:20:03 - SYSTEM STATS: Time:1.2510 Method:cmd.php Processes:1 Threads:N/A Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
22/02/2018 14:20:03 - POLLER: Poller[Main Poller] Parsed MULTI output field '10min:0.05' [map 10min->load_15min]
22/02/2018 14:20:03 - POLLER: Poller[Main Poller] Parsed MULTI output field '5min:0.01' [map 5min->load_5min]
22/02/2018 14:20:03 - POLLER: Poller[Main Poller] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
22/02/2018 14:20:02 - POLLER: Poller[Main Poller] Time: 0.1118 s, Poller: , Theads: N/A, Devices: 1
22/02/2018 14:20:01 - POLLER: Poller[Main Poller] NOTE: There are no items in your poller for this polling cycle!
22/02/2018 14:20:01 - POLLER: Poller[Main Poller] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '300.78', Max Runtime '298', Poller Runs: '1'

but when I have on the poller Spine int the logs below
22/02/2018 14:40:01 - POLLER: Poller[Main Poller] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '300.71', Max Runtime '298', Poller Runs: '1'
22/02/2018 14:40:00 - SYSTEM STATS: Time:299.6625 Method:spine Processes:1 Threads:10 Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
22/02/2018 14:40:00 - POLLER: Poller[Main Poller] Maximum runtime of 298 seconds exceeded. Exiting.
22/02/2018 14:35:02 - SYSTEM BOOST STATS: Time:0.1200 RRDUpdates:0
22/02/2018 14:35:01 - SYSTEM STATS: Time:299.6707 Method:spine Processes:1 Threads:10 Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
22/02/2018 14:35:01 - POLLER: Poller[Main Poller] Maximum runtime of 298 seconds exceeded. Exiting.

[netniV]

There is nothing wrong with this log. You just have your logging levels high or are logging the poller process within the Settings -> General tab. Try setting it to LOW

[randymendes]

Hi thanks for your replay,
just to informe you that I change as requested to low - Statistics and Erros, using spine does not generate the graphs

23/02/2018 09:05:00 - SYSTEM STATS: Time:298.6740 Method:spine Processes:1 Threads:1 Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
23/02/2018 09:05:00 - POLLER: Poller[Main Poller] Maximum runtime of 298 seconds exceeded. Exiting.
23/02/2018 09:00:00 - SYSTEM STATS: Time:298.8205 Method:spine Processes:1 Threads:1 Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
23/02/2018 09:00:00 - POLLER: Poller[Main Poller] Maximum runtime of 298 seconds exceeded. Exiting.
23/02/2018 08:55:01 - SYSTEM STATS: Time:298.6786 Method:spine Processes:1 Threads:1 Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
23/02/2018 08:55:01 - POLLER: Poller[Main Poller] Maximum runtime of 298 seconds exceeded. Exiting.
23/02/2018 08:50:01 - SYSTEM STATS: Time:299.6690 Method:spine Processes:1 Threads:1 Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
23/02/2018 08:50:01 - POLLER: Poller[Main Poller] Maximum runtime of 298 seconds exceeded. Exiting.
23/02/2018 08:41:51 - BOOST NOTE: Updating Local Data Id:'3', Template:users, Output: 1519371601:0
23/02/2018 08:41:51 - BOOST NOTE: Updating Local Data Id:'1', Template:proc, Output: 1519371601:170
23/02/2018 08:41:51 - BOOST NOTE: Updating Local Data Id:'2', Template:load_1min:load_5min:load_15min, Output: 1519371601:0.00:0.05:0.05
23/02/2018 08:41:51 - BOOST NOTE: Updating Local Data Id:'5', Template:mem_swap, Output: 1519371601:7340028
23/02/2018 08:41:51 - BOOST NOTE: Updating Local Data Id:'4', Template:mem_buffers, Output: 1519371601:6995004

[randymendes]

Hi,
Now a get erros

3/02/2018 11:40:02 - CMDPHP SQL Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1036 rrdtool_cacti_compare)(/lib/rrd.php: 2459 db_fetch_assoc_prepared)(/lib/database.php: 401 cacti_debug_backtrace)
23/02/2018 11:40:02 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS ds' at line 1
23/02/2018 11:40:02 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT dspc.consolidation_function_id AS cf, dsp.x_files_factor AS xff, dspr.steps AS steps, dspr.rows AS rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS dspc ON dsp.id=dspc.data_source_profile_id INNER JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id WHERE dsp.id = ? ORDER BY dspc.consolidation_function_id, dspr.steps'
23/02/2018 11:40:02 - CMDPHP PHP ERROR WARNING Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1033 rrdtool_function_info)(/lib/rrd.php: 2395 sizeof)(CactiErrorHandler)(/lib/functions.php: 4619 cacti_debug_backtrace)
23/02/2018 11:40:02 - ERROR PHP WARNING: sizeof(): Parameter must be an array or an object that implements Countable in file: /var/www/html/cacti/lib/rrd.php on line: 2395
23/02/2018 11:40:01 - SYSTEM STATS: Time:298.6564 Method:spine Processes:1 Threads:4 Hosts:1 HostsPerProcess:1 DataSources:5 RRDsProcessed:0
23/02/2018 11:40:01 - POLLER: Poller[Main Poller] Maximum runtime of 298 seconds exceeded. Exiting.
23/02/2018 11:39:10 - CMDPHP SQL Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1036 rrdtool_cacti_compare)(/lib/rrd.php: 2459 db_fetch_assoc_prepared)(/lib/database.php: 401 cacti_debug_backtrace)
23/02/2018 11:39:10 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS ds' at line 1
23/02/2018 11:39:10 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT dspc.consolidation_function_id AS cf, dsp.x_files_factor AS xff, dspr.steps AS steps, dspr.rows AS rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS dspc ON dsp.id=dspc.data_source_profile_id INNER JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id WHERE dsp.id = ? ORDER BY dspc.consolidation_function_id, dspr.steps'
23/02/2018 11:39:10 - CMDPHP PHP ERROR WARNING Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1033 rrdtool_function_info)(/lib/rrd.php: 2395 sizeof)(CactiErrorHandler)(/lib/functions.php: 4619 cacti_debug_backtrace)
23/02/2018 11:39:10 - ERROR PHP WARNING: sizeof(): Parameter must be an array or an object that implements Countable in file: /var/www/html/cacti/lib/rrd.php on line: 2395
23/02/2018 11:39:02 - CMDPHP SQL Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1036 rrdtool_cacti_compare)(/lib/rrd.php: 2459 db_fetch_assoc_prepared)(/lib/database.php: 401 cacti_debug_backtrace)
23/02/2018 11:39:02 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS ds' at line 1
23/02/2018 11:39:02 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT dspc.consolidation_function_id AS cf, dsp.x_files_factor AS xff, dspr.steps AS steps, dspr.rows AS rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS dspc ON dsp.id=dspc.data_source_profile_id INNER JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id WHERE dsp.id = ? ORDER BY dspc.consolidation_function_id, dspr.steps'
23/02/2018 11:39:02 - CMDPHP PHP ERROR WARNING Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1033 rrdtool_function_info)(/lib/rrd.php: 2395 sizeof)(CactiErrorHandler)(/lib/functions.php: 4619 cacti_debug_backtrace)
23/02/2018 11:39:02 - ERROR PHP WARNING: sizeof(): Parameter must be an array or an object that implements Countable in file: /var/www/html/cacti/lib/rrd.php on line: 2395
23/02/2018 11:38:41 - CMDPHP SQL Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1036 rrdtool_cacti_compare)(/lib/rrd.php: 2459 db_fetch_assoc_prepared)(/lib/database.php: 401 cacti_debug_backtrace)
23/02/2018 11:38:41 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS ds' at line 1
23/02/2018 11:38:41 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT dspc.consolidation_function_id AS cf, dsp.x_files_factor AS xff, dspr.steps AS steps, dspr.rows AS rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS dspc ON dsp.id=dspc.data_source_profile_id INNER JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id WHERE dsp.id = ? ORDER BY dspc.consolidation_function_id, dspr.steps'
23/02/2018 11:38:41 - CMDPHP PHP ERROR WARNING Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1033 rrdtool_function_info)(/lib/rrd.php: 2395 sizeof)(CactiErrorHandler)(/lib/functions.php: 4619 cacti_debug_backtrace)
23/02/2018 11:38:41 - ERROR PHP WARNING: sizeof(): Parameter must be an array or an object that implements Countable in file: /var/www/html/cacti/lib/rrd.php on line: 2395
23/02/2018 11:38:09 - CMDPHP SQL Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1036 rrdtool_cacti_compare)(/lib/rrd.php: 2459 db_fetch_assoc_prepared)(/lib/database.php: 401 cacti_debug_backtrace)
23/02/2018 11:38:09 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS ds' at line 1
23/02/2018 11:38:09 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT dspc.consolidation_function_id AS cf, dsp.x_files_factor AS xff, dspr.steps AS steps, dspr.rows AS rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS dspc ON dsp.id=dspc.data_source_profile_id INNER JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id WHERE dsp.id = ? ORDER BY dspc.consolidation_function_id, dspr.steps'
23/02/2018 11:38:09 - CMDPHP PHP ERROR WARNING Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1033 rrdtool_function_info)(/lib/rrd.php: 2395 sizeof)(CactiErrorHandler)(/lib/functions.php: 4619 cacti_debug_backtrace)
23/02/2018 11:38:09 - ERROR PHP WARNING: sizeof(): Parameter must be an array or an object that implements Countable in file: /var/www/html/cacti/lib/rrd.php on line: 2395
23/02/2018 11:37:59 - CMDPHP SQL Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1036 rrdtool_cacti_compare)(/lib/rrd.php: 2459 db_fetch_assoc_prepared)(/lib/database.php: 401 cacti_debug_backtrace)
23/02/2018 11:37:59 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS ds' at line 1
23/02/2018 11:37:59 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT dspc.consolidation_function_id AS cf, dsp.x_files_factor AS xff, dspr.steps AS steps, dspr.rows AS rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS dspc ON dsp.id=dspc.data_source_profile_id INNER JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id WHERE dsp.id = ? ORDER BY dspc.consolidation_function_id, dspr.steps'
23/02/2018 11:37:59 - CMDPHP PHP ERROR WARNING Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1033 rrdtool_function_info)(/lib/rrd.php: 2395 sizeof)(CactiErrorHandler)(/lib/functions.php: 4619 cacti_debug_backtrace)
23/02/2018 11:37:59 - ERROR PHP WARNING: sizeof(): Parameter must be an array or an object that implements Countable in file: /var/www/html/cacti/lib/rrd.php on line: 2395