Chucks cannot be dropped during housekeeper run with TimescaleDB

[caxton]

Recently built a new test Zabbix environment with 5.0 TLS using a PostgreSQL 12 DB and TimescaleDB. Each hour I am receiving the below messages in /var/log/zabbix/zabbix_server.log. This is my first time to use TimescaleDB and I'm not very database savvy so hoping this is something simple that missed.

Output from log:

1210:20210120:200040.984 executing housekeeper
1210:20210120:200041.010 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid hypertable or continuous aggregate
[SELECT drop_chunks(1603418440,'history')]
1210:20210120:200041.011 cannot drop chunks for history
1210:20210120:200041.011 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid hypertable or continuous aggregate
[SELECT drop_chunks(1603418440,'history_str')]
1210:20210120:200041.011 cannot drop chunks for history_str
1210:20210120:200041.012 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid hypertable or continuous aggregate
[SELECT drop_chunks(1603418440,'history_log')]
1210:20210120:200041.012 cannot drop chunks for history_log
1210:20210120:200041.012 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid hypertable or continuous aggregate
[SELECT drop_chunks(1603418440,'history_uint')]
1210:20210120:200041.012 cannot drop chunks for history_uint
1210:20210120:200041.013 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid hypertable or continuous aggregate
[SELECT drop_chunks(1603418440,'history_text')]
1210:20210120:200041.013 cannot drop chunks for history_text
1210:20210120:200041.013 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid hypertable or continuous aggregate
[SELECT drop_chunks(1579658440,'trends')]
1210:20210120:200041.013 cannot drop chunks for trends
1210:20210120:200041.014 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid hypertable or continuous aggregate
[SELECT drop_chunks(1579658440,'trends_uint')]
1210:20210120:200041.014 cannot drop chunks for trends_uint
1210:20210120:200041.020 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 0.010359 sec, idle for 1 hour(s)]

Thanks advance for any assistance.

[vhati]

Hi Caxton,

We have same issue, we using:

Zabbix 5.0.7
Postgres 12.5
Timescaledb 2.0

[itspief]

Hi, we have same issue. I've created problem in zabbix support:

https://support.zabbix.com/browse/ZBX-18902

[vhati]

Thanks itspief.
It's ok on dev and staging after applied workaround