Table './nagios/nagios_contactnotifications' is marked as cr

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
saptech
Posts: 53
Joined: Thu Dec 10, 2015 11:19 am

Re: Table './nagios/nagios_contactnotifications' is marked a

Post by saptech »

after few hours I got the same error:

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

I trap an error during the optimization of the DB related to this table:

# mysqlcheck -o -u root -pp0l9r1s --databases nagios

Code: Select all

nagios.nagios_acknowledgements                     Table is already up to date
nagios.nagios_commands
error    : Found 148 keys of 166
status   : Operation failed
nagios.nagios_commenthistory                       OK
nagios.nagios_comments                             OK
nagios.nagios_configfiles                          OK
nagios.nagios_configfilevariables                  OK
nagios.nagios_conninfo
error    : Key in wrong position at page 1024
status   : Operation failed
nagios.nagios_contact_addresses                    Table is already up to date
nagios.nagios_contact_notificationcommands         OK
nagios.nagios_contactgroup_members                 OK
nagios.nagios_contactgroups                        OK
nagios.nagios_contactnotificationmethods           Table is already up to date
nagios.nagios_contactnotifications
error    : Can't create new tempfile: '/var/lib/mysql/nagios/nagios_contactnotifications.TMM'
status   : Operation failed
nagios.nagios_contacts                             OK
nagios.nagios_contactstatus                        OK
nagios.nagios_customvariables                      OK
nagios.nagios_customvariablestatus                 OK
nagios.nagios_dbversion                            Table is already up to date
nagios.nagios_downtimehistory                      Table is already up to date
nagios.nagios_eventhandlers                        Table is already up to date
nagios.nagios_externalcommands                     OK
nagios.nagios_flappinghistory                      Table is already up to date
nagios.nagios_host_contactgroups                   OK
nagios.nagios_host_contacts                        OK
nagios.nagios_host_parenthosts                     Table is already up to date
nagios.nagios_hostchecks                           Table is already up to date
nagios.nagios_hostdependencies                     Table is already up to date
nagios.nagios_hostescalation_contactgroups         Table is already up to date
nagios.nagios_hostescalation_contacts              Table is already up to date
nagios.nagios_hostescalations                      Table is already up to date
nagios.nagios_hostgroup_members                    OK
nagios.nagios_hostgroups                           OK
nagios.nagios_hosts                                OK
nagios.nagios_hoststatus
warning  : Duplicate key for record at 3320 against record at 3020
warning  : Number of rows changed from 23 to 22
status   : OK
nagios.nagios_instances                            Table is already up to date
nagios.nagios_logentries                           OK
nagios.nagios_notifications                        Table is already up to date
nagios.nagios_objects
error    : Found 101 keys of 572
status   : Operation failed
nagios.nagios_processevents
error    : Found 101 keys of 436
status   : Operation failed
nagios.nagios_programstatus                        OK
nagios.nagios_runtimevariables                     OK
nagios.nagios_scheduleddowntime                    Table is already up to date
nagios.nagios_service_contactgroups
error    : Found 368 keys of 604
status   : Operation failed
nagios.nagios_service_contacts                     Table is already up to date
nagios.nagios_service_parentservices               OK
nagios.nagios_servicechecks                        Table is already up to date
nagios.nagios_servicedependencies                  Table is already up to date
nagios.nagios_serviceescalation_contactgroups      Table is already up to date
nagios.nagios_serviceescalation_contacts           Table is already up to date
nagios.nagios_serviceescalations                   Table is already up to date
nagios.nagios_servicegroup_members                 Table is already up to date
nagios.nagios_servicegroups                        Table is already up to date
nagios.nagios_services
error    : Found 366 keys of 602
status   : Operation failed
nagios.nagios_servicestatus
warning  : Duplicate key for record at 108116 against record at 0
warning  : Number of rows changed from 338 to 337
status   : OK
nagios.nagios_statehistory                         Table is already up to date
nagios.nagios_systemcommands                       OK
nagios.nagios_timedeventqueue                      Table is already up to date
nagios.nagios_timedevents                          Table is already up to date
nagios.nagios_timeperiod_timeranges                OK
nagios.nagios_timeperiods                          OK
Last edited by tgriep on Wed Dec 14, 2016 11:08 am, edited 1 time in total.
Reason: Added Code Wraps around large output.
Top
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Table './nagios/nagios_contactnotifications' is marked a

Post by tgriep »

Can you run the following commands and post the /tmp/ls.txt file?

Code: Select all

ls -lR /var/lib/mysql/ >/tmp/ls.txt
df -h >>/tmp/ls.txt
df -i >>/tmp/ls.txt
The can't create new tempfile could be a permission issue causing the problem and I would like to see the file permissions for the mysql database.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Top
saptech
Posts: 53
Joined: Thu Dec 10, 2015 11:19 am

Re: Table './nagios/nagios_contactnotifications' is marked a

Post by saptech »

Code: Select all

/var/lib/mysql/:
total 28720
-rw-rw---- 1 mysql mysql 18874368 Dec 15 09:54 ibdata1
-rw-rw---- 1 mysql mysql  5242880 Dec 15 09:54 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 Mar 11  2015 ib_logfile1
drwx------ 2 mysql mysql     4096 Dec 13 10:35 mysql
srwxrwxrwx 1 mysql mysql        0 Dec 15 09:54 mysql.sock
-rw------- 1 root  root         6 Dec 13 10:35 mysql_upgrade_info
drwx------ 2 mysql mysql    12288 Dec 15 09:55 nagios
drwx------ 2 mysql mysql    20480 Dec 15 09:55 nagiosql
drwx------ 2 mysql mysql     4096 Dec 13 10:35 performance_schema
drwx------ 2 mysql mysql     4096 Mar 11  2015 test

