| Bug #39345 | Incorrect info in backup_history table for drivers column | ||
|---|---|---|---|
| Submitted: | 9 Sep 2008 17:11 | Modified: | 3 Apr 2009 3:21 |
| Reporter: | Hema Sridharan | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Backup | Severity: | S3 (Non-critical) |
| Version: | mysql-6.0-backup | OS: | Linux |
| Assigned to: | Chuck Bell | CPU Architecture: | Any |
[3 Mar 2009 2:01]
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/68065 2783 Chuck Bell 2009-03-02 BUG#39345 : Incorrect info in backup_history table for drivers column This patch corrects the comment on the drivers column in the mysql.backup_history table statement. modified: mysql-test/suite/funcs_1/r/is_columns_mysql.result mysql-test/suite/funcs_1/r/is_columns_mysql_embedded.result scripts/mysql_system_tables.sql
[5 Mar 2009 14:32]
Jørgen Løland
Patch approved
[5 Mar 2009 16:19]
Hema Sridharan
Patch approved. Good to push.
[5 Mar 2009 22:13]
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/68435 2789 Chuck Bell 2009-03-05 BUG#39345 : Incorrect info in backup_history table for drivers column This patch corrects the comment on the drivers column in the mysql.backup_history table statement. modified: mysql-test/suite/funcs_1/r/is_columns_mysql.result mysql-test/suite/funcs_1/r/is_columns_mysql_embedded.result 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)
[3 Apr 2009 3:21]
Paul DuBois
Cosmetic change. No changelog entry needed.
Description: 1)Mysql database has backup_history table. 2)The drivers column in backup_history table shows wrong user comment as: "The name of the storage engines used in the operation". Instead it can be, "The name of drivers used in operation" The drivers that are currently used by engines are Myisam, Consistent Snapshot or Default drivers. How to repeat: mysql> show tables from mysql; +---------------------------+ | Tables_in_mysql | +---------------------------+ | backup_history | | backup_progress | ----------------------------- mysql> show create table mysql.backup_history\G *************************** 1. row *************************** Table: backup_history Create Table: CREATE TABLE `backup_history` ( ....... ......... `backup_file` char(100) NOT NULL DEFAULT '' COMMENT 'The name of the file', `user_comment` varchar(200) NOT NULL DEFAULT '' COMMENT 'The comment from user entered at command line', `command` varchar(512) NOT NULL DEFAULT '' COMMENT 'The command used to issue operation', `drivers` varchar(100) NOT NULL DEFAULT '' COMMENT 'The name of the storage engines used in the operation' ) ENGINE=CSV DEFAULT CHARSET=utf8 1 row in set (0.00 sec) eg: CREATE DATABASE ino; CREATE TABLE ino.t1(id int)ENGINE=INNODB; CREATE TABLE ino.t2(id int)ENGINE=MEMORY; BACKUP DATABASE ino to 'ino.bak'; SELECT * FROM mysql.backup_history\G *************************** 5. row *************************** backup_id: 256 process_id: 0 .................. backup_file: ino.bak user_comment: command: BACKUP DATABASE ino to 'ino.bak' drivers: Snapshot, Default From the above table, we see that drivers name indicated in the drivers column and not engines. Note: Innodb uses Snapshot driver and Memory uses Default driver.