-
Type:
Incident report
-
Resolution: Incomplete
-
Priority:
Major
-
None
-
Affects Version/s: None
-
Component/s: Proxy (P), Server (S)
hello
we have some problem in housekeeping process in my zabbix server .
my zabbix server version is 3.0.7 and worked with IBM_DB2 database.
my zabbix server housekeeping configuration is :
### Option: HousekeepingFrequency # How often Zabbix will perform housekeeping procedure (in hours). # Housekeeping is removing outdated information from the database. # To prevent Housekeeper from being overloaded, no more than 4 times HousekeepingFrequency # hours of outdated information are deleted in one housekeeping cycle, for each item. # To lower load on server startup housekeeping is postponed for 30 minutes after server start. # With HousekeepingFrequency=0 the housekeeper can be only executed using the runtime control option. # In this case the period of outdated information deleted in one housekeeping cycle is 4 times the # period since the last housekeeping cycle, but not less than 4 hours and not greater than 4 days. # # Mandatory: no # Range: 0-24 # Default: HousekeepingFrequency=3 ### Option: MaxHousekeeperDelete # The table "housekeeper" contains "tasks" for housekeeping procedure in the format: # [housekeeperid], [tablename], [field], [value]. # No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value]) # will be deleted per one task in one housekeeping cycle. # SQLite3 does not use this parameter, deletes all corresponding rows without a limit. # If set to 0 then no limit is used at all. In this case you must know what you are doing! # # Mandatory: no # Range: 0-1000000 # Default: MaxHousekeeperDelete=5000
in bellow you can see housekeeping log at debug level 2
1177650:20180228:123520.427 executing housekeeper 1177650:20180228:123520.633 housekeeper [deleted 0 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 0.192291 sec, idle for 3 hour(s)]