/var/lib/mysql/mysql:
total 1004
-rw-rw---- 1 mysql mysql   8820 Dec 13 10:35 columns_priv.frm
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 columns_priv.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 13 10:35 columns_priv.MYI
-rw-rw---- 1 mysql mysql   9582 Dec 13 10:35 db.frm
-rw-rw---- 1 mysql mysql   1760 Dec 13 10:35 db.MYD
-rw-rw---- 1 mysql mysql   5120 Dec 13 10:35 db.MYI
-rw-rw---- 1 mysql mysql  10223 Dec 13 10:35 event.frm
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 event.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 13 10:35 event.MYI
-rw-rw---- 1 mysql mysql   8665 Dec 13 10:35 func.frm
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 func.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 13 10:35 func.MYI
-rw-rw---- 1 mysql mysql     35 Dec 15 09:54 general_log.CSM
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 general_log.CSV
-rw-rw---- 1 mysql mysql   8776 Dec 13 10:35 general_log.frm
-rw-rw---- 1 mysql mysql   8700 Nov  1 10:06 help_category.frm
-rw-rw---- 1 mysql mysql   1120 Dec  9 15:03 help_category.MYD
-rw-rw---- 1 mysql mysql   3072 Dec  9 15:03 help_category.MYI
-rw-rw---- 1 mysql mysql   8612 Nov  1 10:06 help_keyword.frm
-rw-rw---- 1 mysql mysql  89241 Dec  9 15:03 help_keyword.MYD
-rw-rw---- 1 mysql mysql  15360 Dec  9 15:03 help_keyword.MYI
-rw-rw---- 1 mysql mysql   8630 Nov  1 10:06 help_relation.frm
-rw-rw---- 1 mysql mysql   9081 Dec  9 15:03 help_relation.MYD
-rw-rw---- 1 mysql mysql  16384 Dec  9 15:03 help_relation.MYI
-rw-rw---- 1 mysql mysql   8770 Nov  1 10:06 help_topic.frm
-rw-rw---- 1 mysql mysql 464340 Dec  9 15:03 help_topic.MYD
-rw-rw---- 1 mysql mysql  16384 Dec  9 15:03 help_topic.MYI
-rw-rw---- 1 mysql mysql   9510 Dec 13 10:35 host.frm
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 host.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 13 10:35 host.MYI
-rw-rw---- 1 mysql mysql   8778 Nov  1 10:06 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql   1024 Dec  9 15:03 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql   8586 Dec 13 10:35 plugin.frm
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 plugin.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 13 10:35 plugin.MYI
-rw-rw---- 1 mysql mysql   9996 Dec 13 10:35 proc.frm
-rw-rw---- 1 mysql mysql    828 Dec 13 10:35 proc.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 13 10:43 proc.MYI
-rw-rw---- 1 mysql mysql   8875 Dec 13 10:35 procs_priv.frm
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 procs_priv.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 13 10:35 procs_priv.MYI
-rw-rw---- 1 mysql mysql   8800 Dec 13 10:35 proxies_priv.frm
-rw-rw---- 1 mysql mysql    693 Dec 13 10:35 proxies_priv.MYD
-rw-rw---- 1 mysql mysql   5120 Dec 13 10:35 proxies_priv.MYI
-rw-rw---- 1 mysql mysql   8838 Nov  1 10:06 servers.frm
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 servers.MYD
-rw-rw---- 1 mysql mysql   1024 Dec  9 15:03 servers.MYI
-rw-rw---- 1 mysql mysql     35 Dec 15 09:54 slow_log.CSM
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 slow_log.CSV
-rw-rw---- 1 mysql mysql   8976 Dec 13 10:35 slow_log.frm
-rw-rw---- 1 mysql mysql   8955 Dec 13 10:35 tables_priv.frm
-rw-rw---- 1 mysql mysql      0 Dec 13 10:35 tables_priv.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 13 10:35 tables_priv.MYI
-rw-rw---- 1 mysql mysql   8636 Nov  1 10:06 time_zone.frm
-rw-rw---- 1 mysql mysql   8624 Nov  1 10:06 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql   1024 Dec  9 15:03 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 time_zone.MYD
-rw-rw---- 1 mysql mysql   1024 Dec  9 15:03 time_zone.MYI
-rw-rw---- 1 mysql mysql   8606 Nov  1 10:06 time_zone_name.frm
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 time_zone_name.MYD
-rw-rw---- 1 mysql mysql   1024 Dec  9 15:03 time_zone_name.MYI
-rw-rw---- 1 mysql mysql   8686 Nov  1 10:06 time_zone_transition.frm
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql   1024 Dec  9 15:03 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql   8748 Nov  1 10:06 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql      0 Dec  9 15:03 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql   1024 Dec  9 15:03 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql  10630 Dec 13 10:35 user.frm
-rw-rw---- 1 mysql mysql    512 Dec 13 10:35 user.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 13 10:35 user.MYI

