To reproduce

Minimal reproducer:

create table x (ts timestamp) timestamp(ts) partition by day;
insert into x values('2000-01-01T12:00'),('2010-01-01T12:00'),('2020-01-01T12:00');
create materialized view x_1y as select ts, first(ts) as first_ts from x sample by 10y;

The view gets marked as invalid after the initial refresh with the timestamp out of replace range reason.

QuestDB version:

9.1

OS, in case of Docker specify Docker and the Host OS:

Ubuntu 24.04

File System, in case of Docker specify Host File System:

ext4

Full Name:

Andrei Pechkurov

Affiliation:

QuestDB

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response