Sven Klemm

Still happening: https://github.com/timescale/timescaledb/runs/7552425996?check_suite_focus=true

Another one: https://github.com/timescale/timescaledb/runs/7816309184?check_suite_focus=true

Can you provide a minimal sql script to reproduce the issue in a new database? EXPLAIN output for the query would be helpful too.

There have been many bugfixes that could be a potential cause for this since this has been reported. Can you try on the latest version or provide a self-contained script...

So you cannot query any data older than 2 days?

Could you please provide a complete self-contained script to reproduce the issue. Your cagg definition references columns not part of your table definitions.

Hmm looks like the decompression is not working, can you post the EXPLAIN for the failing query?

your screenshot shows you are running explain (analyze) which does explain but also tries to execute the query. Does just running EXPLAIN without ANALYSE and BUFFERS work?

Do you still get the error if you disable bitmapscan? ``` set enable_bitmapscan to false; ```

I would consider it safe. It will prevent bitmap scans from being used but bitmap scans are not as common and ideally you only have sequential scan and index scan,...