holland-coredev team mailing list archive

[m00dawg <tim@xxxxxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: holland-backup
     Importance: Undecided
         Status: New

-- 
Holland is attempting to backup performance_schema
https://bugs.launchpad.net/bugs/666259
You received this bug notification because you are a member of Holland
Developers, which is the registrant for holland-backup.

Status in Holland Backup Framework: New

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.