The issue: when drilling down into a service or host, and getting to the part where it allows you to view the status details, force an immediate recheck, acknowledge an alarm, etc., the page loads take 1-2 minutes. This started a couple weeks ago. I attempted to log onto the web portal to configure a new monitor and it gave me an alert saying to run /usr/local/nagiosxi/scripts/repair_databases.sh. I received the following output:
===============
REPAIR COMPLETE
===============
=======================
nagios database repair succeeded
nagiosql database repair succeeded
nagiosxi database repair succeeded
After running that script and was able to get in to the interface, but then I noticed that the monitors were having this issue of incredibly slow load times.
I came across this thread and began running through the things suggested (https://support.nagios.com/forum/viewto ... 16&t=39176). I set the internal program URL to its inside IP on the AWS instance, and left the external program URL with the host name that I'm accessing the instance with remotely. That had no change.
I then checked /var/log/mariadb.log and found the following:
Code: Select all
171031 08:39:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
171031 8:39:31 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 2147 ...
171031 8:39:33 InnoDB: The InnoDB memory heap is disabled
171031 8:39:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171031 8:39:33 InnoDB: Compressed tables use zlib 1.2.7
171031 8:39:33 InnoDB: Using Linux native AIO
171031 8:39:34 InnoDB: Initializing buffer pool, size = 128.0M
171031 8:39:34 InnoDB: Completed initialization of buffer pool
171031 8:39:34 InnoDB: highest supported file format is Barracuda.
171031 8:39:37 InnoDB: Waiting for the background threads to start
171031 8:39:38 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence number 1633177
171031 8:39:38 [Note] Plugin 'FEEDBACK' is disabled.
171031 8:39:39 [Note] Server socket created on IP: '0.0.0.0'.
171031 8:39:44 [Note] Event Scheduler: Loaded 0 events
171031 8:39:44 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.56-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
171031 8:39:49 [ERROR] mysqld: Table './nagios/nagios_conninfo' is marked as crashed and should be repaired
171031 8:39:49 [Warning] Checking table: './nagios/nagios_conninfo'
171031 8:39:51 [ERROR] mysqld: Table './nagios/nagios_programstatus' is marked as crashed and should be repaired
171031 8:39:51 [Warning] Checking table: './nagios/nagios_programstatus'
171031 8:39:51 [ERROR] mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
171031 8:39:51 [Warning] Checking table: './nagios/nagios_hoststatus'
171031 8:39:51 [ERROR] mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
171031 8:39:51 [Warning] Checking table: './nagios/nagios_servicestatus'
171031 8:39:51 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and should be repaired
171031 8:39:51 [Warning] Checking table: './nagios/nagios_logentries'
171031 8:40:01 [ERROR] mysqld: Table './nagios/nagios_systemcommands' is marked as crashed and should be repaired
171031 8:40:01 [Warning] Checking table: './nagios/nagios_systemcommands'
171031 8:40:01 [ERROR] mysqld: Table './nagios/nagios_eventhandlers' is marked as crashed and should be repaired
171031 8:40:01 [Warning] Checking table: './nagios/nagios_eventhandlers'
171031 8:40:01 [ERROR] mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
171031 8:40:01 [Warning] Checking table: './nagios/nagios_customvariablestatus'
171031 8:40:09 [ERROR] mysqld: Table './nagiosxi/xi_sysstat' is marked as crashed and should be repaired
171031 8:40:09 [ERROR] mysqld: Table './nagiosxi/xi_meta' is marked as crashed and should be repaired
171031 8:40:09 [Warning] Checking table: './nagiosxi/xi_sysstat'
171031 8:40:09 [ERROR] mysqld: Table './nagiosxi/xi_eventqueue' is marked as crashed and should be repaired
171031 8:40:09 [Warning] Checking table: './nagiosxi/xi_meta'
171031 8:40:10 [Warning] Checking table: './nagiosxi/xi_eventqueue'
171031 8:40:12 [ERROR] mysqld: Table './nagios/nagios_notifications' is marked as crashed and should be repaired
171031 8:40:12 [Warning] Checking table: './nagios/nagios_notifications'
171031 8:40:12 [ERROR] mysqld: Table './nagios/nagios_contactnotifications' is marked as crashed and should be repaired
171031 8:40:12 [Warning] Checking table: './nagios/nagios_contactnotifications'
171031 8:40:12 [ERROR] mysqld: Table './nagios/nagios_contactnotificationmethods' is marked as crashed and should be repaired
171031 8:40:12 [Warning] Checking table: './nagios/nagios_contactnotificationmethods'
171031 8:40:12 [ERROR] mysqld: Table './nagios/nagios_statehistory' is marked as crashed and should be repaired
171031 8:40:12 [Warning] Checking table: './nagios/nagios_statehistory'
171031 8:40:13 [ERROR] mysqld: Table './nagiosxi/xi_events' is marked as crashed and should be repaired
171031 8:40:13 [Warning] Checking table: './nagiosxi/xi_events'