/var/lib/mysql/nagios:
total 54456
-rw-rw---- 1 mysql mysql       61 Mar 11  2015 db.opt
-rw-rw---- 1 mysql mysql     9100 Nov  1 10:06 nagios_acknowledgements.frm
-rw-rw---- 1 mysql mysql       60 Dec 15 09:55 nagios_acknowledgements.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_acknowledgements.MYI
-rw-rw---- 1 mysql mysql     8746 Nov  1 10:06 nagios_commands.frm
-rw-rw---- 1 mysql mysql    12368 Dec 15 09:55 nagios_commands.MYD
-rw-rw---- 1 mysql mysql     7168 Dec 15 09:55 nagios_commands.MYI
-rw-rw---- 1 mysql mysql     9340 Nov  1 10:06 nagios_commenthistory.frm
-rw-rw---- 1 mysql mysql     2420 Dec 15 09:55 nagios_commenthistory.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_commenthistory.MYI
-rw-rw---- 1 mysql mysql     9220 Nov  1 10:06 nagios_comments.frm
-rw-rw---- 1 mysql mysql       76 Dec 15 09:55 nagios_comments.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_comments.MYI
-rw-rw---- 1 mysql mysql     8726 Nov  1 10:06 nagios_configfiles.frm
-rw-rw---- 1 mysql mysql       44 Dec 15 09:55 nagios_configfiles.MYD
-rw-rw---- 1 mysql mysql     5120 Dec 15 09:55 nagios_configfiles.MYI
-rw-rw---- 1 mysql mysql     8760 Nov  1 10:06 nagios_configfilevariables.frm
-rw-rw---- 1 mysql mysql     8456 Dec 15 09:55 nagios_configfilevariables.MYD
-rw-rw---- 1 mysql mysql     4096 Dec 15 09:55 nagios_configfilevariables.MYI
-rw-rw---- 1 mysql mysql     9262 Nov  1 10:06 nagios_conninfo.frm
-rw-rw---- 1 mysql mysql    26188 Dec 15 09:55 nagios_conninfo.MYD
-rw-rw---- 1 mysql mysql     5120 Dec 15 10:26 nagios_conninfo.MYI
-rw-rw---- 1 mysql mysql     8760 Nov  1 10:06 nagios_contact_addresses.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_contact_addresses.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_contact_addresses.MYI
-rw-rw---- 1 mysql mysql     8748 Nov  1 10:06 nagios_contactgroup_members.frm
-rw-rw---- 1 mysql mysql      255 Dec 15 09:55 nagios_contactgroup_members.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_contactgroup_members.MYI
-rw-rw---- 1 mysql mysql     8768 Nov  1 10:06 nagios_contactgroups.frm
-rw-rw---- 1 mysql mysql      172 Dec 15 09:55 nagios_contactgroups.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_contactgroups.MYI
-rw-rw---- 1 mysql mysql     8856 Nov  1 10:06 nagios_contact_notificationcommands.frm
-rw-rw---- 1 mysql mysql     1848 Dec 15 09:55 nagios_contact_notificationcommands.MYD
-rw-rw---- 1 mysql mysql     5120 Dec 15 09:55 nagios_contact_notificationcommands.MYI
-rw-rw---- 1 mysql mysql     9000 Nov  1 10:06 nagios_contactnotificationmethods.frm
-rw-rw---- 1 mysql mysql   121476 Dec 15 09:55 nagios_contactnotificationmethods.MYD
-rw-rw---- 1 mysql mysql   141312 Dec 15 10:00 nagios_contactnotificationmethods.MYI
-rw-rw---- 1 mysql mysql     8928 Nov  1 10:06 nagios_contactnotifications.frm
-rw-rw---- 1 mysql mysql     2106 Dec 15 09:55 nagios_contactnotifications.MYD
-rw-rw---- 1 mysql mysql     7168 Dec 15 09:55 nagios_contactnotifications.MYI
-rw-rw---- 1 mysql mysql  3063808 Jun 14  2016 nagios_contactnotifications.TMM
-rw-rw---- 1 mysql mysql    10026 Nov  1 10:06 nagios_contacts.frm
-rw-rw---- 1 mysql mysql      708 Dec 15 09:55 nagios_contacts.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_contacts.MYI
-rw-rw---- 1 mysql mysql     9240 Nov  1 10:06 nagios_contactstatus.frm
-rw-rw---- 1 mysql mysql      357 Dec 15 09:55 nagios_contactstatus.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_contactstatus.MYI
-rw-rw---- 1 mysql mysql     8844 Nov  1 10:06 nagios_customvariables.frm
-rw-rw---- 1 mysql mysql       40 Dec 15 09:55 nagios_customvariables.MYD
-rw-rw---- 1 mysql mysql     7168 Dec 15 09:55 nagios_customvariables.MYI
-rw-rw---- 1 mysql mysql     8870 Nov  1 10:06 nagios_customvariablestatus.frm
-rw-rw---- 1 mysql mysql       44 Dec 15 10:27 nagios_customvariablestatus.MYD
-rw-rw---- 1 mysql mysql     7168 Dec 15 10:27 nagios_customvariablestatus.MYI
-rw-rw---- 1 mysql mysql     8596 Nov  1 10:06 nagios_dbversion.frm
-rw-rw---- 1 mysql mysql       20 Dec 15 09:55 nagios_dbversion.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_dbversion.MYI
-rw-rw---- 1 mysql mysql     9490 Nov  1 10:06 nagios_downtimehistory.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_downtimehistory.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_downtimehistory.MYI
-rw-rw---- 1 mysql mysql     9380 Nov  1 10:06 nagios_eventhandlers.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_eventhandlers.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_eventhandlers.MYI
-rw-rw---- 1 mysql mysql     8812 Nov  1 10:06 nagios_externalcommands.frm
-rw-rw---- 1 mysql mysql  6018476 Dec 15 09:55 nagios_externalcommands.MYD
-rw-rw---- 1 mysql mysql   329728 Dec 15 10:25 nagios_externalcommands.MYI
-rw-rw---- 1 mysql mysql     9166 Nov  1 10:06 nagios_flappinghistory.frm
-rw-rw---- 1 mysql mysql     2080 Dec 15 09:55 nagios_flappinghistory.MYD
-rw-rw---- 1 mysql mysql     2048 Dec 15 09:55 nagios_flappinghistory.MYI
-rw-rw---- 1 mysql mysql     9660 Nov  1 10:06 nagios_hostchecks.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_hostchecks.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_hostchecks.MYI
-rw-rw---- 1 mysql mysql     8738 Nov  1 10:06 nagios_host_contactgroups.frm
-rw-rw---- 1 mysql mysql      330 Dec 15 09:55 nagios_host_contactgroups.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_host_contactgroups.MYI
-rw-rw---- 1 mysql mysql     8718 Nov  1 10:06 nagios_host_contacts.frm
-rw-rw---- 1 mysql mysql       30 Dec 15 09:55 nagios_host_contacts.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_host_contacts.MYI
-rw-rw---- 1 mysql mysql     9108 Nov  1 10:06 nagios_hostdependencies.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_hostdependencies.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_hostdependencies.MYI
-rw-rw---- 1 mysql mysql     8778 Nov  1 10:06 nagios_hostescalation_contactgroups.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_hostescalation_contactgroups.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_hostescalation_contactgroups.MYI
-rw-rw---- 1 mysql mysql     8758 Nov  1 10:06 nagios_hostescalation_contacts.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_hostescalation_contacts.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_hostescalation_contacts.MYI
-rw-rw---- 1 mysql mysql     9148 Nov  1 10:06 nagios_hostescalations.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_hostescalations.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_hostescalations.MYI
-rw-rw---- 1 mysql mysql     8730 Nov  1 10:06 nagios_hostgroup_members.frm
-rw-rw---- 1 mysql mysql      255 Dec 15 09:55 nagios_hostgroup_members.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_hostgroup_members.MYI
-rw-rw---- 1 mysql mysql     8756 Nov  1 10:06 nagios_hostgroups.frm
-rw-rw---- 1 mysql mysql      132 Dec 15 09:55 nagios_hostgroups.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_hostgroups.MYI
-rw-rw---- 1 mysql mysql     8732 Nov  1 10:06 nagios_host_parenthosts.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_host_parenthosts.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_host_parenthosts.MYI
-rw-rw---- 1 mysql mysql    11932 Nov  1 10:06 nagios_hosts.frm
-rw-rw---- 1 mysql mysql     3976 Dec 15 09:55 nagios_hosts.MYD
-rw-rw---- 1 mysql mysql     4096 Dec 15 09:55 nagios_hosts.MYI
-rw-rw---- 1 mysql mysql    15368 Nov  1 10:06 nagios_hoststatus.frm
-rw-rw---- 1 mysql mysql     6348 Dec 15 09:55 nagios_hoststatus.MYD
-rw-rw---- 1 mysql mysql    21504 Dec 15 10:27 nagios_hoststatus.MYI
-rw-rw---- 1 mysql mysql     8684 Nov  1 10:06 nagios_instances.frm
-rw-rw---- 1 mysql mysql       20 Dec 15 09:55 nagios_instances.MYD
-rw-rw---- 1 mysql mysql     2048 Dec 15 09:55 nagios_instances.MYI
-rw-rw---- 1 mysql mysql     8972 Nov  1 10:06 nagios_logentries.frm
-rw-rw---- 1 mysql mysql 24789952 Dec 15 09:55 nagios_logentries.MYD
-rw-rw---- 1 mysql mysql 10501120 Dec 15 10:25 nagios_logentries.MYI
-rw-rw---- 1 mysql mysql     9168 Nov  1 10:06 nagios_notifications.frm
-rw-rw---- 1 mysql mysql   307148 Dec 15 09:55 nagios_notifications.MYD
-rw-rw---- 1 mysql mysql   103424 Dec 15 10:00 nagios_notifications.MYI
-rw-rw---- 1 mysql mysql     8766 Nov  1 10:06 nagios_objects.frm
-rw-rw---- 1 mysql mysql    31028 Dec 15 09:55 nagios_objects.MYD
-rw-rw---- 1 mysql mysql    34816 Dec 15 09:55 nagios_objects.MYI
-rw-rw---- 1 mysql mysql     8948 Nov  1 10:06 nagios_processevents.frm
-rw-rw---- 1 mysql mysql    23036 Dec 15 09:55 nagios_processevents.MYD
-rw-rw---- 1 mysql mysql     7168 Dec 15 09:55 nagios_processevents.MYI
-rw-rw---- 1 mysql mysql    10174 Nov  1 10:06 nagios_programstatus.frm
-rw-rw---- 1 mysql mysql      116 Dec 15 09:55 nagios_programstatus.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 10:27 nagios_programstatus.MYI
-rw-rw---- 1 mysql mysql     8706 Nov  1 10:06 nagios_runtimevariables.frm
-rw-rw---- 1 mysql mysql     1016 Dec 15 09:55 nagios_runtimevariables.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_runtimevariables.MYI
-rw-rw---- 1 mysql mysql     9332 Nov  1 10:06 nagios_scheduleddowntime.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_scheduleddowntime.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_scheduleddowntime.MYI
-rw-rw---- 1 mysql mysql     9626 Nov  1 10:06 nagios_servicechecks.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_servicechecks.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_servicechecks.MYI
-rw-rw---- 1 mysql mysql     8750 Nov  1 10:06 nagios_service_contactgroups.frm
-rw-rw---- 1 mysql mysql     5055 Dec 15 09:55 nagios_service_contactgroups.MYD
-rw-rw---- 1 mysql mysql    12288 Dec 15 09:55 nagios_service_contactgroups.MYI
-rw-rw---- 1 mysql mysql     8730 Nov  1 10:06 nagios_service_contacts.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_service_contacts.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_service_contacts.MYI
-rw-rw---- 1 mysql mysql     9178 Nov  1 10:06 nagios_servicedependencies.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_servicedependencies.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_servicedependencies.MYI
-rw-rw---- 1 mysql mysql     8790 Nov  1 10:06 nagios_serviceescalation_contactgroups.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_serviceescalation_contactgroups.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_serviceescalation_contactgroups.MYI
-rw-rw---- 1 mysql mysql     8770 Nov  1 10:06 nagios_serviceescalation_contacts.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_serviceescalation_contacts.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_serviceescalation_contacts.MYI
-rw-rw---- 1 mysql mysql     9220 Nov  1 10:06 nagios_serviceescalations.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_serviceescalations.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_serviceescalations.MYI
-rw-rw---- 1 mysql mysql     8748 Nov  1 10:06 nagios_servicegroup_members.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_servicegroup_members.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_servicegroup_members.MYI
-rw-rw---- 1 mysql mysql     8768 Nov  1 10:06 nagios_servicegroups.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_servicegroups.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_servicegroups.MYI
-rw-rw---- 1 mysql mysql     8756 Nov  1 10:06 nagios_service_parentservices.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_service_parentservices.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_service_parentservices.MYI
-rw-rw---- 1 mysql mysql    11766 Nov  1 10:06 nagios_services.frm
-rw-rw---- 1 mysql mysql    64164 Dec 15 09:55 nagios_services.MYD
-rw-rw---- 1 mysql mysql    18432 Dec 15 09:55 nagios_services.MYI
-rw-rw---- 1 mysql mysql    15448 Nov  1 10:06 nagios_servicestatus.frm
-rw-rw---- 1 mysql mysql   108172 Dec 15 09:55 nagios_servicestatus.MYD
-rw-rw---- 1 mysql mysql    93184 Dec 15 10:27 nagios_servicestatus.MYI
-rw-rw---- 1 mysql mysql     9174 Nov  1 10:06 nagios_statehistory.frm
-rw-rw---- 1 mysql mysql  6849908 Dec 15 09:55 nagios_statehistory.MYD
-rw-rw---- 1 mysql mysql  1889280 Dec 15 10:24 nagios_statehistory.MYI
-rw-rw---- 1 mysql mysql     9110 Nov  1 10:06 nagios_systemcommands.frm
-rw-rw---- 1 mysql mysql    10792 Dec 15 09:55 nagios_systemcommands.MYD
-rw-rw---- 1 mysql mysql    12288 Dec 15 10:27 nagios_systemcommands.MYI
-rw-rw---- 1 mysql mysql     8914 Nov  1 10:06 nagios_timedeventqueue.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_timedeventqueue.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_timedeventqueue.MYI
-rw-rw---- 1 mysql mysql     9104 Nov  1 10:06 nagios_timedevents.frm
-rw-rw---- 1 mysql mysql        0 Dec 15 09:55 nagios_timedevents.MYD
-rw-rw---- 1 mysql mysql     1024 Dec 15 09:55 nagios_timedevents.MYI
-rw-rw---- 1 mysql mysql     8760 Nov  1 10:06 nagios_timeperiods.frm
-rw-rw---- 1 mysql mysql      292 Dec 15 09:55 nagios_timeperiods.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_timeperiods.MYI
-rw-rw---- 1 mysql mysql     8794 Nov  1 10:06 nagios_timeperiod_timeranges.frm
-rw-rw---- 1 mysql mysql      651 Dec 15 09:55 nagios_timeperiod_timeranges.MYD
-rw-rw---- 1 mysql mysql     3072 Dec 15 09:55 nagios_timeperiod_timeranges.MYI

