** Changed in: holland-backup
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Holland
Discuss, which is subscribed to holland-backup.
https://bugs.launchpad.net/bugs/666259
Title:
Holland is attempting to backup performance_schema
Status in Holland Backup Framework:
Fix Released
Bug description:
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.
_______________________________________________
Mailing list: https://launchpad.net/~holland-coredev
Post to : [email protected]
Unsubscribe : https://launchpad.net/~holland-coredev
More help : https://help.launchpad.net/ListHelp
