-
Notifications
You must be signed in to change notification settings - Fork 7.5k
Closed
Labels
flaky testflaky test found by CIflaky test found by CItestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI
Description
Example failure (from here):
2025-06-21 04:12:08 Reason: result differs with reference:
2025-06-21 04:12:08 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01532_execute_merges_on_single_replica_long.reference 2025-06-21 03:41:33.178319710 +0200
2025-06-21 04:12:08 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01532_execute_merges_on_single_replica_long.stdout 2025-06-21 04:12:08.743773891 +0200
2025-06-21 04:12:08 @@ -61,17 +61,17 @@
2025-06-21 04:12:08 Row 5:
2025-06-21 04:12:08 ──────
2025-06-21 04:12:08 part_name: all_0_0_5
2025-06-21 04:12:08 -mergers: ['execute_on_single_replica_r1','execute_on_single_replica_r2']
2025-06-21 04:12:08 -fetchers: []
2025-06-21 04:12:08 +mergers: ['execute_on_single_replica_r1']
2025-06-21 04:12:08 +fetchers: ['execute_on_single_replica_r2']
2025-06-21 04:12:08
2025-06-21 04:12:08 Row 6:
2025-06-21 04:12:08 ──────
2025-06-21 04:12:08 part_name: all_0_0_6
2025-06-21 04:12:08 -mergers: ['execute_on_single_replica_r1','execute_on_single_replica_r2']
2025-06-21 04:12:08 -fetchers: []
2025-06-21 04:12:08 +mergers: ['execute_on_single_replica_r2']
2025-06-21 04:12:08 +fetchers: ['execute_on_single_replica_r1']
2025-06-21 04:12:08
2025-06-21 04:12:08 Row 7:
2025-06-21 04:12:08 ──────
2025-06-21 04:12:08 part_name: all_0_0_7
2025-06-21 04:12:08 -mergers: ['execute_on_single_replica_r1','execute_on_single_replica_r2']
2025-06-21 04:12:08 -fetchers: []
2025-06-21 04:12:08 +mergers: ['execute_on_single_replica_r2']
2025-06-21 04:12:08 +fetchers: ['execute_on_single_replica_r1']
2025-06-21 04:12:08
2025-06-21 04:12:08
2025-06-21 04:12:08 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 132739 --group_by_two_level_threshold_bytes 42857894 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 13572105 --max_read_buffer_size 899956 --prefer_localhost_replica 1 --max_block_size 97850 --max_joined_block_size_rows 67985 --max_threads 2 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 55 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 12111762 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 6570512954 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 0 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 17 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1194312938 --min_compress_block_size 1810053 --max_compress_block_size 1807989 --merge_tree_compact_parts_min_granules_to_multibuffer_read 113 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 7492980 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.98 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table true --enable_vertical_final 1 --optimize_extract_common_expressions 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 0 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.2 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 0
2025-06-21 04:12:08
2025-06-21 04:12:08 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 5594310430 --vertical_merge_algorithm_min_rows_to_activate 607092 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 6268185031 --index_granularity_bytes 4254283 --merge_max_block_size 23936 --index_granularity 60758 --min_bytes_for_wide_part 990181988 --marks_compress_block_size 37077 --primary_key_compress_block_size 84156 --replace_long_file_name_to_hash 1 --max_file_name_length 87 --min_bytes_for_full_part_storage 356994739 --compact_parts_max_bytes_to_buffer 389240641 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 1459112 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 121 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1
2025-06-21 04:12:08
2025-06-21 04:12:08 Database: test_5pnsbzri
Note that the failures happen only for azure + arm_asan.
Metadata
Metadata
Assignees
Labels
flaky testflaky test found by CIflaky test found by CItestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI