Skip to content

test_backup_outer_table is flaky #88566

@Ergus

Description

@Ergus

Test case history:

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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions