Boost giving me some hard time with the DB, and or Wheathermap

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
Rno
Cacti Pro User
Posts: 704
Joined: Wed Dec 07, 2011 9:19 am

Boost giving me some hard time with the DB, and or Wheathermap

Post by Rno »

Hello,
My boost is give me crazy, one in a while I'm getting a lot of error like that:

Code: Select all

11/10/2024 12:35:16 - BOOST INFO: Boost prepare tables took 0 seconds.
11/10/2024 12:35:16 - CMDPHP SQL Backtrace: (/poller.php[941]:api_plugin_hook(), /lib/plugins.php[95]:api_plugin_run_plugin_hook(), /lib/plugins.php[237]:weathermap_poller_bottom(), /plugins/weathermap/setup.php[1169]:weathermap_run_maps(), /plugins/weathermap/lib/poller-common.php[430]:WeatherMap->ReadData(), /plugins/weathermap/lib/WeatherMap.class.php[1058]:WeatherMapDataSource_rrd->ReadData(), /plugins/weathermap/lib/datasources/WeatherMapDataSource_rrd.php[647]:rrdtool_function_fetch(), /lib/rrd.php[995]:boost_fetch_cache_check(), /lib/boost.php[299]:boost_process_poller_output(), /lib/boost.php[773]:db_execute(), /lib/database.php[420]:db_execute_prepared())
11/10/2024 12:35:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown table 'poller_output_boost_temp_261064_1118363813_1728642916.1834'
11/10/2024 12:35:16 - CMDPHP SQL Backtrace: (/poller.php[941]:api_plugin_hook(), /lib/plugins.php[95]:api_plugin_run_plugin_hook(), /lib/plugins.php[237]:weathermap_poller_bottom(), /plugins/weathermap/setup.php[1169]:weathermap_run_maps(), /plugins/weathermap/lib/poller-common.php[430]:WeatherMap->ReadData(), /plugins/weathermap/lib/WeatherMap.class.php[1058]:WeatherMapDataSource_rrd->ReadData(), /plugins/weathermap/lib/datasources/WeatherMapDataSource_rrd.php[647]:rrdtool_function_fetch(), /lib/rrd.php[995]:boost_fetch_cache_check(), /lib/boost.php[299]:boost_process_poller_output(), /lib/boost.php[767]:db_fetch_assoc_prepared(), /lib/database.php[788]:db_execute_prepared())
11/10/2024 12:35:16 - CMDPHP ERROR: A DB Row Failed!, Error: SELECT command denied to user 'cacti_test'@'lslcact03.lausanne.ch' for table `poller_output_boost_temp_261064_1118363813_1728642916`.`1834`
11/10/2024 12:35:16 - CMDPHP SQL Backtrace: (/poller.php[941]:api_plugin_hook(), /lib/plugins.php[95]:api_plugin_run_plugin_hook(), /lib/plugins.php[237]:weathermap_poller_bottom(), /plugins/weathermap/setup.php[1169]:weathermap_run_maps(), /plugins/weathermap/lib/poller-common.php[430]:WeatherMap->ReadData(), /plugins/weathermap/lib/WeatherMap.class.php[1058]:WeatherMapDataSource_rrd->ReadData(), /plugins/weathermap/lib/datasources/WeatherMapDataSource_rrd.php[647]:rrdtool_function_fetch(), /lib/rrd.php[995]:boost_fetch_cache_check(), /lib/boost.php[299]:boost_process_poller_output(), /lib/boost.php[725]:db_execute(), /lib/database.php[420]:db_execute_prepared())
11/10/2024 12:35:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Access denied for user 'cacti_test'@'%' to database 'poller_output_boost_temp_261064_1118363813_1728642916'
11/10/2024 12:35:16 - SYSTEM MONITOR STATS: Time:0.05 Reboots:0 DownDevices:0 Notifications:0 Purges:0
11/10/2024 12:35:16 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:15 Removes:15 XFers:15 Alerts:5 Alarms:0 Reports:0
11/10/2024 12:35:16 - BOOST INFO: Boost processing a total of 513906 entries.
11/10/2024 12:35:16 - BOOST INFO: Boost archive table poller_output_boost_arch_1728642916 has 513906 entries.
11/10/2024 12:35:16 - BOOST INFO: Boost counting entries in archive tables ...
11/10/2024 12:35:16 - BOOST INFO: Boost done rotating poller_output_boost
11/10/2024 12:35:16 - BOOST INFO: Boost rotating poller_output_boost into archive table: poller_output_boost_arch_1728642916
11/10/2024 12:35:16 - BOOST INFO: Boost preparing tables ...
The temp table are not on my DB server, and I can't find the link with weathermap.

Any hint ?
Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: Boost giving me some hard time with the DB, and or Wheathermap

Post by macan »

https://github.com/Cacti/cacti/commit/d ... 74362b41f2

Change one line in file lib/boost.php
Let the Cacti grow!
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests