2024.10.21 19:33:20.833912 [ 342 ] {} Context: The setting 'allow_remote_fs_zero_copy_replication' is enabled for MergeTree tables. But the feature of 'zero-copy replication' is under development and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production. 2024.10.21 19:33:20.838830 [ 342 ] {} Application: Integrity check of the executable skipped because the reference checksum could not be read. 2024.10.21 19:33:20.844444 [ 342 ] {} Context: The setting 'merge_tree_metadata_cache' is enabled. But the feature of 'metadata cache in RocksDB' is experimental and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production. See the corresponding report at https://github.com/ClickHouse/ClickHouse/issues/51182 2024.10.21 19:33:20.954099 [ 342 ] {} KeeperLogStore: No logs exists in /var/lib/clickhouse/coordination/logs. It's Ok if it's the first run of clickhouse-keeper. 2024.10.21 19:33:20.954710 [ 342 ] {} KeeperLogStore: Removing all changelogs 2024.10.21 19:33:20.955027 [ 342 ] {} KeeperServer: Got 1000000000000000 value for setting 'reserved_log_items' which is bigger than int32_t max value, lowering value to 2147483647. 2024.10.21 19:33:20.956534 [ 342 ] {} KeeperStateManager: No state was read 2024.10.21 19:33:20.956557 [ 342 ] {} RaftInstance: invalid election timeout lower bound detected, adjusted to 0 2024.10.21 19:33:20.956570 [ 342 ] {} RaftInstance: invalid election timeout upper bound detected, adjusted to 0 2024.10.21 19:33:21.007277 [ 554 ] {} RaftInstance: Election timeout, initiate leader election 2024.10.21 19:33:21.024086 [ 342 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.10.21 19:33:21.024102 [ 342 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.10.21 19:33:21.053416 [ 342 ] {} Context: Table system.session_log is enabled. It's unreliable and may contain garbage. Do not use it for any kind of security monitoring. 2024.10.21 19:35:05.543205 [ 556 ] {} RaftInstance: failed to accept a rpc connection due to error 125, Operation canceled 2024.10.21 19:35:05.553927 [ 552 ] {} KeeperLogStore: Raft server is not set in LogStore. 2024.10.21 19:35:05.557776 [ 342 ] {} KeeperLogStore: Changelog is shut down 2024.10.21 19:35:05.912084 [ 721 ] {} Context: The setting 'allow_remote_fs_zero_copy_replication' is enabled for MergeTree tables. But the feature of 'zero-copy replication' is under development and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production. 2024.10.21 19:35:05.916716 [ 721 ] {} Application: Integrity check of the executable skipped because the reference checksum could not be read. 2024.10.21 19:35:05.921248 [ 721 ] {} Context: The setting 'merge_tree_metadata_cache' is enabled. But the feature of 'metadata cache in RocksDB' is experimental and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production. See the corresponding report at https://github.com/ClickHouse/ClickHouse/issues/51182 2024.10.21 19:35:06.019218 [ 721 ] {} KeeperServer: Got 1000000000000000 value for setting 'reserved_log_items' which is bigger than int32_t max value, lowering value to 2147483647. 2024.10.21 19:35:06.021046 [ 721 ] {} RaftInstance: invalid election timeout lower bound detected, adjusted to 0 2024.10.21 19:35:06.021073 [ 721 ] {} RaftInstance: invalid election timeout upper bound detected, adjusted to 0 2024.10.21 19:35:06.071775 [ 933 ] {} RaftInstance: Election timeout, initiate leader election 2024.10.21 19:35:06.194779 [ 721 ] {} Context: Table system.session_log is enabled. It's unreliable and may contain garbage. Do not use it for any kind of security monitoring. 2024.10.21 19:36:03.597379 [ 724 ] {39c28543-a961-4ecd-9fdc-4f2e856379c3} executeQuery: Code: 158. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 1.00 million, current rows: 8.88 million: While processing (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery3: While processing 1 = ((SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery3). (TOO_MANY_ROWS) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:34298) (comment: 00175_counting_resources_in_subqueries.sql) (in query: SELECT 1 = (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID));), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:65: DB::ReadFromMergeTree::initializePipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118e8a18 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./contrib/llvm-project/libcxx/include/vector:1420: DB::ISourceStep::updatePipeline(std::vector>, std::allocator>>>, DB::BuildQueryPipelineSettings const&) @ 0x00000000118b16d4 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118c6100 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:818: DB::InterpreterSelectWithUnionQuery::execute() @ 0x00000000104ed49c in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./src/Interpreters/ExecuteScalarSubqueriesVisitor.cpp:188: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTSubquery const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010566cf8 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:815: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x000000001056587c in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ./build_docker/./contrib/llvm-project/libcxx/include/__iterator/wrap_iter.h:100: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTFunction const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010570558 in /usr/lib/debug/usr/bin/clickhouse.debug 11. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:78: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x00000000105658a8 in /usr/lib/debug/usr/bin/clickhouse.debug 12. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 13. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:0: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659e8 in /usr/lib/debug/usr/bin/clickhouse.debug 14. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:1551: DB::(anonymous namespace)::executeScalarSubqueries(std::shared_ptr&, std::shared_ptr, unsigned long, std::map, std::allocator>>&, std::map, std::allocator>>&, bool, bool) @ 0x00000000107481a0 in /usr/lib/debug/usr/bin/clickhouse.debug 15. ./build_docker/./src/Core/SettingsFields.h:47: DB::TreeRewriter::analyzeSelect(std::shared_ptr&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std::vector> const&, std::vector> const&, std::shared_ptr) const @ 0x0000000010744660 in /usr/lib/debug/usr/bin/clickhouse.debug 16. ./build_docker/./contrib/llvm-project/libcxx/include/__utility/swap.h:37: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr)::$_0::operator()(bool) const @ 0x000000001045b4cc in /usr/lib/debug/usr/bin/clickhouse.debug 17. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:0: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000010455ea8 in /usr/lib/debug/usr/bin/clickhouse.debug 18. ./build_docker/./contrib/llvm-project/libcxx/include/optional:260: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x00000000104e9108 in /usr/lib/debug/usr/bin/clickhouse.debug 19. ./build_docker/./contrib/llvm-project/libcxx/include/vector:434: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000010415624 in /usr/lib/debug/usr/bin/clickhouse.debug 20. ./build_docker/./src/Interpreters/executeQuery.cpp:1026: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000107d9900 in /usr/lib/debug/usr/bin/clickhouse.debug 21. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000107d6868 in /usr/lib/debug/usr/bin/clickhouse.debug 22. ./build_docker/./src/Server/TCPHandler.cpp:496: DB::TCPHandler::runImpl() @ 0x00000000114d3bf0 in /usr/lib/debug/usr/bin/clickhouse.debug 23. ./build_docker/./src/Common/CurrentThread.cpp:94: DB::TCPHandler::run() @ 0x00000000114e3d28 in /usr/lib/debug/usr/bin/clickhouse.debug 24. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x00000000139ea584 in /usr/lib/debug/usr/bin/clickhouse.debug 25. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x00000000139eba80 in /usr/lib/debug/usr/bin/clickhouse.debug 26. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x0000000013b5d9fc in /usr/lib/debug/usr/bin/clickhouse.debug 27. ./build_docker/./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000013b5bbc4 in /usr/lib/debug/usr/bin/clickhouse.debug 28. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 29. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.598582 [ 724 ] {39c28543-a961-4ecd-9fdc-4f2e856379c3} TCPHandler: Code: 158. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 1.00 million, current rows: 8.88 million: While processing (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery3: While processing 1 = ((SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery3). (TOO_MANY_ROWS), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:65: DB::ReadFromMergeTree::initializePipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118e8a18 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./contrib/llvm-project/libcxx/include/vector:1420: DB::ISourceStep::updatePipeline(std::vector>, std::allocator>>>, DB::BuildQueryPipelineSettings const&) @ 0x00000000118b16d4 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118c6100 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:818: DB::InterpreterSelectWithUnionQuery::execute() @ 0x00000000104ed49c in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./src/Interpreters/ExecuteScalarSubqueriesVisitor.cpp:188: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTSubquery const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010566cf8 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:815: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x000000001056587c in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ./build_docker/./contrib/llvm-project/libcxx/include/__iterator/wrap_iter.h:100: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTFunction const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010570558 in /usr/lib/debug/usr/bin/clickhouse.debug 11. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:78: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x00000000105658a8 in /usr/lib/debug/usr/bin/clickhouse.debug 12. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 13. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:0: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659e8 in /usr/lib/debug/usr/bin/clickhouse.debug 14. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:1551: DB::(anonymous namespace)::executeScalarSubqueries(std::shared_ptr&, std::shared_ptr, unsigned long, std::map, std::allocator>>&, std::map, std::allocator>>&, bool, bool) @ 0x00000000107481a0 in /usr/lib/debug/usr/bin/clickhouse.debug 15. ./build_docker/./src/Core/SettingsFields.h:47: DB::TreeRewriter::analyzeSelect(std::shared_ptr&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std::vector> const&, std::vector> const&, std::shared_ptr) const @ 0x0000000010744660 in /usr/lib/debug/usr/bin/clickhouse.debug 16. ./build_docker/./contrib/llvm-project/libcxx/include/__utility/swap.h:37: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr)::$_0::operator()(bool) const @ 0x000000001045b4cc in /usr/lib/debug/usr/bin/clickhouse.debug 17. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:0: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000010455ea8 in /usr/lib/debug/usr/bin/clickhouse.debug 18. ./build_docker/./contrib/llvm-project/libcxx/include/optional:260: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x00000000104e9108 in /usr/lib/debug/usr/bin/clickhouse.debug 19. ./build_docker/./contrib/llvm-project/libcxx/include/vector:434: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000010415624 in /usr/lib/debug/usr/bin/clickhouse.debug 20. ./build_docker/./src/Interpreters/executeQuery.cpp:1026: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000107d9900 in /usr/lib/debug/usr/bin/clickhouse.debug 21. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000107d6868 in /usr/lib/debug/usr/bin/clickhouse.debug 22. ./build_docker/./src/Server/TCPHandler.cpp:496: DB::TCPHandler::runImpl() @ 0x00000000114d3bf0 in /usr/lib/debug/usr/bin/clickhouse.debug 23. ./build_docker/./src/Common/CurrentThread.cpp:94: DB::TCPHandler::run() @ 0x00000000114e3d28 in /usr/lib/debug/usr/bin/clickhouse.debug 24. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x00000000139ea584 in /usr/lib/debug/usr/bin/clickhouse.debug 25. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x00000000139eba80 in /usr/lib/debug/usr/bin/clickhouse.debug 26. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x0000000013b5d9fc in /usr/lib/debug/usr/bin/clickhouse.debug 27. ./build_docker/./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000013b5bbc4 in /usr/lib/debug/usr/bin/clickhouse.debug 28. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 29. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.612509 [ 724 ] {2c06d856-e276-464c-83e5-d257de6782e3} executeQuery: Code: 158. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 1.00 million, current rows: 8.88 million. (TOO_MANY_ROWS) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:34298) (comment: 00175_counting_resources_in_subqueries.sql) (in query: SELECT 1 IN (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID));), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:65: DB::ReadFromMergeTree::initializePipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118e8a18 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./contrib/llvm-project/libcxx/include/vector:1420: DB::ISourceStep::updatePipeline(std::vector>, std::allocator>>>, DB::BuildQueryPipelineSettings const&) @ 0x00000000118b16d4 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118c6100 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:818: DB::InterpreterSelectWithUnionQuery::execute() @ 0x00000000104ed49c in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000107d9f88 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000107d6868 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./src/Server/TCPHandler.cpp:496: DB::TCPHandler::runImpl() @ 0x00000000114d3bf0 in /usr/lib/debug/usr/bin/clickhouse.debug 10. ./build_docker/./src/Common/CurrentThread.cpp:94: DB::TCPHandler::run() @ 0x00000000114e3d28 in /usr/lib/debug/usr/bin/clickhouse.debug 11. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x00000000139ea584 in /usr/lib/debug/usr/bin/clickhouse.debug 12. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x00000000139eba80 in /usr/lib/debug/usr/bin/clickhouse.debug 13. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x0000000013b5d9fc in /usr/lib/debug/usr/bin/clickhouse.debug 14. ./build_docker/./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000013b5bbc4 in /usr/lib/debug/usr/bin/clickhouse.debug 15. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 16. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.612738 [ 724 ] {2c06d856-e276-464c-83e5-d257de6782e3} TCPHandler: Code: 158. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 1.00 million, current rows: 8.88 million. (TOO_MANY_ROWS), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:65: DB::ReadFromMergeTree::initializePipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118e8a18 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./contrib/llvm-project/libcxx/include/vector:1420: DB::ISourceStep::updatePipeline(std::vector>, std::allocator>>>, DB::BuildQueryPipelineSettings const&) @ 0x00000000118b16d4 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118c6100 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:818: DB::InterpreterSelectWithUnionQuery::execute() @ 0x00000000104ed49c in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000107d9f88 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000107d6868 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./src/Server/TCPHandler.cpp:496: DB::TCPHandler::runImpl() @ 0x00000000114d3bf0 in /usr/lib/debug/usr/bin/clickhouse.debug 10. ./build_docker/./src/Common/CurrentThread.cpp:94: DB::TCPHandler::run() @ 0x00000000114e3d28 in /usr/lib/debug/usr/bin/clickhouse.debug 11. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x00000000139ea584 in /usr/lib/debug/usr/bin/clickhouse.debug 12. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x00000000139eba80 in /usr/lib/debug/usr/bin/clickhouse.debug 13. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x0000000013b5d9fc in /usr/lib/debug/usr/bin/clickhouse.debug 14. ./build_docker/./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000013b5bbc4 in /usr/lib/debug/usr/bin/clickhouse.debug 15. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 16. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.638491 [ 724 ] {0ead69c7-e34b-4c99-bd85-d0fd850a13a6} executeQuery: Code: 158. DB::Exception: Limit for rows or bytes to read exceeded, max rows: 15.00 million, current rows: 17.76 million: While executing MergeTreeThread. (TOO_MANY_ROWS) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:34298) (comment: 00175_counting_resources_in_subqueries.sql) (in query: SELECT count() IN (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) FROM test.hits WHERE NOT ignore(AdvEngineID);), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.640050 [ 724 ] {0ead69c7-e34b-4c99-bd85-d0fd850a13a6} TCPHandler: Code: 158. DB::Exception: Limit for rows or bytes to read exceeded, max rows: 15.00 million, current rows: 17.76 million: While executing MergeTreeThread. (TOO_MANY_ROWS), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.670171 [ 724 ] {2734a264-eed2-499d-b12d-f1197cddc59e} executeQuery: Code: 158. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 1.00 million, current rows: 8.88 million: While processing (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery6: While processing CounterID > ((SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery6). (TOO_MANY_ROWS) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:34298) (comment: 00175_counting_resources_in_subqueries.sql) (in query: SELECT count() FROM test.hits WHERE CounterID > (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID));), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:65: DB::ReadFromMergeTree::initializePipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118e8a18 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./contrib/llvm-project/libcxx/include/vector:1420: DB::ISourceStep::updatePipeline(std::vector>, std::allocator>>>, DB::BuildQueryPipelineSettings const&) @ 0x00000000118b16d4 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118c6100 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:818: DB::InterpreterSelectWithUnionQuery::execute() @ 0x00000000104ed49c in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./src/Interpreters/ExecuteScalarSubqueriesVisitor.cpp:188: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTSubquery const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010566cf8 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:815: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x000000001056587c in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ./build_docker/./contrib/llvm-project/libcxx/include/__iterator/wrap_iter.h:100: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTFunction const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010570558 in /usr/lib/debug/usr/bin/clickhouse.debug 11. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:78: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x00000000105658a8 in /usr/lib/debug/usr/bin/clickhouse.debug 12. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 13. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:1551: DB::(anonymous namespace)::executeScalarSubqueries(std::shared_ptr&, std::shared_ptr, unsigned long, std::map, std::allocator>>&, std::map, std::allocator>>&, bool, bool) @ 0x00000000107481a0 in /usr/lib/debug/usr/bin/clickhouse.debug 14. ./build_docker/./src/Core/SettingsFields.h:47: DB::TreeRewriter::analyzeSelect(std::shared_ptr&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std::vector> const&, std::vector> const&, std::shared_ptr) const @ 0x0000000010744660 in /usr/lib/debug/usr/bin/clickhouse.debug 15. ./build_docker/./contrib/llvm-project/libcxx/include/__utility/swap.h:37: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr)::$_0::operator()(bool) const @ 0x000000001045b4cc in /usr/lib/debug/usr/bin/clickhouse.debug 16. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:0: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000010455ea8 in /usr/lib/debug/usr/bin/clickhouse.debug 17. ./build_docker/./contrib/llvm-project/libcxx/include/optional:260: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x00000000104e9108 in /usr/lib/debug/usr/bin/clickhouse.debug 18. ./build_docker/./contrib/llvm-project/libcxx/include/vector:434: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000010415624 in /usr/lib/debug/usr/bin/clickhouse.debug 19. ./build_docker/./src/Interpreters/executeQuery.cpp:1026: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000107d9900 in /usr/lib/debug/usr/bin/clickhouse.debug 20. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000107d6868 in /usr/lib/debug/usr/bin/clickhouse.debug 21. ./build_docker/./src/Server/TCPHandler.cpp:496: DB::TCPHandler::runImpl() @ 0x00000000114d3bf0 in /usr/lib/debug/usr/bin/clickhouse.debug 22. ./build_docker/./src/Common/CurrentThread.cpp:94: DB::TCPHandler::run() @ 0x00000000114e3d28 in /usr/lib/debug/usr/bin/clickhouse.debug 23. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x00000000139ea584 in /usr/lib/debug/usr/bin/clickhouse.debug 24. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x00000000139eba80 in /usr/lib/debug/usr/bin/clickhouse.debug 25. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x0000000013b5d9fc in /usr/lib/debug/usr/bin/clickhouse.debug 26. ./build_docker/./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000013b5bbc4 in /usr/lib/debug/usr/bin/clickhouse.debug 27. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 28. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.670401 [ 724 ] {2734a264-eed2-499d-b12d-f1197cddc59e} TCPHandler: Code: 158. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 1.00 million, current rows: 8.88 million: While processing (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery6: While processing CounterID > ((SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID)) AS _subquery6). (TOO_MANY_ROWS), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:65: DB::ReadFromMergeTree::initializePipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118e8a18 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./contrib/llvm-project/libcxx/include/vector:1420: DB::ISourceStep::updatePipeline(std::vector>, std::allocator>>>, DB::BuildQueryPipelineSettings const&) @ 0x00000000118b16d4 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) @ 0x00000000118c6100 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:818: DB::InterpreterSelectWithUnionQuery::execute() @ 0x00000000104ed49c in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./src/Interpreters/ExecuteScalarSubqueriesVisitor.cpp:188: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTSubquery const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010566cf8 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:815: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x000000001056587c in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ./build_docker/./contrib/llvm-project/libcxx/include/__iterator/wrap_iter.h:100: DB::ExecuteScalarSubqueriesMatcher::visit(DB::ASTFunction const&, std::shared_ptr&, DB::ExecuteScalarSubqueriesMatcher::Data&) @ 0x0000000010570558 in /usr/lib/debug/usr/bin/clickhouse.debug 11. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:78: DB::InDepthNodeVisitor>::doVisit(std::shared_ptr&) @ 0x00000000105658a8 in /usr/lib/debug/usr/bin/clickhouse.debug 12. ./build_docker/./src/Interpreters/InDepthNodeVisitor.h:64: void DB::InDepthNodeVisitor>::visitChildren(std::shared_ptr&) @ 0x00000000105659dc in /usr/lib/debug/usr/bin/clickhouse.debug 13. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:1551: DB::(anonymous namespace)::executeScalarSubqueries(std::shared_ptr&, std::shared_ptr, unsigned long, std::map, std::allocator>>&, std::map, std::allocator>>&, bool, bool) @ 0x00000000107481a0 in /usr/lib/debug/usr/bin/clickhouse.debug 14. ./build_docker/./src/Core/SettingsFields.h:47: DB::TreeRewriter::analyzeSelect(std::shared_ptr&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std::vector> const&, std::vector> const&, std::shared_ptr) const @ 0x0000000010744660 in /usr/lib/debug/usr/bin/clickhouse.debug 15. ./build_docker/./contrib/llvm-project/libcxx/include/__utility/swap.h:37: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr)::$_0::operator()(bool) const @ 0x000000001045b4cc in /usr/lib/debug/usr/bin/clickhouse.debug 16. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:0: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000010455ea8 in /usr/lib/debug/usr/bin/clickhouse.debug 17. ./build_docker/./contrib/llvm-project/libcxx/include/optional:260: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x00000000104e9108 in /usr/lib/debug/usr/bin/clickhouse.debug 18. ./build_docker/./contrib/llvm-project/libcxx/include/vector:434: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000010415624 in /usr/lib/debug/usr/bin/clickhouse.debug 19. ./build_docker/./src/Interpreters/executeQuery.cpp:1026: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000107d9900 in /usr/lib/debug/usr/bin/clickhouse.debug 20. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000107d6868 in /usr/lib/debug/usr/bin/clickhouse.debug 21. ./build_docker/./src/Server/TCPHandler.cpp:496: DB::TCPHandler::runImpl() @ 0x00000000114d3bf0 in /usr/lib/debug/usr/bin/clickhouse.debug 22. ./build_docker/./src/Common/CurrentThread.cpp:94: DB::TCPHandler::run() @ 0x00000000114e3d28 in /usr/lib/debug/usr/bin/clickhouse.debug 23. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x00000000139ea584 in /usr/lib/debug/usr/bin/clickhouse.debug 24. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x00000000139eba80 in /usr/lib/debug/usr/bin/clickhouse.debug 25. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x0000000013b5d9fc in /usr/lib/debug/usr/bin/clickhouse.debug 26. ./build_docker/./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000013b5bbc4 in /usr/lib/debug/usr/bin/clickhouse.debug 27. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 28. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.694231 [ 724 ] {7b45ec77-b1b7-406a-8a5a-bd506adfa0d5} executeQuery: Code: 158. DB::Exception: Limit for rows or bytes to read exceeded, max rows: 10.00 million, current rows: 13.12 million: While executing MergeTreeThread. (TOO_MANY_ROWS) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:34298) (comment: 00175_counting_resources_in_subqueries.sql) (in query: SELECT count() FROM test.hits WHERE CounterID < (SELECT count() FROM test.hits WHERE NOT ignore(AdvEngineID));), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:03.695266 [ 724 ] {7b45ec77-b1b7-406a-8a5a-bd506adfa0d5} TCPHandler: Code: 158. DB::Exception: Limit for rows or bytes to read exceeded, max rows: 10.00 million, current rows: 13.12 million: While executing MergeTreeThread. (TOO_MANY_ROWS), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, String&&, String&&) @ 0x000000000f9e2bd0 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:25: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2a88 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:41.865269 [ 1764 ] {50e27f61-3e0b-4cb6-949b-ccac6f48ea5a} executeQuery: Code: 307. DB::Exception: Limit for rows or bytes to read exceeded, max bytes: 572.20 MiB, current bytes: 587.69 MiB: While executing MergeTreeThread. (TOO_MANY_BYTES) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:50464) (comment: 00091_prewhere_two_conditions.sql) (in query: SELECT uniq(URL) FROM test.hits WHERE toTimeZone(EventTime, 'Asia/Dubai') >= '2014-03-20 00:00:00' AND toTimeZone(EventTime, 'Asia/Dubai') < '2014-03-21 00:00:00';), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, ReadableSize&&, ReadableSize&&) @ 0x000000000f9e2d88 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:36: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2924 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:41.868130 [ 1764 ] {50e27f61-3e0b-4cb6-949b-ccac6f48ea5a} TCPHandler: Code: 307. DB::Exception: Limit for rows or bytes to read exceeded, max bytes: 572.20 MiB, current bytes: 587.69 MiB: While executing MergeTreeThread. (TOO_MANY_BYTES), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, ReadableSize&&, ReadableSize&&) @ 0x000000000f9e2d88 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:36: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2924 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:41.966081 [ 1764 ] {bf2477dc-abe5-4eee-8329-eb4a04f48e48} executeQuery: Code: 307. DB::Exception: Limit for rows or bytes to read exceeded, max bytes: 572.20 MiB, current bytes: 579.11 MiB: While executing MergeTreeThread. (TOO_MANY_BYTES) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:50464) (comment: 00091_prewhere_two_conditions.sql) (in query: SELECT uniq(URL) FROM test.hits WHERE toTimeZone(EventTime, 'Asia/Dubai') >= '2014-03-20 00:00:00' AND URL != '' AND toTimeZone(EventTime, 'Asia/Dubai') < '2014-03-21 00:00:00';), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, ReadableSize&&, ReadableSize&&) @ 0x000000000f9e2d88 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:36: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2924 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:41.968533 [ 1764 ] {bf2477dc-abe5-4eee-8329-eb4a04f48e48} TCPHandler: Code: 307. DB::Exception: Limit for rows or bytes to read exceeded, max bytes: 572.20 MiB, current bytes: 579.11 MiB: While executing MergeTreeThread. (TOO_MANY_BYTES), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, ReadableSize&&, ReadableSize&&) @ 0x000000000f9e2d88 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:36: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2924 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:42.068086 [ 1764 ] {111c5527-1d0e-4b61-97ea-41f8e407b25c} executeQuery: Code: 307. DB::Exception: Limit for rows or bytes to read exceeded, max bytes: 572.20 MiB, current bytes: 582.97 MiB: While executing MergeTreeThread. (TOO_MANY_BYTES) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:50464) (comment: 00091_prewhere_two_conditions.sql) (in query: SELECT uniq(URL) FROM test.hits PREWHERE toTimeZone(EventTime, 'Asia/Dubai') >= '2014-03-20 00:00:00' AND URL != '' AND toTimeZone(EventTime, 'Asia/Dubai') < '2014-03-21 00:00:00';), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, ReadableSize&&, ReadableSize&&) @ 0x000000000f9e2d88 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:36: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2924 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:36:42.070274 [ 1764 ] {111c5527-1d0e-4b61-97ea-41f8e407b25c} TCPHandler: Code: 307. DB::Exception: Limit for rows or bytes to read exceeded, max bytes: 572.20 MiB, current bytes: 582.97 MiB: While executing MergeTreeThread. (TOO_MANY_BYTES), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000b2d2c84 in /usr/lib/debug/usr/bin/clickhouse.debug 1. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, char const*&, ReadableSize&&, ReadableSize&&) @ 0x000000000f9e2d88 in /usr/lib/debug/usr/bin/clickhouse.debug 2. ./build_docker/./src/QueryPipeline/SizeLimits.cpp:36: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000000f9e2924 in /usr/lib/debug/usr/bin/clickhouse.debug 3. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:109: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x000000000f9d0980 in /usr/lib/debug/usr/bin/clickhouse.debug 4. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:62: DB::ExecutionThreadContext::executeTask() @ 0x0000000011530e64 in /usr/lib/debug/usr/bin/clickhouse.debug 5. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000115289f4 in /usr/lib/debug/usr/bin/clickhouse.debug 6. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000011529bfc in /usr/lib/debug/usr/bin/clickhouse.debug 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000000b3a9ac4 in /usr/lib/debug/usr/bin/clickhouse.debug 8. ./build_docker/./src/Common/ThreadPool.h:243: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000b3acf40 in /usr/lib/debug/usr/bin/clickhouse.debug 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000b3ab9dc in /usr/lib/debug/usr/bin/clickhouse.debug 10. ? @ 0x000000000007d5c8 in /usr/lib/aarch64-linux-gnu/libc.so.6 11. ? @ 0x00000000000e5edc in /usr/lib/aarch64-linux-gnu/libc.so.6 2024.10.21 19:37:22.971079 [ 721 ] {} Application: Closed all listening sockets. Waiting for 4 outstanding connections. 2024.10.21 19:37:24.642211 [ 936 ] {} RaftInstance: failed to accept a rpc connection due to error 125, Operation canceled 2024.10.21 19:37:24.653002 [ 932 ] {} KeeperLogStore: Raft server is not set in LogStore. 2024.10.21 19:37:24.662832 [ 721 ] {} KeeperLogStore: Changelog is shut down