Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17229

Zabbix not cleaning old hist and hist_uint data

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Won't fix
    • Affects Version/s: 4.4.4
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Zabbix Appliance Ubuntu 16.04.4 LTS

      Description

      Housekeeper is working properly and is deleting data according to default settings.

      We have set history period to 365 days.

      As we look deeper into history and history_uint tables we see that there are some leftovers older thatn a year.

      mysql> select min(clock), itemid from history_uint GROUP BY itemid ORDER BY min(clock) ASC LIMIT 5;
      +------------+--------+
      | min(clock) | itemid |
      +------------+--------+
      | 1532417237 | 205997 |
      | 1546338322 | 208822 |
      | 1548099088 | 209128 |
      | 1551173401 |  42360 |
      | 1551173401 |  42780 |
      +------------+--------+
      5 rows in set (1.35 sec)
      
      mysql> select itemid, value_type from items where itemid=205997;
      Empty set (0.00 sec)
      
      mysql> select itemid, value_type from items where itemid=208822;
      Empty set (0.00 sec)
      
      mysql> select itemid, value_type from items where itemid=209128;
      Empty set (0.00 sec)
      
      mysql> select itemid, value_type from items where itemid=42360;
      +--------+------------+
      | itemid | value_type |
      +--------+------------+
      |  42360 |          3 |
      +--------+------------+
      1 row in set (0.00 sec)
      

      we can see 3 items not being cleared (older than a year) but there is no additional info in items table (epmty).

      The same thing is with history table, but there is about 20 or more items like that.

       

      Should this be cleard manually?

        Attachments

          Activity

            People

            Assignee:
            igorbach Igor Gorbach
            Reporter:
            dawy123 Dan Wys
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: