-
Notifications
You must be signed in to change notification settings - Fork 848
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Bug]: Continuous aggregates with time_bucket hourly and timezone fail to update #6902
Comments
Thanks for the script, it reproduces for me. The error is related to the NULL value of the @fabriziomello should the end point calculation follow the same logic as |
Hi @akuzm thank you for the reply. I believe in the However I believe we should add a warning or enhance the code related to handling cases with NULL as we had lots of issue with it from back in time |
What type of bug is this?
Incorrect result, Unexpected error
What subsystems and features are affected?
Continuous aggregate
What happened?
I have a number of Continuous aggregates that uses hourly buckets
I noticed that i stopped seeing the new results after recreating the hypertable. After hours of debugging i pinned down that the hourly buckets dont refresh when used with timezone
TimescaleDB version affected
2.14.2 and 2.15.0
PostgreSQL version used
15.6
What operating system did you use?
Arch Linux and Ubuntu Linux
What installation method did you use?
Deb/Apt
What platform did you run on?
On prem/Self-hosted
Relevant log output and stack trace
How can we reproduce the bug?
The text was updated successfully, but these errors were encountered: