Holland is attempting to backup performance_schema

[m00dawg]

Holland appears to be trying to backup performance_schema on our test box:

2010-10-24 17:22:47,579 [INFO] --- Starting backup run ---
2010-10-24 17:22:47,587 [INFO] Acquired lock /etc/holland/backupsets/default.conf : u'/etc/holland/backupsets/default.conf'
2010-10-24 17:22:47,696 [INFO] Creating backup path /var/spool/holland/default/20101024_172247
2010-10-24 17:22:47,697 [INFO] Estimating size of mysqldump backup
2010-10-24 17:22:47,753 [WARNING] The user specified as a definer ('foo'@'doesnotexist.com') does not exist
2010-10-24 17:22:47,754 [INFO] Estimated Backup Size: 2.29GB
2010-10-24 17:22:47,756 [INFO] Starting backup[default/20101024_172247] via plugin mysqldump
2010-10-24 17:22:47,757 [INFO] Using mysqldump executable: /usr/bin/mysqldump
2010-10-24 17:22:47,767 [INFO] mysqldump version 5.5.6
2010-10-24 17:22:47,769 [INFO] Using /bin/gzip compression level 1
2010-10-24 17:22:47,770 [INFO] Wrote backup manifest /var/spool/holland/default/20101024_172247/backup_data/MANIFEST.txt
2010-10-24 17:22:47,777 [INFO] Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20101024_172247/my.cnf --single-transaction benchmark
2010-10-24 17:22:52,754 [INFO] Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20101024_172247/my.cnf --lock-tables mysql
2010-10-24 17:22:52,944 [INFO] Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20101024_172247/my.cnf --lock-tables performance_schema
2010-10-24 17:22:52,990 [ERROR] /usr/bin/mysqldump[32685]: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'COND_INSTANCES' when using LOCK TABLES
2010-10-24 17:22:52,991 [ERROR] Backup failed after 5.30 seconds
2010-10-24 17:22:53,026 [INFO] Purged failed backup: default/20101024_172247
2010-10-24 17:22:53,026 [ERROR] Backup failed: mysqldump exited with non-zero status 2
2010-10-24 17:22:53,026 [INFO] Released lock /etc/holland/backupsets/default.conf

I resolved the issue by manually skipping performance_schema from the backup, though I suspect we will want to account for this in Holland, perhaps by checking to see if the version of MySQL is 5.5 or later and to auto-filter it.

[Andrew Garner (abg)]

Fix committed to master here:

https://github.com/holland-backup/holland/commit/a8f6f5d67c2d99f1d75f6448d81c3a4e7ccd1e85