Innodb tables don't support repair by design, they are self repairing, so that's not a problem.
http://bugs.mysql.com/bug.php?id=42563 Bye, Emilio 2010/5/24 Roberto R. Morelli <[email protected]>: > Any status update ? > > Cheers, > Roberto > > --On May 19, 2010 6:50:47 AM -0700 "Roberto R. Morelli" <[email protected]> > wrote: > >> Ton, >> >> Here is what you requested: >> >> mysql> select * from runtime.nagios_programstatus\G >> *************************** 1. row *************************** >> programstatus_id: 48 >> instance_id: 1 >> status_update_time: 2010-05-19 13:50:04 >> program_start_time: 2010-05-19 13:29:50 >> program_end_time: 0000-00-00 00:00:00 >> is_currently_running: 1 >> process_id: 3373 >> daemon_mode: 1 >> last_command_check: 2010-05-19 13:49:54 >> last_log_rotation: 1970-01-01 00:00:00 >> notifications_enabled: 1 >> active_service_checks_enabled: 1 >> passive_service_checks_enabled: 1 >> active_host_checks_enabled: 1 >> passive_host_checks_enabled: 1 >> event_handlers_enabled: 1 >> flap_detection_enabled: 1 >> failure_prediction_enabled: 1 >> process_performance_data: 1 >> obsess_over_hosts: 1 >> obsess_over_services: 1 >> modified_host_attributes: 128 >> modified_service_attributes: 128 >> global_host_event_handler: >> global_service_event_handler: >> 1 row in set (0.00 sec) >> >> >> Cheers, >> Roberto >> >> --On May 18, 2010 10:46:12 PM +0100 Ton Voon <[email protected]> wrote: >> >>> >>> On 18 May 2010, at 20:22, Roberto R. Morelli wrote: >>> >>>> Ton, >>>> >>>> Looks like DB errors, here is dump of the tests: >>>> >>>> mysql.columns_priv OK >>>> mysql.db OK >>>> mysql.func OK >>>> mysql.help_category OK >>>> mysql.help_keyword OK >>>> mysql.help_relation OK >>>> mysql.help_topic OK >>>> mysql.host OK >>>> mysql.proc OK >>>> mysql.procs_priv OK >>>> mysql.tables_priv OK >>>> mysql.time_zone OK >>>> mysql.time_zone_leap_second OK >>>> mysql.time_zone_name OK >>>> mysql.time_zone_transition OK >>>> mysql.time_zone_transition_type OK >>>> mysql.user OK >>>> odw.acknowledgement_host OK >>>> odw.acknowledgement_service OK >>>> odw.availability OK >>>> odw.availability_host_summary OK >>>> odw.availability_hostgroup_summary OK >>>> odw.availability_summary OK >>>> odw.database_version OK >>>> odw.dataloads OK >>>> odw.downtime_host_history OK >>>> odw.downtime_service_history OK >>>> odw.events OK >>>> odw.hosts OK >>>> odw.locks OK >>>> odw.metadata OK >>>> odw.notification_host_history OK >>>> odw.notification_service_history OK >>>> odw.performance_data OK >>>> odw.performance_labels OK >>>> odw.report_comments OK >>>> odw.reports OK >>>> odw.schema_version >>>> note : The storage engine for the table doesn't support repair >>>> odw.service_availability_hourly_summary OK >>>> odw.service_outages OK >>>> odw.service_saved_state OK >>>> odw.servicecheck_results OK >>>> odw.servicechecks OK >>>> odw.state_history OK >>>> opsview.access >>>> note : The storage engine for the table doesn't support repair >>>> opsview.agentplugins >>>> note : The storage engine for the table doesn't support repair >>>> opsview.agents >>>> note : The storage engine for the table doesn't support repair >>>> opsview.application_plugins >>>> note : The storage engine for the table doesn't support repair >>>> opsview.auditlogs >>>> note : The storage engine for the table doesn't support repair >>>> opsview.checktypes >>>> note : The storage engine for the table doesn't support repair >>>> opsview.contact_hostgroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.contact_keywords >>>> note : The storage engine for the table doesn't support repair >>>> opsview.contact_servicegroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.contact_variables >>>> note : The storage engine for the table doesn't support repair >>>> opsview.contacts >>>> note : The storage engine for the table doesn't support repair >>>> opsview.embeddedservices >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostcheckcommands >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostgroupinfo >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostgroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hosthosttemplates >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostinfo >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostperformancemonitors >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hosts >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostservicechecks >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostserviceeventhandlers >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hostsnmpinterfaces >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hosttemplatemanagementurls >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hosttemplateperformancemonitors >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hosttemplates >>>> note : The storage engine for the table doesn't support repair >>>> opsview.hosttemplateservicechecks >>>> note : The storage engine for the table doesn't support repair >>>> opsview.icons >>>> note : The storage engine for the table doesn't support repair >>>> opsview.keywordhostgroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.keywordhosts >>>> note : The storage engine for the table doesn't support repair >>>> opsview.keywordhosttemplates >>>> note : The storage engine for the table doesn't support repair >>>> opsview.keywords >>>> note : The storage engine for the table doesn't support repair >>>> opsview.keywordservicechecks >>>> note : The storage engine for the table doesn't support repair >>>> opsview.keywordservicegroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.metadata >>>> note : The storage engine for the table doesn't support repair >>>> opsview.modules >>>> note : The storage engine for the table doesn't support repair >>>> opsview.monitoringclusternodes >>>> note : The storage engine for the table doesn't support repair >>>> opsview.monitoringservers >>>> note : The storage engine for the table doesn't support repair >>>> opsview.notificationmethod_variables >>>> note : The storage engine for the table doesn't support repair >>>> opsview.notificationmethods >>>> note : The storage engine for the table doesn't support repair >>>> opsview.notificationprofile_hostgroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.notificationprofile_keywords >>>> note : The storage engine for the table doesn't support repair >>>> opsview.notificationprofile_notificationmethods >>>> note : The storage engine for the table doesn't support repair >>>> opsview.notificationprofile_servicegroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.notificationprofiles >>>> note : The storage engine for the table doesn't support repair >>>> opsview.parents >>>> note : The storage engine for the table doesn't support repair >>>> opsview.performancemonitors >>>> note : The storage engine for the table doesn't support repair >>>> opsview.plugins >>>> note : The storage engine for the table doesn't support repair >>>> opsview.rancid_vendors >>>> note : The storage engine for the table doesn't support repair >>>> opsview.reloadmessages >>>> note : The storage engine for the table doesn't support repair >>>> opsview.reloadtimes >>>> note : The storage engine for the table doesn't support repair >>>> opsview.roles >>>> note : The storage engine for the table doesn't support repair >>>> opsview.roles_access >>>> note : The storage engine for the table doesn't support repair >>>> opsview.roles_hostgroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.roles_monitoringservers >>>> note : The storage engine for the table doesn't support repair >>>> opsview.schema_version >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicecheckdependencies >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicecheckhostexceptions >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicecheckhosttemplateexceptions >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicechecks >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicechecksnmpactions >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicechecksnmpignores >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicechecksnmppolling >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicechecktimedoverridehostexceptions >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicechecktimedoverridehosttemplateexceptions >>>> note : The storage engine for the table doesn't support repair >>>> opsview.servicegroups >>>> note : The storage engine for the table doesn't support repair >>>> opsview.snmptraprules >>>> note : The storage engine for the table doesn't support repair >>>> opsview.snmptraps >>>> note : The storage engine for the table doesn't support repair >>>> opsview.snmpwalkcache >>>> note : The storage engine for the table doesn't support repair >>>> opsview.systempreferences >>>> note : The storage engine for the table doesn't support repair >>>> opsview.temporary_hostmonitoredbynode >>>> note : The storage engine for the table doesn't support repair >>>> opsview.timeperiods >>>> note : The storage engine for the table doesn't support repair >>>> opsview.useragents >>>> note : The storage engine for the table doesn't support repair >>>> reports.generic_availability_targets_hostgroup >>>> note : The storage engine for the table doesn't support repair >>>> reports.report_types >>>> note : The storage engine for the table doesn't support repair >>>> reports.reports >>>> note : The storage engine for the table doesn't support repair >>>> reports.schema_version >>>> note : The storage engine for the table doesn't support repair >>>> reports.selectionhostgroups >>>> note : The storage engine for the table doesn't support repair >>>> reports.selections >>>> note : The storage engine for the table doesn't support repair >>>> reports.selectionworkinghours >>>> note : The storage engine for the table doesn't support repair >>>> reports.weekly_availability_keyword_critical_states >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_acknowledgements >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_commands >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_commenthistory >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_comments >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_configfiles >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_configfilevariables >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_conninfo >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contact_addresses >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contact_notificationcommands >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contactgroup_members >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contactgroups >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contactnotificationmethods >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contactnotifications >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contacts >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_contactstatus >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_customvariables >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_customvariablestatus >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_database_version OK >>>> runtime.nagios_dbversion >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_downtimehistory >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_eventhandlers >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_externalcommands >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_flappinghistory >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_host_contactgroups >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_host_contacts >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_host_parenthosts >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hostchecks >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hostdependencies >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hostescalation_contactgroups >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hostescalation_contacts >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hostescalations >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hostgroup_members >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hostgroups >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hosts >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_hoststatus >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_instances >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_logentries >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_notifications >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_objects >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_processevents >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_programstatus >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_runtimevariables >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_scheduleddowntime >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_schema_version >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_service_contactgroups >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_service_contacts >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_servicechecks >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_servicedependencies >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_serviceescalation_contactgroups >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_serviceescalation_contacts >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_serviceescalations >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_servicegroup_members >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_servicegroups >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_services >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_servicestatus >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_statehistory >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_systemcommands >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_timedeventqueue >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_timedevents >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_timeperiod_timeranges >>>> note : The storage engine for the table doesn't support repair >>>> runtime.nagios_timeperiods >>>> note : The storage engine for the table doesn't support repair >>>> runtime.opsview_contact_hosts OK >>>> runtime.opsview_contact_objects OK >>>> runtime.opsview_contact_services OK >>>> runtime.opsview_database_version >>>> note : The storage engine for the table doesn't support repair >>>> runtime.opsview_host_objects OK >>>> runtime.opsview_host_services OK >>>> runtime.opsview_hostgroup_hosts OK >>>> runtime.opsview_hostgroups OK >>>> runtime.opsview_hosts OK >>>> runtime.opsview_monitoringclusternodes OK >>>> runtime.opsview_monitoringclusters OK >>>> runtime.opsview_performance_metrics OK >>>> runtime.opsview_viewports OK >>>> runtime.schema_version >>>> note : The storage engine for the table doesn't support repair >>>> runtime.snmptrapdebug OK >>>> runtime.snmptrapexceptions OK >>>> runtime.snmptrapruledebug OK >>>> test.agentplugins OK >>>> >>>> What would the correct way to fix this for opsview ? >>> >>> I don't think this is necessarily the problem. All tables of type innodb >>> above say "doesn't support repair". >>> >>> What does this say? >>> >>> select * from runtime.nagios_programstatus\G >>> >>> Ton >>> >>> _______________________________________________ >>> Opsview-users mailing list >>> [email protected] >>> http://lists.opsview.org/lists/listinfo/opsview-users > > -------------------------------- > Roberto R. Morelli > [email protected] > Energy Sciences Network > Lawrence Berkeley National Lab. > 510-486-7255 > > PGP Key Fingerprint: F49F 1186 0E2B F591 1BF7 0538 79AA F8C7 7E8B 4562 > > > _______________________________________________ > Opsview-users mailing list > [email protected] > http://lists.opsview.org/lists/listinfo/opsview-users > > _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
