Какая-то беда, zabbix показывает ошибку, открываешь мониторинг->обзор группа все, группа элементов все, сразу бросает:
но как видно это tmp таблица, прогон этого запроса вручную в ком строке или phpmyadmin спокойно возвращает результат, куда можно копнуть?
mysqli_query(): (HY000/126): Incorrect key file for table '/tmp/#sql1059e_ee01_3.MYI'; try to repair it [overview.php:86 → CView->render() → include() → getItemsDataOverview() → DBselect() → mysqli_query() in /usr/local/www/zabbix22/include/db.inc.php:406]
Error in query [SELECT DISTINCT h.hostid,h.name AS hostname,i.itemid,i.key_,i.value_type,i.units,i.na me,t.priority,i.valuemapid,t.value AS tr_value,t.triggerid FROM hosts h,items i LEFT JOIN functions f ON f.itemid=i.itemid LEFT JOIN triggers t ON t.triggerid=f.triggerid AND t.status=0 WHERE (h.hostid BETWEEN '10049' AND '10071' OR h.hostid BETWEEN '10073' AND '10083' OR h.hostid BETWEEN '10085' AND '10089' OR h.hostid BETWEEN '10102' AND '10110' OR h.hostid BETWEEN '10123' AND '10132' OR h.hostid BETWEEN '10145' AND '10149' OR h.hostid BETWEEN '10170' AND '10183' OR h.hostid BETWEEN '10225' AND '10229' OR h.hostid IN ('10017','10095','10098','10100','10112','10113',' 10114','10116','10118','10120','10135','10136','10 137','10138','10140','10142','10143','10151','1015 2','10157','10187','10191','10192','10193','10195' ,'10197','10198','10207','10208','10210','10212',' 10213','10217','10221','10222','10231','10236','10 237','10238','10239','10242','10244','10246','1024 9','10250')) AND h.status=0 AND h.hostid=i.hostid AND i.status=0 AND i.flags IN ('0','4')] [Incorrect key file for table '/tmp/#sql1059e_ee01_3.MYI'; try to repair it]
Error in query [SELECT DISTINCT h.hostid,h.name AS hostname,i.itemid,i.key_,i.value_type,i.units,i.na me,t.priority,i.valuemapid,t.value AS tr_value,t.triggerid FROM hosts h,items i LEFT JOIN functions f ON f.itemid=i.itemid LEFT JOIN triggers t ON t.triggerid=f.triggerid AND t.status=0 WHERE (h.hostid BETWEEN '10049' AND '10071' OR h.hostid BETWEEN '10073' AND '10083' OR h.hostid BETWEEN '10085' AND '10089' OR h.hostid BETWEEN '10102' AND '10110' OR h.hostid BETWEEN '10123' AND '10132' OR h.hostid BETWEEN '10145' AND '10149' OR h.hostid BETWEEN '10170' AND '10183' OR h.hostid BETWEEN '10225' AND '10229' OR h.hostid IN ('10017','10095','10098','10100','10112','10113',' 10114','10116','10118','10120','10135','10136','10 137','10138','10140','10142','10143','10151','1015 2','10157','10187','10191','10192','10193','10195' ,'10197','10198','10207','10208','10210','10212',' 10213','10217','10221','10222','10231','10236','10 237','10238','10239','10242','10244','10246','1024 9','10250')) AND h.status=0 AND h.hostid=i.hostid AND i.status=0 AND i.flags IN ('0','4')] [Incorrect key file for table '/tmp/#sql1059e_ee01_3.MYI'; try to repair it]
но как видно это tmp таблица, прогон этого запроса вручную в ком строке или phpmyadmin спокойно возвращает результат, куда можно копнуть?
Comment