Ad Widget

Collapse

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

Collapse
This topic has been answered.
X
X
 
  • Time
  • Show
Clear All
new posts
  • cfrancis
    Junior Member
    • Jun 2019
    • 17

    #1

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

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

    Click image for larger version  Name:	imagen.png Views:	1 Size:	19.6 KB ID:	508596
    Although there are graphs for the last 2 days

    Click image for larger version  Name:	imagen.png Views:	1 Size:	46.9 KB ID:	508597

    The date it stops recording is when it was updated.
    Last edited by cfrancis; 04-11-2025, 18:43.
  • Answer selected by cfrancis at 05-11-2025, 22:07.
    cfrancis
    Junior Member
    • Jun 2019
    • 17

    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.

    Comment

    • cfrancis
      Junior Member
      • Jun 2019
      • 17

      #2
      The date it stops recording is when it was updated.

      Comment

      • cfrancis
        Junior Member
        • Jun 2019
        • 17

        #3
        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.

        Comment

        • bsi010
          Junior Member
          • Jan 2024
          • 1

          #4
          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.

          Comment

          • Petr Sehnal
            Junior Member
            • Nov 2025
            • 3

            #5
            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.

            Code:
            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);
            ​

            Comment

            • chrisallennc
              Junior Member
              • Jul 2018
              • 2

              #6
              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.

              Comment

              • Petr Sehnal
                Junior Member
                • Nov 2025
                • 3

                #7
                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

                Comment

                Working...