2026-02-03 14:52:16 Reason: return code:  36
2026-02-03 14:52:16 [e9d36135555e] 2026.02.03 10:52:15.319210 [ 4414 ] {2d524059-531f-4818-978f-487efac117b0} <Error> executeQuery: Code: 36. DB::Exception: Unexpected key `test_ewxzpzgh` in named collection. Required keys: addresses_expr, host, hostname, table, optional keys: database, db, password, port, sharding_key, username, user. (BAD_ARGUMENTS) (version 26.2.1.198) (from [::1]:44912) (comment: 02046_remote_table_function_named_collections.sql-test_ewxzpzgh) (query 7, line 9) (in query: SELECT count() FROM remote(remote1, database=currentDatabase());), Stack trace (when copying this message, always include the lines below):
2026-02-03 14:52:16 
2026-02-03 14:52:16 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:0: Poco::Exception::Exception(String const&, int) @ 0x000000003f13b2a0
2026-02-03 14:52:16 1. ./ci/tmp/build/./src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001e02c87c
2026-02-03 14:52:16 2. ./src/Common/Exception.h:172: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000f33df1c
2026-02-03 14:52:16 3. ./src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000f33d208
2026-02-03 14:52:16 4. ./src/Common/Exception.h:190: DB::Exception::Exception<String, fmt::v12::join_view<std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, char>, fmt::v12::join_view<std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, char>>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<fmt::v12::join_view<std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, char>>::type, std::type_identity<fmt::v12::join_view<std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, char>>::type>, String&&, fmt::v12::join_view<std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, char>&&, fmt::v12::join_view<std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, std::__tree_const_iterator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::__tree_node<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, void*>*, long>, char>&&) @ 0x00000000231a4768
2026-02-03 14:52:16 5. ./src/Storages/NamedCollectionsHelpers.h:141: void DB::validateNamedCollection<std::multiset<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::less<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>>, std::allocator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>>>>(DB::NamedCollection const&, std::multiset<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::less<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>>, std::allocator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>>> const&, std::multiset<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>, std::less<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>>, std::allocator<DB::NamedCollectionValidateKey<DB::ExternalDatabaseEqualKeysSet>>> const&, std::vector<std::shared_ptr<re2::RE2>, std::allocator<std::shared_ptr<re2::RE2>>> const&) @ 0x00000000231a1d0c
2026-02-03 14:52:16 6. ./ci/tmp/build/./src/TableFunctions/TableFunctionRemote.cpp:67: DB::TableFunctionRemote::parseArguments(boost::intrusive_ptr<DB::IAST> const&, std::shared_ptr<DB::Context const>) @ 0x000000002319a280
2026-02-03 14:52:16 7. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:3966: DB::QueryAnalyzer::resolveTableFunction(std::shared_ptr<DB::IQueryTreeNode>&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&, bool) @ 0x0000000029c1674c
2026-02-03 14:52:16 8. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:4604: DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptr<DB::IQueryTreeNode>&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x0000000029c47340
2026-02-03 14:52:16 9. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:4868: DB::QueryAnalyzer::resolveQuery(std::shared_ptr<DB::IQueryTreeNode> const&, DB::IdentifierResolveScope&) @ 0x0000000029c088b0
2026-02-03 14:52:16 10. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:138: DB::QueryAnalyzer::resolve(std::shared_ptr<DB::IQueryTreeNode>&, std::shared_ptr<DB::IQueryTreeNode> const&, std::shared_ptr<DB::Context const>) @ 0x0000000029c068d0
2026-02-03 14:52:16 11. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalysisPass.cpp:18: DB::QueryAnalysisPass::run(std::shared_ptr<DB::IQueryTreeNode>&, std::shared_ptr<DB::Context const>) @ 0x0000000029c05074
2026-02-03 14:52:16 12. ./ci/tmp/build/./src/Analyzer/QueryTreePassManager.cpp:194: DB::QueryTreePassManager::run(std::shared_ptr<DB::IQueryTreeNode>&) @ 0x0000000029cad30c
2026-02-03 14:52:16 13. ./ci/tmp/build/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:170: DB::buildQueryTreeAndRunPasses(boost::intrusive_ptr<DB::IAST> const&, DB::SelectQueryOptions const&, std::shared_ptr<DB::Context const> const&, std::shared_ptr<DB::IStorage> const&) @ 0x000000002b630bfc
2026-02-03 14:52:16 14. ./ci/tmp/build/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:184: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(boost::intrusive_ptr<DB::IAST> const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x000000002b62dab0
2026-02-03 14:52:16 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:759: std::unique_ptr<DB::InterpreterSelectQueryAnalyzer, std::default_delete<DB::InterpreterSelectQueryAnalyzer>> std::make_unique[abi:ne210105]<DB::InterpreterSelectQueryAnalyzer, boost::intrusive_ptr<DB::IAST>&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, 0>(boost::intrusive_ptr<DB::IAST>&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&) @ 0x000000002b639af8
2026-02-03 14:52:16 16. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x000000002b5a3d84
2026-02-03 14:52:16 17. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1695: 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>>&, boost::intrusive_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>, std::function<void ()>, DB::QueryResultDetails&) @ 0x000000002bc19f20
2026-02-03 14:52:16 18. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1984: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002bc127e0
2026-02-03 14:52:16 19. ./ci/tmp/build/./src/Server/TCPHandler.cpp:788: DB::TCPHandler::runImpl() @ 0x00000000331dec54
2026-02-03 14:52:16 20. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2890: DB::TCPHandler::run() @ 0x0000000033217224
2026-02-03 14:52:16 21. ./ci/tmp/build/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x000000003f2fe1f8
2026-02-03 14:52:16 22. ./ci/tmp/build/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x000000003f2fee10
2026-02-03 14:52:16 23. ./ci/tmp/build/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x000000003f212e38
2026-02-03 14:52:16 24. ./base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003f20d500
2026-02-03 14:52:16 25. asan_thread_start(void*) @ 0x000000000f2eb9a8
2026-02-03 14:52:16 26. start_thread @ 0x0000000000080398
2026-02-03 14:52:16 27. thread_start @ 0x00000000000e9e9c
2026-02-03 14:52:16 
2026-02-03 14:52:16 Received exception from server (version 26.2.1):
2026-02-03 14:52:16 Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Unexpected key `test_ewxzpzgh` in named collection. Required keys: addresses_expr, host, hostname, table, optional keys: database, db, password, port, sharding_key, username, user. (BAD_ARGUMENTS)
2026-02-03 14:52:16 (query: SELECT count() FROM remote(remote1, database=currentDatabase());)
2026-02-03 14:52:16 , result:
2026-02-03 14:52:16 
2026-02-03 14:52:16 
2026-02-03 14:52:16 
2026-02-03 14:52:16 stdout:
2026-02-03 14:52:16 
2026-02-03 14:52:16 
2026-02-03 14:52:16 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 71321 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 10917749 --max_read_buffer_size 796001 --prefer_localhost_replica 1 --max_block_size 54296 --max_joined_block_size_rows 65716 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 1000000 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 0 --optimize_if_chain_to_multiif 0 --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 25 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 7638211 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --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 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --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 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 15 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1475442308 --min_compress_block_size 358821 --max_compress_block_size 2167602 --merge_tree_compact_parts_min_granules_to_multibuffer_read 97 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 6826167 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone America/Mazatlan --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.13 --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 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 0 --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 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 0 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 0 --short_circuit_function_evaluation_for_nulls_threshold 0.8490494467590516 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 823281 --query_plan_optimize_join_order_algorithm dpsize,greedy --max_bytes_before_external_sort 3872006794 --max_bytes_before_external_group_by 3193740147 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 1
2026-02-03 14:52:16 
2026-02-03 14:52:16 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 3529884567 --index_granularity_bytes 7457130 --merge_max_block_size 5303 --index_granularity 41913 --min_bytes_for_wide_part 0 --marks_compress_block_size 49137 --primary_key_compress_block_size 74683 --replace_long_file_name_to_hash 1 --max_file_name_length 29 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 283538018 --compact_parts_max_granules_to_buffer 96 --compact_parts_merge_max_bytes_to_prefetch_part 27874776 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 324 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --object_serialization_version v2 --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 22 --object_shared_data_buckets_for_wide_part 8 --dynamic_serialization_version v2 --serialization_info_version basic --string_serialization_version with_size_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 0 --min_columns_to_activate_adaptive_write_buffer 975 --reduce_blocking_parts_sleep_ms 1962 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 7
2026-02-03 14:52:16 
2026-02-03 14:52:16 Database: test_ewxzpzgh

Run attempt 1 out of 5