Skip to content

Flaky tests with SYSTEM SYNC REPLICA (02962_system_sync_replica_lightweight_from_modifier) #60480

@vitlibar

Description

@vitlibar

Test 02962_system_sync_replica_lightweight_from_modifier is sometimes failing, also in master

See failure:

2024-02-28 03:28:15 [3c9dec1b654b] 2024.02.28 02:28:11.724015 [ 55373 ] {dea8d0c3-a9e7-4817-bcb9-fcf95c3df2c9} <Error> InterpreterSystemQuery: SYNC REPLICA test_0mkeommx.test_table_10 (b4752209-5f64-44f7-8876-f0289a438f09): Timed out.
2024-02-28 03:28:15 [3c9dec1b654b] 2024.02.28 02:28:11.788185 [ 55373 ] {dea8d0c3-a9e7-4817-bcb9-fcf95c3df2c9} <Error> executeQuery: Code: 159. DB::Exception: SYNC REPLICA test_0mkeommx.test_table_10 (b4752209-5f64-44f7-8876-f0289a438f09): command timed out. See the 'receive_timeout' setting. (TIMEOUT_EXCEEDED) (version 24.2.1.1) (from [::1]:52138) (comment: 02962_system_sync_replica_lightweight_from_modifier.sh) (in query: SYSTEM SYNC REPLICA test_table_10 STRICT), Stack trace (when copying this message, always include the lines below):
2024-02-28 03:28:15 
2024-02-28 03:28:15 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001e88a903 in /usr/bin/clickhouse
2024-02-28 03:28:15 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f6499b4 in /usr/bin/clickhouse
2024-02-28 03:28:15 2. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x00000000075a0ad9 in /usr/bin/clickhouse
2024-02-28 03:28:15 3. ./build_docker/./src/Interpreters/InterpreterSystemQuery.cpp:0: DB::InterpreterSystemQuery::syncReplica(DB::ASTSystemQuery&) @ 0x00000000196b18be in /usr/bin/clickhouse
2024-02-28 03:28:15 4. ./build_docker/./src/Interpreters/InterpreterSystemQuery.cpp:651: DB::InterpreterSystemQuery::execute() @ 0x00000000196a5595 in /usr/bin/clickhouse
2024-02-28 03:28:15 5. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000019668fd6 in /usr/bin/clickhouse
2024-02-28 03:28:15 6. ./build_docker/./src/Interpreters/executeQuery.cpp:1309: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000019664478 in /usr/bin/clickhouse
2024-02-28 03:28:15 7. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x000000001ad615de in /usr/bin/clickhouse
2024-02-28 03:28:15 8. ./build_docker/./src/Server/TCPHandler.cpp:2315: DB::TCPHandler::run() @ 0x000000001ad80808 in /usr/bin/clickhouse
2024-02-28 03:28:15 9. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001e717e63 in /usr/bin/clickhouse
2024-02-28 03:28:15 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001e7186db in /usr/bin/clickhouse
2024-02-28 03:28:15 11. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001e919927 in /usr/bin/clickhouse
2024-02-28 03:28:15 12. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001e917bf0 in /usr/bin/clickhouse
2024-02-28 03:28:15 13. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001e9160aa in /usr/bin/clickhouse
2024-02-28 03:28:15 14. __tsan_thread_start_func @ 0x000000000750e98f in /usr/bin/clickhouse
2024-02-28 03:28:15 15. ? @ 0x00007f6a48ae9ac3
2024-02-28 03:28:15 16. ? @ 0x00007f6a48b7aa04
2024-02-28 03:28:15 
2024-02-28 03:28:15 Received exception from server (version 24.2.1):
2024-02-28 03:28:15 Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: SYNC REPLICA test_0mkeommx.test_table_10 (b4752209-5f64-44f7-8876-f0289a438f09): command timed out. See the 'receive_timeout' setting. (TIMEOUT_EXCEEDED)
2024-02-28 03:28:15 (query: SYSTEM SYNC REPLICA test_table_10 STRICT)

Other failures

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