-
Problem report
-
Resolution: Duplicate
-
Trivial
-
None
-
7.0.6
-
None
-
Rocky 9.5
Before upgrade: Zabbix 6.0.36, Postgres 16, Timescale 2.14.2
After upgrade: Zabbix 7.0.5, Portgress 16, Timescale 2.17
Steps to reproduce:
- I was doing upgrade server 6.0.36 -> 7.0.6, postgres 16 -> 17, timescale 2.14.1 -> 2.17.2 . The zabbix server and DB are separate VMs
- The upgrade process qoes without any errors, the upgraded Zabbix server started without anything suspicious in log
- When I tried to display in GUI graph that utilizes Trend data (e.g. "This year so far"), some of graphs does not diplay with error message (see screenshot), postgresql log displays error messages (below))
- I revoked DB server to checkpoint before upgrade (back to postgres 16, timescale 2.14.1), started the Zabbis server that perfromt DB upggrade, re-appply timescale SQL -> and now everything works OK
Screenshot
The postgres log file contains these lines:
2024-11-29 14:56:59.876 CET [180137] ERROR: aggregated compressed column not found 2024-11-29 14:56:59.876 CET [180137] DETAIL: Assertion 'value_column_description != NULL' failed. 2024-11-29 14:56:59.876 CET [180137] STATEMENT: SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(2232.0*(clock-1704063600)/28825019,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='44344' AND clock>='1704063600' AND clock<='1732888619' GROUP BY itemid,round(2232.0*(clock-1704063600)/28825019,0) 2024-11-29 14:56:59.936 CET [180140] ERROR: aggregated compressed column not found 2024-11-29 14:56:59.936 CET [180140] DETAIL: Assertion 'value_column_description != NULL' failed. 2024-11-29 14:56:59.936 CET [180140] STATEMENT: SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(2232.0*(clock-1704063600)/28825019,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='44337' AND clock>='1704063600' AND clock<='1732888619' GROUP BY itemid,round(2232.0*(clock-1704063600)/28825019,0) 2024-11-29 14:57:00.728 CET [180147] ERROR: aggregated compressed column not found 2024-11-29 14:57:00.728 CET [180147] DETAIL: Assertion 'value_column_description != NULL' failed. 2024-11-29 14:57:00.728 CET [180147] STATEMENT: SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(2232.0*(clock-1704063600)/28825020,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='44344' AND clock>='1704063600' AND clock<='1732888620' GROUP BY itemid,round(2232.0*(clock-1704063600)/28825020,0) 2024-11-29 14:57:00.765 CET [180145] ERROR: aggregated compressed column not found 2024-11-29 14:57:00.765 CET [180145] DETAIL: Assertion 'value_column_description != NULL' failed. 2024-11-29 14:57:00.765 CET [180145] STATEMENT: SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(2232.0*(clock-1704063600)/28825020,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='44337' AND clock>='1704063600' AND clock<='1732888620' GROUP BY itemid,round(2232.0*(clock-1704063600)/28825020,0) 2024-11-29 14:57:01.006 CET [180150] ERROR: aggregated compressed column not found 2024-11-29 14:57:01.006 CET [180150] DETAIL: Assertion 'value_column_description != NULL' failed. 2024-11-29 14:57:01.006 CET [180150] STATEMENT: SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(2232.0*(clock-1704063600)/28825020,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='29163' AND clock>='1704063600' AND clock<='1732888620' GROUP BY itemid,round(2232.0*(clock-1704063600)/28825020,0) 2024-11-29 14:57:01.009 CET [180150] ERROR: aggregated compressed column not found 2024-11-29 14:57:01.009 CET [180150] DETAIL: Assertion 'value_column_description != NULL' failed. 2024-11-29 14:57:01.009 CET [180150] STATEMENT: SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(2232.0*(clock-1704063600)/28825020,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='29176' AND clock>='1704063600' AND clock<='1732888620' GROUP BY itemid,round(2232.0*(clock-1704063600)/28825020,0)
- duplicates
-
-
- Closed
-