/var/lib/mysql/nagiosql:
total 1916
-rw-rw---- 1 mysql mysql     61 Mar 11  2015 db.opt
-rw-rw---- 1 mysql mysql   8870 Jul  9  2015 tbl_command.frm
-rw-rw---- 1 mysql mysql  15412 Dec 15 09:55 tbl_command.MYD
-rw-rw---- 1 mysql mysql  11264 Dec 15 09:55 tbl_command.MYI
-rw-rw---- 1 mysql mysql  18664 Jul  9  2015 tbl_contact.frm
-rw-rw---- 1 mysql mysql   8918 Jul  9  2015 tbl_contactgroup.frm
-rw-rw---- 1 mysql mysql    176 Dec 15 09:55 tbl_contactgroup.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_contactgroup.MYI
-rw-rw---- 1 mysql mysql    776 Dec 15 09:55 tbl_contact.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_contact.MYI
-rw-rw---- 1 mysql mysql  18636 Jul  9  2015 tbl_contacttemplate.frm
-rw-rw---- 1 mysql mysql    192 Dec 15 09:55 tbl_contacttemplate.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_contacttemplate.MYI
-rw-rw---- 1 mysql mysql  21770 Jul  9  2015 tbl_domain.frm
-rw-rw---- 1 mysql mysql    364 Dec 15 09:55 tbl_domain.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_domain.MYI
-rw-rw---- 1 mysql mysql   9258 Jul  9  2015 tbl_hostdependency.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_hostdependency.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 15 09:55 tbl_hostdependency.MYI
-rw-rw---- 1 mysql mysql   9246 Jul  9  2015 tbl_hostescalation.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_hostescalation.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 15 09:55 tbl_hostescalation.MYI
-rw-rw---- 1 mysql mysql  17392 Jul  9  2015 tbl_hostextinfo.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_hostextinfo.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_hostextinfo.MYI
-rw-rw---- 1 mysql mysql  19704 Jul  9  2015 tbl_host.frm
-rw-rw---- 1 mysql mysql  13116 Jul  9  2015 tbl_hostgroup.frm
-rw-rw---- 1 mysql mysql    212 Dec 15 09:55 tbl_hostgroup.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_hostgroup.MYI
-rw-rw---- 1 mysql mysql   4180 Dec 15 09:55 tbl_host.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_host.MYI
-rw-rw---- 1 mysql mysql  19600 Jul  9  2015 tbl_hosttemplate.frm
-rw-rw---- 1 mysql mysql   5108 Dec 15 09:55 tbl_hosttemplate.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_hosttemplate.MYI
-rw-rw---- 1 mysql mysql   8728 Jul  9  2015 tbl_info.frm
-rw-rw---- 1 mysql mysql 119692 Dec 15 09:55 tbl_info.MYD
-rw-rw---- 1 mysql mysql  20480 Dec 15 09:55 tbl_info.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContactgroupToContact.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContactgroupToContactgroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkContactgroupToContactgroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkContactgroupToContactgroup.MYI
-rw-rw---- 1 mysql mysql    153 Dec 15 09:55 tbl_lnkContactgroupToContact.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContactgroupToContact.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContacttemplateToCommandHost.frm
-rw-rw---- 1 mysql mysql     18 Dec 15 09:55 tbl_lnkContacttemplateToCommandHost.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContacttemplateToCommandHost.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContacttemplateToCommandService.frm
-rw-rw---- 1 mysql mysql     18 Dec 15 09:55 tbl_lnkContacttemplateToCommandService.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContacttemplateToCommandService.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContacttemplateToContactgroup.frm
-rw-rw---- 1 mysql mysql      9 Dec 15 09:55 tbl_lnkContacttemplateToContactgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContacttemplateToContactgroup.MYI
-rw-rw---- 1 mysql mysql   8674 Jul  9  2015 tbl_lnkContacttemplateToContacttemplate.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkContacttemplateToContacttemplate.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkContacttemplateToContacttemplate.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContacttemplateToVariabledefinition.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkContacttemplateToVariabledefinition.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkContacttemplateToVariabledefinition.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContactToCommandHost.frm
-rw-rw---- 1 mysql mysql     45 Dec 15 09:55 tbl_lnkContactToCommandHost.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContactToCommandHost.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContactToCommandService.frm
-rw-rw---- 1 mysql mysql     45 Dec 15 09:55 tbl_lnkContactToCommandService.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContactToCommandService.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContactToContactgroup.frm
-rw-rw---- 1 mysql mysql     36 Dec 15 09:55 tbl_lnkContactToContactgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContactToContactgroup.MYI
-rw-rw---- 1 mysql mysql   8674 Jul  9  2015 tbl_lnkContactToContacttemplate.frm
-rw-rw---- 1 mysql mysql     70 Dec 15 09:55 tbl_lnkContactToContacttemplate.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkContactToContacttemplate.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkContactToVariabledefinition.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkContactToVariabledefinition.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkContactToVariabledefinition.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostdependencyToHost_DH.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostdependencyToHost_DH.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostdependencyToHost_DH.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostdependencyToHostgroup_DH.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostdependencyToHostgroup_DH.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostdependencyToHostgroup_DH.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostdependencyToHostgroup_H.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostdependencyToHostgroup_H.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostdependencyToHostgroup_H.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostdependencyToHost_H.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostdependencyToHost_H.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostdependencyToHost_H.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostescalationToContact.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostescalationToContactgroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostescalationToContactgroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostescalationToContactgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostescalationToContact.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostescalationToContact.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostescalationToHost.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostescalationToHostgroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostescalationToHostgroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostescalationToHostgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostescalationToHost.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostescalationToHost.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostgroupToHost.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostgroupToHostgroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostgroupToHostgroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostgroupToHostgroup.MYI
-rw-rw---- 1 mysql mysql    144 Dec 15 09:55 tbl_lnkHostgroupToHost.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHostgroupToHost.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHosttemplateToContact.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHosttemplateToContactgroup.frm
-rw-rw---- 1 mysql mysql     36 Dec 15 09:55 tbl_lnkHosttemplateToContactgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHosttemplateToContactgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHosttemplateToContact.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHosttemplateToContact.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHosttemplateToHost.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHosttemplateToHostgroup.frm
-rw-rw---- 1 mysql mysql      9 Dec 15 09:55 tbl_lnkHosttemplateToHostgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHosttemplateToHostgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHosttemplateToHost.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHosttemplateToHost.MYI
-rw-rw---- 1 mysql mysql   8674 Jul  9  2015 tbl_lnkHosttemplateToHosttemplate.frm
-rw-rw---- 1 mysql mysql    658 Dec 15 09:55 tbl_lnkHosttemplateToHosttemplate.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHosttemplateToHosttemplate.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHosttemplateToVariabledefinition.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHosttemplateToVariabledefinition.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHosttemplateToVariabledefinition.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostToContact.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostToContactgroup.frm
-rw-rw---- 1 mysql mysql    189 Dec 15 09:55 tbl_lnkHostToContactgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHostToContactgroup.MYI
-rw-rw---- 1 mysql mysql     18 Dec 15 09:55 tbl_lnkHostToContact.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHostToContact.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostToHost.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostToHostgroup.frm
-rw-rw---- 1 mysql mysql      9 Dec 15 09:55 tbl_lnkHostToHostgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHostToHostgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkHostToHost.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkHostToHost.MYI
-rw-rw---- 1 mysql mysql   8674 Jul  9  2015 tbl_lnkHostToHosttemplate.frm
-rw-rw---- 1 mysql mysql     28 Dec 15 09:55 tbl_lnkHostToHosttemplate.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHostToHosttemplate.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkHostToVariabledefinition.frm
-rw-rw---- 1 mysql mysql      9 Dec 15 09:55 tbl_lnkHostToVariabledefinition.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkHostToVariabledefinition.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicedependencyToHost_DH.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicedependencyToHost_DH.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicedependencyToHost_DH.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicedependencyToHostgroup_DH.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicedependencyToHostgroup_DH.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicedependencyToHostgroup_DH.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicedependencyToHostgroup_H.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicedependencyToHostgroup_H.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicedependencyToHostgroup_H.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicedependencyToHost_H.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicedependencyToHost_H.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicedependencyToHost_H.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicedependencyToService_DS.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicedependencyToService_DS.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicedependencyToService_DS.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicedependencyToService_S.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicedependencyToService_S.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicedependencyToService_S.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceescalationToContact.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceescalationToContactgroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceescalationToContactgroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceescalationToContactgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceescalationToContact.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceescalationToContact.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceescalationToHost.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceescalationToHostgroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceescalationToHostgroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceescalationToHostgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceescalationToHost.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceescalationToHost.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceescalationToService.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceescalationToService.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceescalationToService.MYI
-rw-rw---- 1 mysql mysql   8684 Jul  9  2015 tbl_lnkServicegroupToService.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicegroupToServicegroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicegroupToServicegroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicegroupToServicegroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicegroupToService.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicegroupToService.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicetemplateToContact.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicetemplateToContactgroup.frm
-rw-rw---- 1 mysql mysql      9 Dec 15 09:55 tbl_lnkServicetemplateToContactgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkServicetemplateToContactgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicetemplateToContact.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicetemplateToContact.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicetemplateToHost.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicetemplateToHostgroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicetemplateToHostgroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicetemplateToHostgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicetemplateToHost.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicetemplateToHost.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicetemplateToServicegroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicetemplateToServicegroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicetemplateToServicegroup.MYI
-rw-rw---- 1 mysql mysql   8674 Jul  9  2015 tbl_lnkServicetemplateToServicetemplate.frm
-rw-rw---- 1 mysql mysql   1036 Dec 15 09:55 tbl_lnkServicetemplateToServicetemplate.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 15 09:55 tbl_lnkServicetemplateToServicetemplate.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServicetemplateToVariabledefinition.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServicetemplateToVariabledefinition.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServicetemplateToVariabledefinition.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceToContact.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceToContactgroup.frm
-rw-rw---- 1 mysql mysql    837 Dec 15 09:55 tbl_lnkServiceToContactgroup.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 15 09:55 tbl_lnkServiceToContactgroup.MYI
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceToContact.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceToContact.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceToHost.frm
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceToHostgroup.frm
-rw-rw---- 1 mysql mysql      9 Dec 15 09:55 tbl_lnkServiceToHostgroup.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkServiceToHostgroup.MYI
-rw-rw---- 1 mysql mysql   3051 Dec 15 09:55 tbl_lnkServiceToHost.MYD
-rw-rw---- 1 mysql mysql   7168 Dec 15 09:55 tbl_lnkServiceToHost.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceToServicegroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceToServicegroup.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceToServicegroup.MYI
-rw-rw---- 1 mysql mysql   8674 Jul  9  2015 tbl_lnkServiceToServicetemplate.frm
-rw-rw---- 1 mysql mysql    112 Dec 15 09:55 tbl_lnkServiceToServicetemplate.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_lnkServiceToServicetemplate.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkServiceToVariabledefinition.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkServiceToVariabledefinition.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkServiceToVariabledefinition.MYI
-rw-rw---- 1 mysql mysql   8604 Jul  9  2015 tbl_lnkTimeperiodToTimeperiod.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_lnkTimeperiodToTimeperiod.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_lnkTimeperiodToTimeperiod.MYI
-rw-rw---- 1 mysql mysql   8720 Jul  9  2015 tbl_logbook.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_logbook.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_logbook.MYI
-rw-rw---- 1 mysql mysql   8690 Jul  9  2015 tbl_mainmenu.frm
-rw-rw---- 1 mysql mysql    260 Dec 15 09:55 tbl_mainmenu.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_mainmenu.MYI
-rw-rw---- 1 mysql mysql   9398 Jul  9  2015 tbl_servicedependency.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_servicedependency.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 15 09:55 tbl_servicedependency.MYI
-rw-rw---- 1 mysql mysql   9306 Jul  9  2015 tbl_serviceescalation.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_serviceescalation.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 15 09:55 tbl_serviceescalation.MYI
-rw-rw---- 1 mysql mysql  13182 Jul  9  2015 tbl_serviceextinfo.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_serviceextinfo.MYD
-rw-rw---- 1 mysql mysql   1024 Dec 15 09:55 tbl_serviceextinfo.MYI
-rw-rw---- 1 mysql mysql  15678 Jul  9  2015 tbl_service.frm
-rw-rw---- 1 mysql mysql  13128 Jul  9  2015 tbl_servicegroup.frm
-rw-rw---- 1 mysql mysql      0 Dec 15 09:55 tbl_servicegroup.MYD
-rw-rw---- 1 mysql mysql   4096 Dec 15 09:55 tbl_servicegroup.MYI
-rw-rw---- 1 mysql mysql  20796 Dec 15 09:55 tbl_service.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_service.MYI
-rw-rw---- 1 mysql mysql  15652 Jul  9  2015 tbl_servicetemplate.frm
-rw-rw---- 1 mysql mysql   7196 Dec 15 09:55 tbl_servicetemplate.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_servicetemplate.MYI
-rw-rw---- 1 mysql mysql   8656 Jul  9  2015 tbl_settings.frm
-rw-rw---- 1 mysql mysql    368 Dec 15 09:55 tbl_settings.MYD
-rw-rw---- 1 mysql mysql   3072 Dec 15 09:55 tbl_settings.MYI
-rw-rw---- 1 mysql mysql   8738 Jul  9  2015 tbl_submenu.frm
-rw-rw---- 1 mysql mysql   1616 Dec 15 09:55 tbl_submenu.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_submenu.MYI
-rw-rw---- 1 mysql mysql   8710 Jul  9  2015 tbl_timedefinition.frm
-rw-rw---- 1 mysql mysql   1444 Dec 15 09:55 tbl_timedefinition.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_timedefinition.MYI
-rw-rw---- 1 mysql mysql   8882 Jul  9  2015 tbl_timeperiod.frm
-rw-rw---- 1 mysql mysql    404 Dec 15 09:55 tbl_timeperiod.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_timeperiod.MYI
-rw-rw---- 1 mysql mysql   8948 Jul  9  2015 tbl_user.frm
-rw-rw---- 1 mysql mysql    204 Dec 15 09:55 tbl_user.MYD
-rw-rw---- 1 mysql mysql   9216 Dec 15 09:55 tbl_user.MYI
-rw-rw---- 1 mysql mysql   8666 Jul  9  2015 tbl_variabledefinition.frm
-rw-rw---- 1 mysql mysql     40 Dec 15 09:55 tbl_variabledefinition.MYD
-rw-rw---- 1 mysql mysql   2048 Dec 15 09:55 tbl_variabledefinition.MYI

