Hi,

The service ‘Partitioning’ on my server goes critical.

Result of /usr/share/centreon-bi/etl/centreonbiMonitoring.pl --db-content
bmod_bi_metriccentilemonthlyvalue: 2023-07-01 00:00:00] :mod_bi_metriccentileweeklyvalue: 2023-07-17 00:00:00]

database view from centreon-web:

command i try :

nohup /usr/share/centreon-bi/etl/dimensionsBuilder.pl -d > /var/log/centreon-bi/rebuild_dimensions.log &

2023-10-10 14:42:17 - INFO - Getting servicecategories properties from Centreon database
2023-10-10 14:42:17 - INFO - Updating servicecategories dimension in Centstorage
2023-10-10 14:42:17 - INFO - Getting service properties from Centreon database
2023-10-10 14:42:17 - INFO - Updating service dimension in Centstorage
2023-10-10 14:42:17 - INFO - Updating metric dimension in Centstorage
2023-10-10 14:42:17 - INFO - Updating liveservice dimension in Centstorage
2023-10-10 14:42:17 - INFO - Updating centile properties
2023-10-10 14:42:17 - INFO - Send ACL synchronization signal to CBIS
2023-10-10 14:42:17 - INFO - FSCHEDULER]UDIMENSIONS] <<<<<<< end
2023-10-10 14:42:17 - INFO - FSCHEDULER] <<<<<<< end

nohup /usr/share/centreon-bi/etl/eventStatisticsBuilder.pl -r --events-only > /var/log/centreon-bi/rebuild_events.log &

2023-10-10 14:42:57 - INFO - FSCHEDULER] >>>>>>> start
2023-10-10 14:42:59 - INFO - FSCHEDULER]UEVENT] >>>>>>> start
2023-10-10 14:43:01 - INFO - FHOST] Processing host events
2023-10-10 14:43:01 - INFO - FHOST] Loading calculated events in reporting table
2023-10-10 14:43:13 - INFO - FSERVICE] Processing service events
2023-10-10 14:43:13 - INFO - FSERVICE] Loading calculated events in reporting table
2023-10-10 14:43:13 - INFO - FSCHEDULER]UEVENT] <<<<<<< end
2023-10-10 14:43:13 - INFO - FSCHEDULER] <<<<<<< end

nohup /usr/share/centreon-bi/etl/eventStatisticsBuilder.pl -r --no-purge --availability-only -s 2023-07-01 -e 2023-07-31 > /var/log/centreon-bi/rebuild_availability.log &

2023-10-10 14:44:05 - INFO - FPURGE] Truncate partition 20230705 on table amod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - FPURGE] Truncate partition 20230706 on table amod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - FPURGE] Truncate partition 20230707 on table amod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - FPURGE] Truncate partition 20230708 on table amod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - FPURGE] Truncate partition 20230709 on table amod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - FPURGE] Truncate partition 20230710 on table amod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - FPURGE] Truncate partition 20230711 on table amod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - FPARTITIONS] Add partition tp20230712] on table amod_bi_hostavailability]
2023-10-10 14:44:05 - ERROR - SQL error: VALUES LESS THAN value must be strictly increasing for each partition (caller: gorgone::modules::centreon::mbi::etlworkers::event::main:/usr/share/perl5/vendor_perl/gorgone/modules/centreon/mbi/etlworkers/event/main.pm:72)
Query: ALTER TABLE `mod_bi_hostavailability` ADD PARTITION (PARTITION `p20230712` VALUES LESS THAN(1689112800))