Skip to content

Flaky test: test_max_temporary_data_size_on_disk/test.py::test #93911

@pamarcos

Description

@pamarcos

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: test_max_temporary_data_size_on_disk/test.py::test
Failure reason: DB::Exception: Limit for temporary files size exceeded (would consume 10501 / 10240 bytes)
CI report: Integration tests (amd_asan, db disk, old analyzer, 6/6)

Failing test history: cidb

Test output:

File: test_max_temporary_data_size_on_disk/test.py:31 - in test
    node.query("SELECT k1, k2, k3, sum(value) v FROM t_proj_external GROUP BY k1, k2, k3 ORDER BY k1, k2, k3 SETTINGS optimize_aggregation_in_order = 0, max_bytes_before_external_group_by = 1, max_bytes_ratio_before_external_group_by = 0, group_by_two_level_threshold = 1")
File: helpers/cluster.py:4479 - in query
    return self.client.query(
File: helpers/client.py:40 - in wrap
    return func(self, *args, **kwargs)
File: helpers/client.py:80 - in query
    ).get_answer()
File: helpers/client.py:269 - in get_answer
    raise QueryRuntimeException(
E   helpers.client.QueryRuntimeException: Client failed! Return code: 140, stderr: Received exception from server (version 26.1.1):
E   Code: 396. DB::Exception: Received from 172.16.1.6:9000. DB::Exception: Limit for temporary files size exceeded (would consume 10501 / 10240 bytes). Stack trace:
E   
E   0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x000000004e2542f1
E   1. ./ci/tmp/build/./src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000024e92d34
E   2. ./src/Common/Exception.h:172: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000eabedf7
E   3. ./src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000eabdf2b
E   4. ./src/Common/Exception.h:190: DB::Exception::Exception<unsigned long&, unsigned long const&>(int, FormatStringHelperImpl<std::type_identity<unsigned long&>::type, std::type_identity<unsigned long const&>::type>, unsigned long&, unsigned long const&) @ 0x0000000020f3e53e
E   5. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:531: DB::TemporaryDataOnDiskScope::deltaAllocAndCheck(long, long) @ 0x00000000362905ec
E   6. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:520: DB::TemporaryDataOnDiskScope::deltaAllocAndCheck(long, long) @ 0x000000003629038c
E   7. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:520: DB::TemporaryDataOnDiskScope::deltaAllocAndCheck(long, long) @ 0x000000003629038c
E   8. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:520: DB::TemporaryDataOnDiskScope::deltaAllocAndCheck(long, long) @ 0x000000003629038c
E   9. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:520: DB::TemporaryDataOnDiskScope::deltaAllocAndCheck(long, long) @ 0x000000003629038c
E   10. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:496: DB::TemporaryDataBuffer::updateAllocAndCheck() @ 0x000000003628f266
E   11. ./src/IO/WriteBuffer.h:53: DB::WriteBuffer::next() @ 0x000000000eaf642c
E   12. ./ci/tmp/build/./src/Interpreters/TemporaryDataOnDisk.cpp:552: DB::TemporaryBlockStreamHolder::finishWriting() const @ 0x00000000362911dc
E   13. ./ci/tmp/build/./src/Interpreters/Aggregator.cpp:1888: DB::Aggregator::writeToTemporaryFile(DB::AggregatedDataVariants&, unsigned long) const @ 0x0000000034613168
E   14. ./ci/tmp/build/./src/Processors/Transforms/AggregatingTransform.cpp:941: DB::AggregatingTransform::initGenerate() @ 0x000000004047917f
E   15. ./ci/tmp/build/./src/Processors/Transforms/AggregatingTransform.cpp:860: DB::AggregatingTransform::work() @ 0x00000000404780c3
E   16. ./ci/tmp/build/./src/Processors/Executors/ExecutionThreadContext.cpp:53: DB::ExecutionThreadContext::executeTask() @ 0x000000003fe1a1b4
E   17. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:351: DB::PipelineExecutor::executeStepImpl(unsigned long, DB::IAcquiredSlot*, std::atomic<bool>*) @ 0x000000003fdf99de
E   18. ./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*) @ 0x000000003fdfc9c4
E   19. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x00000000251c7de8
E   20. ./src/Common/ThreadPool.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()() @ 0x00000000251d61e3
E   21. ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ? @ 0x00000000251c1fab
E   22. ./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*) @ 0x00000000251d0f90
E   23. asan_thread_start(void*) @ 0x000000000ea64dd7
E   24. ? @ 0x0000000000094ac3
E   25. ? @ 0x00000000001268c0
E   . (TOO_MANY_ROWS_OR_BYTES)
E   (query: SELECT k1, k2, k3, sum(value) v FROM t_proj_external GROUP BY k1, k2, k3 ORDER BY k1, k2, k3 SETTINGS optimize_aggregation_in_order = 0, max_bytes_before_external_group_by = 1, max_bytes_ratio_before_external_group_by = 0, group_by_two_level_threshold = 1)

Metadata

Metadata

Assignees

Labels

flaky testflaky test found by CItestingSpecial issue with list of bugs found by CI

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions