-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Flaky test: 01079_parallel_alter_detach_table_zookeeper #97358
Copy link
Copy link
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
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: 01079_parallel_alter_detach_table_zookeeper
Failure reason: y
CI report: Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, sequential)
Failing test history: cidb
Test output:
2026-02-18 20:29:18 Reason: result differs with reference:
2026-02-18 20:29:18 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01079_parallel_alter_detach_table_zookeeper.reference 2026-02-18 19:40:35.892756987 +0200
2026-02-18 20:29:18 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01079_parallel_alter_detach_table_zookeeper.stdout 2026-02-18 20:29:18.628829040 +0200
2026-02-18 20:29:18 @@ -1,11 +1,15 @@
2026-02-18 20:29:18 1725
2026-02-18 20:29:18 1725
2026-02-18 20:29:18 1725
2026-02-18 20:29:18 Starting alters
2026-02-18 20:29:18 Finishing alters
2026-02-18 20:29:18 1
2026-02-18 20:29:18 0
2026-02-18 20:29:18 +Received exception from server (version 26.2.1):
2026-02-18 20:29:18 +(query: DROP TABLE IF EXISTS concurrent_alter_detach_1)
2026-02-18 20:29:18 1
2026-02-18 20:29:18 0
2026-02-18 20:29:18 +Received exception from server (version 26.2.1):
2026-02-18 20:29:18 +(query: DROP TABLE IF EXISTS concurrent_alter_detach_2)
2026-02-18 20:29:18 1
2026-02-18 20:29:18 0
2026-02-18 20:29:18
2026-02-18 20:29:18
2026-02-18 20:29:18 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_lgv3os3q/01079_parallel_alter_detach_table_zookeeper.sh.debuglog:
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:10] REPLICAS=3
2026-02-18 20:29:18 ++ [2026-02-18 20:21:15] [:12] seq 3
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:12] for i in $(seq $REPLICAS)
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] grep -Fv TIMEOUT_EXCEEDED
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=fatal --database=test_lgv3os3q --log_comment 01079_parallel_alter_detach_table_zookeeper.sh-test_lgv3os3q --max_insert_threads 1 --group_by_two_level_threshold 667697 --group_by_two_level_threshold_bytes 44385929 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 15544538 --max_read_buffer_size 821517 --prefer_localhost_replica 1 --max_block_size 32767 --max_joined_block_size_rows 44326 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 1000000 --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 85 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 46840610 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --distributed_cache_discard_connection_if_unread_data 0 --distributed_cache_use_clients_cache_for_write 0 --distributed_cache_use_clients_cache_for_read 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --enable_filesystem_cache 1 --enable_filesystem_cache_on_write_operations 0 --compile_expressions 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 24 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 2033881898 --min_compress_block_size 1027238 --max_compress_block_size 475666 --merge_tree_compact_parts_min_granules_to_multibuffer_read 76 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 5655961 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache False --use_page_cache_for_local_disks False --use_page_cache_for_object_storage False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.85 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 1 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 1 --optimize_rewrite_like_perfect_affix 1 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 0 --short_circuit_function_evaluation_for_nulls_threshold 0.6835340054652665 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 821826 --query_plan_optimize_join_order_algorithm greedy --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.0 --use_skip_indexes_if_final_exact_mode 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.11753900819817731 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 836447 --vertical_merge_algorithm_min_columns_to_activate 81 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 18371390 --merge_max_block_size 16577 --index_granularity 18081 --min_bytes_for_wide_part 0 --marks_compress_block_size 14985 --primary_key_compress_block_size 64484 --replace_long_file_name_to_hash 1 --max_file_name_length 61 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 384873606 --compact_parts_max_granules_to_buffer 159 --compact_parts_merge_max_bytes_to_prefetch_part 7964020 --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 0 --enable_block_offset_column 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 --object_serialization_version v2 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 26 --object_shared_data_buckets_for_wide_part 13 --dynamic_serialization_version v3 --auto_statistics_types uniq,countmin,minmax,tdigest --serialization_info_version basic --string_serialization_version with_size_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 673 --reduce_blocking_parts_sleep_ms 253 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 2 --allow_repeated_settings --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01079_parallel_alter_detach_table_zookeeper.stderr-fatal --query 'DROP TABLE IF EXISTS concurrent_alter_detach_1'
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] :
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:12] for i in $(seq $REPLICAS)
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] grep -Fv TIMEOUT_EXCEEDED
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=fatal --database=test_lgv3os3q --log_comment 01079_parallel_alter_detach_table_zookeeper.sh-test_lgv3os3q --max_insert_threads 1 --group_by_two_level_threshold 667697 --group_by_two_level_threshold_bytes 44385929 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 15544538 --max_read_buffer_size 821517 --prefer_localhost_replica 1 --max_block_size 32767 --max_joined_block_size_rows 44326 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 1000000 --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 85 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 46840610 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --distributed_cache_discard_connection_if_unread_data 0 --distributed_cache_use_clients_cache_for_write 0 --distributed_cache_use_clients_cache_for_read 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --enable_filesystem_cache 1 --enable_filesystem_cache_on_write_operations 0 --compile_expressions 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 24 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 2033881898 --min_compress_block_size 1027238 --max_compress_block_size 475666 --merge_tree_compact_parts_min_granules_to_multibuffer_read 76 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 5655961 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache False --use_page_cache_for_local_disks False --use_page_cache_for_object_storage False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.85 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 1 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 1 --optimize_rewrite_like_perfect_affix 1 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 0 --short_circuit_function_evaluation_for_nulls_threshold 0.6835340054652665 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 821826 --query_plan_optimize_join_order_algorithm greedy --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.0 --use_skip_indexes_if_final_exact_mode 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.11753900819817731 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 836447 --vertical_merge_algorithm_min_columns_to_activate 81 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 18371390 --merge_max_block_size 16577 --index_granularity 18081 --min_bytes_for_wide_part 0 --marks_compress_block_size 14985 --primary_key_compress_block_size 64484 --replace_long_file_name_to_hash 1 --max_file_name_length 61 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 384873606 --compact_parts_max_granules_to_buffer 159 --compact_parts_merge_max_bytes_to_prefetch_part 7964020 --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 0 --enable_block_offset_column 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 --object_serialization_version v2 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 26 --object_shared_data_buckets_for_wide_part 13 --dynamic_serialization_version v3 --auto_statistics_types uniq,countmin,minmax,tdigest --serialization_info_version basic --string_serialization_version with_size_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 673 --reduce_blocking_parts_sleep_ms 253 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 2 --allow_repeated_settings --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01079_parallel_alter_detach_table_zookeeper.stderr-fatal --query 'DROP TABLE IF EXISTS concurrent_alter_detach_2'
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] :
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:12] for i in $(seq $REPLICAS)
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] grep -Fv TIMEOUT_EXCEEDED
2026-02-18 20:29:18 + [2026-02-18 20:21:15] [:13] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=fatal --database=test_lgv3os3q --log_comment 01079_parallel_alter_detach_table_zookeeper.sh-test_lgv3os3q --max_insert_threads 1 --group_by_two_level_threshold 667697 --group_by_two_level_threshold_bytes 44385929 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 15544538 --max_read_buffer_size 821517 --prefer_localhost_replica 1 --max_block_size 32767 --max_joined_block_size_rows 44326 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 1000000 --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 85 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 46840610 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --distributed_cache_discard_connection_if_unread_data 0 --distributed_cache_use_clients_cache_for_write 0 --distributed_cache_use_clients_cache_for_read 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --enable_filesystem_cache 1 --enable_filesystem_cache_on_write_
Reactions are currently unavailable
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