no more graphs: zabbix 1.6.5

[wpervaiz]

hey guys,

I've had my zabbix server running for around a year now... yesterday, the server mysteriously powered off during the night. In the monring, when i started it up again, none of my graphs will appear now. if i click on one of my pre-made graphs, i get no values, and the following message:

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:519]

Error in query [SELECT ht.clock FROM trends_uint ht WHERE ht.itemid=23443 ORDER BY ht.itemid, ht.clock limit 1] [Table './zabbix/trends_uint' is marked as crashed and last (automatic?) repair failed]

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:519]

any ideas what might be wrong?

[wpervaiz]

and here is what my logs are showing:

 2870:20101020:172559 [Z3005] Query failed: [144] Table './zabbix/history_uint' is marked as crashed and last (automatic?) repair failed [select sum(value) from history_uint where clock>1287609539 and itemid=22187]
  2867:20101020:172559 [Z3005] Query failed: [144] Table './zabbix/history' is marked as crashed and last (automatic?) repair failed [insert into history (clock,itemid,value) values (1287609959,18469,0.510000)]
  2867:20101020:172559 [Z3005] Query failed: [144] Table './zabbix/history_uint' is marked as crashed and last (automatic?) repair failed [insert into history_uint (clock,itemid,value) values (1287609959,18509,29670195200)]
  2867:20101020:172559 [Z3005] Query failed: [144] Table './zabbix/trends_uint' is marked as crashed and last (automatic?) repair failed [select num,value_min,value_avg,value_max from trends_uint where itemid=18509 and clock=1287608400]
  2867:20101020:172559 [Z3005] Query failed: [144] Table './zabbix/trends_uint' is marked as crashed and last (automatic?) repair failed [insert into trends_uint (clock,itemid,num,value_min,value_avg,value_max) values (1287608400,18509,1,29670195200,29670195200,29670195200)]

[MrKen]

It would seem that your database has crashed!

You need to try to repair it. Or, better still, replace it with your most recent backup. You do backup your database, don't you?

MrKen

[wpervaiz]

yes, i do... repairing the affected tables worked... going to see how this goes.

thanks!