Steps to reproduce:

1. Allow your database to grow (ours reached ~1.3TB)
2. Enable TimescaleDB native compression via Zabbix interface, Administration → Housekeeping → Enable compression
3. Wait until compression is applied (~10h)
4. Open any Graph or Graph (classic) for a time range older than 18 days

Result:

• pg_query(): Query failed: ERROR: aggregated compressed column not found DETAIL: Assertion 'value_column_description != NULL' failed. [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsData() → CHistoryManager->getGraphAggregationByWidth() → CHistoryManager->getGraphAggregationByWidthFromSql() → DBselect() → pg_query() in include/db.inc.php:206]
• Error in query [SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(845.0*(clock-1740839230)/2588400,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='569156' AND clock>='1740839230' AND clock<='1743427630' GROUP BY itemid,round(845.0*(clock-1740839230)/2588400,0)] [ERROR: aggregated compressed column not found DETAIL: Assertion 'value_column_description != NULL' failed.] [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsData() → CHistoryManager->getGraphAggregationByWidth() → CHistoryManager->getGraphAggregationByWidthFromSql() → DBselect() → trigger_error() in include/db.inc.php:207]
• pg_query(): Query failed: ERROR: aggregated compressed column not found DETAIL: Assertion 'value_column_description != NULL' failed. [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsData() → CHistoryManager->getGraphAggregationByWidth() → CHistoryManager->getGraphAggregationByWidthFromSql() → DBselect() → pg_query() in include/db.inc.php:206]
• Error in query [SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(845.0*(clock-1740839230)/2588400,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='60284' AND clock>='1740839230' AND clock<='1743427630' GROUP BY itemid,round(845.0*(clock-1740839230)/2588400,0)] [ERROR: aggregated compressed column not found DETAIL: Assertion 'value_column_description != NULL' failed.] [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsData() → CHistoryManager->getGraphAggregationByWidth() → CHistoryManager->getGraphAggregationByWidthFromSql() → DBselect() → trigger_error() in include/db.inc.php:207]

Expected:
Graphs should correctly show historical data using TimescaleDB compression