Event Log entries missing again after repair

[brucej543]

From previous post: the event log are not show again. Less the 30 minutes after the repair database script was run the issue has returned. The output of the mariaDB log is attached.

[brucej543]

Add error from message log file

[brucej543]

Do I need to truncate the nagios_logentries table to correct the insert issue?

[brucej543]

If I need to truncate the table does nagios need to be halted first (Halt command: " /etc/rc.d/init.d/nagios stop " )

[brucej543]

Run the truncating of both the nagios_logentries and nagios_notifications table and reran the repair database. I will monitor system and report status later

[benjaminsmith]

Hi Bruce,

Run the truncating of both the nagios_logentries and nagios_notifications table and reran the repair database. I will monitor system and report status later

Sounds good. We'll keep this open. If you continue to have issues, please post the output of the command below to check the database table sizes.

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table