When I click on the "Latest Data" tab I receive the following error:
Error in query [SELECT DISTINCT i.*, ia.applicationid FROM items i,items_applications ia WHERE (ia.applicationid IN (236,237,238,239,240,241,242,243,244,245,246,247)) AND i.itemid=ia.itemid AND i.lastvalue IS NOT NULL AND (i.status=0 OR i.status=3) ORDER BY i.description ASC] [Incorrect key file for table '/tmp/#sql_3fdd_0.MYI'; try to repair it]
Configuration:
Fedora core 12
Zabbix 1.8 server
Mysql on same box
This error came up the first time yesterday. I restarted Apache, MYSQL and zabbix_server. It seemed to fix it.
Also at midnight zabbix quit recording data. It is still seeing the client agents as being monitored.
Please help.
Error in query [SELECT DISTINCT i.*, ia.applicationid FROM items i,items_applications ia WHERE (ia.applicationid IN (236,237,238,239,240,241,242,243,244,245,246,247)) AND i.itemid=ia.itemid AND i.lastvalue IS NOT NULL AND (i.status=0 OR i.status=3) ORDER BY i.description ASC] [Incorrect key file for table '/tmp/#sql_3fdd_0.MYI'; try to repair it]
Configuration:
Fedora core 12
Zabbix 1.8 server
Mysql on same box
This error came up the first time yesterday. I restarted Apache, MYSQL and zabbix_server. It seemed to fix it.
Also at midnight zabbix quit recording data. It is still seeing the client agents as being monitored.
Please help.