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.

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

Rare race condition between Boost and Poller can result in unexpected missing table errors #3655

Closed
bmfmancini opened this issue Jul 2, 2020 · 0 comments · Fixed by #3680
Labels
bug Undesired behaviour resolved A fixed issue
Milestone

Comments

@bmfmancini
Copy link
Member

Hey Guys

From time to time I see the following Boost errors

2020/07/02 14:19:38 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.poller_output_boost_arch_1593713562' doesn't exist

SQL backtrace error

2020/07/02 14:19:38 - CMDPHP SQL Backtrace: (/graph_json.php[159]:rrdtool_function_graph(), /lib/rrd.php[1257]:boost_graph_cache_check(), /lib/boost.php[352]:boost_process_poller_output(), /lib/boost.php[899]:db_execute_prepared())

I have not been able to pinpoint the event that causes it to happen and it's not everyday

This seems to be since v1.2.12 but could have been earlier versions

Not sure if we are looking at a bug or not

@bmfmancini bmfmancini added bug Undesired behaviour unverified Some days we don't have a clue labels Jul 2, 2020
@TheWitness TheWitness removed the unverified Some days we don't have a clue label Jul 11, 2020
@TheWitness TheWitness changed the title Periodic Boost Errors v1.2.12 Periodic Boost Errors due to missing tables Jul 11, 2020
@TheWitness TheWitness added this to the 1.2.13 milestone Jul 11, 2020
@TheWitness TheWitness added the resolved A fixed issue label Jul 11, 2020
@TheWitness TheWitness linked a pull request Jul 11, 2020 that will close this issue
@netniV netniV changed the title Periodic Boost Errors due to missing tables Rare race condition between Boost and Poller can result in unexpected missing table errors Jul 12, 2020
@netniV netniV closed this as completed Jul 13, 2020
@github-actions github-actions bot locked and limited conversation to collaborators Oct 12, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Undesired behaviour resolved A fixed issue
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants