XI 2012R1.2 error MySQL backup table 'cond_instances'

[david_sloboda]

After the upgrade to XI 2012R1.2
I see the following error in email from /root/scripts/automysqlbackup

Code: Select all

###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES

The error looks similar to this forum post
http://support.nagios.com/forum/viewtop ... 39&p=32489
and this forum post
http://support.nagios.com/forum/viewtop ... 52&p=36865
However, the table name is different.

I first saw the same error with the dbase information_schema reported by other forum members.
I edited /root/scripts/automysqlbackup to exclude information_schema and that specific error went away.

The error now shows up in a second dbase named performance_schema in a table cond_instances

I have edited /root/scripts/automysqlbackup to also exclude performance_schema and I will see if that resolves the issue.

Code: Select all

# List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)
DBEXCLUDE="information_schema performance_schema"

Code: Select all

[root@nagiosxi-dev-mtl ~]# mysql --version
mysql  Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
[root@nagiosxi-dev-mtl ~]#

I have read the "Repairing The Nagios XI Database" doc
http://exchange.nagios.org/directory/Do ... se/details
and run this script mentioned there
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
This does not appear to have resolved the issue.

David Sloboda

[scottwilkerson]

I have edited /root/scripts/automysqlbackup to also exclude performance_schema and I will see if that resolves the issue.

Code: Select all

# List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)
DBEXCLUDE="information_schema performance_schema"

This should fix it.

performance_schema was recently added in mysql

[david_sloboda]

All Better.

I confirm that adding performance_schema to the list of excluded databases in /root/scripts/automysqlbackup allows the mysql backup to run without error.

I am very glad to have the Forum to help diagnose and fix these issues.
Thanks!