ClickHouse / ClickHouse/ClickHouse

Refreshable Materialized Views autostart after server restart

Open
#81,840 0 comments 0 reactions 0 assignees View on GitHub
comp-refreshable-materialized-view external unexpected behaviour
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

### Company or project name

_No response_

### Describe the unexpected behaviour

RMV are refreshed immediately after server restarts, instead of just being scheduled at a proper time.
That makes impossible to use RMVs with APPEND on a basic MergeTree engine as the RMVs that are scheduled to run daily start to produce duplicates if there was a server restart during the day.

### Which ClickHouse versions are affected?

25.03 LTS

### How to reproduce

Example: RMV is scheduled to run at 00:05. At 00:00 the server is restarted and RMV is immediately run. Then it runs again at 00:05.

### Expected behavior

RMV is not refreshed immediately after restart - just scheduled to run normally at 00:05.

### Error message and/or stacktrace

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.