Details
-
Type:
Incident report
-
Status: Closed
-
Priority:
Trivial
-
Resolution: Fixed
-
Affects Version/s: 3.4.7
-
Fix Version/s: 3.4.9rc1, 4.0.0alpha6, 4.0 (plan)
-
Component/s: Server (S)
-
Labels:
-
Team:Team A
-
Sprint:Sprint 31
-
Story Points:0.25
Description
Currently Zabbix performs SQL query:
DBexecute("delete from sessions where lastaccess<%d", now - cfg.hk.sessions);
It does not have limit for rows to remove. In case of big table (for example, when housekeeper is not enabled for sessions, the query can take long time to remove records).