2025-08-26 13:17:31 Reason: return code:  160
2025-08-26 13:17:31 [11bff038a646] 2025.08.26 18:17:31.058081 [ 98578 ] {fb30d2fa-bf61-4eaa-8223-cf223547c8ff} <Error> executeQuery: Code: 160. DB::Exception: Estimated query execution time (823.83432 seconds) is too long. Maximum: 600. Estimated rows to process: 48491889 (23321315 read in 396.20852 seconds): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (TOO_SLOW) (version 25.9.1.1) (from [::1]:60124) (comment: 02177_issue_31009.sql) (query 10, line 18) (in query: SELECT key, count(1) AS cnt FROM ( SELECT data.key FROM ( SELECT key FROM left AS s ) AS data LEFT JOIN ( SELECT key FROM right GROUP BY key ) AS promo ON promo.key = data.key ) GROUP BY key HAVING count(1) > 1;), Stack trace (when copying this message, always include the lines below):
2025-08-26 13:17:31 
2025-08-26 13:17:31 0. std::exception::exception[abi:ne190107]() @ 0x000000001a3794b4
2025-08-26 13:17:31 1. ./ci/tmp/build/./base/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(String const&, int) @ 0x000000004199c820
2025-08-26 13:17:31 2. ./ci/tmp/build/./src/Common/Exception.cpp:128: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000288fddee
2025-08-26 13:17:31 3. DB::Exception::Exception(String&&, int, String, bool) @ 0x000000001a20b7ad
2025-08-26 13:17:31 4. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000001a20af46
2025-08-26 13:17:31 5. ./src/Common/Exception.h:141: DB::Exception::Exception<double&, int, unsigned long&, unsigned long&, double&>(int, FormatStringHelperImpl<std::type_identity<double&>::type, std::type_identity<int>::type, std::type_identity<unsigned long&>::type, std::type_identity<unsigned long&>::type, std::type_identity<double&>::type>, double&, int&&, unsigned long&, unsigned long&, double&) @ 0x00000000321f57f7
2025-08-26 13:17:31 6. ./ci/tmp/build/./src/QueryPipeline/ExecutionSpeedLimits.cpp:87: DB::ExecutionSpeedLimits::throttle(unsigned long, unsigned long, unsigned long, unsigned long, DB::OverflowMode) const @ 0x00000000321f541c
2025-08-26 13:17:31 7. ./ci/tmp/build/./src/QueryPipeline/ReadProgressCallback.cpp:131: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list<DB::StorageLimits, std::allocator<DB::StorageLimits>> const&) @ 0x00000000321f497b
2025-08-26 13:17:31 8. ./ci/tmp/build/./src/Processors/Executors/ExecutionThreadContext.cpp:68: DB::ExecutionThreadContext::executeTask() @ 0x000000003ac9c124
2025-08-26 13:17:31 9. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:350: DB::PipelineExecutor::executeStepImpl(unsigned long, DB::IAcquiredSlot*, std::atomic<bool>*) @ 0x000000003ac831ce
2025-08-26 13:17:31 10. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:278: void std::__function::__policy_invoker<void ()>::__call_impl[abi:ne190107]<std::__function::__default_alloc_func<DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0, void ()>>(std::__function::__policy_storage const*) @ 0x000000003ac84cf1
2025-08-26 13:17:31 11. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x0000000028b20a19
2025-08-26 13:17:31 12. ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:117: 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'()::operator()() @ 0x0000000028b29a08
2025-08-26 13:17:31 13. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x0000000028b1d9cf
2025-08-26 13:17:31 14. ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:117: void* std::__thread_proxy[abi:ne190107]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>>(void*) @ 0x0000000028b25bea
2025-08-26 13:17:31 15. ? @ 0x0000000000094ac3
2025-08-26 13:17:31 16. ? @ 0x0000000000126850
2025-08-26 13:17:31 
2025-08-26 13:17:31 Received exception from server (version 25.9.1):
2025-08-26 13:17:31 Code: 160. DB::Exception: Received from localhost:9000. DB::Exception: Estimated query execution time (823.83432 seconds) is too long. Maximum: 600. Estimated rows to process: 48491889 (23321315 read in 396.20852 seconds): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (TOO_SLOW)
2025-08-26 13:17:31 (query: SELECT key, count(1) AS cnt
2025-08-26 13:17:31 FROM (
2025-08-26 13:17:31     SELECT data.key
2025-08-26 13:17:31     FROM ( SELECT key FROM left AS s ) AS data
2025-08-26 13:17:31     LEFT JOIN ( SELECT key FROM right GROUP BY key ) AS promo ON promo.key = data.key
2025-08-26 13:17:31 ) GROUP BY key HAVING count(1) > 1;)
2025-08-26 13:17:31 , result: