Page 2 of 3
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Tue Oct 01, 2019 4:42 pm
by rferebee
Tried the supplied fix, still seeing error.
Here is the output you requested:
Code: Select all
root@nagiostest:/tmp/postgresql_backup/data>tail -f /var/log/mysqld.log /var/log/mariadb/mariadb.log
tail: cannot open ‘/var/log/mysqld.log’ for reading: No such file or directory
==> /var/log/mariadb/mariadb.log <==
191001 13:34:17 InnoDB: Completed initialization of buffer pool
191001 13:34:17 InnoDB: highest supported file format is Barracuda.
191001 13:34:17 InnoDB: Waiting for the background threads to start
191001 13:34:18 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 60789451
191001 13:34:18 [Note] Plugin 'FEEDBACK' is disabled.
191001 13:34:18 [Note] Server socket created on IP: '0.0.0.0'.
191001 13:34:18 [Note] Event Scheduler: Loaded 0 events
191001 13:34:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
191001 14:40:25 [Note] Found 651366 of 0 rows when repairing './nagios/nagios_logentries'
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Tue Oct 01, 2019 4:52 pm
by scottwilkerson
That no longer is an error, it is just a note from the repair
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Tue Oct 01, 2019 4:53 pm
by rferebee
I guess what I should say is that I'm still seeing the crashed table alert in the XI interface.
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Tue Oct 01, 2019 4:55 pm
by scottwilkerson
rferebee wrote:I guess what I should say is that I'm still seeing the crashed table alert in the XI interface.
What plugin are you running for that service as it is not a default plugin
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Tue Oct 01, 2019 4:57 pm
by rferebee
When I run this check on the server itself, it says everything is OK.
Code: Select all
/usr/local/nagios/libexec/box293_check_mysql_table_status nagios root nagiosxi
Database "nagios" = All OK
However, the service checks for this database in XI are all showing that the table is crashed. All my servers did this at the same time yesterday. See screen shot from original post.
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Tue Oct 01, 2019 5:09 pm
by scottwilkerson
looks like that script is making the following call, can you post the output of
Code: Select all
echo "show table status in nagios\G;"|mysql -B -uroot -pnagiosxi
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Tue Oct 01, 2019 5:11 pm
by rferebee
Code: Select all
root@nagiostest:/root>echo "show table status in nagios\G;"|mysql -B -uroot -pnagiosxi
*************************** 1. row ***************************
Name: nagios_acknowledgements
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1429
Avg_row_length: 83
Data_length: 119824
Max_data_length: 281474976710655
Index_length: 48128
Data_free: 0
Auto_increment: 1430
Create_time: 2019-10-01 13:33:21
Update_time: 2019-10-01 13:33:21
Check_time: 2019-10-01 13:35:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current and historical host and service acknowledgements
*************************** 2. row ***************************
Name: nagios_commands
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 228
Avg_row_length: 92
Data_length: 21048
Max_data_length: 281474976710655
Index_length: 10240
Data_free: 0
Auto_increment: 3077054
Create_time: 2019-10-01 13:33:21
Update_time: 2019-10-01 14:40:02
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Command definitions
*************************** 3. row ***************************
Name: nagios_commenthistory
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 124331
Avg_row_length: 252
Data_length: 31415988
Max_data_length: 281474976710655
Index_length: 3834880
Data_free: 0
Auto_increment: 397936
Create_time: 2019-10-01 13:33:21
Update_time: 2019-10-01 15:01:01
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical host and service comments
*************************** 4. row ***************************
Name: nagios_comments
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 763
Avg_row_length: 112
Data_length: 85552
Max_data_length: 281474976710655
Index_length: 26624
Data_free: 0
Auto_increment: 4436687
Create_time: 2019-10-01 13:33:23
Update_time: 2019-10-01 15:01:01
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
*************************** 5. row ***************************
Name: nagios_configfiles
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1
Avg_row_length: 44
Data_length: 44
Max_data_length: 281474976710655
Index_length: 5120
Data_free: 0
Auto_increment: 15199
Create_time: 2019-10-01 13:33:23
Update_time: 2019-10-01 13:37:03
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Configuration files
*************************** 6. row ***************************
Name: nagios_configfilevariables
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 131
Avg_row_length: 53
Data_length: 6988
Max_data_length: 281474976710655
Index_length: 4096
Data_free: 0
Auto_increment: 1991015
Create_time: 2019-10-01 13:33:23
Update_time: 2019-10-01 14:40:02
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Configuration file variables
*************************** 7. row ***************************
Name: nagios_conninfo
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 15439
Avg_row_length: 87
Data_length: 1345248
Max_data_length: 281474976710655
Index_length: 160768
Data_free: 0
Auto_increment: 15440
Create_time: 2019-10-01 13:33:23
Update_time: 2019-10-01 15:09:33
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: NDO2DB daemon connection information
*************************** 8. row ***************************
Name: nagios_contact_addresses
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 281474976710655
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:23
Update_time: 2019-10-01 13:33:23
Check_time: 2019-10-01 13:35:04
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Contact addresses
*************************** 9. row ***************************
Name: nagios_contact_notificationcommands
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 2424
Avg_row_length: 22
Data_length: 53328
Max_data_length: 281474976710655
Index_length: 54272
Data_free: 0
Auto_increment: 22553270
Create_time: 2019-10-01 13:33:23
Update_time: 2019-10-01 13:37:06
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Contact host and service notification commands
*************************** 10. row ***************************
Name: nagios_contactgroup_members
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 418
Avg_row_length: 15
Data_length: 6270
Max_data_length: 4222124650659839
Index_length: 15360
Data_free: 0
Auto_increment: 3262742
Create_time: 2019-10-01 13:33:24
Update_time: 2019-10-01 13:37:06
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Contactgroup members
*************************** 11. row ***************************
Name: nagios_contactgroups
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 48
Avg_row_length: 35
Data_length: 1684
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 0
Auto_increment: 626470
Create_time: 2019-10-01 13:33:24
Update_time: 2019-10-01 14:40:02
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Contactgroup definitions
*************************** 12. row ***************************
Name: nagios_contactnotificationmethods
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 120231
Avg_row_length: 43
Data_length: 5266548
Max_data_length: 281474976710655
Index_length: 5481472
Data_free: 440
Auto_increment: 1001950
Create_time: 2019-10-01 13:33:24
Update_time: 2019-10-01 15:05:01
Check_time: 2019-10-01 14:40:02
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical record of contact notification methods
*************************** 13. row ***************************
Name: nagios_contactnotifications
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 120226
Avg_row_length: 39
Data_length: 4689204
Max_data_length: 10977524091715583
Index_length: 6701056
Data_free: 390
Auto_increment: 1001754
Create_time: 2019-10-01 13:33:25
Update_time: 2019-10-01 15:05:01
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical record of contact notifications
*************************** 14. row ***************************
Name: nagios_contacts
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 202
Avg_row_length: 92
Data_length: 18692
Max_data_length: 281474976710655
Index_length: 8192
Data_free: 0
Auto_increment: 1879441
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 14:40:03
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Contact definitions
*************************** 15. row ***************************
Name: nagios_contactstatus
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 202
Avg_row_length: 51
Data_length: 10302
Max_data_length: 14355223812243455
Index_length: 7168
Data_free: 0
Auto_increment: 1883643
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 13:37:05
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Contact status
*************************** 16. row ***************************
Name: nagios_customvariables
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1413
Avg_row_length: 41
Data_length: 57984
Max_data_length: 281474976710655
Index_length: 54272
Data_free: 0
Auto_increment: 8620855
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 14:40:03
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Custom variables
*************************** 17. row ***************************
Name: nagios_customvariablestatus
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1413
Avg_row_length: 48
Data_length: 68312
Max_data_length: 281474976710655
Index_length: 50176
Data_free: 0
Auto_increment: 8683476
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 15:10:07
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Custom variable status information
*************************** 18. row ***************************
Name: nagios_dbversion
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1
Avg_row_length: 20
Data_length: 20
Max_data_length: 281474976710655
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 13:33:26
Check_time: 2019-10-01 13:35:04
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
*************************** 19. row ***************************
Name: nagios_downtimehistory
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 26729
Avg_row_length: 123
Data_length: 3301000
Max_data_length: 281474976710655
Index_length: 949248
Data_free: 0
Auto_increment: 26730
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 15:01:01
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical scheduled host and service downtime
*************************** 20. row ***************************
Name: nagios_eventhandlers
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 9
Avg_row_length: 326
Data_length: 3580
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 640
Auto_increment: 2157824
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 15:10:01
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical host and service event handlers
*************************** 21. row ***************************
Name: nagios_externalcommands
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 113
Avg_row_length: 146
Data_length: 17756
Max_data_length: 281474976710655
Index_length: 4096
Data_free: 1204
Auto_increment: 24625
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 15:05:01
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical record of processed external commands
*************************** 22. row ***************************
Name: nagios_flappinghistory
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 36355
Avg_row_length: 65
Data_length: 2363075
Max_data_length: 18295873486192639
Index_length: 374784
Data_free: 0
Auto_increment: 36356
Create_time: 2019-10-01 13:33:26
Update_time: 2019-10-01 14:34:41
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current and historical record of host and service flapping
*************************** 23. row ***************************
Name: nagios_host_contactgroups
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 968
Avg_row_length: 15
Data_length: 14520
Max_data_length: 4222124650659839
Index_length: 27648
Data_free: 0
Auto_increment: 8161436
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:37:07
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Host contact groups
*************************** 24. row ***************************
Name: nagios_host_contacts
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 426
Avg_row_length: 15
Data_length: 6390
Max_data_length: 4222124650659839
Index_length: 16384
Data_free: 0
Auto_increment: 4037365
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:37:07
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
*************************** 25. row ***************************
Name: nagios_host_parenthosts
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 8
Avg_row_length: 15
Data_length: 120
Max_data_length: 4222124650659839
Index_length: 3072
Data_free: 0
Auto_increment: 1018366
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:37:06
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Parent hosts
*************************** 26. row ***************************
Name: nagios_hostchecks
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 281474976710655
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:33:27
Check_time: 2019-10-01 13:35:04
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical host checks
*************************** 27. row ***************************
Name: nagios_hostdependencies
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 8725724278030335
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:33:27
Check_time: 2019-10-01 13:35:04
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Host dependency definitions
*************************** 28. row ***************************
Name: nagios_hostescalation_contactgroups
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 1194
Avg_row_length: 15
Data_length: 17910
Max_data_length: 4222124650659839
Index_length: 32768
Data_free: 0
Auto_increment: 5519569
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:37:10
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Host escalation contact groups
*************************** 29. row ***************************
Name: nagios_hostescalation_contacts
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 4222124650659839
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:33:27
Check_time: 2019-10-01 13:35:04
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
*************************** 30. row ***************************
Name: nagios_hostescalations
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 1191
Avg_row_length: 35
Data_length: 41685
Max_data_length: 9851624184872959
Index_length: 47104
Data_free: 0
Auto_increment: 5432296
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:37:10
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Host escalation definitions
*************************** 31. row ***************************
Name: nagios_hostgroup_members
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 1394
Avg_row_length: 15
Data_length: 20910
Max_data_length: 4222124650659839
Index_length: 40960
Data_free: 0
Auto_increment: 13675627
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:37:07
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Hostgroup members
*************************** 32. row ***************************
Name: nagios_hostgroups
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 181
Avg_row_length: 38
Data_length: 6980
Max_data_length: 281474976710655
Index_length: 8192
Data_free: 0
Auto_increment: 2067859
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 14:40:03
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Hostgroup definitions
*************************** 33. row ***************************
Name: nagios_hosts
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 594
Avg_row_length: 179
Data_length: 106476
Max_data_length: 281474976710655
Index_length: 25600
Data_free: 0
Auto_increment: 6066797
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 14:40:03
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Host definitions
*************************** 34. row ***************************
Name: nagios_hoststatus
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 594
Avg_row_length: 320
Data_length: 190748
Max_data_length: 281474976710655
Index_length: 136192
Data_free: 300
Auto_increment: 6093903
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 15:10:03
Check_time: 2019-10-01 14:40:03
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current host status information
*************************** 35. row ***************************
Name: nagios_instances
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1
Avg_row_length: 20
Data_length: 20
Max_data_length: 281474976710655
Index_length: 2048
Data_free: 0
Auto_increment: 2
Create_time: 2019-10-01 13:33:27
Update_time: 2019-10-01 13:33:27
Check_time: 2019-10-01 13:35:04
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Location names of various Nagios installations
*************************** 36. row ***************************
Name: nagios_logentries
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 651359
Avg_row_length: 148
Data_length: 96499636
Max_data_length: 281474976710655
Index_length: 49786880
Data_free: 1632
Auto_increment: 21989675
Create_time: 2019-10-01 14:40:20
Update_time: 2019-10-01 15:10:01
Check_time: 2019-10-01 14:40:25
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical record of log entries
*************************** 37. row ***************************
Name: nagios_notifications
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 49611
Avg_row_length: 144
Data_length: 7193052
Max_data_length: 281474976710655
Index_length: 2978816
Data_free: 4212
Auto_increment: 2278312
Create_time: 2019-10-01 13:33:38
Update_time: 2019-10-01 15:10:01
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical record of host and service notifications
*************************** 38. row ***************************
Name: nagios_objects
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 13038
Avg_row_length: 42
Data_length: 559092
Max_data_length: 281474976710655
Index_length: 573440
Data_free: 0
Auto_increment: 13039
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:10
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current and historical objects of all kinds
*************************** 39. row ***************************
Name: nagios_processevents
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 11443
Avg_row_length: 51
Data_length: 594160
Max_data_length: 281474976710655
Index_length: 119808
Data_free: 0
Auto_increment: 73808
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:14
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical Nagios process events
*************************** 40. row ***************************
Name: nagios_programstatus
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1
Avg_row_length: 128
Data_length: 128
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 0
Auto_increment: 15059
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 15:10:03
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current program status information
*************************** 41. row ***************************
Name: nagios_runtimevariables
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 18
Avg_row_length: 44
Data_length: 808
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 0
Auto_increment: 270595
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:14
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Runtime variables from the Nagios daemon
*************************** 42. row ***************************
Name: nagios_scheduleddowntime
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 34
Avg_row_length: 106
Data_length: 3624
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 0
Auto_increment: 375915
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 15:01:01
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current scheduled host and service downtime
*************************** 43. row ***************************
Name: nagios_service_contactgroups
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 6681
Avg_row_length: 15
Data_length: 100215
Max_data_length: 4222124650659839
Index_length: 166912
Data_free: 0
Auto_increment: 62585457
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:10
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Service contact groups
*************************** 44. row ***************************
Name: nagios_service_contacts
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 2315
Avg_row_length: 15
Data_length: 34725
Max_data_length: 4222124650659839
Index_length: 64512
Data_free: 0
Auto_increment: 10960145
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:10
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
*************************** 45. row ***************************
Name: nagios_service_parentservices
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 4222124650659839
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:33:39
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Parent services
*************************** 46. row ***************************
Name: nagios_servicechecks
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 281474976710655
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:33:39
Check_time: 2019-10-01 13:35:09
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical service checks
*************************** 47. row ***************************
Name: nagios_servicedependencies
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 9288674231451647
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:33:39
Check_time: 2019-10-01 13:35:09
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Service dependency definitions
*************************** 48. row ***************************
Name: nagios_serviceescalation_contactgroups
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 8141
Avg_row_length: 15
Data_length: 122115
Max_data_length: 4222124650659839
Index_length: 207872
Data_free: 0
Auto_increment: 27316442
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:12
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Service escalation contact groups
*************************** 49. row ***************************
Name: nagios_serviceescalation_contacts
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 4222124650659839
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:33:39
Check_time: 2019-10-01 13:35:09
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
*************************** 50. row ***************************
Name: nagios_serviceescalations
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 8140
Avg_row_length: 37
Data_length: 301180
Max_data_length: 10414574138294271
Index_length: 313344
Data_free: 0
Auto_increment: 27311645
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:12
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Service escalation definitions
*************************** 51. row ***************************
Name: nagios_servicegroup_members
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 1267
Avg_row_length: 15
Data_length: 19005
Max_data_length: 4222124650659839
Index_length: 36864
Data_free: 0
Auto_increment: 2116186
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:10
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Servicegroup members
*************************** 52. row ***************************
Name: nagios_servicegroups
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 13
Avg_row_length: 40
Data_length: 524
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 0
Auto_increment: 127096
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 13:37:10
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Servicegroup definitions
*************************** 53. row ***************************
Name: nagios_services
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 4070
Avg_row_length: 168
Data_length: 684332
Max_data_length: 281474976710655
Index_length: 145408
Data_free: 0
Auto_increment: 37273558
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 14:40:08
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Service definitions
*************************** 54. row ***************************
Name: nagios_servicestatus
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 4070
Avg_row_length: 310
Data_length: 1264860
Max_data_length: 281474976710655
Index_length: 768000
Data_free: 444
Auto_increment: 37552471
Create_time: 2019-10-01 13:33:39
Update_time: 2019-10-01 15:10:07
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current service status information
*************************** 55. row ***************************
Name: nagios_statehistory
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1715823
Avg_row_length: 101
Data_length: 174472684
Max_data_length: 281474976710655
Index_length: 59600896
Data_free: 0
Auto_increment: 2688437
Create_time: 2019-10-01 13:33:40
Update_time: 2019-10-01 15:07:15
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical host and service state changes
*************************** 56. row ***************************
Name: nagios_systemcommands
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 84
Avg_row_length: 169
Data_length: 27128
Max_data_length: 281474976710655
Index_length: 11264
Data_free: 12852
Auto_increment: 42882522
Create_time: 2019-10-01 13:34:01
Update_time: 2019-10-01 15:10:03
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical system commands that are executed
*************************** 57. row ***************************
Name: nagios_timedeventqueue
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 9851624184872959
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:34:01
Update_time: 2019-10-01 13:34:01
Check_time: 2019-10-01 13:35:15
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Current Nagios event queue
*************************** 58. row ***************************
Name: nagios_timedevents
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 16607023625928703
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2019-10-01 13:34:01
Update_time: 2019-10-01 13:34:01
Check_time: 2019-10-01 13:35:15
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Historical events from the Nagios event queue
*************************** 59. row ***************************
Name: nagios_timeperiod_timeranges
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 1602
Avg_row_length: 21
Data_length: 33642
Max_data_length: 5910974510923775
Index_length: 52224
Data_free: 0
Auto_increment: 16265570
Create_time: 2019-10-01 13:34:01
Update_time: 2019-10-01 13:37:06
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Timeperiod definitions
*************************** 60. row ***************************
Name: nagios_timeperiods
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 223
Avg_row_length: 47
Data_length: 10540
Max_data_length: 281474976710655
Index_length: 10240
Data_free: 0
Auto_increment: 2239426
Create_time: 2019-10-01 13:34:01
Update_time: 2019-10-01 14:40:08
Check_time: 2019-10-01 14:40:08
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Timeperiod definitions
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Wed Oct 02, 2019 6:40 am
by scottwilkerson
I don't see any problems, how often does this service check run?
what if you run this as the nagios user?
Code: Select all
su nagios -c '/usr/local/nagios/libexec/box293_check_mysql_table_status nagios root nagiosxi'
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Wed Oct 02, 2019 9:19 am
by rferebee
Yes, I agree. There doesn't seem to be an issue, but the check is still returning that the table is crashed. The check interval is 5 minutes.
When I run the command you provided it returns that all databases are OK.
Re: Unable to get 'nagios_logentries' DB to recover
Posted: Wed Oct 02, 2019 11:40 am
by scottwilkerson
Can you show the output of the following