xi event logs page blank

mrjsokol · Post by **mrjsokol** » Wed Nov 03, 2021 7:48 am

Good morning all,

We have an issue we noticed in 5.8.6 of xi that our event logs are showing blank. We do not know how long this issue persisted as we do not often use this page. See SS attached.

Post by **pbroste** » Wed Nov 03, 2021 2:07 pm

Hello @mrjsokol

Thanks for reaching out, took a look through solutions related to this issue and see that we need to take a look at your environment using your System Profile so we can narrow things down.

Please provide the results on the following and PM your updated system profile for us to review.

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

To send us your system profile.

Login to the Nagios xi GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and send via Private Message

Thanks,
Perry

mrjsokol · Post by **mrjsokol** » Thu Nov 11, 2021 9:53 am

Sent a profile and waiting for infrastructure to run the SQL statement.

Post by **pbroste** » Thu Nov 11, 2021 1:18 pm

Hello @mrjsokol

Thanks for sending over the system profile, after review we see that there are database errors and want to start by running through the database repair.

Let's start off by looking through the columns to make sure that there isn't anything exceedingly large.

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

run through the database repair.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

[/list]

Let us know how things are looking.

Thanks,
Perry

mrjsokol · Post by **mrjsokol** » Fri Nov 12, 2021 11:35 am

Sent a pm of the SQL results and the repair script was ran prior to making the post.

Post by **pbroste** » Fri Nov 12, 2021 2:19 pm

Hello @mrjsokol

Followed up with a pm reply, please follow up on this thread when you have sent the requested info.

Thanks
Perry

Post by **pbroste** » Tue Nov 16, 2021 3:03 pm

Hello @mrjsokol

Thanks for following up and sending over the updated System Profile, we see that the 'logs' table did not get repaired due to the size.

You will need to truncate these tables then run the repair on the database. Example:

Code: Select all

mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_logentries'

Note: You will lose the historical data that was stored in these tables.

For more info, read the following document:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Thanks,
Perry

mrjsokol · Post by **mrjsokol** » Thu Nov 18, 2021 3:44 pm

Good evening,

After truncating the table we made some progress! We now are seeing events show up in the events but seeing the following for most events
See attachment

Post by **pbroste** » Fri Nov 19, 2021 12:48 pm

Hello @mrjsokol

Sounds like progress, let's take a look at the updated System Profile to see what is going on.

To send us your system profile.

Login to the Nagios xi GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and send via Private Message

Thanks,
Perry

mrjsokol · Post by **mrjsokol** » Tue Nov 23, 2021 2:08 pm

Hey Perry sorry for the delay. I have sent you the latest profile.

Nagios Support Forum

xi event logs page blank

xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank

Re: xi event logs page blank