Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Boost does not operate as it should in certain situations #4623

Closed
bmfmancini opened this issue Mar 15, 2022 · 2 comments
Closed

Boost does not operate as it should in certain situations #4623

bmfmancini opened this issue Mar 15, 2022 · 2 comments
Labels
bug Undesired behaviour resolved A fixed issue

Comments

@bmfmancini
Copy link
Member

Hey guys

After testing the latest commits I am seeing boost reported as crashed however its creating many db tables
i only have 1 device on this system withe 3 remote collectors

Boost reports
BOOST ERROR: Failed to retrieve archive table name

running boost manually produces this result

[root@cacti-main cacti]# php poller_boost.php --verbose --force --debug
PHP Warning: Use of undefined constant cacti - assumed 'cacti' (this will throw an Error in a future version of PHP) in /var/www/html/cacti/include/config.php on line 32
DEBUG: Checking if Boost is ready to run.
DEBUG: Last Runtime was 2022-03-15 05:52:05 (1647337925).
DEBUG: Next Runtime is 2022-03-15 06:52:05 (1647341525).
DEBUG: Records Found:0, Max Threshold:1000000.
DEBUG: Time to Run Boost, Force Run is true!
DEBUG: Parallel Process Setup Begins.

| poller_output_boost                 |
| poller_output_boost_arch_1647341525 |
| poller_output_boost_arch_1647341585 |
| poller_output_boost_arch_1647341645 |
| poller_output_boost_arch_1647341705 |
| poller_output_boost_arch_1647341765 |
| poller_output_boost_arch_1647341826 |
| poller_output_boost_arch_1647341886 |
| poller_output_boost_arch_1647341946 |
| poller_output_boost_arch_1647342005 |
| poller_output_boost_arch_1647342066 |
| poller_output_boost_arch_1647342125 |
| poller_output_boost_arch_1647342185 |
| poller_output_boost_arch_1647342245 |
| poller_output_boost_arch_1647342305 |
| poller_output_boost_arch_1647342365 |
| poller_output_boost_arch_1647342426 |
| poller_output_boost_arch_1647342486 |
| poller_output_boost_arch_1647342545 |
| poller_output_boost_arch_1647342606 |
| poller_output_boost_arch_1647342665 |
| poller_output_boost_arch_1647342725 |
| poller_output_boost_arch_1647342785 |
| poller_output_boost_arch_1647342845 |
| poller_output_boost_arch_1647342906 |
| poller_output_boost_arch_1647342965 |
| poller_output_boost_arch_1647343026 |
| poller_output_boost_arch_1647343084 |
| poller_output_boost_arch_1647343145 |
| poller_output_boost_arch_1647343205 |
| poller_output_boost_arch_1647343265 |
| poller_output_boost_arch_1647343325 |
| poller_output_boost_arch_1647343385 |
| poller_output_boost_arch_1647343445 |
| poller_output_boost_arch_1647343505 |
| poller_output_boost_arch_1647343566 |
| poller_output_boost_arch_1647343625 |
| poller_output_boost_arch_1647343685 |
| poller_output_boost_arch_1647343745 |
| poller_output_boost_arch_1647343805 |
| poller_output_boost_arch_1647343865 |
| poller_output_boost_arch_1647343925 |
| poller_output_boost_arch_1647343986 |
| poller_output_boost_arch_1647344045 |
| poller_output_boost_arch_1647344105 |
| poller_output_boost_arch_1647344165 |
| poller_output_boost_arch_1647344225 |
| poller_output_boost_arch_1647344285 |
| poller_output_boost_arch_1647344345 |
| poller_output_boost_arch_1647344405 |
| poller_output_boost_arch_1647344466 |
| poller_output_boost_arch_1647344525 |
| poller_output_boost_arch_1647344586 |
| poller_output_boost_arch_1647344645 |
| poller_output_boost_arch_1647344705 |
| poller_output_boost_arch_1647344765 |
| poller_output_boost_arch_1647344825 |
| poller_output_boost_arch_1647344885 |
| poller_output_boost_arch_1647344945 |
| poller_output_boost_arch_1647345005 |
| poller_output_boost_arch_1647345065 |
| poller_output_boost_arch_1647345125 |
| poller_output_boost_arch_1647345185 |
| poller_output_boost_arch_1647345246 |
| poller_output_boost_arch_1647345306 |
| poller_output_boost_arch_1647345365 |
| poller_output_boost_arch_1647345425 |
| poller_output_boost_arch_1647345485 |
| poller_output_boost_arch_1647345546 |
| poller_output_boost_arch_1647345605 |
| poller_output_boost_arch_1647345665 |
| poller_output_boost_arch_1647345725 |
| poller_output_boost_arch_1647345785 |
| poller_output_boost_arch_1647345845 |
| poller_output_boost_arch_1647345906 |
| poller_output_boost_arch_1647345965 |
| poller_output_boost_arch_1647346026 |
| poller_output_boost_arch_1647346085 |
| poller_output_boost_arch_1647346145 |
| poller_output_boost_arch_1647346205 |
| poller_output_boost_arch_1647346266 |
| poller_output_boost_arch_1647346325 |
| poller_output_boost_arch_1647346385 |
| poller_output_boost_arch_1647346445 |
| poller_output_boost_arch_1647346506 |
| poller_output_boost_arch_1647346565 |
| poller_output_boost_arch_1647346625 |
| poller_output_boost_arch_1647346685 |
| poller_output_boost_arch_1647346746 |
| poller_output_boost_arch_1647346805 |
| poller_output_boost_arch_1647346865 |
| poller_output_boost_arch_1647346925 |
| poller_output_boost_arch_1647346985 |
| poller_output_boost_arch_1647347046 |
| poller_output_boost_arch_1647347104 |
| poller_output_boost_arch_1647347165 |
| poller_output_boost_arch_1647347225 |
| poller_output_boost_arch_1647347285 |
| poller_output_boost_arch_1647347345 |
| poller_output_boost_arch_1647347405 |
| poller_output_boost_arch_1647347465 |
| poller_output_boost_arch_1647347526 |
| poller_output_boost_arch_1647347585 |
| poller_output_boost_arch_1647347646 |
| poller_output_boost_arch_1647347705 |
| poller_output_boost_arch_1647347766 |
| poller_output_boost_arch_1647347825 |
| poller_output_boost_arch_1647347886 |
| poller_output_boost_arch_1647347945 |
| poller_output_boost_arch_1647348006 |
| poller_output_boost_arch_1647348065 |
| poller_output_boost_arch_1647348125 |
| poller_output_boost_arch_1647348186 |
| poller_output_boost_arch_1647348245 |
| poller_output_boost_arch_1647348306 |
| poller_output_boost_arch_1647348365 |
| poller_output_boost_arch_1647348425 |
| poller_output_boost_arch_1647348486 |
| poller_output_boost_arch_1647348546 |
| poller_output_boost_arch_1647348605 |
| poller_output_boost_arch_1647348666 |
| poller_output_boost_arch_1647348725 |
| poller_output_boost_arch_1647348786 |
| poller_output_boost_arch_1647348845 |
| poller_output_boost_arch_1647348905 |
| poller_output_boost_arch_1647348965 |
| poller_output_boost_arch_1647349025 |
| poller_output_boost_arch_1647349086 |
| poller_output_boost_arch_1647349145 |
| poller_output_boost_arch_1647349206 |
| poller_output_boost_arch_1647349266 |
| poller_output_boost_arch_1647349325 |
| poller_output_boost_arch_1647349385 |
| poller_output_boost_arch_1647349445 |
| poller_output_boost_arch_1647349506 |
| poller_output_boost_arch_1647349565 |
| poller_output_boost_arch_1647349626 |
| poller_output_boost_arch_1647349685 |
| poller_output_boost_arch_1647349747 |
| poller_output_boost_arch_1647349806 |
| poller_output_boost_arch_1647349865 |
| poller_output_boost_arch_1647349926 |
| poller_output_boost_arch_1647349985 |
| poller_output_boost_arch_1647350046 |
| poller_output_boost_arch_1647350105 |
| poller_output_boost_arch_1647350165 |
| poller_output_boost_arch_1647350225 |
| poller_output_boost_arch_1647350286 |
| poller_output_boost_arch_1647350345 |
| poller_output_boost_arch_1647350405 |
| poller_output_boost_arch_1647350466 |
| poller_output_boost_arch_1647350526 |
| poller_output_boost_arch_1647350585 |
| poller_output_boost_arch_1647350646 |
| poller_output_boost_arch_1647350705 |
| poller_output_boost_arch_1647350766 |
| poller_output_boost_arch_1647350825 |
| poller_output_boost_arch_1647350886 |
| poller_output_boost_arch_1647350945 |
| poller_output_boost_arch_1647351006 |
| poller_output_boost_arch_1647351065 |
| poller_output_boost_arch_1647351125 |
| poller_output_boost_arch_1647351185 |
| poller_output_boost_arch_1647351246 |
| poller_output_boost_arch_1647351305 |
| poller_output_boost_arch_1647351366 |
| poller_output_boost_arch_1647351425 |
| poller_output_boost_arch_1647351485 |
| poller_output_boost_arch_1647351546 |
| poller_output_boost_arch_1647351606 |
| poller_output_boost_arch_1647351666 |
| poller_output_boost_arch_1647351725 |
| poller_output_boost_arch_1647351786 |
| poller_output_boost_arch_1647351845 |
| poller_output_boost_arch_1647351906 |
| poller_output_boost_arch_1647351966 |
| poller_output_boost_arch_1647352026 |
| poller_output_boost_arch_1647352085 |
| poller_output_boost_arch_1647352145 |
| poller_output_boost_arch_1647352205 |
| poller_output_boost_arch_1647352265 |
| poller_output_boost_arch_1647352325 |
| poller_output_boost_arch_1647352386 |
| poller_output_boost_arch_1647352445 |
| poller_output_boost_arch_1647352505 |
| poller_output_boost_arch_1647352565 |
| poller_output_boost_arch_1647352625 |
| poller_output_boost_arch_1647352686 |
| poller_output_boost_arch_1647352745 |
| poller_output_boost_arch_1647352805 |
| poller_output_boost_arch_1647352866 |
| poller_output_boost_arch_1647352926 |
| poller_output_boost_arch_1647352985 |
| poller_output_boost_arch_1647353045 |
| poller_output_boost_arch_1647353105 |
| poller_output_boost_arch_1647353166 |
| poller_output_boost_arch_1647353225 |
| poller_output_boost_arch_1647353285 |
| poller_output_boost_arch_1647353345 |
| poller_output_boost_arch_1647353406 |
| poller_output_boost_arch_1647353465 |
| poller_output_boost_arch_1647353525 |
| poller_output_boost_arch_1647353585 |
| poller_output_boost_arch_1647353645 |
| poller_output_boost_arch_1647353705 |
| poller_output_boost_arch_1647353765 |
| poller_output_boost_arch_1647353826 |
| poller_output_boost_arch_1647353886 |
| poller_output_boost_arch_1647353946 |
| poller_output_boost_arch_1647353979 |
| poller_output_boost_arch_1647354005 |
| poller_output_boost_arch_1647354065 |
| poller_output_boost_arch_1647354126 |
| poller_output_boost_arch_1647354185 |
| poller_output_boost_arch_1647354245 |
| poller_output_boost_arch_1647354306 |
| poller_output_boost_arch_1647354365 |
| poller_output_boost_arch_1647354425 |
| poller_output_boost_arch_1647354485 |
| poller_output_boost_arch_1647354546 |
| poller_output_boost_arch_1647354606 |
| poller_output_boost_arch_1647354620 |
| poller_output_boost_arch_1647354665 |
@bmfmancini bmfmancini added bug Undesired behaviour unverified Some days we don't have a clue labels Mar 15, 2022
@browniebraun
Copy link
Member

