Re: Table './nagios/nagios_contactnotifications' is marked a
Posted: Fri Nov 11, 2016 4:02 am
followed your suggestions. Here output:
but after 5 minutes the errors appearing is the same:
SQL: SQL Error [ndoutils] : Table './nagios/nagios_contactnotifications' is marked as crashed and last (automatic?) repair failed SQL: SQL Error [ndoutils] : Table './nagios/nagios_contactnotifications' is marked as crashed and last (automatic?) repair failed
Code: Select all
mysql.columns_priv OK
mysql.db
warning : Number of rows changed from 0 to 4
status : OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category
warning : Number of rows changed from 0 to 40
status : OK
mysql.help_keyword
warning : Number of rows changed from 0 to 453
status : OK
mysql.help_relation
warning : Number of rows changed from 0 to 1009
status : OK
mysql.help_topic
warning : Number of rows changed from 0 to 510
status : OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log 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
warning : Number of rows changed from 0 to 7
status : OK
nagios.nagios_acknowledgements
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_commands
warning : Number of rows changed from 0 to 119
status : OK
nagios.nagios_commenthistory
warning : Number of rows changed from 0 to 12
status : OK
nagios.nagios_comments
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_configfiles
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_configfilevariables
warning : Number of rows changed from 0 to 131
status : OK
nagios.nagios_conninfo
warning : Number of rows changed from 0 to 291
status : OK
nagios.nagios_contact_addresses OK
nagios.nagios_contact_notificationcommands
warning : Number of rows changed from 0 to 96
status : OK
nagios.nagios_contactgroup_members
warning : Number of rows changed from 0 to 13
status : OK
nagios.nagios_contactgroups
warning : Number of rows changed from 0 to 3
status : OK
nagios.nagios_contactnotificationmethods
warning : Number of rows changed from 0 to 2424
status : OK
nagios.nagios_contactnotifications
warning : Number of rows changed from 0 to 505
status : OK
nagios.nagios_contacts
warning : Number of rows changed from 0 to 8
status : OK
nagios.nagios_contactstatus
warning : Number of rows changed from 0 to 8
status : OK
nagios.nagios_customvariables
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_customvariablestatus
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_dbversion
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_downtimehistory OK
nagios.nagios_eventhandlers OK
nagios.nagios_externalcommands
info : Delete link points outside datafile at 1216500
info : Delete link points outside datafile at 2062568
info : Delete link points outside datafile at 2063516
info : Delete link points outside datafile at 2861092
info : Delete link points outside datafile at 2863392
info : Delete link points outside datafile at 3749108
info : Delete link points outside datafile at 3751288
warning : Number of rows changed from 0 to 32253
status : OK
nagios.nagios_flappinghistory
warning : Number of rows changed from 0 to 32
status : OK
nagios.nagios_host_contactgroups
warning : Number of rows changed from 0 to 22
status : OK
nagios.nagios_host_contacts
warning : Number of rows changed from 0 to 2
status : OK
nagios.nagios_host_parenthosts OK
nagios.nagios_hostchecks OK
nagios.nagios_hostdependencies OK
nagios.nagios_hostescalation_contactgroups OK
nagios.nagios_hostescalation_contacts OK
nagios.nagios_hostescalations OK
nagios.nagios_hostgroup_members
warning : Number of rows changed from 0 to 17
status : OK
nagios.nagios_hostgroups
warning : Number of rows changed from 0 to 3
status : OK
nagios.nagios_hosts
warning : Number of rows changed from 0 to 22
status : OK
nagios.nagios_hoststatus
info : Delete link points outside datafile at 6348
warning : Number of rows changed from 0 to 22
status : OK
nagios.nagios_instances
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_logentries
info : Delete link points outside datafile at 188216
info : Delete link points outside datafile at 2100420
info : Delete link points outside datafile at 5376556
info : Delete link points outside datafile at 14670120
warning : Number of rows changed from 0 to 145886
status : OK
nagios.nagios_notifications
warning : Number of rows changed from 0 to 1528
status : OK
nagios.nagios_objects
warning : Number of rows changed from 0 to 572
status : OK
nagios.nagios_processevents
warning : Number of rows changed from 0 to 506
status : OK
nagios.nagios_programstatus
warning : Number of rows changed from 0 to 1
status : OK
nagios.nagios_runtimevariables
warning : Number of rows changed from 0 to 18
status : OK
nagios.nagios_scheduleddowntime OK
nagios.nagios_service_contactgroups
warning : Number of rows changed from 0 to 337
status : OK
nagios.nagios_service_contacts OK
nagios.nagios_service_parentservices OK
nagios.nagios_servicechecks OK
nagios.nagios_servicedependencies OK
nagios.nagios_serviceescalation_contactgroups OK
nagios.nagios_serviceescalation_contacts OK
nagios.nagios_serviceescalations OK
nagios.nagios_servicegroup_members OK
nagios.nagios_servicegroups OK
nagios.nagios_services
warning : Number of rows changed from 0 to 337
status : OK
nagios.nagios_servicestatus
info : Delete link points outside datafile at 108376
info : Found block that points outside data file at 108424
info : Found block that points outside data file at 108532
warning : Number of rows changed from 0 to 337
status : OK
nagios.nagios_statehistory
warning : Number of rows changed from 0 to 51737
status : OK
nagios.nagios_systemcommands
info : Delete link points outside datafile at 0
info : Found block with too small length at 592; Skipped
info : Found block with too small length at 1860; Skipped
info : Found block with too small length at 2452; Skipped
info : Found block with too small length at 3112; Skipped
info : Found block with too small length at 4472; Skipped
info : Found block with too small length at 5456; Skipped
info : Found block with too small length at 7184; Skipped
info : Found block with too small length at 8624; Skipped
info : Found block with too small length at 9120; Skipped
info : Found block with too small length at 10840; Skipped
info : Delete link points outside datafile at 14900
info : Found block with too small length at 14920; Skipped
info : Found block with too small length at 16560; Skipped
info : Found block with too small length at 16760; Skipped
info : Delete link points outside datafile at 17092
info : Delete link points outside datafile at 22752
info : Delete link points outside datafile at 25748
info : Delete link points outside datafile at 26148
warning : Number of rows changed from 0 to 68
status : OK
nagios.nagios_timedeventqueue OK
nagios.nagios_timedevents OK
nagios.nagios_timeperiod_timeranges
warning : Number of rows changed from 0 to 31
status : OK
nagios.nagios_timeperiods
warning : Number of rows changed from 0 to 8
status : OK
nagiosql.tbl_command
warning : Number of rows changed from 0 to 125
status : OK
nagiosql.tbl_contact
warning : Number of rows changed from 0 to 7
status : OK
nagiosql.tbl_contactgroup
warning : Number of rows changed from 0 to 3
status : OK
nagiosql.tbl_contacttemplate
warning : Number of rows changed from 0 to 2
status : OK
nagiosql.tbl_domain
warning : Number of rows changed from 0 to 1
status : OK
nagiosql.tbl_host
warning : Number of rows changed from 0 to 22
status : OK
nagiosql.tbl_hostdependency OK
nagiosql.tbl_hostescalation OK
nagiosql.tbl_hostextinfo OK
nagiosql.tbl_hostgroup
warning : Number of rows changed from 0 to 4
status : OK
nagiosql.tbl_hosttemplate
warning : Number of rows changed from 0 to 49
status : OK
nagiosql.tbl_info
warning : Number of rows changed from 0 to 218
status : OK
nagiosql.tbl_lnkContactToCommandHost
warning : Number of rows changed from 0 to 7
status : OK
nagiosql.tbl_lnkContactToCommandService
warning : Number of rows changed from 0 to 7
status : OK
nagiosql.tbl_lnkContactToContactgroup
warning : Number of rows changed from 0 to 5
status : OK
nagiosql.tbl_lnkContactToContacttemplate
warning : Number of rows changed from 0 to 6
status : OK
nagiosql.tbl_lnkContactToVariabledefinition OK
nagiosql.tbl_lnkContactgroupToContact
warning : Number of rows changed from 0 to 11
status : OK
nagiosql.tbl_lnkContactgroupToContactgroup OK
nagiosql.tbl_lnkContacttemplateToCommandHost
warning : Number of rows changed from 0 to 2
status : OK
nagiosql.tbl_lnkContacttemplateToCommandService
warning : Number of rows changed from 0 to 2
status : OK
nagiosql.tbl_lnkContacttemplateToContactgroup
warning : Number of rows changed from 0 to 1
status : OK
nagiosql.tbl_lnkContacttemplateToContacttemplate OK
nagiosql.tbl_lnkContacttemplateToVariabledefinition OK
nagiosql.tbl_lnkHostToContact
warning : Number of rows changed from 0 to 2
status : OK
nagiosql.tbl_lnkHostToContactgroup
warning : Number of rows changed from 0 to 21
status : OK
nagiosql.tbl_lnkHostToHost OK
nagiosql.tbl_lnkHostToHostgroup
warning : Number of rows changed from 0 to 1
status : OK
nagiosql.tbl_lnkHostToHosttemplate
warning : Number of rows changed from 0 to 2
status : OK
nagiosql.tbl_lnkHostToVariabledefinition
warning : Number of rows changed from 0 to 1
status : OK
nagiosql.tbl_lnkHostdependencyToHost_DH OK
nagiosql.tbl_lnkHostdependencyToHost_H OK
nagiosql.tbl_lnkHostdependencyToHostgroup_DH OK
nagiosql.tbl_lnkHostdependencyToHostgroup_H OK
nagiosql.tbl_lnkHostescalationToContact OK
nagiosql.tbl_lnkHostescalationToContactgroup OK
nagiosql.tbl_lnkHostescalationToHost OK
nagiosql.tbl_lnkHostescalationToHostgroup OK
nagiosql.tbl_lnkHostgroupToHost
warning : Number of rows changed from 0 to 16
status : OK
nagiosql.tbl_lnkHostgroupToHostgroup OK
nagiosql.tbl_lnkHosttemplateToContact OK
nagiosql.tbl_lnkHosttemplateToContactgroup
warning : Number of rows changed from 0 to 4
status : OK
nagiosql.tbl_lnkHosttemplateToHost OK
nagiosql.tbl_lnkHosttemplateToHostgroup
warning : Number of rows changed from 0 to 1
status : OK
nagiosql.tbl_lnkHosttemplateToHosttemplate
warning : Number of rows changed from 0 to 47
status : OK
nagiosql.tbl_lnkHosttemplateToVariabledefinition OK
nagiosql.tbl_lnkServiceToContact OK
nagiosql.tbl_lnkServiceToContactgroup
warning : Number of rows changed from 0 to 93
status : OK
nagiosql.tbl_lnkServiceToHost
warning : Number of rows changed from 0 to 339
status : OK
nagiosql.tbl_lnkServiceToHostgroup
warning : Number of rows changed from 0 to 1
status : OK
nagiosql.tbl_lnkServiceToServicegroup OK
nagiosql.tbl_lnkServiceToServicetemplate
warning : Number of rows changed from 0 to 8
status : OK
nagiosql.tbl_lnkServiceToVariabledefinition OK
nagiosql.tbl_lnkServicedependencyToHost_DH OK
nagiosql.tbl_lnkServicedependencyToHost_H OK
nagiosql.tbl_lnkServicedependencyToHostgroup_DH OK
nagiosql.tbl_lnkServicedependencyToHostgroup_H OK
nagiosql.tbl_lnkServicedependencyToService_DS OK
nagiosql.tbl_lnkServicedependencyToService_S OK
nagiosql.tbl_lnkServiceescalationToContact OK
nagiosql.tbl_lnkServiceescalationToContactgroup OK
nagiosql.tbl_lnkServiceescalationToHost OK
nagiosql.tbl_lnkServiceescalationToHostgroup OK
nagiosql.tbl_lnkServiceescalationToService OK
nagiosql.tbl_lnkServicegroupToService OK
nagiosql.tbl_lnkServicegroupToServicegroup OK
nagiosql.tbl_lnkServicetemplateToContact OK
nagiosql.tbl_lnkServicetemplateToContactgroup
warning : Number of rows changed from 0 to 1
status : OK
nagiosql.tbl_lnkServicetemplateToHost OK
nagiosql.tbl_lnkServicetemplateToHostgroup OK
nagiosql.tbl_lnkServicetemplateToServicegroup OK
nagiosql.tbl_lnkServicetemplateToServicetemplate
warning : Number of rows changed from 0 to 74
status : OK
nagiosql.tbl_lnkServicetemplateToVariabledefinition OK
nagiosql.tbl_lnkTimeperiodToTimeperiod OK
nagiosql.tbl_logbook OK
nagiosql.tbl_mainmenu
warning : Number of rows changed from 0 to 7
status : OK
nagiosql.tbl_service
warning : Number of rows changed from 0 to 102
status : OK
nagiosql.tbl_servicedependency OK
nagiosql.tbl_serviceescalation OK
nagiosql.tbl_serviceextinfo OK
nagiosql.tbl_servicegroup OK
nagiosql.tbl_servicetemplate
warning : Number of rows changed from 0 to 76
status : OK
nagiosql.tbl_settings
warning : Number of rows changed from 0 to 12
status : OK
nagiosql.tbl_submenu
warning : Number of rows changed from 0 to 29
status : OK
nagiosql.tbl_timedefinition
warning : Number of rows changed from 0 to 37
status : OK
nagiosql.tbl_timeperiod
warning : Number of rows changed from 0 to 7
status : OK
nagiosql.tbl_user
warning : Number of rows changed from 0 to 2
status : OK
nagiosql.tbl_variabledefinition
warning : Number of rows changed from 0 to 1
status : OK
SQL: SQL Error [ndoutils] : Table './nagios/nagios_contactnotifications' is marked as crashed and last (automatic?) repair failed SQL: SQL Error [ndoutils] : Table './nagios/nagios_contactnotifications' is marked as crashed and last (automatic?) repair failed