This support forum board is for support questions relating to
Nagios XI , our flagship commercial network monitoring solution.
ssax
Dreams In Code
Posts: 7682 Joined: Wed Feb 11, 2015 12:54 pm
Post
by ssax » Mon Apr 06, 2020 2:55 pm
Please send the output of these commands (as root):
- NOTE: You may need to adjust the -uroot, and -pnagiosxi in the commands if you've changed the root mysql password
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
Code: Select all
echo "DESC xi_usermeta;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi --table
ssax
Dreams In Code
Posts: 7682 Joined: Wed Feb 11, 2015 12:54 pm
Post
by ssax » Mon Apr 06, 2020 3:03 pm
In addition to my previous post (send me that info as well, I need it), please run this command as root and PM me the resulting
/tmp/xi_usermeta.tar.gz file:
Code: Select all
mysqldump -h 127.0.0.1 -uroot -pnagiosxi nagiosxi xi_usermeta --add-drop-table > /tmp/xi_usermeta.sql
tar -czf /tmp/xi_usermeta.tar.gz /tmp/xi_usermeta.sql
Thank you
ssax
Dreams In Code
Posts: 7682 Joined: Wed Feb 11, 2015 12:54 pm
Post
by ssax » Thu Apr 09, 2020 1:37 pm
Please create a ticket for this and
include a link back to this forum thread so we can get a remote session setup:
https://support.nagios.com/tickets/
shoreypu
Posts: 134 Joined: Wed Mar 13, 2019 2:06 pm
Post
by shoreypu » Wed Apr 15, 2020 7:31 am
Support request opened.
Of note, I upgraded to 5.6.13 yesterday, as part of our normal maintenance, but this problem still exists.
ssax
Dreams In Code
Posts: 7682 Joined: Wed Feb 11, 2015 12:54 pm
Post
by ssax » Wed Apr 15, 2020 10:15 am
Ok, thanks for the update. Locking thread, ticket received, we will continue support through the ticket.