Skip to main content
Solved

Partitioning alert got critical in database

  • May 27, 2024
  • 3 replies
  • 541 views
Naveen_rch
Forum|alt.badge.img+2

Hi all,

we have received critical alert for partitioning at database.

Please find the status info in the below.

CRITICAL: Partitions for table 'centreon_storage.logs' are not up to date (current retention forward in days: 0) - Partitions for table 'centreon_storage.log_archive_service' are not up to date (current retention forward in days: 0) - Partitions for table 'centreon_storage.log_archive_host' are not up to date (current retention forward in days: 0) UNKNOWN: Couldn't get partition infos for table 'centreon_storage.data_bin'

FYI we are using the version of - Centreon 22.04.19

Can anyone help me out of this issue.

 

Thanks in advance.

Best answer by thakala

This means that database partitioning task is not running properly on your system.

Database partitioning is being executed daily in /etc/cron.d/centstorage cronjob of your Centreon frontend server, it logs to /var/log/centreon/centreon-partitioning.log which should give you some hints why it might be failing.

You should probably also check if partitioning task is stuck waiting lock in MySQL, run a mysql shell and execut “show processlist;”

If you see any ALTER TABLE queries check what their state is, for example it could be waiting a lock which prevents it from executing until lock is released 

Waiting for table metadata lock | ALTER TABLE `centreon_storage`.data_bin REORGANIZE PARTITION `pmax` INTO (PARTITION

3 replies

T
Forum|alt.badge.img+6
  • thakala
  • Steward **
  • Answer
  • May 27, 2024

This means that database partitioning task is not running properly on your system.

Database partitioning is being executed daily in /etc/cron.d/centstorage cronjob of your Centreon frontend server, it logs to /var/log/centreon/centreon-partitioning.log which should give you some hints why it might be failing.

You should probably also check if partitioning task is stuck waiting lock in MySQL, run a mysql shell and execut “show processlist;”

If you see any ALTER TABLE queries check what their state is, for example it could be waiting a lock which prevents it from executing until lock is released 

Waiting for table metadata lock | ALTER TABLE `centreon_storage`.data_bin REORGANIZE PARTITION `pmax` INTO (PARTITION

Naveen_rch
Forum|alt.badge.img+2
  • Naveen_rch
  • Author
  • Steward *
  • May 28, 2024

Hi Thakala,

Thanks for your inputs, Let me try this one.

 

fgbetokpanou
Centreonian
Forum|alt.badge.img+11

Hi @Naveen_rch,

After trying out his solution, what was the outcome? Please don't forget to select the “Best Answer” button below @thakala’s comment, or simply let us know how you resolved the issue.

It will undoubtedly help someone with the same problem.

Thank you,

Here to help you enjoy your experience on The Watch ¯\_ (ツ) _/¯
    Terms & ConditionsCookie settingsAccessibility statement