Ad Widget

Collapse

housekeeper not deleting

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • christianlll
    Junior Member
    • May 2018
    • 8

    #1

    housekeeper not deleting

    Hi all. housekeeper stopped working properly in zabbix 3.2

    Im running it with /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf -R housekeeper_execute once a day in crontab.

    On logs it says "housekeeping procedure is already in progress" and nothing else. DB (innodb) is growing about 4Gb per day and need to get it work again.

    Also I've tried running sql script. It deleted some stuff but /var/lib/mysql didn't shrink

    SET @history_interval = 7;
    SET @trends_interval = 90;

    DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM acknowledges WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM events WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM history WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM history_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM history_str WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM history_text WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM history_log WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
    DELETE FROM trends WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
    DELETE FROM trends_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);

    Any tip would be appreciated. Txs.
    Last edited by christianlll; 17-07-2018, 18:33.
Working...