Cancelando envio de alertas… no Zabbix

Um belo dia meu servidor Zabbix perdeu conexao com a internet e minha fila de alertas(70mil) ficou causando lentidão no servidor. Descobri pelos forums como resolver..

Logue no mysql do seu servidor Zabbix e faça o seguinte comando:

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> use zabbix;
Database changed
mysql> update alerts set status=2,error='' where status=0 and alerttype=0;
Query OK, 28314 rows affected (1.21 sec)
Rows matched: 28314 Changed: 28314 Warnings: 0
mysql> delete from escalations;
Query OK, 12 rows affected (0.00 sec)
mysql> quit
Bye

Desse jeito ele irá cancelar todos os alertas da fila… ;-))

Espero que seja útil…

Vida longa ao Zabbix

[‘]sss

Leave a Reply