-
Notifications
You must be signed in to change notification settings - Fork 8.3k
test_backup_outer_table is flaky #88566
Copy link
Copy link
Closed
Labels
flaky testflaky test found by CIflaky test found by CI
Description
Example failure from here
File: test_refreshable_mv/test.py:521 - in test_backup_outer_table
do_test_backup(True)
File: test_refreshable_mv/test.py:510 - in do_test_backup
assert node2.query(f"SELECT * FROM re.{target}") == "1\n"
File: helpers/cluster.py:4255 - in query
return self.client.query(
File: helpers/client.py:39 - in wrap
return func(self, *args, **kwargs)
File: helpers/client.py:79 - in query
).get_answer()
File: helpers/client.py:247 - in get_answer
raise QueryRuntimeException(
E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 25.10.1):
E Code: 60. DB::Exception: Received from 172.16.3.9:9000. DB::Exception: Table re.tgt (9ad6f6cb-aab2-4698-bf28-6d388d99ef7b) does not exist. Maybe you meant tgt?. Stack trace:
E
E 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x000000001e292972
E 1. ./ci/tmp/build/./src/Common/Exception.cpp:129: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000010065c5e
E 2. DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000924e50e
E 3. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000924e100
E 4. DB::Exception::Exception<String, String>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<String>::type>, String&&, String&&) @ 0x000000000924d6ab
E 5. ./ci/tmp/build/./src/Interpreters/DatabaseCatalog.cpp:397: DB::DatabaseCatalog::getTableImpl(DB::StorageID const&, std::shared_ptr<DB::Context const>, std::optional<DB::Exception>*) const @ 0x00000000159efdd4
E 6. ./ci/tmp/build/./src/Interpreters/DatabaseCatalog.cpp:1051: DB::DatabaseCatalog::getTable(DB::StorageID const&, std::shared_ptr<DB::Context const>) const @ 0x00000000159f7548
E 7. ./ci/tmp/build/./src/Storages/MaterializedView/RefreshTask.cpp:1079: DB::RefreshTask::getAndLockTargetTable(DB::StorageID const&, std::shared_ptr<DB::Context const> const&) @ 0x0000000019189014
E 8. ./ci/tmp/build/./src/Analyzer/Resolve/IdentifierResolver.cpp:187: DB::IdentifierResolver::tryResolveTableIdentifier(DB::Identifier const&, std::shared_ptr<DB::Context const> const&) @ 0x00000000152a5162
E 9. ./ci/tmp/build/./src/Analyzer/Resolve/IdentifierResolver.cpp:217: DB::IdentifierResolver::tryResolveTableIdentifierFromDatabaseCatalog(DB::Identifier const&, std::shared_ptr<DB::Context const> const&) @ 0x00000000152a5a92
E 10. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:1306: DB::QueryAnalyzer::tryResolveIdentifier(DB::IdentifierLookup const&, DB::IdentifierResolveScope&, DB::IdentifierResolveContext) @ 0x0000000014ff5fa9
E 11. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:3348: DB::QueryAnalyzer::initializeQueryJoinTreeNode(std::shared_ptr<DB::IQueryTreeNode>&, DB::IdentifierResolveScope&) @ 0x000000001500602f
E 12. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:4704: DB::QueryAnalyzer::resolveQuery(std::shared_ptr<DB::IQueryTreeNode> const&, DB::IdentifierResolveScope&) @ 0x0000000014fe4006
E 13. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalyzer.cpp:135: DB::QueryAnalyzer::resolve(std::shared_ptr<DB::IQueryTreeNode>&, std::shared_ptr<DB::IQueryTreeNode> const&, std::shared_ptr<DB::Context const>) @ 0x0000000014fe30fa
E 14. ./ci/tmp/build/./src/Analyzer/Resolve/QueryAnalysisPass.cpp:18: DB::QueryAnalysisPass::run(std::shared_ptr<DB::IQueryTreeNode>&, std::shared_ptr<DB::Context const>) @ 0x0000000014fe2696
E 15. ./ci/tmp/build/./src/Analyzer/QueryTreePassManager.cpp:192: DB::QueryTreePassManager::run(std::shared_ptr<DB::IQueryTreeNode>) @ 0x0000000015035636
E 16. ./ci/tmp/build/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:165: DB::buildQueryTreeAndRunPasses(std::shared_ptr<DB::IAST> const&, DB::SelectQueryOptions const&, std::shared_ptr<DB::Context const> const&, std::shared_ptr<DB::IStorage> const&) @ 0x0000000015b8795c
E 17. ./ci/tmp/build/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:182: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000015b85daa
E 18. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:634: std::__unique_if<DB::InterpreterSelectQueryAnalyzer>::__unique_single std::make_unique[abi:ne190107]<DB::InterpreterSelectQueryAnalyzer, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&) @ 0x0000000015b88c20
E 19. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x0000000015b0c7a9
E 20. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1534: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, std::unique_ptr<DB::ReadBuffer, std::default_delete<DB::ReadBuffer>>&, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>, std::function<void ()>) @ 0x0000000015ed8fbb
E 21. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1812: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000015ed4dd2
E 22. ./ci/tmp/build/./src/Server/TCPHandler.cpp:743: DB::TCPHandler::runImpl() @ 0x0000000019355379
E 23. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2754: DB::TCPHandler::run() @ 0x0000000019372456
E 24. ./ci/tmp/build/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x000000001e34db47
E 25. ./ci/tmp/build/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x000000001e34e0fe
E 26. ./ci/tmp/build/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x000000001e2ed2bf
E 27. ./base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001e2ea8cf
E 28. ? @ 0x0000000000094ac3
E 29. ? @ 0x0000000000126850
E . (UNKNOWN_TABLE)
E (query: SELECT * FROM re.tgt)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
flaky testflaky test found by CIflaky test found by CI