Nagios/SQL crash of Journal Suppressed messages
Posted: Wed Jul 22, 2020 11:35 am
Running Nagios XI 5.6.14. The application crashed after getting the below message from running out of memory: Message is from the /var/log/messages file
Jul 22 11:01:06 bcnagios01 journal: Suppressed 4150 messages from /system.slice/ndo2db.service
Jul 22 11:01:06 bcnagios01 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (This message repeated until system crashed)
Ran database repair script after hard reboot.
Truncated both the nagios_logentries and nagios_notifications tables and reran the database repair script.
What would be the cause of this issue.
Jul 22 11:01:06 bcnagios01 journal: Suppressed 4150 messages from /system.slice/ndo2db.service
Jul 22 11:01:06 bcnagios01 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (This message repeated until system crashed)
Ran database repair script after hard reboot.
Truncated both the nagios_logentries and nagios_notifications tables and reran the database repair script.
What would be the cause of this issue.