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 Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:6.0.8 OS:Any
Assigned to: Chuck Bell
Triage: Triaged: D3 (Medium)

[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:alik@sun.com-20090326121822-pt84kzxxayzho4mn) (version source revid:charles.bell@sun.com-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.)