After updating to Zabbix 7.4.4, they stopped saving graphs older than 7 days.

[cfrancis]

Since the update from 7.4.3 to 7.4.4, they stopped saving graphs older than 7 days.


Although there are graphs for the last 2 days



The date it stops recording is when it was updated.

[cfrancis]

I found the problem. Even though the cleanup wasn't enabled, "Specify historical metrics period" was selected. This seems to have caused a problem with the update. I enabled and removed all the selected options and then disabled them. From then on, it started generating 7-day charts.

Regards.

[cfrancis]

The date it stops recording is when it was updated.

[cfrancis]

I found the problem. Even though the cleanup wasn't enabled, "Specify historical metrics period" was selected. This seems to have caused a problem with the update. I enabled and removed all the selected options and then disabled them. From then on, it started generating 7-day charts.

Regards.

[bsi010]

It's still a problem... Graph is only showing History and not Trends.
If you select "Auto" in "Displaying options" the graph will be empty, if you have selected "Last 2 days" or "Last 7 days".
If you select Last 30 days, it will show "Trends" data from before you upgraded to version 7.4.5.

[Petr Sehnal]

Just to add more details on this, as it took us quite a while to investigate what the problem was. This impacts both 7.4.4 and 7.4.5. Version 7.4.3 is not impacted, and this setting has no effect there.

After upgrading, the trend data tables (trends + trends_uint) will not be updated if the following conditions are met:
- In Admin → Housekeeping → Trends, "Enable internal housekeeping" is unchecked (typically when you use partitioning and your own SQL housekeeping)
- In Admin → Housekeeping → Trends, "Override item trend period" is checked (you probably forgot it there, because with the above setting you may think it is not relevant)
- The Zabbix server is restarted (which always happens after an upgrade)

If all of the above conditions are met, Zabbix will not start writing data to the trend tables. As a result, graphs with a 10+ day time span show no data, because Zabbix uses trend tables for longer time spans and history tables for shorter ones.

I would not call this a bug, but it is a somewhat unexpected change in behavior.

You can check it with the following SQL query. Data is typically written there backward, for the last fully completed hour (-1, so at 08:44 there will be data for 07:00). When the Zabbix service restarts, it flushes the calculated data there even if the full hour is not over, so at 08:44 you can already see 08:00. If you simulate the issue described above and wait for two hours, no new data will be added.

SELECT
    'trends' AS table_name,
    COUNT(*) AS recent_rows_1days,
    MAX(clock) AS last_clock,
    FROM_UNIXTIME(MAX(clock)) AS last_time
FROM trends
WHERE clock > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)
UNION ALL
SELECT
    'trends_uint' AS table_name,
    COUNT(*) AS recent_rows_1days,
    MAX(clock) AS last_clock,
    FROM_UNIXTIME(MAX(clock)) AS last_time
FROM trends_uint
WHERE clock > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY);
​

[chrisallennc]

We started experiencing the same issue with 7.4.4 and 7.4.5. We use partitioning to purge data, unchecking "Override item history period" and "Override item trend period" and restarting the server process resolved the issue.

[Petr Sehnal]

It's a confirmed bug now, should be fixed in 7.4.6. https://support.zabbix.com/browse/ZBX-27229
When housekeeping for trends is disabled, - In Admin → Housekeeping → Trends, "Override item trend period" needs to be unchecked as well with 7.4.4 and 7.4.5 as a workaround