Skip to content

Flaky test: 03238_create_or_replace_view_atomically_with_replicated_engine #92917

@thevar1able

Description

@thevar1able

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:
CI report: Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, parallel)

CIDB statistics: cidb

Test output:

2025-12-19 13:16:13 Reason: having stderror:  
2025-12-19 13:16:13 [eba708079ae9] 2025.12.19 19:16:11.795121 [ 728628 ] {d786877e-513d-44c1-a105-592ea90f9c49} <Error> executeQuery: Code: 60. DB::Exception: Table test_ruskp40a_db.test_view (d8c73a49-2762-4e50-ba5b-aee19f15635a) does not exist. Maybe you meant test_view?. (UNKNOWN_TABLE) (version 26.1.1.52) (from [::1]:52414) (comment: 03238_create_or_replace_view_atomically_with_replicated_engine.sh-test_ruskp40a) (query 1, line 1) (in query: SELECT * FROM test_ruskp40a_db.test_view), Stack trace (when copying this message, always include the lines below):
2025-12-19 13:16:13 
2025-12-19 13:16:13 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x0000000021f0cf32
2025-12-19 13:16:13 1. ./ci/tmp/build/./src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000013494929
2025-12-19 13:16:13 2. DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000b08784e
2025-12-19 13:16:13 3. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000b087309
2025-12-19 13:16:13 4. DB::Exception::Exception<String, String>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<String>::type>, String&&, String&&) @ 0x000000000b0868f6
2025-12-19 13:16:13 5. ./ci/tmp/build/./src/Interpreters/DatabaseCatalog.cpp:399: DB::DatabaseCatalog::getTableImpl(DB::StorageID const&, std::shared_ptr<DB::Context const>, std::optional<DB::Exception>*) const @ 0x00000000191d5bca
2025-12-19 13:16:13 6. ./ci/tmp/build/./src/Interpreters/DatabaseCatalog.cpp:1074: DB::DatabaseCatalog::getTable(DB::StorageID const&, std::shared_ptr<DB::Context const>) const @ 0x00000000191dc208
2025-12-19 13:16:13 7. ./ci/tmp/build/./src/Interpreters/JoinedTables.cpp:245: DB::JoinedTables::getLeftTableStorage() @ 0x00000000193bd25e
2025-12-19 13:16:13 8. ./ci/tmp/build/./src/Interpreters/InterpreterSelectQuery.cpp:582: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000019356958
2025-12-19 13:16:13 9. ./ci/tmp/build/./src/Interpreters/InterpreterSelectQuery.cpp:330: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000019355b11
2025-12-19 13:16:13 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:759: DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000019391292
2025-12-19 13:16:13 11. ./ci/tmp/build/./src/Interpreters/InterpreterSelectWithUnionQuery.cpp:167: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x000000001938feeb
2025-12-19 13:16:13 12. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:759: std::unique_ptr<DB::IInterpreter, std::default_delete<DB::IInterpreter>> std::__function::__policy_func<std::unique_ptr<DB::IInterpreter, std::default_delete<DB::IInterpreter>> (DB::InterpreterFactory::Arguments const&)>::__call_func[abi:ne210105]<DB::registerInterpreterSelectWithUnionQuery(DB::InterpreterFactory&)::$_0>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x00000000193937e2
2025-12-19 13:16:13 13. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x000000001930bbc2
2025-12-19 13:16:13 14. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1687: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, std::unique_ptr<DB::ReadBuffer, std::default_delete<DB::ReadBuffer>>&, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>, std::function<void ()>, DB::QueryResultDetails&) @ 0x00000000196f0c3e
2025-12-19 13:16:13 15. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1972: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x00000000196ec311
2025-12-19 13:16:13 16. ./ci/tmp/build/./src/Server/TCPHandler.cpp:774: DB::TCPHandler::runImpl() @ 0x000000001caf17c8
2025-12-19 13:16:13 17. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2862: DB::TCPHandler::run() @ 0x000000001cb0f3e3
2025-12-19 13:16:13 18. ./ci/tmp/build/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x0000000021fd1807
2025-12-19 13:16:13 19. ./ci/tmp/build/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x0000000021fd1e3e
2025-12-19 13:16:13 20. ./ci/tmp/build/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000021f6adff
2025-12-19 13:16:13 21. ./base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000021f68451
2025-12-19 13:16:13 22. ? @ 0x0000000000094ac3
2025-12-19 13:16:13 23. ? @ 0x00000000001268c0
2025-12-19 13:16:13 
2025-12-19 13:16:13 Received exception from server (version 26.1.1):
2025-12-19 13:16:13 Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Table test_ruskp40a_db.test_view (d8c73a49-2762-4e50-ba5b-aee19f15635a) does not exist. Maybe you meant test_view?. (UNKNOWN_TABLE)
2025-12-19 13:16:13 (query: SELECT * FROM test_ruskp40a_db.test_view)
2025-12-19 13:16:13 
2025-12-19 13:16:13 stdout:
2025-12-19 13:16:13 
2025-12-19 13:16:13 
2025-12-19 13:16:13 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_ruskp40a/03238_create_or_replace_view_atomically_with_replicated_engine.sh.debuglog:
2025-12-19 13:16:13 + [2025-12-19 13:16:09] [:8] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_ruskp40a --log_comment 03238_create_or_replace_view_atomically_with_replicated_engine.sh-test_ruskp40a --max_insert_threads 2 --group_by_two_level_threshold 309189 --group_by_two_level_threshold_bytes 30093441 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 5438927 --max_read_buffer_size 617648 --prefer_localhost_replica 1 --max_block_size 83135 --max_joined_block_size_rows 91762 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 0 --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 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 94 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 11053863 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 5 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 2966440418 --min_compress_block_size 2562538 --max_compress_block_size 311919 --merge_tree_compact_parts_min_granules_to_multibuffer_read 72 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9946880 --http_wait_end_of_query False --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 0 --session_timezone Africa/Juba --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.32 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table false --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 1 --use_skip_indexes_on_data_read 0 --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 1 --max_bytes_before_external_sort 10737418240 --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 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.2928042362901232 --prefer_fetch_merged_part_size_threshold 9997437902 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 31 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 14988326 --merge_max_block_size 14704 --index_granularity 35267 --min_bytes_for_wide_part 0 --marks_compress_block_size 28075 --primary_key_compress_block_size 95325 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 106609660 --compact_parts_max_bytes_to_buffer 516982922 --compact_parts_max_granules_to_buffer 71 --compact_parts_merge_max_bytes_to_prefetch_part 25807463 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 64 --old_parts_lifetime 293 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --object_serialization_version v3 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts map_with_buckets --object_shared_data_buckets_for_compact_part 30 --object_shared_data_buckets_for_wide_part 6 --dynamic_serialization_version v3 --auto_statistics_types minmax,countmin,tdigest,uniq --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 1 --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_ruskp40a_db ENGINE=Replicated('\''/test/clickhouse/db/test_ruskp40a_db'\'', '\''s1'\'', '\''r1'\'')'
2025-12-19 13:16:13 + [2025-12-19 13:16:09] [:16] export -f create_or_replace_view_thread
2025-12-19 13:16:13 + [2025-12-19 13:16:09] [:24] export -f select_view_thread
2025-12-19 13:16:13 + [2025-12-19 13:16:09] [:26] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_ruskp40a --log_comment 03238_create_or_replace_view_atomically_with_replicated_engine.sh-test_ruskp40a --max_insert_threads 2 --group_by_two_level_threshold 309189 --group_by_two_level_threshold_bytes 30093441 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 5438927 --max_read_buffer_size 617648 --prefer_localhost_replica 1 --max_block_size 83135 --max_joined_block_size_rows 91762 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 0 --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 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 94 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 11053863 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 5 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 2966440418 --min_compress_block_size 2562538 --max_compress_block_size 311919 --merge_tree_compact_parts_min_granules_to_multibuffer_read 72 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9946880 --http_wait_end_of_query False --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 0 --session_timezone Africa/Juba --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.32 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table false --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 1 --use_skip_indexes_on_data_read 0 --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 1 --max_bytes_before_external_sort 10737418240 --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 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.2928042362901232 --prefer_fetch_merged_part_size_threshold 9997437902 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 31 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 14988326 --merge_max_block_size 14704 --index_granularity 35267 --min_bytes_for_wide_part 0 --marks_compress_block_size 28075 --primary_key_compress_block_size 95325 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 106609660 --compact_parts_max_bytes_to_buffer 516982922 --compact_parts_max_granules_to_buffer 71 --compact_parts_merge_max_bytes_to_prefetch_part 25807463 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 64 --old_parts_lifetime 293 --prewarm_mark_cache 0 --use_const_a

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