Have you already applied my update for poller_boost.php committed 4 hours ago? I noticed the same situation this morning on my lab instance, but in my case it started after upgrading MariaDB to version 10.6.7. I have seen that the information schema is not updating when boost renames table poller_output_boost. It is always returning Tables_rows = 0.

@browniebraun browniebraun removed the unverified Some days we don't have a clue label Mar 15, 2022
browniebraun referenced this issue Mar 15, 2022
@browniebraun
force update of information table schema
94bfec8 
ensure that information schema will not return TABLE_ROWS = 0 as seen in MariaDB 10.6.7
@bmfmancini
Copy link
Member Author

bmfmancini commented Mar 15, 2022 via email

@TheWitness TheWitness changed the title [1.2.20] Boost creates multiple DB tables and reports its crashed but is not running Boost creates multiple DB tables and reports its crashed but is not running Mar 16, 2022
TheWitness added a commit that referenced this issue Mar 16, 2022
@TheWitness
Fixing Issue #4623 - ChangeLog Update
2978942 
This is an update to the changelog and a softtab removal.
@TheWitness TheWitness added the resolved A fixed issue label Mar 16, 2022
@netniV netniV changed the title Boost creates multiple DB tables and reports its crashed but is not running Boost does not operate as it should in certain situations Apr 3, 2022
@github-actions github-actions bot locked and limited conversation to collaborators Dec 1, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
bug Undesired behaviour resolved A fixed issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@TheWitness @browniebraun @bmfmancini