Page 1 of 1
Event Log entries missing again after repair
Posted: Tue Feb 18, 2020 9:47 am
by 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.
Re: Event Log entries missing again after repair
Posted: Tue Feb 18, 2020 10:21 am
by brucej543
Add error from message log file
Re: Event Log entries missing again after repair
Posted: Tue Feb 18, 2020 10:30 am
by brucej543
Do I need to truncate the nagios_logentries table to correct the insert issue?
Re: Event Log entries missing again after repair
Posted: Tue Feb 18, 2020 10:51 am
by brucej543
If I need to truncate the table does nagios need to be halted first (Halt command: " /etc/rc.d/init.d/nagios stop " )
Re: Event Log entries missing again after repair
Posted: Tue Feb 18, 2020 11:34 am
by 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
Re: Event Log entries missing again after repair
Posted: Tue Feb 18, 2020 2:33 pm
by 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