-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Flaky test: 03238_create_or_replace_view_atomically_with_replicated_engine #93696
Copy link
Copy link
Closed
Closed
Copy link
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: 03238_create_or_replace_view_atomically_with_replicated_engine
Failure reason: having stderror
CI report: Stateless tests (amd_asan, distributed plan, parallel, 1/2)
Failing test history: cidb
Test output:
2026-01-08 22:16:55 Reason: having stderror:
2026-01-08 22:16:55 environment: line 1: 426691 Killed $CLICKHOUSE_CLIENT --query "SELECT * FROM ${CLICKHOUSE_DATABASE}_db.test_view" > /dev/null
2026-01-08 22:16:55 environment: line 1: 426706 Killed $CLICKHOUSE_CLIENT --query "SELECT * FROM ${CLICKHOUSE_DATABASE}_db.test_view" > /dev/null
2026-01-08 22:16:55
2026-01-08 22:16:55 stdout:
2026-01-08 22:16:55
2026-01-08 22:16:55
2026-01-08 22:16:55 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_qndhn2h0/03238_create_or_replace_view_atomically_with_replicated_engine.sh.debuglog:
2026-01-08 22:16:55 + [2026-01-08 22:16:32] [:8] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_qndhn2h0 --log_comment 03238_create_or_replace_view_atomically_with_replicated_engine.sh-test_qndhn2h0 --max_insert_threads 1 --group_by_two_level_threshold 94797 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 15957296 --max_read_buffer_size 729068 --prefer_localhost_replica 1 --max_block_size 65292 --max_joined_block_size_rows 89446 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 820 --max_threads 3 --optimize_append_index 1 --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 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 1 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 30723749 --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 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 4 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1318738763 --min_compress_block_size 1836918 --max_compress_block_size 2236040 --merge_tree_compact_parts_min_granules_to_multibuffer_read 12 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 10386665 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --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.14 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 0 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table false --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 0 --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 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 1043996 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.3306238229189773 --prefer_fetch_merged_part_size_threshold 1323945294 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 91 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 11104890 --merge_max_block_size 4063 --index_granularity 10934 --min_bytes_for_wide_part 1057440937 --marks_compress_block_size 20365 --primary_key_compress_block_size 66362 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 133146268 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 11054472 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 --object_serialization_version v3 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts map --object_shared_data_buckets_for_compact_part 32 --object_shared_data_buckets_for_wide_part 8 --dynamic_serialization_version v2 --serialization_info_version with_types --string_serialization_version with_size_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 0 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03238_create_or_replace_view_atomically_with_replicated_engine.stderr-fatal --query 'CREATE DATABASE IF NOT EXISTS test_qndhn2h0_db ENGINE=Replicated('\''/test/clickhouse/db/test_qndhn2h0_db'\'', '\''s1'\'', '\''r1'\'')'
2026-01-08 22:16:55 + [2026-01-08 22:16:33] [:16] export -f create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:33] [:24] export -f select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:33] [:26] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_qndhn2h0 --log_comment 03238_create_or_replace_view_atomically_with_replicated_engine.sh-test_qndhn2h0 --max_insert_threads 1 --group_by_two_level_threshold 94797 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 15957296 --max_read_buffer_size 729068 --prefer_localhost_replica 1 --max_block_size 65292 --max_joined_block_size_rows 89446 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 820 --max_threads 3 --optimize_append_index 1 --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 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 1 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 30723749 --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 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 4 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1318738763 --min_compress_block_size 1836918 --max_compress_block_size 2236040 --merge_tree_compact_parts_min_granules_to_multibuffer_read 12 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 10386665 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --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.14 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 0 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table false --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 0 --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 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 1043996 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.3306238229189773 --prefer_fetch_merged_part_size_threshold 1323945294 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 91 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 11104890 --merge_max_block_size 4063 --index_granularity 10934 --min_bytes_for_wide_part 1057440937 --marks_compress_block_size 20365 --primary_key_compress_block_size 66362 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 133146268 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 11054472 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 --object_serialization_version v3 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts map --object_shared_data_buckets_for_compact_part 32 --object_shared_data_buckets_for_wide_part 8 --dynamic_serialization_version v2 --serialization_info_version with_types --string_serialization_version with_size_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 0 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03238_create_or_replace_view_atomically_with_replicated_engine.stderr-fatal --query 'CREATE OR REPLACE VIEW test_qndhn2h0_db.test_view AS SELECT '\''abcdef'\'''
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:28] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:29] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:30] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:31] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:33] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:34] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:32] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:35] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:36] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:37] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:43] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:44] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:38] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:42] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:41] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:39] bash -c select_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:45] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:46] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:52] wait
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:49] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:50] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:47] bash -c create_or_replace_view_thread
2026-01-08 22:16:55 + [2026-01-08 22:16:34] [:48] bash -c create_or_replace_view_thread
2026-01-08 22:16:55
2026-01-08 22:16:55 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 94797 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 15957296 --max_read_buffer_size 729068 --prefer_localhost_replica 1 --max_block_size 65292 --max_joined_block_size_rows 89446 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 820 --max_threads 3 --optimize_append_index 1 --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 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 1 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 30723749 --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 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 4 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1318738763 --min_compress_block_size 1836918 --max_compress_block_size 2236040 --merge_tree_compact_parts_min_granules_to_multibuffer_read 12 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 10386665 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --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.14 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_bl
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