Stop Graphing after full partition error [SOLVED]

[jthemovie]

Hi Everyone,

My cacti was working perfectly fine until i ran into a full partition problem (lasted 2 days).
After having deleted the useless stuffs, i could log in again to cacti but
now despite that the problem is fixed, i don't get any graph working,
none of them are displaying anything (-nan-).

I tried restarting mysql, apache, story to tell cacti, "oh, its fixed now, u can graph again", no joy...

All the rras are OK, my scripts for fetching data for cacti as well, is there any "magic trick" i could force cacti to graph again without deleting the rras of course .

Thanks in advance

[cigamit]

Check your mysql tables, some of them probably need to be repaired.

[jthemovie]

Thanks for your suggestion

i did the following:

Code: Select all

mysqlcheck -p --auto-repair --databases cacti

Code: Select all

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.plugin_config                                OK
cacti.plugin_db_changes                            OK
cacti.plugin_hooks                                 OK
cacti.plugin_realms                                OK
cacti.poller                                       OK
cacti.poller_command                               OK
cacti.poller_item                                  OK
cacti.poller_output
Error    : Can't find file: 'poller_output' (errno: 2)
status   : Operation failed
cacti.poller_output_rt                             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.user_auth                                    OK
cacti.user_auth_perms                              OK
cacti.user_auth_realm                              OK
cacti.user_log                                     OK
cacti.version                                      OK

Repairing tables
cacti.poller_output
Error    : Can't find file: 'poller_output' (errno: 2)
status   : Operation failed

I'm not quite sure what is this poller_output, do you think it could be related ?

Kind regards

[cigamit]

Yep, that is the main table that data is written to before it is written to rrd files.

Open your cacti.sql and find the "CREATE TABLE" entry for it, and rerun only that section in MySQL. You may need to drop the table first.

[jthemovie]

Thanks for your answer, i did the following:

Code: Select all

CREATE TABLE poller_output (
  local_data_id mediumint(8) unsigned NOT NULL default '0',
  rrd_name varchar(19) NOT NULL default '',
  time datetime NOT NULL default '0000-00-00 00:00:00',
  output text NOT NULL,
  PRIMARY KEY (local_data_id,rrd_name,time) /*!50060 USING BTREE */
) ENGINE=MyISAM;

now the following command do not show output any errors

Code: Select all

mysqlcheck -p --auto-repair --databases cacti

Cacti is back to work, everything works fine again.

Thanks you very much for your precious help, much appreciated