All my graphs disappeared

[efe_rhl]

I have a worrisome issue heer and would be glad to get the help of evryone in this forum.
All the graphs on my Cacti just disappeared although the rrd files are still there.If someone deleted all the graphs which I don't think,is it possble for the graph to be recovered since all the rrd files are still there?

I am running Cacti version 0.8.6i on RedHat 9 Operating System

My cacti.log file has the following errors:


05/03/2007 03:44:56 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from poller_command where poller_id=0"
05/03/2007 03:44:56 PM - RECACHE STATS: RecacheTime:0.6779 HostsRecached:4
05/03/2007 03:45:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select id from host where disabled = '' order by id"
05/03/2007 03:45:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select * from host where (disabled = '' and id >= 0 and id <= 0) ORDER by id"
05/03/2007 03:45:12 PM - CMDPHP: Poller[0] Host[0] DS[1616] WARNING: Result from CMD not valid. Partial Result:

Your contribution is highly appreciated.

[gandalf]

MySQL tables corrupted? Please run a repair on all tables
Reinhard

[efe_rhl]

Thanks a million for your reply. I am a newbie to the cacti application. Please can you help me on how I can do that ?

[fmangeant]

Hi

I had the same problems following an unclean shutdown...

Run this :

Code: Select all

$ mysqlcheck --user=cactiuser -p cacti

If some tables are "corrupted", add the '--repair' option.

[iza_wnc]

Hi;
Mine too. But after checking the database; evrything looks fine:
[root@sgmon1 rra]# mysqlcheck -ucactiuser -p cacti
Enter password:
cacti.cdef OK
cacti.cdef_items OK
cacti.colors OK
cacti.data_input OK
cacti.data_input_data OK
cacti.data_input_fields OK
cacti.data_local OK
cacti.data_template OK
cacti.data_template_data OK
cacti.data_template_data_rra OK
cacti.data_template_rrd OK
cacti.graph_local OK
cacti.graph_template_input OK
cacti.graph_template_input_defs OK
cacti.graph_templates OK
cacti.graph_templates_gprint OK
cacti.graph_templates_graph OK
cacti.graph_templates_item OK
cacti.graph_tree OK
cacti.graph_tree_items OK
cacti.host OK
cacti.host_graph OK
cacti.host_snmp_cache OK
cacti.host_snmp_query OK
cacti.host_template OK
cacti.host_template_graph OK
cacti.host_template_snmp_query OK
cacti.poller OK
cacti.poller_command OK
cacti.poller_item OK
cacti.poller_output OK
cacti.poller_reindex OK
cacti.poller_time OK
cacti.rra OK
cacti.rra_cf OK
cacti.settings OK
cacti.settings_graphs OK
cacti.settings_tree OK
cacti.snmp_query OK
cacti.snmp_query_graph OK
cacti.snmp_query_graph_rrd OK
cacti.snmp_query_graph_rrd_sv OK
cacti.snmp_query_graph_sv OK
cacti.tholdset OK
cacti.user_auth OK
cacti.user_auth_perms OK
cacti.user_auth_realm OK
cacti.user_log OK
cacti.version OK

But my logs are a bit different than yours:

05/06/2007 08:59:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=74 and data_template_rrd.local_data_id=2091"
05/06/2007 08:59:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=74 and data_template_rrd.local_data_id=2084"[/b]

[efe_rhl]

Thanks guys,

I was able to do the repair and the graphs came back up.

[Moriarty]

Hi;
Mine too. But after checking the database; evrything looks fine:
<snip>

iza_wnc, did you figure out what was wrong? I think I'm experiencing a very similar issue here :\

[iza_wnc]

No I did not. But I tried to use older version...but i get other errors like snmp not valid even though in my cacti page the snmp is working and rrd is OK.

So finally i decided to install new and create one by one again....