-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
4.4.4
-
None
-
Zabbix Appliance Ubuntu 16.04.4 LTS
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?