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
pgpyugWkoOzct.pgp
Description: PGP signature
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
