Bug #39655 The mysql_upgrade process does not remove old online_backup tables.

• Submitted: 25 Sep 2008 19:21
• Modified: 26 Mar 2009 23:49
• Reporter: Chuck Bell
• Status: Closed
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 6.0.8
• OS: Any
• Assigned to: Chuck Bell
• CPU Architecture: Any

[25 Sep 2008 19:21] Chuck Bell

Description:
If a user has installed version 6.0.7 or prior, the mysql_upgrade process does not remove the old backup logging tables.

It should remove:

mysql.online_backup
mysql.online_backup_progress

How to repeat:
Install an earlier version of mysql prior to WL#4296 implementation (6.0.7 or earlier).

Download latest code and compile.

Run mysql_upgrade.

Observe old tables still in the mysql database along with new tables.

Suggested fix:
Add the following to the the mysql_upgrade scripts that process the tables in the mysql database.

DROP TABLE IF EXISTS mysql.online_backup;
DROP TABLE IF EXISTS mysql.online_backup_progress;

[26 Sep 2008 5:47] Sveta Smirnova

Thank you for the report.

Verified as described.

[3 Mar 2009 21:24] Chuck Bell

Reviewers assigned.

[3 Mar 2009 22:25] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68150

2783 Chuck Bell	2009-03-03
      BUG#39655 : The mysql_upgrade process does not remove old online_backup tables
      
      This patch adds to the scripts mysql_upgrade uses to
      upgrade the mysql database tables. Specifically, it
      adds the drops to drop the old mysql online backup
      progress tables (online_backup, online_backup_progress).
      added:
        mysql-test/suite/backup/r/backup_mysql_upgrade.result
        mysql-test/suite/backup/t/backup_mysql_upgrade.test
      modified:
        scripts/mysql_system_tables.sql

[4 Mar 2009 16:19] Hema Sridharan

Patch approved

[5 Mar 2009 6:36] Rafal Somla

Good to push.

[5 Mar 2009 22:08] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68433

2788 Chuck Bell	2009-03-05
      BUG#39655 : The mysql_upgrade process does not remove old online_backup tables
      
      This patch adds to the scripts mysql_upgrade uses to
      upgrade the mysql database tables. Specifically, it
      adds the drops to drop the old mysql online backup
      progress tables (online_backup, online_backup_progress).
      added:
        mysql-test/suite/backup/r/backup_mysql_upgrade.result
        mysql-test/suite/backup/t/backup_mysql_upgrade.test
      modified:
        scripts/mysql_system_tables.sql

[26 Mar 2009 12:33] Bugs System

Pushed into 6.0.11-alpha (revid:[e-mail]-20090326121822-pt84kzxxayzho4mn) (version source revid:[e-mail]-20090309134019-vr480npdp30f2gvh) (merge vers: 6.0.11-alpha) (pib:6)

[26 Mar 2009 23:49] Paul DuBois

Noted in 6.0.11 changelog.

mysql_upgrade did not remove the online_backup and
online_backup_progress tables from the mysql database. (These are
what the backup_history and backup_progress tables were called
previously.)