Corrupted database tables

[Nicarlo]

Cacti Version 0.8.7g
Cacti OS unix

Hi there,

My cacti install suffered from a power loss this weekend and in result it had corrupted a few databases.

Here are the tables that are corrupted.

Code: Select all

cacti.poller                                       OK
cacti.poller_command                               OK
cacti.poller_item
Error    : Incorrect information in file: './cacti/poller_item.frm'
error    : Corrupt
cacti.poller_output
Error    : Incorrect information in file: './cacti/poller_output.frm'
error    : Corrupt
cacti.poller_reindex
Error    : Incorrect information in file: './cacti/poller_reindex.frm'
error    : Corrupt
cacti.poller_time                                  OK

I tried running a

Code: Select all

repair table database use_frm;

and had no luck

Im thinking I will need to recreate these tables but first wanted to make sure that there isn't something else I should be considering before I do this.

Thanks!

[artagel]

You might want to try to rebuild the poller cache in the system utilities menu. It looks like it's just your poller tables.
-Dan

[Nicarlo]

I tried this and all i get is a blank table.

Also this is what im finding in the log file. Something in the DB seems to be missing. check the pastebin below

http://pastebin.com/qYYPXN0b

Thanks for your help

[artagel]

Open up mysql and double check that all the columns in the sql statement that is failing exists in the table. If not, re-add it. I've seen it before where certain columns get lost for one reason or another.
If all the columns are there, execute one of the sql statements in the log to see what the error is.
-Dan