No data for None of the graph

[ponnuchelvam]

Hi Team,

We have distribution setup using cacti(primary and remote poller). 1500 devices getting monitored.But all graph is showing value as -nan. Even Device up and running and snmp status is also good.

I checked log in Primary poller through GUI and find the below error frequently

2020/01/13 19:09:04 - CMDPHP SQL Backtrace: (/poller.php: 560 process_poller_output)(/lib/poller.php: 510 api_plugin_hook_function)(/lib/plugins.php: 113 api_plugin_run_plugin_hook_function)(/lib/plugins.php: 214 thold_poller_output)(/plugins/thold/includes/polling.php: 367 thold_calculate_expression)(/plugins/thold/thold_functions.php: 766 get_current_value)(/plugins/thold/thold_functions.php: 3224 rrdtool_function_fetch)(/lib/rrd.php: 780 boost_fetch_cache_check)(/lib/boost.php: 243 boost_process_poller_output)(/lib/boost.php: 681 db_fetch_assoc)(/lib/database.php: 361 db_fetch_assoc_prepared)(/lib/database.php: 402 cacti_debug_backtrace)

2020/01/13 19:09:04 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_output_boost' doesn't exist

2020/01/13 19:09:04 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:' (SELECT local_data_id, UNIX_TIMESTAMP(time) AS timestamp, rrd_name, output FROM poller_output_boost WHERE local_data_id = 5542 AND time < FROM_UNIXTIME(1578922744)) ORDER BY timestamp ASC, rrd_name ASC '


I did the below step before raising here as basic troubleshooting:-

1) Ran rebuild poller cache from primary cacti server through cli
2) Ran repair_database.php through cli
3) The same thing did through mysqlcheck cmd for cacti database.
4) Reboot the server.

Still we are facing the same issue. Please help to resolve the issue. 4 remote poller is connecting primary poller. 3 poller is working fine with 1 min polling . one remote stopped due to connectivity.

Thanks and Regards
Ponnuchelvam.V

[ponnuchelvam]

We are running Cacti 1.1.38

[cigamit]

If that table goes missing, then something is really, really wrong. We have made a change in 1.2.X to help combat this though.

https://github.com/Cacti/cacti/issues/3161

[ponnuchelvam]

Hi Team, Thanks for your response. It helps me. I fixed the issue by recreating the boost output table.

Thanks and Regards
Ponnuchelvam.V

[svg]

Thanks for this forum post. it helped me to recreate my poller_output_boost table.
as i´d to figure out how this is done without re-installing the whole of cacti i did this go path:

apt download cacti
...then extract the Cacti.sql file , then lookup inside the requirements of the poller_output_boost table

mysql -u root -p
... login to the database service

use cacti;
... choose the cacti DB

show tables;
... to verify that the poller_output_boost table is not there.

SET SESSION sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
... to Allow MySQL to handle Cacti's legacy syntax

CREATE TABLE `poller_output_boost` (
`local_data_id` mediumint(8) unsigned NOT NULL default '0',
`rrd_name` varchar(19) NOT NULL default '',
`time` timestamp NOT NULL default '0000-00-00 00:00:00',
`output` varchar(512) NOT NULL,
PRIMARY KEY USING BTREE (`local_data_id`, `time`, `rrd_name`)
) ENGINE=InnoDB;
... to recreate the table.


rgds
Stephan