Today my server crashed due to eletricity loss. Mysql tables were corrupted. Zabbix server seemd to work but there was no data in history.
I looked to lok and see
Query::insert into history (clock,itemid,value) values (1103664066,23368,0.000000)
Query failed:Incorrect key file for table: 'history'. Try to repair it [1034]
I have script which checks if zabbix server is runing. But there is no chance to know if it writes to history
Maybe zabbix server should die in this situatuon ? And I know there is problem and repair tables.
I looked to lok and see
Query::insert into history (clock,itemid,value) values (1103664066,23368,0.000000)
Query failed:Incorrect key file for table: 'history'. Try to repair it [1034]
I have script which checks if zabbix server is runing. But there is no chance to know if it writes to history
Maybe zabbix server should die in this situatuon ? And I know there is problem and repair tables.