Skip to main content

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.

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

Hi Thakala,

Thanks for your inputs, Let me try this one.

 

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,

Reply


Terms & ConditionsCookie settings