-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Flaky test: 01111_create_drop_replicated_db_stress #97539
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: 01111_create_drop_replicated_db_stress
Failure reason: DB::Exception: Unable to acquire the database lock of default_repl_01111_14 after 1000 ms. (TIMEOUT_EXCEEDED)
CI report: Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, sequential)
Failing test history: cidb
Test output:
2026-02-20 17:55:24 Reason: having exception in stdout:
2026-02-20 17:55:24 Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Unable to acquire the database lock of default_repl_01111_14 after 1000 ms. (TIMEOUT_EXCEEDED)
2026-02-20 17:55:24
2026-02-20 17:55:24 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_qkts4cva/01111_create_drop_replicated_db_stress.sh.debuglog:
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:92] TIMEOUT=20
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:94] create_db 20
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:13] local TIMELIMIT=21
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:14] '[' 1 -lt 21 ']'
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:95] sync_db 20
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:15] SHARD=1
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:16] REPLICA=0
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:17] SUFFIX=3
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:43] local TIMELIMIT=21
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:44] '[' 1 -lt 21 ']'
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:96] create_table 20
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:55] local TIMELIMIT=21
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:97] alter_table 20
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:56] '[' 1 -lt 21 ']'
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:100] sleep 1
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:68] local TIMELIMIT=21
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:69] '[' 1 -lt 21 ']'
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:98] insert 20
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:22] grep -Fa 'Exception: '
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:81] local TIMELIMIT=21
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:82] '[' 1 -lt 21 ']'
2026-02-20 17:55:24 + [2026-02-20 17:55:02] [:20] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=fatal --database=test_qkts4cva --log_comment 01111_create_drop_replicated_db_stress.sh-test_qkts4cva --max_insert_threads 3 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 15975634 --max_read_buffer_size 768387 --prefer_localhost_replica 0 --max_block_size 14059 --max_joined_block_size_rows 41170 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 350 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 8348720 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 3517085055 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --distributed_cache_discard_connection_if_unread_data 1 --distributed_cache_use_clients_cache_for_write 1 --distributed_cache_use_clients_cache_for_read 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --enable_filesystem_cache 0 --enable_filesystem_cache_on_write_operations 0 --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 13 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1787697372 --min_compress_block_size 2160832 --max_compress_block_size 2246210 --merge_tree_compact_parts_min_granules_to_multibuffer_read 9 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 1170839 --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 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --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.29 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 0 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 1 --optimize_extract_common_expressions 1 --use_async_executor_for_materialized_views 1 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 1 --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 0 --allow_special_serialization_kinds_in_output_formats 1 --short_circuit_function_evaluation_for_nulls_threshold 0.3300978967936698 --automatic_parallel_replicas_mode 2 --temporary_files_buffer_size 1204294 --query_plan_optimize_join_order_algorithm dpsize,greedy --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.11 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 1 --cluster_for_parallel_replicas parallel_replicas --parallel_replicas_for_non_replicated_merge_tree 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 8839333433 --vertical_merge_algorithm_min_rows_to_activate 520688 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 2494943445 --index_granularity_bytes 29233516 --merge_max_block_size 8631 --index_granularity 2907 --min_bytes_for_wide_part 0 --marks_compress_block_size 83472 --primary_key_compress_block_size 80664 --replace_long_file_name_to_hash 0 --max_file_name_length 123 --min_bytes_for_full_part_storage 196424398 --compact_parts_max_bytes_to_buffer 42987957 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 27146575 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 50 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v3 --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 7 --object_shared_data_buckets_for_wide_part 1 --dynamic_serialization_version v2 --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 694 --reduce_blocking_parts_sleep_ms 1914 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 5 --allow_repeated_settings --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_qkts4cva_repl_01111_3 engine=Replicated('\''/test/01111/01111_create_drop_replicated_db_stress_test_qkts4cva'\'', '\''1'\'', '\''0'\'')'
2026-02-20 17:55:24 ++ [2026-02-20 17:55:02] [:45] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=fatal --database=test_qkts4cva --log_comment 01111_create_drop_replicated_db_stress.sh-test_qkts4cva --max_insert_threads 3 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 15975634 --max_read_buffer_size 768387 --prefer_localhost_replica 0 --max_block_size 14059 --max_joined_block_size_rows 41170 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 350 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 8348720 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 3517085055 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --distributed_cache_discard_connection_if_unread_data 1 --distributed_cache_use_clients_cache_for_write 1 --distributed_cache_use_clients_cache_for_read 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --enable_filesystem_cache 0 --enable_filesystem_cache_on_write_operations 0 --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 13 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1787697372 --min_compress_block_size 2160832 --max_compress_block_size 2246210 --merge_tree_compact_parts_min_granules_to_multibuffer_read 9 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 1170839 --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 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --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.29 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 0 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 1 --optimize_extract_common_expressions 1 --use_async_executor_for_materialized_views 1 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 1 --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 0 --allow_special_serialization_kinds_in_output_formats 1 --short_circuit_function_evaluation_for_nulls_threshold 0.3300978967936698 --automatic_parallel_replicas_mode 2 --temporary_files_buffer_size 1204294 --query_plan_optimize_join_order_algorithm dpsize,greedy --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.11 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 1 --cluster_for_parallel_replicas parallel_replicas --parallel_replicas_for_non_replicated_merge_tree 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 8839333433 --vertical_merge_algorithm_min_rows_to_activate 520688 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 2494943445 --index_granularity_bytes 29233516 --merge_max_block_size 8631 --index_granularity 2907 --min_bytes_for_wide_part 0 --marks_compress_block_size 83472 --primary_key_compress_block_size 80664 --replace_long_file_name_to_hash 0 --max_file_name_length 123 --min_bytes_for_full_part_storage 196424398 --compact_parts_max_bytes_to_buffer 42987957 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 27146575 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 50 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v3 --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 7 --object_shared_data_buckets_for_wide_part 1 --dynamic_serialization_version v2 --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 694 --reduce_blocking_parts_sleep_ms 1914 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 5 --allow_repeated_settings --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_qkts4cva%'\'' order by rand() limit 1'
2026-02-20 17:55:24 ++ [2026-02-20 17:55:02] [:57] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=fatal --database=test_qkts4cva --log_comment 01111_create_drop_replicated_db_stress.sh-test_qkts4cva --max_insert_threads 3 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 15975634 --max_read_buffer_size 768387 --prefer_localhost_replica 0 --max_block_size 14059 --max_joined_block_size_rows 41170 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 350 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 8348720 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 3517085055 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --distributed_cache_discard_connection_if_unread_data 1 --distributed_cache_use_clients_cache_for_write 1 --distributed_cache_use_clients_cache_for_read 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --enable_filesystem_cache 0 --enable_filesystem_c
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