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
