Hi @Achraf04 

Create table using:

CREATE TABLE IF NOT EXISTS `data_bin` (
  `id_metric` int(11) DEFAULT NULL,
  `ctime` int(11) DEFAULT NULL,
  `value` float DEFAULT NULL,
  `status` enum('0','1','2','3','4') DEFAULT NULL,
  KEY `index_metric` (`id_metric`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Then execute cron manually:

php /usr/share/centreon/cron/centreon-partitioning.php

Thank you for your answer @Laurent.

However, I have already created the table after the crash. Unfortunately, I encountered an error indicating that a partition already exists.

One thing that caught my attention is when I manually executed the partition cron, the output of the partition p<year><month><day> showed the same day as the execution, but the year was different.

Should I make any changes in the configuration or do I need to delete all partitions in the MySQL disk storage /var/lib/mysql/centreon_storage/? I'm concerned about losing the data bin_data.

Hi @Achraf04 

Are you sure that you will need the older data_bin datas in the future ? :)

Actually, they’re required if you want to rebuild your graphs, of if you use Centreon MBI and need to rebuild your performances datas. That’s all.
So you certainly can restart with an empty data_bin table, it will directly affect the monitoring only if you have to rebuild some graphs (their history will start at the first data_bin data if you rebuild).

If you still have a lot of datas on the centreon_storage database (a big retention conf. for logs, etc.) and a whole dump seems to be complicated due to the time it will take, you can try to manually delete the partitions on the disk, but it can be risky to broke the consistency even more.

I’m not a DBA but  IMO the proper way to resolve such an inconsistency should be to :

0. Make a backup (VM snapshot, LVM snapshot...)

1. dump centreon_storage database (as its data_bin table is corrupted, you certainly have nothing from it on the dump)
2. drop the centreon_storage DB (from the SQL console, not on the FS!)
3. stop MySQL and check that the centreon_storage folder had been deleted. If it’s not the case, rm it
4. start MySQL, create a new empty centreon_storage database
5. import your dump
6. create the data_bin table with the Laurent’s infos
7. use the PHP partitioning script on data_bin
8. check & enjoy

Last but not least, the good PHP script to use is /usr/share/centreon/bin/centreon-partitioning.php , not /usr/share/centreon/cron/centreon-partitioning.php as the last one will not create all your partitions since your retention conf, just update the futures ones.