|
Duplicate |
Team A
[ZBX-13696] Removal limit for sessions table Created: 2018 Apr 04 Updated: 2024 Apr 10 Resolved: 2018 Apr 11 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 3.4.7 |
| Fix Version/s: | 3.4.9rc1, 4.0.0alpha6, 4.0 (plan) |
| Type: | Incident report | Priority: | Trivial |
| Reporter: | Alexey Pustovalov | Assignee: | Andris Zeila |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | housekeeper, sessions | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| 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). |
| Comments |
| Comment by Andris Zeila [ 2018 Apr 05 ] |
|
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-13696 |
| Comment by Andris Mednis [ 2018 Apr 09 ] |
|
Successfully tested. |
| Comment by Andris Zeila [ 2018 Apr 09 ] |
|
Released in:
|