Hi,
I am getting this errors always in the zabbix web.
Error in query [SELECT DISTINCT s.*,hg.hostid FROM scripts s,hosts_groups hg WHERE ((hg.groupid IN ('2','8') AND hg.groupid=s.groupid) OR (s.groupid IS NULL AND scriptid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY s.name] [Can't create/write to file '/tmp/#sql_70c1_0.MYI' (Errcode: 28)]
I made sure that i have enough space in my system. and /tmp is having 777 permission. Please advice.
I am getting this errors always in the zabbix web.
Error in query [SELECT DISTINCT s.*,hg.hostid FROM scripts s,hosts_groups hg WHERE ((hg.groupid IN ('2','8') AND hg.groupid=s.groupid) OR (s.groupid IS NULL AND scriptid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY s.name] [Can't create/write to file '/tmp/#sql_70c1_0.MYI' (Errcode: 28)]
I made sure that i have enough space in my system. and /tmp is having 777 permission. Please advice.