-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
7.0.6
-
None
-
Debian v12.8, TimescaleDB v2.17.2, Postgresql v16.6, Zabbix 7.0.6.
Steps to reproduce:
- Go to graphs.
- Select "Last 30 Days".
- See the error on the screenshot.
Result:
- See screenshot.
- Log error:
2024-11-26 10:50:10.777 UTC [127989] zabbix@zabbix ERROR: aggregated compressed column not found 2024-11-26 10:50:10.777 UTC [127989] zabbix@zabbix DETAIL: Assertion 'value_column_description != NULL' failed. 2024-11-26 10:50:10.777 UTC [127989] zabbix@zabbix STATEMENT: SELECT itemid,COUNT(*) AS count,AVG(value) AS avg,MIN(value) AS min,MAX(value) AS max,round(1607.0*(clock-1731963600)/86399,0) AS i,MAX(clock) AS clock FROM history WHERE itemid='50441' AND clock>='1731963600' AND clock<='1732049999' GROUP BY itemid,round(1607.0*(clock-1731963600)/86399,0)
Additionally:
I found out that the problem is in TimescaleDB. I found an issue:
- https://github.com/timescale/timescaledb/issues/7410
- https://github.com/timescale/timescaledb/pull/7415#issuecomment-2500314015
The developers will fix the problem in TimescaleDB v2.18. But Zabbix v7.0.6 supports maximum TimescaleDB v2.17. Please increase the supported TimescaleDB version in the next version of Zabbix.
- is duplicated by
-
-
- Closed
-