suckerd dying when start

[JiriK]

Hi,

whenever I try to start suckerd from /opt/zabbix/bin/, I get entries similar to the following in my zabbix_suckerd.log file, then zabbix_suckerd dies:


002892:20050719:102656 Starting zabbix_suckerd...
002892:20050719:102656 Query::select distinct t.triggerid from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1121761616 and i.key_<>'status' and h.status not in (4,3)
002892:20050719:102656 Query failed:Can't open file: 'functions.MYI'. (errno: 145) [1016]


I have ZABBIX v1.0, Suse 9.2. All was ok last month, until I restartd server.

any ideas or suggestions?

Thanks!

[Alexei]

This is MySQL error message. It seems that table FUNCTIONS is corrupted. Try &quot;repair table functions&quot; and possibly other tables.