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

When remote poller is in offline mode, data is written to more tables than necessary #4227

Closed
bmfmancini opened this issue Apr 12, 2021 · 0 comments
Labels
bug Undesired behaviour resolved A fixed issue
Milestone

Comments

@bmfmancini
Copy link
Member

Hey Everyone

While testing 1.2.17 off the 1.2.x branch from this morning I have found the following

when a poller is in offline mode it is supposed to write the values locally to poller_output_boost which is a innodb table
instead the poller is writting to both poller_output ( memory table) and poller_output_boost( Innodb table)
in this case the poller_output table can grown large enough to exhaust the memory of the system rather than consume the disk

Database changed
MariaDB [cacti]> select count(*),time from poller_output_boost;
+----------+---------------------+
| count(*) | time                |
+----------+---------------------+
|    17950 | 2021-04-12 12:29:01 |
+----------+---------------------+
1 row in set (0.010 sec)

MariaDB [cacti]> select count(*),time from poller_output;
+----------+---------------------+
| count(*) | time                |
+----------+---------------------+
|    17950 | 2021-04-12 12:29:01 |
+----------+---------------------+
1 row in set (0.027 sec)

MariaDB [cacti]>

image

@bmfmancini bmfmancini added bug Undesired behaviour unverified Some days we don't have a clue labels Apr 12, 2021
@TheWitness TheWitness changed the title [1.2.17] - When remote poller is in offline mode data is written to poller_output as well as poller_output_boost When remote poller is in offline mode data is written to poller_output as well as poller_output_boost Apr 13, 2021
@TheWitness TheWitness removed the unverified Some days we don't have a clue label Apr 13, 2021
@TheWitness TheWitness added this to the v1.2.17 milestone Apr 13, 2021
TheWitness added a commit that referenced this issue Apr 13, 2021
When remote poller is in offline mode data is written to poller_output as well as poller_output_boost
@TheWitness TheWitness added the resolved A fixed issue label Apr 13, 2021
@netniV netniV changed the title When remote poller is in offline mode data is written to poller_output as well as poller_output_boost When remote poller is in offline mode, data is written to more tables than necessary Apr 30, 2021
@github-actions github-actions bot locked and limited conversation to collaborators Jul 30, 2021
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

No branches or pull requests

2 participants