Flaky test: 02319_lightweight_delete_on_merge_tree #92633
Description
Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.
Test name: 02319_lightweight_delete_on_merge_tree
Failure reason: result differs with reference
CI report: Stateless tests (amd_debug, AsyncInsert, s3 storage, parallel)
CIDB statistics: cidb
Test output:
2025-12-19 10:04:06 Reason: result differs with reference:
2025-12-19 10:04:06 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02319_lightweight_delete_on_merge_tree.reference 2025-12-19 09:54:18.737515223 +0500
2025-12-19 10:04:06 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02319_lightweight_delete_on_merge_tree.stdout 2025-12-19 10:04:06.450120809 +0500
2025-12-19 10:04:06 @@ -4,32 +4,32 @@
2025-12-19 10:04:06 1
2025-12-19 10:04:06 0
2025-12-19 10:04:06 1
2025-12-19 10:04:06 -----lightweight mutation type-----
2025-12-19 10:04:06 1
2025-12-19 10:04:06 1
2025-12-19 10:04:06 1
2025-12-19 10:04:06 (UPDATE _row_exists = 0 WHERE (c % 5) = 1) 1
2025-12-19 10:04:06 (UPDATE _row_exists = 0 WHERE c = 4) 1
2025-12-19 10:04:06 (MATERIALIZE INDEX i_c) 1
2025-12-19 10:04:06 -(UPDATE b = -1 WHERE a < 3) 1
2025-12-19 10:04:06 -(DROP INDEX i_c) 1
2025-12-19 10:04:06 +(UPDATE b = -1 WHERE a < 3) 0
2025-12-19 10:04:06 +(DROP INDEX i_c) 0
2025-12-19 10:04:06 -----Check that select and merge with lightweight delete.-----
2025-12-19 10:04:06 7
2025-12-19 10:04:06 -0 -1 0
2025-12-19 10:04:06 +0 0 0
2025-12-19 10:04:06 2 -1 2
2025-12-19 10:04:06 3 3 3
2025-12-19 10:04:06 5 5 5
2025-12-19 10:04:06 7 7 7
2025-12-19 10:04:06 8 8 8
2025-12-19 10:04:06 9 9 9
2025-12-19 10:04:06 -t_light 0 0_1_1_0_10 2
2025-12-19 10:04:06 +t_light 0 0_1_1_0_8 2
2025-12-19 10:04:06 t_light 1 1_2_2_0_10 2
2025-12-19 10:04:06 t_light 2 2_3_3_0_10 2
2025-12-19 10:04:06 t_light 3 3_4_4_0_10 2
2025-12-19 10:04:06 t_light 4 4_5_5_0_10 2
2025-12-19 10:04:06 7
2025-12-19 10:04:06 t_light 0 0_1_1_1_10 2
2025-12-19 10:04:06 t_light 2 2_3_3_1_10 2
2025-12-19 10:04:06 t_light 3 3_4_4_1_10 2
2025-12-19 10:04:06 t_light 4 4_5_5_1_10 1
2025-12-19 10:04:06 -----Test lightweight delete in multi blocks-----
2025-12-19 10:04:06
2025-12-19 10:04:06
2025-12-19 10:04:06
2025-12-19 10:04:06 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 7505773205 --vertical_merge_algorithm_min_rows_to_activate 847878 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 3503798 --merge_max_block_size 21863 --index_granularity 27384 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 48952 --primary_key_compress_block_size 15890 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 92788809 --compact_parts_max_granules_to_buffer 98 --compact_parts_merge_max_bytes_to_prefetch_part 16544586 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 480 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 --object_serialization_version v3 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts map_with_buckets --object_shared_data_buckets_for_compact_part 16 --object_shared_data_buckets_for_wide_part 29 --dynamic_serialization_version v2 --auto_statistics_types uniq,tdigest,countmin --serialization_info_version with_types --string_serialization_version with_size_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 1
2025-12-19 10:04:06
2025-12-19 10:04:06 Database: test_zledkslr