Skip to content

failed to pause matview #1055

@yokofly

Description

@yokofly

Company or project name

No response

Describe what's wrong

create stream v(id int);

create random stream randv(id int);

create materialized view mv into v as select * from randv

SYSTEM PAUSE MATERIALIZED VIEW mv

Query id: 41a3affa-a782-40bc-89db-e39b0c53f0f8

0 rows in set. Elapsed: 10.021 sec.

Received exception from server (version 3.0.11):
Code: 159. DB::Exception: Received from localhost:8463. DB::Exception: Failed to PAUSE MATERIALIZED VIEW 'default.mv' error_message=Failed to pause materialized view default.mv. (TIMEOUT_EXCEEDED)

proton :)

Does it reproduce on the most recent release?

Yes

How to reproduce

2025.12.11 07:42:24.012936 [ 10 ] {41a3affa-a782-40bc-89db-e39b0c53f0f8} <Information> LocalFileSystemCheckpointStorage: Created directory '.mv-534739af-1992-4b08-906f-6c20fd459c13/1_01KC65RWRC09T9WBS9B851H0RV' on disk local_fs_ckpt_storage (/var/lib/proton/checkpoint/)
2025.12.11 07:42:24.012969 [ 10 ] {41a3affa-a782-40bc-89db-e39b0c53f0f8} <Information> CheckpointCoordinator: Triggered checkpointing state for query=.mv-534739af-1992-4b08-906f-6c20fd459c13 epoch=1_01KC65RWRC09T9WBS9B851H0RV
2025.12.11 07:42:24.178608 [ 219 ] {} <Information> default.v.0: Committed sn=801 to local file system
2025.12.11 07:42:26.189008 [ 219 ] {} <Information> default.v.0: Committed sn=1201 to local file system
2025.12.11 07:42:27.217250 [ 35 ] {} <Warning> CheckpointCoordinator: Failed to trigger checkpointing state for query=.mv-534739af-1992-4b08-906f-6c20fd459c13 epoch=1_01KC65RWRC09T9WBS9B851H0RV, since prev checkpoint is still in-progress, nodes_to_ack={1001-StreamSink()}
2025.12.11 07:42:28.198550 [ 219 ] {} <Information> default.v.0: Committed sn=1603 to local file system
2025.12.11 07:42:30.201323 [ 219 ] {} <Information> default.v.0: Committed sn=2005 to local file system
2025.12.11 07:42:32.214021 [ 219 ] {} <Information> default.v.0: Committed sn=2407 to local file system
2025.12.11 07:42:32.217232 [ 35 ] {} <Warning> CheckpointCoordinator: Failed to trigger checkpointing state for query=.mv-534739af-1992-4b08-906f-6c20fd459c13 epoch=1_01KC65RWRC09T9WBS9B851H0RV, since prev checkpoint is still in-progress, nodes_to_ack={1001-StreamSink()}
2025.12.11 07:42:33.399008 [ 188 ] {} <Information> system.introspection_state_log.0: Committed sn=7 to local file system
2025.12.11 07:42:33.400767 [ 190 ] {} <Information> system.stream_metric_log.0: Committed sn=6 to local file system
2025.12.11 07:42:34.031873 [ 10 ] {41a3affa-a782-40bc-89db-e39b0c53f0f8} <Error> executeQuery: Code: 159. DB::Exception: Failed to PAUSE MATERIALIZED VIEW 'default.mv'  error_message=Failed to pause materialized view default.mv. (TIMEOUT_EXCEEDED) (version 3.0.11) (from 127.0.0.1:44788) (in query: system pause materialized view mv)
2025.12.11 07:42:34.032276 [ 10 ] {41a3affa-a782-40bc-89db-e39b0c53f0f8} <Error> TCPHandler: Code: 159. DB::Exception: Failed to PAUSE MATERIALIZED VIEW 'default.mv'  error_message=Failed to pause materialized view default.mv. (TIMEOUT_EXCEEDED), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000de15915 in /usr/bin/proton
1. DB::Exception::Exception<std::__1::basic_string_view<char, std::__1::char_traits<char>>&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&, char const*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&>(int, FormatStringHelperImpl<std::__1::type_identity<std::__1::basic_string_view<char, std::__1::char_traits<char>>&>::type, std::__1::type_identity<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&>::type, std::__1::type_identity<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&>::type, std::__1::type_identity<char const*>::type, std::__1::type_identity<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&>::type>, std::__1::basic_string_view<char, std::__1::char_traits<char>>&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&, char const*&&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>&) @ 0x0000000013e749f4 in /usr/bin/proton
2. DB::InterpreterSystemQuery::executeMaterializedViewAdmission(DB::ASTSystemQuery const&) @ 0x0000000013e7371e in /usr/bin/proton
3. DB::InterpreterSystemQuery::execute() @ 0x0000000013e63989 in /usr/bin/proton
4. DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000013e495db in /usr/bin/proton
5. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>> const&, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000013e44b33 in /usr/bin/proton
6. DB::TCPHandler::runImpl() @ 0x000000001474663c in /usr/bin/proton
7. DB::TCPHandler::run() @ 0x000000001475b6b9 in /usr/bin/proton
8. Poco::Net::TCPServerConnection::start() @ 0x000000001c402787 in /usr/bin/proton
9. Poco::Net::TCPServerDispatcher::run() @ 0x000000001c402c91 in /usr/bin/proton
10. Poco::PooledThread::run() @ 0x000000001ce81d67 in /usr/bin/proton
11. Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001ce7f7fd in /usr/bin/proton
12. ? @ 0x000074e3a0de2ac3 in ?
13. __clone @ 0x000074e3a0e73a74 in ?

2025.12.11 07:42:34.224023 [ 219 ] {} <Information> default.v.0: Committed sn=2808 to local file system
2025.12.11 07:42:36.234015 [ 219 ] {} <Information> default.v.0: Committed sn=3210 to local file system
2025.12.11 07:42:37.217090 [ 35 ] {} <Warning> CheckpointCoordinator: Failed to trigger checkpointing state for query=.mv-534739af-1992-4b08-906f-6c20fd459c13 epoch=1_01KC65RWRC09T9WBS9B851H0RV, since prev checkpoint is still in-progress, nodes_to_ack={1001-StreamSink()}
2025.12.11 07:42:38.244233 [ 219 ] {} <Information> default.v.0: Committed sn=3612 to local file system
2025.12.11 07:42:40.254596 [ 219 ] {} <Information> default.v.0: Committed sn=4014 to local file system
2025.12.11 07:42:42.217215 [ 35 ] {} <Warning> CheckpointCoordinator: Failed to trigger checkpointing state for query=.mv-534739af-1992-4b08-906f-6c20fd459c13 epoch=1_01KC65RWRC09T9WBS9B851H0RV, since prev checkpoint is still in-progress, nodes_to_ack={1001-StreamSink()}

Expected behavior

No response

Error message and/or stacktrace

No response

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions