Query::update items set nextcheck=1161071842,lastclock=1161071825 where itemid=17242

[rootlinux]

I got the message below in my zabbix log file. How can I solve it? I have no idea.


006495:20061017:155705 Query::update items set nextcheck=1161071842,lastclock=1161071825 where itemid=17242
006495:20061017:155705 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]
006495:20061017:155705 Query::update items set nextcheck=1161071845,lastclock=1161071825 where itemid=17245
006495:20061017:155705 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]
006495:20061017:155705 Query::update items set nextcheck=1161071848,lastclock=1161071825 where itemid=17248
006495:20061017:155705 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]
006495:20061017:155705 Query::update items set nextcheck=1161071851,lastclock=1161071825 where itemid=17251
006495:20061017:155705 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]
006495:20061017:155705 Query::update items set nextcheck=1161071854,lastclock=1161071825 where itemid=17254
006495:20061017:155705 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]
006495:20061017:155708 Query::update items set nextcheck=1161071857,lastclock=1161071828 where itemid=17257
006495:20061017:155708 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]
006495:20061017:155708 Query::update items set nextcheck=1161071860,lastclock=1161071828 where itemid=17260
006495:20061017:155708 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]
006495:20061017:155708 Query::update items set nextcheck=1161071863,lastclock=1161071828 where itemid=17263
006495:20061017:155708 Query failed:Incorrect key file for table: 'items'. Try to repair it [1034]

[Alexei]

Your database is corrupted. Try to repair it.

http://dev.mysql.com/doc/refman/5.0/en/repair.html

[rootlinux]

Thank you,

[rootlinux]

I run this command myisamchk -r *.MYI in /var/lib/mysql/zabbix

But now I can't start zabbix. Got this message below: -

016682:20061017:174339 Starting zabbix_server. ZABBIX 1.1.2.
016682:20061017:174339 Query::select distinct t.triggerid,t.value 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<1161078219 and i.key_<>'status' and h.status not in (4,3)
016682:20061017:174339 Query failed:Got error 127 from table handler [1030]