Boost log error messages

[kjstech]

Hi.
Cacti 1.2.19.

Was cleaning out my logs and now the only remaining thing is that it looks like a Christmas tree with alternating green, red, blue lines of the following:

Code: Select all

2021/11/08 15:19:39 - SYSTEM STATS: Time:8.8403 Method:spine Processes:8 Threads:2 Hosts:41 HostsPerProcess:6 DataSources:3739 RRDsProcessed:1854
2021/11/08 15:19:37 - CMDPHP SQL Backtrace: (/utilities.php[84]:boost_display_run_status(), /utilities.php[2222]:db_fetch_cell(), /lib/database.php[411]:db_fetch_cell_prepared(), /lib/database.php[427]:db_execute_prepared())
2021/11/08 15:19:37 - CMDPHP ERROR: A DB Cell Failed!, Error: Table 'cacti.poller_output_boost_local_data_ids' doesn't exist

I think this is because in configuration > settings > performance I turned on both the Enable On-demand RRD Updating and Enable Image Caching. I've never had these on before. This install was migrated and upgraded to a new VM and everything was working so good.

Well its still working ok, just the logs are noisy.

Since I never had these features on before, I just turned them off. But that didn't stop the logs. They are still spamming even though those two features are off. How can I get it to stop?

[kjstech]

Hmm I MAY have figured it out...

MySQL -u root cacti

CREATE TABLE IF NOT EXISTS poller_output_boost_local_data_ids (local_data_id int unsigned default "0",process_handler int unsigned default "0",PRIMARY KEY (local_data_id),INDEX process_handler(process_handler))ENGINE=MEMORY;

I'll keep an eye on it.

[kjstech]

Yup that fixed it!

So maybe I can use boost? Ok so I turned boost and the image caching on again but got this:
2021/11/08 15:32:13 - CMDPHP SQL Backtrace: (/graph_json.php[159]:rrdtool_function_graph(), /lib/rrd.php[1257]:boost_graph_cache_check(), /lib/boost.php[360]:boost_process_poller_output(), /lib/boost.php[906]:db_execute_prepared())
2021/11/08 15:32:13 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.poller_output_boost_arch_1636403529' doesn't exist
2021/11/08 15:32:13 - CMDPHP SQL Backtrace: (/graph_json.php[159]:rrdtool_function_graph(), /lib/rrd.php[1257]:boost_graph_cache_check(), /lib/boost.php[360]:boost_process_poller_output(), /lib/boost.php[906]:db_execute_prepared())
2021/11/08 15:32:13 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.poller_output_boost_arch_1636403529' doesn't exist


I turned boost off but left the image caching on. Logs have been clean for almost 2 hours now. Everything seems to be working fine so I'll leave it at that!