WAL event file is too small error when refreshing materialized view with a very large SAMPLE BY interval #6040
Description
To reproduce
The DDLs are same as in #6029 with the only change in SAMPLE BY 1000y instead of SAMPLE BY 2y. After the mat view refresh, WAL apply job fails with a critical level message:
WAL event file is too small, size=436, required=734064817
2025-08-08T14:11:45.107816Z C i.q.c.w.ApplyWal2TableJob job failed, table suspended [table=Samples_latest~61, error=
io.questdb.cairo.CairoException: [0] WAL event file is too small, size=436, required=1321933545
]
QuestDB version:
9.0.1
OS, in case of Docker specify Docker and the Host OS:
Ubuntu
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