We often encounter 388 status errors during the optimize table xxxx on cluster 'xxx-cluster' final merge, which cannot be resolved
Code: 388. DB::Exception: There was an error on [10.x.x.x:9000]: Code: 388. DB::Exception: Cannot select parts for optimization: Part db9dac7d35bb1a2b1679b67437c85c28_655_1001_30_658 has already been assigned a merge into db9dac7d35bb1a2b1679b67437c85c28_655_1002_31_658 (in partition db9dac7d35bb1a2b1679b67437c85c28). (CANNOT_ASSIGN_OPTIMIZE) (version 22.3.2.1). (CANNOT_ASSIGN_OPTIMIZE) (version 22.3.2.1) │ optimize table fin_xx_local.prd_xxx_hourly_360big_mv on cluster 'xxx-cluster' final settings replication_alter_partitions_sync=2,optimize_throw_if_noop = 1,distributed_ddl_task_timeout = 1200
Could you please help analyze it? It has had a significant impact on us. Thank you very much