/var/lib/mysql/performance_schema:
total 208
-rw-rw---- 1 mysql mysql 8624 Dec 13 10:35 cond_instances.frm
-rw-rw---- 1 mysql mysql   61 Dec 13 10:35 db.opt
-rw-rw---- 1 mysql mysql 9220 Dec 13 10:35 events_waits_current.frm
-rw-rw---- 1 mysql mysql 9220 Dec 13 10:35 events_waits_history.frm
-rw-rw---- 1 mysql mysql 9220 Dec 13 10:35 events_waits_history_long.frm
-rw-rw---- 1 mysql mysql 8878 Dec 13 10:35 events_waits_summary_by_instance.frm
-rw-rw---- 1 mysql mysql 8854 Dec 13 10:35 events_waits_summary_by_thread_by_event_name.frm
-rw-rw---- 1 mysql mysql 8814 Dec 13 10:35 events_waits_summary_global_by_event_name.frm
-rw-rw---- 1 mysql mysql 8654 Dec 13 10:35 file_instances.frm
-rw-rw---- 1 mysql mysql 8800 Dec 13 10:35 file_summary_by_event_name.frm
-rw-rw---- 1 mysql mysql 8840 Dec 13 10:35 file_summary_by_instance.frm
-rw-rw---- 1 mysql mysql 8684 Dec 13 10:35 mutex_instances.frm
-rw-rw---- 1 mysql mysql 8776 Dec 13 10:35 performance_timers.frm
-rw-rw---- 1 mysql mysql 8758 Dec 13 10:35 rwlock_instances.frm
-rw-rw---- 1 mysql mysql 8605 Dec 13 10:35 setup_consumers.frm
-rw-rw---- 1 mysql mysql 8637 Dec 13 10:35 setup_instruments.frm
-rw-rw---- 1 mysql mysql 8650 Dec 13 10:35 setup_timers.frm
-rw-rw---- 1 mysql mysql 8650 Dec 13 10:35 threads.frm

