cacti.data_source_stats_hourly_cache note

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Moderators, Developers

Post Reply
Author
Message
koolzfire
Posts: 2
Joined: Mon Feb 11, 2019 12:57 pm

cacti.data_source_stats_hourly_cache note

#1 Post by koolzfire » Mon Feb 11, 2019 1:14 pm

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
:cry:

netniV
Cacti Guru User
Posts: 2691
Joined: Sun Aug 27, 2017 12:05 am

Re: cacti.data_source_stats_hourly_cache note

#2 Post by netniV » Tue Feb 12, 2019 5:17 am

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
Posts: 2
Joined: Mon Feb 11, 2019 12:57 pm

Re: cacti.data_source_stats_hourly_cache note

#3 Post by koolzfire » Wed Feb 13, 2019 10:15 am

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
Cacti Guru User
Posts: 2691
Joined: Sun Aug 27, 2017 12:05 am

Re: cacti.data_source_stats_hourly_cache note

#4 Post by netniV » Wed Feb 13, 2019 11:20 am

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

Post Reply