cacti.data_source_stats_hourly_cache note

[koolzfire]

Dear All
I am new to this forums kindly help me i am dire need of help i am using cacti 8.8a i am running my system smoothly but today after power breakdown i am having trouble i can view live graphs but unable to see any other graphs
when i run this mysqlcheck --repair cacti -u root -p command
i get this message with these four tables

cacti.data_source_stats_hourly_cache
note : The storage engine for the table doesn't support repair
cacti.data_source_stats_hourly_last
note : The storage engine for the table doesn't support repair
cacti.plugin_flowview_dnscache
note : The storage engine for the table doesn't support repair
cacti.plugin_hmib_processes
note : The storage engine for the table doesn't support repair


Kindly help me in this regards i will be very grateful to you

[netniV]

The message is really a MySQL issue, though the error that you are seeing is because of the InnoDB engine that is used for most of the tables does not need to repair it's tables because it uses the ACID compliant transactions with referential integrity. MyISAM on the other hand does need to be repaired so would not show the above errors when there are tables using that format.

[koolzfire]

Thanks netniV i figure that out and it is not more error message in my cacti but i am stuck in another problem that is real graph plugin showing graphs but no other are not and when i gave this rrdtool fetch <rrd file> AVERAGE it will show nan to every entry. When i use this

cd /var/www/html/rra

ls -l it shows root:root:filename.rrd
i am unable to change its ownership to cacti or apachi user
what is the exact issue how can i get my graph back without losing my historical data
Is there any way out?

[netniV]

You must use root to change the ownership/permissions of both files and the folders that they are held in.