Flaky test: 03514_grace_hash_join_logical_error #94702
Description
Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.
Test name: 03514_grace_hash_join_logical_error
Failure reason: DB::Exception: Failed to reserve 841211 bytes for temporary file: reason cannot evict enough space
CI report: Stateless tests (amd_binary, ParallelReplicas, s3 storage, parallel)
Failing test history: cidb
Test output:
2026-01-21 02:26:31 Reason: return code: 243
2026-01-21 02:26:31 [e3be1db55d73] 2026.01.20 08:26:30.317336 [ 153901 ] {fde21f7c-5ed2-421e-8661-12e5e28b5155} <Error> executeQuery: Code: 243. DB::Exception: Failed to reserve 841211 bytes for temporary file: reason cannot evict enough space (stat: releasable size: 2022, releasable count: 9, non-releasable size: 429226495, non-releasable count: 458, evicting count: 0, invalidated count: 579, total size: 740893964/1073741824, total elements: 845/10000000, background download elements: 0), Ephemeral hold 409.34 MiB, can release 0.00 B; Regular hold 0.00 B, can release 1.97 KiB; (segment info: File segment: [0, 841210], key: 8829cca5b797980bcab37ea373ab4244, state: PARTIALLY_DOWNLOADED_NO_CONTINUATION, downloaded size: 0, reserved size: 0, downloader id: fde21f7c-5ed2-421e-8661-12e5e28b5155:323263, current write offset: 0, caller id: fde21f7c-5ed2-421e-8661-12e5e28b5155:323263, kind: Ephemeral, unbound: 1, background download: 1): While executing JoiningTransform. (NOT_ENOUGH_SPACE) (version 26.1.1.698) (from [::ffff:127.0.0.1]:40304) (comment: 03514_grace_hash_join_logical_error.sql-test_rmwcqpw9) (query 6, line 12) (in query: SELECT `__table1`.`A` AS `A`, `__table1`.`B` AS `B`, `__table1`.`S` AS `S`, `__table2`.`A` AS `b.A`, `__table2`.`B` AS `b.B`, `__table2`.`S` AS `b.S` FROM `test_rmwcqpw9`.`A` AS `__table1` ALL INNER JOIN `test_rmwcqpw9`.`A` AS `__table2` ON `__table1`.`A` = `__table2`.`A` LIMIT _CAST(1, 'UInt64')), Stack trace (when copying this message, always include the lines below):
2026-01-21 02:26:31
2026-01-21 02:26:31 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x00000000224a5af2
2026-01-21 02:26:31 1. ./ci/tmp/build/./src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000136c51a9
2026-01-21 02:26:31 2. ./src/Common/Exception.h:172: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000b22d8ce
2026-01-21 02:26:31 3. ./src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000b22d389
2026-01-21 02:26:31 4. ./src/Common/Exception.h:190: DB::Exception::Exception<unsigned long&, char const*, String&, String&, String>(int, FormatStringHelperImpl<std::type_identity<unsigned long&>::type, std::type_identity<char const*>::type, std::type_identity<String&>::type, std::type_identity<String&>::type, std::type_identity<String>::type>, unsigned long&, char const*&&, String&, String&, String&&) @ 0x0000000019c96644
2026-01-21 02:26:31 5. ./ci/tmp/build/./src/Interpreters/Cache/WriteBufferToFileSegment.cpp:93: DB::WriteBufferToFileSegment::nextImpl() @ 0x0000000019c959c9
2026-01-21 02:26:31 6. ./src/IO/WriteBuffer.h:54: DB::WriteBuffer::next() @ 0x000000000b244b9e
2026-01-21 02:26:31 7. ./src/IO/WriteBuffer.h:87: DB::WriteBuffer::write(char const*, unsigned long) @ 0x00000000137cbfd0
2026-01-21 02:26:31 8. ./ci/tmp/build/./src/Compression/CompressedWriteBuffer.cpp:60: DB::CompressedWriteBuffer::nextImpl() @ 0x000000001dd4c18d
2026-01-21 02:26:31 9. ./src/IO/WriteBuffer.h:54: DB::WriteBuffer::next() @ 0x000000000b244b9e
2026-01-21 02:26:31 10. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:404: DB::TemporaryDataBuffer::nextImpl() @ 0x0000000019ab0de3
2026-01-21 02:26:31 11. ./src/IO/WriteBuffer.h:54: DB::WriteBuffer::next() @ 0x000000000b244b9e
2026-01-21 02:26:31 12. ./src/IO/WriteBuffer.h:87: DB::WriteBuffer::write(char const*, unsigned long) @ 0x00000000137cbfd0
2026-01-21 02:26:31 13. ./ci/tmp/build/./src/DataTypes/Serializations/SerializationString.cpp:137: DB::SerializationString::serializeBinaryBulk(DB::IColumn const&, DB::WriteBuffer&, unsigned long, unsigned long) const @ 0x00000000187f479e
2026-01-21 02:26:31 14. ./ci/tmp/build/./src/DataTypes/Serializations/ISerialization.cpp:218: DB::ISerialization::serializeBinaryBulkWithMultipleStreams(DB::IColumn const&, unsigned long, unsigned long, DB::ISerialization::SerializeBinaryBulkSettings&, std::shared_ptr<DB::ISerialization::SerializeBinaryBulkState>&) const @ 0x00000000186ed3ee
2026-01-21 02:26:31 15. ./ci/tmp/build/./src/Formats/NativeWriter.cpp:94: DB::NativeWriter::writeData(DB::ISerialization const&, COW<DB::IColumn>::immutable_ptr<DB::IColumn> const&, DB::WriteBuffer&, std::optional<DB::FormatSettings> const&, unsigned long, unsigned long, unsigned long) @ 0x000000001d0b0ef2
2026-01-21 02:26:31 16. ./ci/tmp/build/./src/Formats/NativeWriter.cpp:208: DB::NativeWriter::write(DB::Block const&) @ 0x000000001d0b1c12
2026-01-21 02:26:31 17. ./ci/tmp/build/./src/Interpreters/GraceHashJoin.cpp:193: DB::GraceHashJoin::FileBucket::addBlockImpl(DB::Block const&, DB::TemporaryBlockStreamHolder&, std::unique_lock<std::mutex>&) @ 0x00000000196fdb50
2026-01-21 02:26:31 18. ./ci/tmp/build/./src/Interpreters/GraceHashJoin.cpp:151: DB::GraceHashJoin::joinBlock(DB::Block) @ 0x00000000196f8431
2026-01-21 02:26:31 19. ./ci/tmp/build/./src/Processors/Transforms/JoiningTransform.cpp:237: DB::JoiningTransform::readExecute(DB::Chunk&) @ 0x000000001d39782b
2026-01-21 02:26:31 20. ./ci/tmp/build/./src/Processors/Transforms/JoiningTransform.cpp:221: DB::JoiningTransform::transform(DB::Chunk&) @ 0x000000001d3965dd
2026-01-21 02:26:31 21. ./ci/tmp/build/./src/Processors/Transforms/JoiningTransform.cpp:146: DB::JoiningTransform::work() @ 0x000000001d395e34
2026-01-21 02:26:31 22. ./ci/tmp/build/./src/Processors/Executors/ExecutionThreadContext.cpp:53: DB::ExecutionThreadContext::executeTask() @ 0x000000001d0fe8e0
2026-01-21 02:26:31 23. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:351: DB::PipelineExecutor::executeStepImpl(unsigned long, DB::IAcquiredSlot*, std::atomic<bool>*) @ 0x000000001d0f1b2e
2026-01-21 02:26:31 24. ./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*) @ 0x000000001d0f3243
2026-01-21 02:26:31 25. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x000000001380d5cc
2026-01-21 02:26:31 26. ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:0: 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()() @ 0x00000000138127a6
2026-01-21 02:26:31 27. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x000000001380b2b5
2026-01-21 02:26:31 28. ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:0: 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*) @ 0x0000000013810b3b
2026-01-21 02:26:31 29. ? @ 0x0000000000094ac3
2026-01-21 02:26:31 30. ? @ 0x00000000001268c0
2026-01-21 02:26:31
2026-01-21 02:26:31 [e3be1db55d73] 2026.01.20 08:26:31.028600 [ 4070 ] {262aedf8-180d-4e31-b291-47defd3fd5bc} <Error> executeQuery: Code: 243. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Failed to reserve 841211 bytes for temporary file: reason cannot evict enough space (stat: releasable size: 2022, releasable count: 9, non-releasable size: 429226495, non-releasable count: 458, evicting count: 0, invalidated count: 579, total size: 740893964/1073741824, total elements: 845/10000000, background download elements: 0), Ephemeral hold 409.34 MiB, can release 0.00 B; Regular hold 0.00 B, can release 1.97 KiB; (segment info: File segment: [0, 841210], key: 8829cca5b797980bcab37ea373ab4244, state: PARTIALLY_DOWNLOADED_NO_CONTINUATION, downloaded size: 0, reserved size: 0, downloader id: fde21f7c-5ed2-421e-8661-12e5e28b5155:323263, current write offset: 0, caller id: fde21f7c-5ed2-421e-8661-12e5e28b5155:323263, kind: Ephemeral, unbound: 1, background download: 1): While executing JoiningTransform. Stack trace:
2026-01-21 02:26:31
2026-01-21 02:26:31 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x00000000224a5af2
2026-01-21 02:26:31 1. ./ci/tmp/build/./src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000136c51a9
2026-01-21 02:26:31 2. ./src/Common/Exception.h:172: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000b22d8ce
2026-01-21 02:26:31 3. ./src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000b22d389
2026-01-21 02:26:31 4. ./src/Common/Exception.h:190: DB::Exception::Exception<unsigned long&, char const*, String&, String&, String>(int, FormatStringHelperImpl<std::type_identity<unsigned long&>::type, std::type_identity<char const*>::type, std::type_identity<String&>::type, std::type_identity<String&>::type, std::type_identity<String>::type>, unsigned long&, char const*&&, String&, String&, String&&) @ 0x0000000019c96644
2026-01-21 02:26:31 5. ./ci/tmp/build/./src/Interpreters/Cache/WriteBufferToFileSegment.cpp:93: DB::WriteBufferToFileSegment::nextImpl() @ 0x0000000019c959c9
2026-01-21 02:26:31 6. ./src/IO/WriteBuffer.h:54: DB::WriteBuffer::next() @ 0x000000000b244b9e
2026-01-21 02:26:31 7. ./src/IO/WriteBuffer.h:87: DB::WriteBuffer::write(char const*, unsigned long) @ 0x00000000137cbfd0
2026-01-21 02:26:31 8. ./ci/tmp/build/./src/Compression/CompressedWriteBuffer.cpp:60: DB::CompressedWriteBuffer::nextImpl() @ 0x000000001dd4c18d
2026-01-21 02:26:31 9. ./src/IO/WriteBuffer.h:54: DB::WriteBuffer::next() @ 0x000000000b244b9e
2026-01-21 02:26:31 10. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:404: DB::TemporaryDataBuffer::nextImpl() @ 0x0000000019ab0de3
2026-01-21 02:26:31 11. ./src/IO/WriteBuffer.h:54: DB::WriteBuffer::next() @ 0x000000000b244b9e
2026-01-21 02:26:31 12. ./src/IO/WriteBuffer.h:87: DB::WriteBuffer::write(char const*, unsigned long) @ 0x00000000137cbfd0
~~~~~ truncated 32 lines ~~~~~