/var/lib/mysql/test:
total 0

Code: Select all

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_polsysmgmt-LogVol00
                      3.8G  977M  2.7G  27% /
tmpfs                 2.9G   12K  2.9G   1% /dev/shm
/dev/sda1             477M   87M  365M  20% /boot
/dev/mapper/vg_polsysmgmt-LogVol09
                      256G  108G  135G  45% /data
/dev/mapper/vg_polsysmgmt-LogVol06
                      1.9G  1.3G  553M  70% /home
/dev/mapper/vg_polsysmgmt-LogVol08
                      9.5G  273M  8.8G   3% /software
/dev/mapper/vg_polsysmgmt-LogVol07
                      1.9G  249M  1.6G  14% /tmp
/dev/mapper/vg_polsysmgmt-LogVol02
                      5.7G  3.7G  1.8G  69% /usr
/dev/mapper/vg_polsysmgmt-LogVol03
                      3.8G  896M  2.8G  25% /usr/local
/dev/mapper/vg_polsysmgmt-LogVol04
                      3.8G  2.7G  930M  75% /var
/dev/mapper/vg_polsysmgmt-LogVol05
                      969M   25M  894M   3% /var/log/audit
tmpfs                 900M  892K  900M   1% /var/nagiosramdisk
Filesystem             Inodes  IUsed    IFree IUse% Mounted on
/dev/mapper/vg_polsysmgmt-LogVol00
                       256000  27233   228767   11% /
