Skip to content

Flaky test: 01079_parallel_alter_detach_table_zookeeper #97358

@vdimir

Description

@vdimir

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_

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CItestingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions