2024-06-19 19:47:59 [d1253c69569d] 2024.06.19 19:47:59.643602 [ 12646 ] {0dbf865b-3287-42e1-af11-68c3300cbd78} <Error> executeQuery: Code: 241. DB::Exception: Memory limit (for query) exceeded: would use 382.09 MiB (attempt to allocate chunk of 1053727 bytes), maximum: 381.47 MiB.: (while reading column s): (while reading from part /var/lib/clickhouse/disks/s3/store/515/5155bb39-8be7-4651-869d-b1b05a5d2cc3/40_41_41_1/ in table test_555j25mg.order_by_desc (5155bb39-8be7-4651-869d-b1b05a5d2cc3) located on disk s3 of type s3, from mark 2 with max_rows_to_read = 1024): While executing MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InReverseOrder). (MEMORY_LIMIT_EXCEEDED) (version 24.6.1.4323) (from [::1]:46862) (comment: 01926_order_by_desc_limit.sql) (in query: SELECT s FROM order_by_desc ORDER BY u DESC LIMIT 10 FORMAT Null SETTINGS max_memory_usage = '400M';), Stack trace (when copying this message, always include the lines below):
2024-06-19 19:47:59 
2024-06-19 19:47:59 0. /build/contrib/llvm-project/libcxx/include/exception:141: std::exception::capture() @ 0x000000000ab4c302
2024-06-19 19:47:59 1. /build/contrib/llvm-project/libcxx/include/exception:116: std::exception::exception[abi:v15000]() @ 0x000000000ab4c2cd
2024-06-19 19:47:59 2. /build/base/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(String const&, int) @ 0x0000000022b7f240
2024-06-19 19:47:59 3. /build/src/Common/Exception.cpp:99: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000013099c8e
2024-06-19 19:47:59 4. /build/src/Common/Exception.h:95: DB::Exception::Exception(String&&, int, bool) @ 0x000000000ab4220a
2024-06-19 19:47:59 5. /build/src/Common/Exception.h:68: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000ab3f9e9
2024-06-19 19:47:59 6. /build/src/Common/Exception.h:113: DB::Exception::Exception<char const*, char const*, String, long&, String, char const*, std::basic_string_view<char, std::char_traits<char>>>(int, FormatStringHelperImpl<std::type_identity<char const*>::type, std::type_identity<char const*>::type, std::type_identity<String>::type, std::type_identity<long&>::type, std::type_identity<String>::type, std::type_identity<char const*>::type, std::type_identity<std::basic_string_view<char, std::char_traits<char>>>::type>, char const*&&, char const*&&, String&&, long&, String&&, char const*&&, std::basic_string_view<char, std::char_traits<char>>&&) @ 0x00000000130c954f
2024-06-19 19:47:59 7. /build/src/Common/MemoryTracker.cpp:340: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000130c7cf1
2024-06-19 19:47:59 8. /build/src/Common/MemoryTracker.cpp:398: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000130c8042
2024-06-19 19:47:59 9. /build/src/Common/CurrentMemoryTracker.cpp:58: CurrentMemoryTracker::allocImpl(long, bool) @ 0x0000000013034471
2024-06-19 19:47:59 10. /build/src/Common/CurrentMemoryTracker.cpp:90: CurrentMemoryTracker::alloc(long) @ 0x0000000013034681
2024-06-19 19:47:59 11. /build/src/Common/Allocator.cpp:151: Allocator<false, false>::alloc(unsigned long, unsigned long) @ 0x00000000130325c6
2024-06-19 19:47:59 12. /build/src/IO/BufferWithOwnMemory.h:130: DB::Memory<Allocator<false, false>>::alloc(unsigned long) @ 0x000000001314aa8c
2024-06-19 19:47:59 13. /build/src/IO/BufferWithOwnMemory.h:87: DB::Memory<Allocator<false, false>>::resize(unsigned long) @ 0x000000001316c9d3
2024-06-19 19:47:59 14. /build/src/Compression/CompressedReadBufferFromFile.cpp:31: DB::CompressedReadBufferFromFile::nextImpl() @ 0x000000001a21352c
2024-06-19 19:47:59 15. /build/src/IO/ReadBuffer.h:70: DB::ReadBuffer::next() @ 0x000000000b15c10a
2024-06-19 19:47:59 16. /build/src/IO/ReadBuffer.h:106: void DB::deserializeBinarySSE2<1>(DB::PODArray<char8_t, 4096ul, Allocator<false, false>, 63ul, 64ul>&, DB::PODArray<unsigned long, 4096ul, Allocator<false, false>, 63ul, 64ul>&, DB::ReadBuffer&, unsigned long) @ 0x000000001a4a85bf
2024-06-19 19:47:59 17. /build/src/DataTypes/Serializations/SerializationString.cpp:258: DB::SerializationString::dese