tmpfs                  748177      4   748173    1% /dev/shm
/dev/sda1              128016     51   127965    1% /boot
/dev/mapper/vg_polsysmgmt-LogVol09
                     17006592 247958 16758634    2% /data
/dev/mapper/vg_polsysmgmt-LogVol06
                       128000   1933   126067    2% /home
/dev/mapper/vg_polsysmgmt-LogVol08
                       640848   5218   635630    1% /software
/dev/mapper/vg_polsysmgmt-LogVol07
                       128000  25463   102537   20% /tmp
/dev/mapper/vg_polsysmgmt-LogVol02
                       384272  73577   310695   20% /usr
/dev/mapper/vg_polsysmgmt-LogVol03
                       256000   9610   246390    4% /usr/local
/dev/mapper/vg_polsysmgmt-LogVol04
                       256000  18429   237571    8% /var
/dev/mapper/vg_polsysmgmt-LogVol05
                        64000     16    63984    1% /var/log/audit
tmpfs                  748177     14   748163    1% /var/nagiosramdisk
Last edited by tgriep on Thu Dec 15, 2016 9:40 am, edited 1 time in total.
Reason: Added Code Wraps around large output.
Top
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Table './nagios/nagios_contactnotifications' is marked a

Post by tgriep »

It looks like that file from the error exists and that is causing the issue. Try removing the file by running the following,

Code: Select all

rm /var/lib/mysql/nagios/nagios_contactnotifications.TMM
Then run the following to optimize the database and hopefully the issue will be resolved.

Code: Select all

mysqlcheck -o -u root -pp0l9r1s --databases nagios
Be sure to check out our Knowledgebase for helpful articles and solutions!
Top
saptech
Posts: 53
Joined: Thu Dec 10, 2015 11:19 am

Re: Table './nagios/nagios_contactnotifications' is marked a

Post by saptech »

if I remove that file then I get other errors. I tried already many times but still the same
Top
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Table './nagios/nagios_contactnotifications' is marked a

Post by rkennedy »

saptech wrote:if I remove that file then I get other errors. I tried already many times but still the same
Please show us the errors, and the output from the optimize.
Former Nagios Employee
Top
Locked

Return to “Nagios XI”