holland-coredev team mailing list archive

[Andrew Garner <666259@xxxxxxxxxxxxxxxxxx>]

** 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.