Item and Trigger pages not loading

[ben.bressler]

We have been running zabbix for a while and its been functioning fine. Today I logged into make some small changes but the Item and Trigger pages won't load for any hosts - page is displayed but nothing shows up (I've attached a screenshot to show what I mean). All the triggers still fire and alerts are sent out I just can't make any changes... I've tried rebooting the server but it didn't make any difference.

Also, when I go into Latest Data I see this error:
Error in query [SELECT DISTINCT i.*, ia.applicationid FROM items i,items_applications ia WHERE (ia.applicationid BETWEEN '1540' AND '1554' OR ia.applicationid IN ('1669','1670')) AND i.itemid=ia.itemid AND i.lastvalue IS NOT NULL AND (i.status=0 OR i.status=3) AND i.flags IN ('0','4')] [Incorrect key file for table '/tmp/#sql_130c_12.MYI'; try to repair it]


Running 2.0.9 on ubuntu.

[ingus.vilnis]

Hi,

Can you recall the possible changes you made that may have caused this?

The blank screen problem looks like PHP out of memory issue. Check webserver's error log. In that case bump up your PHP memory_limit. Search for posts here how to do it.

Regarding that SQL error - https://www.google.lv/search?q=incor...m=122&ie=UTF-8

2.0.9 is pretty old Zabbix already. You should consider upgrading.

Best Regards,
Ingus