Hi,
The service ‘Partitioning’ on my server goes critical.
Result of /usr/share/centreon-bi/etl/centreonbiMonitoring.pl --db-content
[mod_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 - [SCHEDULER][DIMENSIONS] <<<<<<< end
2023-10-10 14:42:17 - INFO - [SCHEDULER] <<<<<<< 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 - [SCHEDULER] >>>>>>> start
2023-10-10 14:42:59 - INFO - [SCHEDULER][EVENT] >>>>>>> start
2023-10-10 14:43:01 - INFO - [HOST] Processing host events
2023-10-10 14:43:01 - INFO - [HOST] Loading calculated events in reporting table
2023-10-10 14:43:13 - INFO - [SERVICE] Processing service events
2023-10-10 14:43:13 - INFO - [SERVICE] Loading calculated events in reporting table
2023-10-10 14:43:13 - INFO - [SCHEDULER][EVENT] <<<<<<< end
2023-10-10 14:43:13 - INFO - [SCHEDULER] <<<<<<< 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 - [PURGE] Truncate partition 20230705 on table [mod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - [PURGE] Truncate partition 20230706 on table [mod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - [PURGE] Truncate partition 20230707 on table [mod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - [PURGE] Truncate partition 20230708 on table [mod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - [PURGE] Truncate partition 20230709 on table [mod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - [PURGE] Truncate partition 20230710 on table [mod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - [PURGE] Truncate partition 20230711 on table [mod_bi_hostavailability]
2023-10-10 14:44:05 - INFO - [PARTITIONS] Add partition [p20230712] on table [mod_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))