-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Logical error: Column 'col1 Int64 Sparse(size = 0, Nullable(size = 1, Int64(size = 1), UInt8(size = 1)), UInt64(size = 0))' is expected to be nullable #92920
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release
Description
Describe what's wrong
Repro: https://fiddle.clickhouse.com/314bff79-4369-4492-961a-2acbf95297f8
Bisected to: #88999
Error:
[nikpc] 2025.12.23 17:41:45.643103 [ 3112482 ] {b216cc1f-ac60-4656-98f6-5247673aef39} <Fatal> : Logical error: 'Column 'lookup_id Int64 Sparse(size = 0, Nullable(size = 1, Int64(size = 1), UInt8(size = 1)), UInt64(size = 0))' is expected to be nullable'.
[nikpc] 2025.12.23 17:41:45.643190 [ 3112482 ] {b216cc1f-ac60-4656-98f6-5247673aef39} <Fatal> : Stack trace (when copying this message, always include the lines below):
0. ./ci/tmp/build/./src/Common/Exception.cpp:131: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000151fdf1f
1. DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000ce7204e
2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000ce71a40
3. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000ce716ab
4. ./ci/tmp/build/./src/Interpreters/JoinUtils.cpp:241: DB::JoinCommon::removeColumnNullability(DB::ColumnWithTypeAndName&) @ 0x000000001a1ea555
5. ./ci/tmp/build/./src/Interpreters/HashJoin/HashJoinResult.cpp:27: DB::HashJoinResult::generateBlock(std::optional<DB::HashJoinResult::GenerateCurrentRowState>&, DB::LazyOutput const&, DB::HashJoinResult::Properties const&) @ 0x000000001a925c91
6. ./ci/tmp/build/./src/Interpreters/HashJoin/HashJoinResult.cpp:397: DB::HashJoinResult::next() @ 0x000000001a927c04
7. ./ci/tmp/build/./src/Processors/Transforms/JoiningTransform.cpp:222: DB::JoiningTransform::work() @ 0x000000001c68d669
8. ./ci/tmp/build/./src/Processors/Executors/ExecutionThreadContext.cpp:53: DB::ExecutionThreadContext::executeTask() @ 0x000000001c3a4b57
9. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:351: DB::PipelineExecutor::executeStepImpl(unsigned long, DB::IAcquiredSlot*, std::atomic<bool>*) @ 0x000000001c39711b
10. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:279: void std::__function::__policy_func<void ()>::__call_func[abi:ne210105]<DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0>(std::__function::__policy_storage const*) @ 0x000000001c39b143
11. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x000000001535420b
12. ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:217: void std::__function::__policy_func<void ()>::__call_func[abi:ne210105]<ThreadFromGlobalPoolImpl<false, true>::ThreadFromGlobalPoolImpl<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&)::'lambda'()>(std::__function::__policy_storage const*) @ 0x000000001535b126
13. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x000000001535139f
14. ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:217: void* std::__thread_proxy[abi:ne210105]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>>(void*) @ 0x0000000015358a5a
15. start_thread @ 0x000000000009caa4
16. clone3 @ 0x0000000000129c6c
[nikpc] 2025.12.23 17:41:45.650670 [ 3111636 ] <Fatal> BaseDaemon: 5. ./ci/tmp/build/./src/Common/Exception.cpp:52: DB::abortOnFailedAssertion(String const&, void* const*, unsigned long, unsigned long) @ 0x00000000151fd674
[nikpc] 2025.12.23 17:41:45.658750 [ 3111636 ] <Fatal> BaseDaemon: 6.0. inlined from ./ci/tmp/build/./src/Common/Exception.cpp:85: DB::handle_error_code(String const&, std::basic_string_view<char, std::char_traits<char>>, int, bool, std::vector<void*, std::allocator<void*>> const&)
[nikpc] 2025.12.23 17:41:45.658775 [ 3111636 ] <Fatal> BaseDaemon: 6. ./ci/tmp/build/./src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000151fe2b5
[nikpc] 2025.12.23 17:41:47.781807 [ 3111636 ] <Fatal> BaseDaemon: 7. DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000ce7204e
[nikpc] 2025.12.23 17:41:49.502901 [ 3111636 ] <Fatal> BaseDaemon: 8. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000ce71a40
[nikpc] 2025.12.23 17:41:51.661973 [ 3111636 ] <Fatal> BaseDaemon: 9. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000ce716ab
[nikpc] 2025.12.23 17:41:51.674004 [ 3111636 ] <Fatal> BaseDaemon: 10. ./ci/tmp/build/./src/Interpreters/JoinUtils.cpp:241: DB::JoinCommon::removeColumnNullability(DB::ColumnWithTypeAndName&) @ 0x000000001a1ea555
[nikpc] 2025.12.23 17:41:51.682764 [ 3111636 ] <Fatal> BaseDaemon: 11.0. inlined from ./ci/tmp/build/./src/Interpreters/HashJoin/HashJoinResult.cpp:27: DB::correctNullabilityInplace(DB::ColumnWithTypeAndName&, bool)
[nikpc] 2025.12.23 17:41:51.682824 [ 3111636 ] <Fatal> BaseDaemon: 11.1. inlined from ./ci/tmp/build/./src/Interpreters/HashJoin/HashJoinResult.cpp:64: DB::copyLeftKeyColumnToRight(std::shared_ptr<DB::IDataType const> const&, String const&, DB::ColumnWithTypeAndName const&, DB::PODArray<char8_t, 4096ul, Allocator<false, false>, 63ul, 64ul> const*)
[nikpc] 2025.12.23 17:41:51.682853 [ 3111636 ] <Fatal> BaseDaemon: 11.2. inlined from ./ci/tmp/build/./src/Interpreters/HashJoin/HashJoinResult.cpp:137: DB::appendRightColumns(DB::Block&, std::vector<COW<DB::IColumn>::mutable_ptr<DB::IColumn>, std::allocator<COW<DB::IColumn>::mutable_ptr<DB::IColumn>>>, DB::PODArray<unsigned long, 4096ul, Allocator<false, false>, 63ul, 64ul> const&, DB::PODArray<char8_t, 4096ul, Allocator<false, false>, 63ul, 64ul> const&, std::vector<DB::NameAndTypePair, std::allocator<DB::NameAndTypePair>> const&, DB::HashJoinResult::Properties const&)
[nikpc] 2025.12.23 17:41:51.682888 [ 3111636 ] <Fatal> BaseDaemon: 11. ./ci/tmp/build/./src/Interpreters/HashJoin/HashJoinResult.cpp:263: DB::HashJoinResult::generateBlock(std::optional<DB::HashJoinResult::GenerateCurrentRowState>&, DB::LazyOutput const&, DB::HashJoinResult::Properties const&) @ 0x000000001a925c91
[nikpc] 2025.12.23 17:41:51.695293 [ 3111636 ] <Fatal> BaseDaemon: 12. ./ci/tmp/build/./src/Interpreters/HashJoin/HashJoinResult.cpp:397: DB::HashJoinResult::next() @ 0x000000001a927c04
[nikpc] 2025.12.23 17:41:51.704454 [ 3111636 ] <Fatal> BaseDaemon: 13.0. inlined from ./ci/tmp/build/./src/Processors/Transforms/JoiningTransform.cpp:222: DB::JoiningTransform::readExecute(DB::Chunk&)
[nikpc] 2025.12.23 17:41:51.704489 [ 3111636 ] <Fatal> BaseDaemon: 13.1. inlined from ./ci/tmp/build/./src/Processors/Transforms/JoiningTransform.cpp:203: DB::JoiningTransform::transform(DB::Chunk&)
[nikpc] 2025.12.23 17:41:51.704538 [ 3111636 ] <Fatal> BaseDaemon: 13. ./ci/tmp/build/./src/Processors/Transforms/JoiningTransform.cpp:136: DB::JoiningTransform::work() @ 0x000000001c68d669
[nikpc] 2025.12.23 17:41:51.708727 [ 3111636 ] <Fatal> BaseDaemon: 14.0. inlined from ./ci/tmp/build/./src/Processors/Executors/ExecutionThreadContext.cpp:53: DB::executeJob(DB::ExecutingGraph::Node*, DB::ReadProgressCallback*)
[nikpc] 2025.12.23 17:41:51.708768 [ 3111636 ] <Fatal> BaseDaemon: 14. ./ci/tmp/build/./src/Processors/Executors/ExecutionThreadContext.cpp:102: DB::ExecutionThreadContext::executeTask() @ 0x000000001c3a4b57
[nikpc] 2025.12.23 17:41:51.719558 [ 3111636 ] <Fatal> BaseDaemon: 15. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:351: DB::PipelineExecutor::executeStepImpl(unsigned long, DB::IAcquiredSlot*, std::atomic<bool>*) @ 0x000000001c39711b
[nikpc] 2025.12.23 17:41:51.731532 [ 3111636 ] <Fatal> BaseDaemon: 16.0. inlined from ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:279: DB::PipelineExecutor::executeSingleThread(unsigned long, DB::IAcquiredSlot*)
[nikpc] 2025.12.23 17:41:51.731574 [ 3111636 ] <Fatal> BaseDaemon: 16.1. inlined from ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:565: operator()
[nikpc] 2025.12.23 17:41:51.731598 [ 3111636 ] <Fatal> BaseDaemon: 16.2. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:249: decltype(std::declval<DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>()()) std::__invoke[abi:ne210105]<DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>(DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&)
[nikpc] 2025.12.23 17:41:51.731620 [ 3111636 ] <Fatal> BaseDaemon: 16.3. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:342: void std::__invoke_void_return_wrapper<void, true>::__call[abi:ne210105]<DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>(DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&)
[nikpc] 2025.12.23 17:41:51.731640 [ 3111636 ] <Fatal> BaseDaemon: 16.4. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:348: void std::__invoke_r[abi:ne210105]<void, DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>(DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&)
[nikpc] 2025.12.23 17:41:51.731660 [ 3111636 ] <Fatal> BaseDaemon: 16. ./contrib/llvm-project/libcxx/include/__functional/function.h:450: ? @ 0x000000001c39b143
[nikpc] 2025.12.23 17:41:51.740177 [ 3111636 ] <Fatal> BaseDaemon: 17.0. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
[nikpc] 2025.12.23 17:41:51.740215 [ 3111636 ] <Fatal> BaseDaemon: 17.1. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
[nikpc] 2025.12.23 17:41:51.740234 [ 3111636 ] <Fatal> BaseDaemon: 17. ./ci/tmp/build/./src/Common/ThreadPool.cpp:801: ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::worker() @ 0x000000001535420b
[nikpc] 2025.12.23 17:41:51.751299 [ 3111636 ] <Fatal> BaseDaemon: 18.0. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:217: decltype(*std::declval<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&>().*std::declval<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)()>()()) std::__invoke[abi:ne210105]<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&, void>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&)
[nikpc] 2025.12.23 17:41:51.751364 [ 3111636 ] <Fatal> BaseDaemon: 18.1. inlined from ./contrib/llvm-project/libcxx/include/tuple:1380: decltype(auto) std::__apply_tuple_impl[abi:ne210105]<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&, 0ul>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&, std::__tuple_indices<0ul>)
[nikpc] 2025.12.23 17:41:51.751387 [ 3111636 ] <Fatal> BaseDaemon: 18.2. inlined from ./contrib/llvm-project/libcxx/include/tuple:1384: decltype(auto) std::apply[abi:ne210105]<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&)
[nikpc] 2025.12.23 17:41:51.751414 [ 3111636 ] <Fatal> BaseDaemon: 18.3. inlined from ./src/Common/ThreadPool.h:312: operator()
[nikpc] 2025.12.23 17:41:51.751463 [ 3111636 ] <Fatal> BaseDaemon: 18.4. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:249: decltype(std::declval<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*)()>()(std::declval<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>())) std::__invoke[abi:ne210105]<ThreadFromGlobalPoolImpl<false, true>::ThreadFromGlobalPoolImpl<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&)::'lambda'()&>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&)
[nikpc] 2025.12.23 17:41:51.751499 [ 3111636 ] <Fatal> BaseDaemon: 18.5. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:342: void std::__invoke_void_return_wrapper<void, true>::__call[abi:ne210105]<ThreadFromGlobalPoolImpl<false, true>::ThreadFromGlobalPoolImpl<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&)::'lambda'()&>(ThreadFromGlobalPoolImpl<false, true>::ThreadFromGlobalPoolImpl<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&)::'lambda'()&)
[nikpc] 2025.12.23 17:41:51.751538 [ 3111636 ] <Fatal> BaseDaemon: 18.6. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:348: void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*std::__invoke_r[abi:ne210105]<void, ThreadFromGlobalPoolImpl<false, true>::ThreadFromGlobalPoolImpl<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&)::'lambda'()&>(ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&))()
[nikpc] 2025.12.23 17:41:51.751555 [ 3111636 ] <Fatal> BaseDaemon: 18. ./contrib/llvm-project/libcxx/include/__functional/function.h:450: ? @ 0x000000001535b126
[nikpc] 2025.12.23 17:41:51.758406 [ 3111636 ] <Fatal> BaseDaemon: 19.0. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
[nikpc] 2025.12.23 17:41:51.758447 [ 3111636 ] <Fatal> BaseDaemon: 19.1. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
[nikpc] 2025.12.23 17:41:51.758484 [ 3111636 ] <Fatal> BaseDaemon: 19. ./ci/tmp/build/./src/Common/ThreadPool.cpp:811: ThreadPoolImpl<std::thread>::ThreadFromThreadPool::worker() @ 0x000000001535139f
[nikpc] 2025.12.23 17:41:51.770124 [ 3111636 ] <Fatal> BaseDaemon: 20.0. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:217: decltype(*std::declval<ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>().*std::declval<void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)()>()()) std::__invoke[abi:ne210105]<void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*, void>(void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*&&)
[nikpc] 2025.12.23 17:41:51.770196 [ 3111636 ] <Fatal> BaseDaemon: 20.1. inlined from ./contrib/llvm-project/libcxx/include/__thread/thread.h:159: void std::__thread_execute[abi:ne210105]<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*, 2ul>(std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>&, std::__tuple_indices<2ul>)
[nikpc] 2025.12.23 17:41:51.770210 [ 3111636 ] <Fatal> BaseDaemon: 20. ./contrib/llvm-project/libcxx/include/__thread/thread.h:168: void* std::__thread_proxy[abi:ne210105]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>>(void*) @ 0x0000000015358a5a
[nikpc] 2025.12.23 17:41:51.770234 [ 3111636 ] <Fatal> BaseDaemon: 21. start_thread @ 0x000000000009caa4
[nikpc] 2025.12.23 17:41:51.770275 [ 3111636 ] <Fatal> BaseDaemon: 22. clone3 @ 0x0000000000129c6c
[nikpc] 2025.12.23 17:41:52.148727 [ 3111636 ] <Fatal> BaseDaemon: Integrity check of the executable successfully passed (checksum: C54F7BBC064F5F7192DCACF704E7D289)
[nikpc] 2025.12.23 17:42:03.917674 [ 3111636 ] <Fatal> BaseDaemon: Report this error to https://github.com/ClickHouse/ClickHouse/issues
[nikpc] 2025.12.23 17:42:03.918372 [ 3111636 ] <Fatal> BaseDaemon: Changed settings: min_external_table_block_size_rows = 1048449, min_external_table_block_size_bytes = 268402944, max_joined_block_size_bytes = 0, min_joined_block_size_rows = 0, min_joined_block_size_bytes = 524288, use_concurrency_control = false, max_parsing_threads = 12, connect_timeout_with_failover_ms = 50, connect_timeout_with_failover_secure_ms = 100, hedged_connection_timeout_ms = 100, idle_connection_timeout = 36000, azure_strict_upload_part_size = 0, azure_max_blocks_in_multipart_upload = 50000, azure_min_upload_part_size = 16777216, s3_max_part_number = 10000, s3_max_single_operation_copy_size = 33554432, azure_upload_part_size_multiply_factor = 2, azure_upload_part_size_multiply_parts_count_threshold = 500, azure_max_inflight_parts_for_one_file = 20, azure_max_single_part_upload_size = 104857600, azure_max_single_part_copy_size = 268435456, azure_max_unexpected_write_error_retries = 4, azure_max_redirects = 10, azure_max_get_rps = 0, azure_max_get_burst = 0, azure_max_put_rps = 0, azure_max_put_burst = 0, s3_max_get_rps = 1000000, s3_max_get_burst = 2000000, s3_max_put_rps = 1000000, s3_max_put_burst = 2000000, s3_slow_all_threads_after_network_error = false, s3_skip_empty_files = false, s3_check_objects_after_upload = true, azure_allow_parallel_part_upload = true, azure_sdk_max_retries = 10, azure_sdk_retry_initial_backoff_ms = 10, azure_sdk_retry_max_backoff_ms = 1000, azure_request_timeout_ms = 30000, azure_connect_timeout_ms = 1000, s3_connect_timeout_ms = 1000, s3queue_keeper_fault_injection_probability = 0., max_remote_read_network_bandwidth = 1000000000000, max_remote_write_network_bandwidth = 1000000000000, max_local_read_bandwidth = 1000000000000, max_local_write_bandwidth = 1000000000000, stream_like_engine_allow_direct_select = true, alter_sync = 2, replication_wait_for_inactive_replica_timeout = 30, allow_suspicious_indices = true, allow_suspicious_ttl_expressions = true, allow_suspicious_variant_types = true, allow_suspicious_primary_key = true, allow_suspicious_types_in_group_by = true, allow_suspicious_types_in_order_by = true, compile_expressions = false, allow_nonconst_timezone_arguments = true, enable_time_time64_type = false, function_locate_has_mysql_compatible_argument_order = false, parallel_distributed_insert_select = 0, output_format_compression_level = 3, output_format_compression_zstd_window_log = 0, allow_special_serialization_kinds_in_output_formats = false, enable_parsing_to_custom_serialization = false, merge_tree_use_v1_object_and_dynamic_serialization = true, split_parts_ranges_into_intersecting_and_non_intersecting_final = false, mysql_map_string_to_text_in_show_columns = false, mysql_map_fixed_string_to_text_in_show_columns = false, use_skip_indexes_if_final = false, use_skip_indexes_if_final_exact_mode = false, use_skip_indexes_for_disjunctions = false, secondary_indices_enable_bulk_filtering = false, log_queries = true, log_processors_profiles = false, insert_quorum_timeout = 60000, enable_http_compression = false, http_response_headers = [], http_write_exception_in_output_format = false, fsync_metadata = false, join_output_by_rowlist_perkey_rows_threshold = 0, query_plan_join_swap_table = false, query_plan_optimize_join_order_limit = 1, query_plan_max_step_description_length = 1000000000, min_free_disk_bytes_to_perform_insert = 0, http_send_timeout = 180., http_receive_timeout = 180., use_index_for_in_with_subqueries_max_values = 1000000000, opentelemetry_start_trace_probability = 0.10000000149011612, enable_vertical_final = false, max_rows_to_read = 9999999999999999, max_bytes_to_read = 1000000000000, max_bytes_to_read_leaf = 1000000000000, max_rows_to_group_by = 10000000000, max_bytes_ratio_before_external_group_by = 0., max_rows_to_sort = 10000000000, max_bytes_to_sort = 10000000000, prefer_external_sort_block_bytes = 0, max_bytes_ratio_before_external_sort = 0., max_result_rows = 1000000000, max_result_bytes = 1000000000, max_execution_speed = 100000000000, max_execution_speed_bytes = 10000000000000, timeout_before_checking_execution_speed = 300., max_estimated_execution_time = 0., max_columns_to_read = 20000, max_temporary_columns = 20000, max_temporary_non_const_columns = 20000, max_rows_in_set = 10000000000, max_bytes_in_set = 10000000000, max_rows_in_join = 10000000000, max_bytes_in_join = 10000000000, join_algorithm = 'default', cross_join_min_rows_to_compress = 0, cross_join_min_bytes_to_compress = 0, max_rows_in_set_to_optimize_join = 100000, max_rows_to_transfer = 1000000000, max_bytes_to_transfer = 1000000000, max_rows_in_distinct = 10000000000, max_bytes_in_distinct = 10000000000, max_memory_usage = 5000000000, max_memory_usage_for_user = 32000000000, max_untracked_memory = 1048576, max_reverse_dictionary_lookup_cache_size_bytes = 104857600, memory_profiler_step = 1048576, max_network_bandwidth = 100000000000, max_network_bytes = 1000000000000, max_network_bandwidth_for_user = 100000000000, max_network_bandwidth_for_all_users = 100000000000, max_temporary_data_on_disk_size_for_user = 100000000000, max_temporary_data_on_disk_size_for_query = 100000000000, backup_restore_keeper_max_retries = 20, backup_restore_failure_after_host_disconnected_for_seconds = 0, backup_restore_keeper_max_retries_while_initializing = 0, backup_restore_keeper_max_retries_while_handling_error = 0, backup_restore_finish_timeout_after_error_sec = 0, backup_restore_s3_retry_attempts = 1000, backup_restore_s3_retry_initial_backoff_ms = 25, backup_restore_s3_retry_max_backoff_ms = 5000, backup_restore_s3_retry_jitter_factor = 0., max_backup_bandwidth = 100000000000, query_metric_log_interval = 0, allow_push_predicate_ast_for_distributed_subqueries = false, read_in_order_use_buffering = false, max_hyperscan_regexp_length = 1000000, max_hyperscan_regexp_total_length = 10000000, allow_introspection_functions = true, formatdatetime_f_prints_single_zero = true, formatdatetime_f_prints_scale_number_of_digits = true, formatdatetime_parsedatetime_m_is_month_name = false, parsedatetime_parse_without_leading_zeros = false, parsedatetime_e_requires_space_padding = true, formatdatetime_e_with_space_padding = true, least_greatest_legacy_null_behavior = true, h3togeo_lon_lat_result_order = true, geotoh3_argument_order = 'lon_lat', max_partitions_per_insert_block = 99999999, max_parts_to_move = 0, postgresql_connection_attempt_timeout = 2, postgresql_connection_pool_retries = 2, default_table_engine = 'None', database_atomic_wait_for_drop_and_detach_synchronously = true, mutations_sync = 2, lightweight_deletes_sync = 2, count_matches_stop_at_empty_match = true, optimize_functions_to_subcolumns = false, throw_if_deduplication_in_dependent_materialized_views_enabled_with_async_insert = false, allow_materialized_view_with_bad_select = true, materialized_views_squash_parallel_inserts = false, max_parser_backtracks = 0, max_recursive_cte_evaluation_depth = 1000, validate_mutation_query = false, lock_acquire_timeout = 60., optimize_trivial_insert_select = true, optimize_use_projection_filtering = false, max_projection_rows_to_use_projection_index = 1000000, min_table_rows_to_use_projection_index = 1000000, enable_lightweight_update = false, apply_patch_parts_join_cache_buckets = 8, query_cache_system_table_handling = 'save', query_cache_max_size_in_bytes = 10000000, query_cache_max_entries = 100000, use_query_condition_cache = false, merge_tree_storage_snapshot_sleep_ms = 0, optimize_rewrite_sum_if_to_count_if = false, optimize_empty_string_comparisons = false, optimize_rewrite_like_perfect_affix = false, execute_exists_as_scalar_subquery = false, optimize_rewrite_regexp_functions = false, max_size_to_preallocate_for_aggregation = 100000000, collect_hash_table_stats_during_joins = false, max_size_to_preallocate_for_joins = 0, enable_url_encoding = true, database_replicated_allow_replicated_engine_arguments = 1, database_replicated_allow_explicit_uuid = 1, database_replicated_allow_heavy_create = true, database_shared_drop_table_delay_seconds = 28800, cloud_mode_database_engine = 1, distributed_ddl_output_mode = 'none', distributed_ddl_entry_format_version = 6, external_storage_max_read_rows = 10000000000, external_storage_max_read_bytes = 10000000000, allow_experimental_correlated_subqueries = false, optimize_injective_functions_in_group_by = false, optimize_group_by_constant_keys = false, query_plan_merge_filters = false, query_plan_convert_outer_join_to_inner_join = false, query_plan_merge_filter_into_join_condition = false, query_plan_try_use_vector_search = false, query_plan_optimize_lazy_materialization = false, query_plan_max_limit_for_lazy_materialization = 10, enable_lazy_columns_replication = false, query_plan_use_new_logical_join_step = false, correlated_subqueries_substitute_equivalent_expressions = false, correlated_subqueries_default_join_kind = 'left', function_sleep_max_microseconds_per_block = 0, function_visible_width_behavior = 0, merge_tree_min_rows_for_concurrent_read_for_remote_filesystem = 163840, merge_tree_min_bytes_for_concurrent_read_for_remote_filesystem = 251658240, merge_tree_min_bytes_per_task_for_remote_reading = 4194304, merge_tree_min_read_task_size = 8, async_insert = false, async_insert_max_data_size = 1000000, async_insert_poll_timeout_ms = 10, async_insert_use_adaptive_busy_timeout = false, async_insert_busy_timeout_min_ms = 50, async_insert_busy_timeout_max_ms = 200, cluster_function_process_archive_on_multiple_nodes = false, enable_filesystem_cache = true, enable_filesystem_cache_on_write_operations = true, filesystem_cache_skip_download_if_exceeds_per_query_cache_write_limit = true, filesystem_cache_segments_batch_size = 10, filesystem_cache_reserve_space_wait_lock_timeout_milliseconds = 1000, filesystem_cache_boundary_alignment = 0, temporary_data_in_cache_reserve_space_wait_lock_timeout_milliseconds = 600000, page_cache_block_size = 1048576, page_cache_lookahead_blocks = 16, load_marks_asynchronously = true, allow_prefetched_read_pool_for_remote_filesystem = false, allow_prefetched_read_pool_for_local_filesystem = false, filesystem_prefetch_max_memory_usage = 1073741824, max_streams_for_merge_tree_reading = 1000, compatibility = '23.3', read_through_distributed_cache = false, write_through_distributed_cache = false, distributed_cache_throw_on_error = false, distributed_cache_fetch_metrics_only_from_current_az = true, distributed_cache_connect_max_tries = 20, distributed_cache_read_request_max_tries = 20, distributed_cache_receive_response_wait_milliseconds = 60000, distributed_cache_receive_timeout_milliseconds = 10000, distributed_cache_wait_connection_from_pool_milliseconds = 100, distributed_cache_bypass_connection_pool = false, distributed_cache_pool_behaviour_on_limit = 'allocate_bypassing_pool', distributed_cache_alignment = 0, distributed_cache_max_unacked_inflight_packets = 10, distributed_cache_data_packet_ack_window = 5, distributed_cache_min_bytes_for_seek = 0, distributed_cache_credentials_refresh_period_seconds = 5, write_through_distributed_cache_buffer_size = 0, distributed_cache_connect_backoff_min_ms = 0, distributed_cache_connect_backoff_max_ms = 50, distributed_cache_connect_timeout_ms = 50, distributed_cache_receive_timeout_ms = 3000, distributed_cache_send_timeout_ms = 3000, distributed_cache_tcp_keep_alive_timeout_ms = 2900, parallelize_output_from_storages = false, optimize_inverse_dictionary_lookup = false, keeper_max_retries = 10, keeper_retry_initial_backoff_ms = 100, keeper_retry_max_backoff_ms = 5000, insert_keeper_max_retries = 100, insert_keeper_retry_initial_backoff_ms = 1, insert_keeper_retry_max_backoff_ms = 10, insert_keeper_fault_injection_probability = 0.009999999776482582, use_with_fill_by_sorting_prefix = false, ignore_drop_queries_probability = 0., geo_distance_returns_float64_on_float64_arguments = false, allow_dynamic_type_in_join_keys = true, print_pretty_type_names = false, create_table_empty_primary_key_by_default = false, short_circuit_function_evaluation_for_nulls = false, show_data_lake_catalogs_in_system_tables = true, delta_lake_insert_max_rows_in_data_file = 1000000, allow_deprecated_error_prone_window_functions = true, use_iceberg_partition_pruning = false, allow_deprecated_snowflake_conversion_functions = true, extract_key_value_pairs_max_pairs_per_row = 0, allow_experimental_parallel_reading_from_replicas = 0, max_parallel_replicas = 1, parallel_replicas_custom_key_range_lower = 0, parallel_replicas_custom_key_range_upper = 0, parallel_replicas_allow_in_with_subquery = false, parallel_replicas_mark_segment_size = 128, parallel_replicas_local_plan = false, parallel_replicas_index_analysis_only_on_coordinator = false, parallel_replicas_support_projection = false, parallel_replicas_insert_select_local_pipeline = false, parallel_replicas_connect_timeout_ms = 1000, parallel_replicas_for_cluster_engines = false, allow_experimental_analyzer = false, analyzer_compatibility_allow_compound_identifiers_in_unflatten_nested = false, max_limit_for_vector_search_queries = 1000, hnsw_candidate_list_size_for_search = 64, vector_search_with_rescoring = true, mongodb_throw_on_unsupported_query = false, optimize_extract_common_expressions = false, optimize_and_compare_chain = false, push_external_roles_in_interserver_queries = false, shared_merge_tree_sync_parts_on_partition_operations = true, allow_general_join_planning = false, cluster_table_function_buckets_batch_size = 0, merge_table_max_tables_to_look_for_schema_inference = 1, max_autoincrement_series = 1000, use_hive_partitioning = false, parallel_hash_join_threshold = 0, apply_settings_from_server = false, allow_archive_path_syntax = false, low_priority_query_wait_time_ms = 1000, iceberg_insert_max_rows_in_data_file = 1000000, iceberg_insert_max_partitions = 100, min_os_cpu_wait_time_ratio_to_throw = 0., max_os_cpu_wait_time_ratio_to_throw = 0., enable_producing_buckets_out_of_order_in_aggregation = false, enable_parallel_blocks_marshalling = false, min_outstreams_per_resize_after_split = 0, function_date_trunc_return_type_behavior = 1, query_plan_remove_unused_columns = false, show_processlist_include_internal = false, optimize_const_name_size = -1, join_to_sort_minimum_perkey_rows = 0, join_to_sort_maximum_table_rows = 0, allow_statistics_optimize = false, use_statistics_cache = false, text_index_hint_max_selectivity = 0.20000000298023224, allow_experimental_kusto_dialect = true, allow_experimental_prql_dialect = true, allow_experimental_delta_kernel_rs = false, allow_experimental_iceberg_compaction = false, make_distributed_plan = false, distributed_plan_execute_locally = false, distributed_plan_default_shuffle_join_bucket_count = 8, distributed_plan_default_reader_bucket_count = 8, distributed_plan_max_rows_to_broadcast = 20000, distributed_plan_force_shuffle_aggregation = false, join_runtime_filter_exact_values_limit = 10000, join_runtime_bloom_filter_hash_functions = 3, promql_evaluation_time = 0., allow_experimental_shared_merge_tree = false, allow_experimental_database_replicated = false, allow_experimental_refreshable_materialized_view = false, allow_experimental_bfloat16_type = false, allow_experimental_vector_similarity_index = false, enable_vector_similarity_index = false, use_local_cache_for_remote_storage = true, allow_experimental_variant_type = false, allow_experimental_dynamic_type = false, allow_experimental_json_type = false, enable_variant_type = false, enable_dynamic_type = false, enable_json_type = false, azure_sdk_use_native_client = false, allow_not_comparable_types_in_order_by = true, allow_not_comparable_types_in_comparison_functions = true, s3_retry_attempts = 500, max_limit_for_ann_queries = 1000, http_max_chunk_size = 0, allow_experimental_shared_set_join = false, min_external_sort_block_bytes = 0, distributed_cache_read_alignment = 0, use_json_alias_for_old_object_type = true, input_format_parquet_preserve_order = true, input_format_parquet_bloom_filter_push_down = false, input_format_parquet_enable_json_parsing = false, input_format_parquet_use_native_reader_v3 = false, input_format_parquet_local_time_as_utc = false, input_format_orc_allow_missing_columns = false, input_format_orc_dictionary_as_low_cardinality = false, input_format_parquet_allow_missing_columns = false, input_format_parquet_enable_row_group_prefetch = false, input_format_arrow_allow_missing_columns = false, input_format_hive_text_allow_variable_number_of_columns = false, input_format_parquet_max_block_size = 8192, input_format_parquet_prefer_block_bytes = 0, schema_inference_make_columns_nullable = 1, input_format_json_read_bools_as_strings = false, input_format_json_try_infer_numbers_from_strings = true, input_format_json_read_numbers_as_strings = false, input_format_json_read_arrays_as_strings = false, input_format_json_try_infer_named_tuples_from_objects = false, input_format_json_infer_array_of_dynamic_from_array_of_different_types = false, input_format_json_infer_incomplete_types_as_strings = false, input_format_json_ignore_unnecessary_fields = false, input_format_json_max_depth = 1000000, input_format_try_infer_datetimes_only_datetime64 = true, input_format_try_infer_exponent_floats = true, allow_special_bool_values_inside_variant = true, output_format_json_quote_64bit_integers = true, output_format_json_pretty_print = false, output_format_pretty_max_rows = 10000, output_format_pretty_max_column_name_width_cut_to = 0, output_format_pretty_max_column_name_width_min_chars_to_cut = 0, output_format_pretty_max_value_width_apply_for_single_value = 1, output_format_pretty_squash_consecutive_ms = 0, output_format_pretty_squash_max_wait_ms = 0, output_format_pretty_color = 1, output_format_pretty_glue_chunks = 0, output_format_pretty_display_footer_column_names = 0, output_format_pretty_display_footer_column_names_min_rows = 0, output_format_parquet_string_as_string = false, output_format_parquet_compression_method = 'lz4', output_format_parquet_compliant_nested_types = false, output_format_parquet_use_custom_encoder = false, output_format_parquet_write_page_index = false, output_format_parquet_write_bloom_filter = false, output_format_parquet_bloom_filter_flush_threshold_bytes = 134217728, output_format_parquet_datetime_as_uint32 = true, output_format_parquet_date_as_uint16 = true, output_format_parquet_max_dictionary_size = 1048576, output_format_parquet_enum_as_byte_array = false, output_format_parquet_write_checksums = false, output_format_pretty_row_numbers = false, output_format_pretty_highlight_digit_groups = false, output_format_pretty_single_large_number_tip_threshold = 0, output_format_pretty_highlight_trailing_spaces = false, output_format_pretty_multiline_fields = false, output_format_pretty_fallback_to_vertical = false, output_format_pretty_fallback_to_vertical_max_rows_per_chunk = 0, output_format_pretty_fallback_to_vertical_min_table_width = 0, output_format_pretty_fallback_to_vertical_min_columns = 0, output_format_arrow_use_signed_indexes_for_dictionary = false, output_format_arrow_string_as_string = false, output_format_orc_string_as_string = false, output_format_orc_compression_method = 'lz4', output_format_orc_compression_block_size = 65536, validate_experimental_and_suspicious_types_inside_nested_types = false, input_format_max_block_size_bytes = 0, input_format_parquet_allow_geoparquet_parser = false, output_format_parquet_geometadata = false
Does it reproduce on the most recent release?
Yes
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release