image-2024-11-29-15-11-27-907.png
|
Duplicate |
|||
| duplicates |
|
TimescaleDB: aggregated compressed co... | Closed |
[ZBX-25644] Trend data corrupted after upgrade to Postgres 17 + TimescaleDB 2.17 Created: 2024 Nov 29 Updated: 2025 Jan 22 Resolved: 2024 Dec 02 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F), Server (S) |
| Affects Version/s: | 7.0.6 |
| Fix Version/s: | None |
| Type: | Problem report | Priority: | Trivial |
| Reporter: | Karel Bělunek | Assignee: | Zabbix Development Team |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Rocky 9.5 |
||
| Attachments: |
image-2024-11-29-15-11-27-907.png
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
Steps to reproduce:
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) |
| Comments |
| Comment by Alexander Vladishev [ 2024 Dec 02 ] |
|
Closed as duplicate of |
