-
Type:
Problem report
-
Resolution: Workaround proposed
-
Priority:
Trivial
-
None
-
Affects Version/s: 7.0.6
-
Component/s: Frontend (F)
-
None
-
Environment:Debian v12.8, TimescaleDB v2.17.2, Postgresql v16.6, Zabbix 7.0.6.
-
S25-W14/15
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.
- duplicates
-
-
- Closed
-
- is duplicated by
-
-
- Closed
-
-
ZBX-26250 Enabling TimescaleDB compression causes graphs to fail for data older than 18 days with pg_query() error: "aggregated compressed column not found"
-
- Closed
-
- mentioned in
-
Page Loading...