Bug #50255 Backport: backup_no_engine test fails in backport tree due to missing .frm file

• Submitted: 11 Jan 2010 20:28
• Modified: 25 Feb 2010 1:39
• Reporter: Hema Sridharan
• Status: Closed
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Hema Sridharan
• CPU Architecture: Any

[11 Jan 2010 20:28] Hema Sridharan

Description:
The backup_no_engine test fails in backport tree because of the error that occured while copying the .FRM file using copy_file command.

The test fails due to missing bug30938.frm file in mysql-test/std_data directory. 

How to repeat:
./mysql-test-run.pl --suite=backup backup_no_engine.test

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
backup.backup_no_engine                  [ fail ]
        Test ended at 2010-01-11 21:12:18

CURRENT_TEST: backup.backup_no_engine
mysqltest: At line 23: command "copy_file" failed with error 1

Suggested fix:
Copy the bug30938.frm file from mysql-6.0-backup tree to backport tree(mysql-backup-backport) and then run the test. Also mask the error numbers in SHOW WARNINGS statement using replace_column.

[11 Jan 2010 20:52] Hema Sridharan

Note that bug30938.frm file was added by changeset 3051 in the porting tree from original changeset 2476.776.2 from the team tree.

[11 Jan 2010 20:59] 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/96565

3052 Hema Sridharan	2010-01-11
      BUG#50255 (backup_no_engine test fails in backport tree due to missing .frm file)
      The .frm file is ported by changeset 3051 in porting tree from 
      2476.776.2 from team tree.
      The patch for this bug will mask the error numbers in SHOW WARNINGS 
      statement using replace_column and overwrite the result file.
      modified:
        mysql-test/suite/backup/r/backup_no_engine.result
        mysql-test/suite/backup/t/backup_no_engine.test

[11 Jan 2010 22:31] 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/96572

2933 Hema Sridharan	2010-01-11
      BUG#50255 (backup_no_engine test fails in backport tree)
      This patch will mask the errors numbers in SHOW WARNINGS statement using
      replace_column command
      modified:
        mysql-test/suite/backup/r/backup_no_engine.result
        mysql-test/suite/backup/t/backup_no_engine.test

[13 Jan 2010 3:32] 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/96691

3060 Hema Sridharan	2010-01-13
      BUG#50255 (backup_no_engine test fails due to missing .FRM file)
      This patch will overwrite the result file in 5.X due to differences noticed 
      in SHOW WARNINGS statement
      modified:
        mysql-test/suite/backup/r/backup_no_engine.result
        mysql-test/suite/backup/t/backup_no_engine.test

[13 Jan 2010 3:39] Hema Sridharan

Note that we overwrite the result file for the additional warnings that are generated by SHOW WARNINGS statement in 5.X tree. Please see also BUG#50295

[20 Feb 2010 9:19] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100218152520-s4v1ld76bif06eqn) (version source revid:[e-mail]-20100119103538-wtp5alpz4p2jayl5) (merge vers: 6.0.14-alpha) (pib:16)

[25 Feb 2010 1:39] Paul DuBois

Changes to test cases. No changelog entry needed.