Skip to content

Flaky test: 01111_create_drop_replicated_db_stress #95213

@Algunenano

Description

@Algunenano

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: 01111_create_drop_replicated_db_stress
Failure reason: Database is in readonly mode
CI report: Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, sequential)

Failing test history: cidb

Test output:

2026-01-24 03:06:40 Reason: having exception in stdout:  
2026-01-24 03:06:40 [localhost] 2026.01.23 23:06:15.415332 [ 180325 ] {885bd107-a367-4313-8893-b052a56d9e7f} <Error> executeQuery: Code: 225. DB::Exception: Database is in readonly mode, because it cannot connect to ZooKeeper. (NO_ZOOKEEPER) (version 26.1.1.796) (from [::1]:38400) (comment: 01111_create_drop_replicated_db_stress.sh-default) (query 1, line 1) (in query: CREATE TABLE default_repl_01111_11.rmt_10627_1775_24924 (`n` int) ENGINE = ReplicatedMergeTree ORDER BY tuple() SETTINGS index_granularity = 38881, min_bytes_for_wide_part = 1073741824, ratio_of_defaults_for_sparse_serialization = 0.7818230986595154, replace_long_file_name_to_hash = true, max_file_name_length = 0, min_bytes_for_full_part_storage = 504178528, compact_parts_max_bytes_to_buffer = 223964065, compact_parts_max_granules_to_buffer = 123, compact_parts_merge_max_bytes_to_prefetch_part = 31618363, serialization_info_version = 'basic', string_serialization_version = 'single_stream', nullable_serialization_version = 'basic', object_serialization_version = 'v3', object_shared_data_serialization_version = 'advanced', object_shared_data_serialization_version_for_zero_level_parts = 'advanced', object_shared_data_buckets_for_compact_part = 9, object_shared_data_buckets_for_wide_part = 15, dynamic_serialization_version = 'v3', merge_max_block_size = 1105, old_parts_lifetime = 215., min_columns_to_activate_adaptive_write_buffer = 632, prefer_fetch_merged_part_size_threshold = 10737418240, vertical_merge_algorithm_min_rows_to_activate = 1000000, vertical_merge_algorithm_min_columns_to_activate = 1, min_merge_bytes_to_use_direct_io = 7514690800, index_granularity_bytes = 6308427, use_const_adaptive_granularity = true, enable_index_granularity_compression = true, concurrent_part_removal_threshold = 96, allow_vertical_merges_from_compact_to_wide_parts = false, enable_block_number_column = true, enable_block_offset_column = true, auto_statistics_types = 'uniq', cache_populated_by_fetch = true, marks_compress_block_size = 91286, primary_key_compress_block_size = 87922, use_primary_key_cache = false, prewarm_primary_key_cache = true, prewarm_mark_cache = false), Stack trace (when copying this message, always include the lines below):
2026-01-24 03:06:40 Code: 225. DB::Exception: Received from localhost:9000. DB::Exception: Database is in readonly mode, because it cannot connect to ZooKeeper. (NO_ZOOKEEPER)
2026-01-24 03:06:40 
2026-01-24 03:06:40 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_k9tnpwm3/01111_create_drop_replicated_db_stress.sh.debuglog:
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:90] TIMEOUT=20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:92] create_db 20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:11] local TIMELIMIT=20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:12] '[' 0 -lt 20 ']'
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:13] SHARD=0
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:14] REPLICA=0
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:15] SUFFIX=2
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:93] sync_db 20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:41] local TIMELIMIT=20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:42] '[' 0 -lt 20 ']'
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:94] create_table 20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:53] local TIMELIMIT=20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:54] '[' 0 -lt 20 ']'
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:95] alter_table 20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:20] grep -Fa 'Exception: '
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:66] local TIMELIMIT=20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:98] sleep 1
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:67] '[' 0 -lt 20 ']'
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:96] insert 20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:79] local TIMELIMIT=20
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:80] '[' 0 -lt 20 ']'
2026-01-24 03:06:40 + [2026-01-24 03:06:10] [:18] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_k9tnpwm3 --log_comment 01111_create_drop_replicated_db_stress.sh-test_k9tnpwm3 --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 12467751 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 14600997 --max_read_buffer_size 595693 --prefer_localhost_replica 0 --max_block_size 81254 --max_joined_block_size_rows 39760 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 1 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 49 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 17953594 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 1 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --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 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 16 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 1027525279 --min_compress_block_size 2745063 --max_compress_block_size 1493564 --merge_tree_compact_parts_min_granules_to_multibuffer_read 111 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 937938 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.69 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --enable_vertical_final 0 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 0 --use_skip_indexes_on_data_read 0 --optimize_rewrite_like_perfect_affix 0 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 1 --short_circuit_function_evaluation_for_nulls_threshold 0.5830094452064247 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 983659 --query_plan_optimize_join_order_algorithm greedy,dpsize --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.09 --max_bytes_ratio_before_external_group_by 0.0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.7818231122384959 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 7514690800 --index_granularity_bytes 6308427 --merge_max_block_size 1105 --index_granularity 38881 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 91286 --primary_key_compress_block_size 87922 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 504178528 --compact_parts_max_bytes_to_buffer 223964065 --compact_parts_max_granules_to_buffer 123 --compact_parts_merge_max_bytes_to_prefetch_part 31618363 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 96 --old_parts_lifetime 215 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v3 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 9 --object_shared_data_buckets_for_wide_part 15 --dynamic_serialization_version v3 --auto_statistics_types uniq --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 0 --min_columns_to_activate_adaptive_write_buffer 632 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01111_create_drop_replicated_db_stress.stderr-fatal --query 'create database if not exists test_k9tnpwm3_repl_01111_2 engine=Replicated('\''/test/01111/01111_create_drop_replicated_db_stress_test_k9tnpwm3'\'', '\''0'\'', '\''0'\'')'
2026-01-24 03:06:40 ++ [2026-01-24 03:06:10] [:43] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_k9tnpwm3 --log_comment 01111_create_drop_replicated_db_stress.sh-test_k9tnpwm3 --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 12467751 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 14600997 --max_read_buffer_size 595693 --prefer_localhost_replica 0 --max_block_size 81254 --max_joined_block_size_rows 39760 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 1 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 49 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 17953594 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 1 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --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 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 16 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 1027525279 --min_compress_block_size 2745063 --max_compress_block_size 1493564 --merge_tree_compact_parts_min_granules_to_multibuffer_read 111 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 937938 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.69 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --enable_vertical_final 0 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 0 --use_skip_indexes_on_data_read 0 --optimize_rewrite_like_perfect_affix 0 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 1 --short_circuit_function_evaluation_for_nulls_threshold 0.5830094452064247 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 983659 --query_plan_optimize_join_order_algorithm greedy,dpsize --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.09 --max_bytes_ratio_before_external_group_by 0.0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.7818231122384959 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 7514690800 --index_granularity_bytes 6308427 --merge_max_block_size 1105 --index_granularity 38881 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 91286 --primary_key_compress_block_size 87922 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 504178528 --compact_parts_max_bytes_to_buffer 223964065 --compact_parts_max_granules_to_buffer 123 --compact_parts_merge_max_bytes_to_prefetch_part 31618363 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 96 --old_parts_lifetime 215 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v3 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 9 --object_shared_data_buckets_for_wide_part 15 --dynamic_serialization_version v3 --auto_statistics_types uniq --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 0 --min_columns_to_activate_adaptive_write_buffer 632 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01111_create_drop_replicated_db_stress.stderr-fatal -q 'select name from system.databases where name like '\''test_k9tnpwm3%'\'' order by rand() limit 1'
2026-01-24 03:06:40 ++ [2026-01-24 03:06:10] [:55] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_k9tnpwm3 --log_comment 01111_create_drop_replicated_db_stress.sh-test_k9tnpwm3 --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 12467751 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 14600997 --max_read_buffer_size 595693 --prefer_localhost_replica 0 --max_block_size 81254 --max_joined_block_size_rows 39760 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 1 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transfo

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