Bug #50165 Backport: backup_intr_errors test fails due to result mismatch in show warnings
Submitted: 7 Jan 2010 23:28 Modified: 11 Jan 2010 19:35
Reporter: Hema Sridharan Email Updates:
Status: Patch queued Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[7 Jan 2010 23:28] Hema Sridharan
Description:
The backup_intr_errors test from backup suite fails because of result mismatch in show warnings statement. The mismatch also occurs because the query execution is interrupted twice in the result file(please see below) 

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

CURRENT_TEST: backup.backup_intr_errors
--- /export/home/tmp/backup-backport/mysql-backup-backport/mysql-test/suite/backup/r/backup_intr_errors.result  2010-01-07 22:55:43.000000000 +0300
+++ /export/home/tmp/backup-backport/mysql-backup-backport/mysql-test/suite/backup/r/backup_intr_errors.reject  2010-01-08 01:38:07.000000000 +0300
@@ -53,7 +53,7 @@
 Error  <error-code>    Snapshot backup driver can't cancel its backup operation
 Warning        <error-code>    Operation aborted
 Error  <error-code>    Backup/Restore: Error on close of backup stream
-Error  <error-code>    Error on delete of <backup image path> (errno: 176)
+Error  <error-code>    Error on delete of <backup image path> (errno: 175)
 #
 # Examine backup logs.
 #
@@ -112,7 +112,6 @@
 Level  Code    Message
 Error  <error-code>    Query execution was interrupted
 Error  <error-code>    Can't shut down Snapshot restore driver(s)
-Error  <error-code>    Query execution was interrupted
 Warning        <error-code>    Operation aborted - data might be corrupted
 Error  <error-code>    Backup/Restore: Error on close of backup stream
 #

Suggested fix:
Mask the error number in the show warnings statement using replace_regex and overwrite the result file. The change has to be made in backup_restore_interrupt.inc file which is called in backup_intr_errors.test
[7 Jan 2010 23:36] 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/96337

3040 Hema Sridharan	2010-01-08
      BUG#50165 (Backport: backup_intr_errors  test fails due to result
      mismatch in show warnings)
      
      This patch will mask the error numbers using replace_regex
      and overwrite the result file.
      modified:
        mysql-test/suite/backup/r/backup_intr_errors.result
        mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc
[8 Jan 2010 15:45] Andrei Elkin
Patch approved.
[8 Jan 2010 16:17] 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/96411

2931 Hema Sridharan	2010-01-08
      BUG#50165 (Backport: backup_intr_errors tests fails due 
      to result mismatch in error numbers)
      This patch will mask the error numbers using replace_regex 
      and overwrite the result file
      modified:
        mysql-test/suite/backup/r/backup_intr_errors.result
        mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc
[8 Jan 2010 16:26] 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/96412

3044 Hema Sridharan	2010-01-08
      BUG#50165
      This patch will mask the error numbers
      using replace_regex and overwrite the result file
      modified:
        mysql-test/suite/backup/r/backup_intr_errors.result
        mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc
[11 Jan 2010 17:27] Ingo Strüwing
Sorry, back to in-progress. On my machine it still fails:

backup.backup_intr_errors                w4 [ fail ]
        Test ended at 2010-01-11 18:08:53

CURRENT_TEST: backup.backup_intr_errors
--- /home2/mydev/bzrroot/mysql-5.6-backup-backport-ms09-2/mysql-test/suite/backup/r/backup_intr_errors.result	2010-01-08 21:14:44.000000000 +0300
+++ /home2/mydev/bzrroot/mysql-5.6-backup-backport-ms09-2/mysql-test/suite/backup/r/backup_intr_errors.reject	2010-01-11 20:08:52.000000000 +0300
@@ -112,6 +112,7 @@
 Level	Code	Message
 Error	<error-code>	Query execution was interrupted
 Error	<error-code>	Can't shut down Snapshot restore driver(s)
+Error	<error-code>	Query execution was interrupted
 Warning	<error-code>	Operation aborted - data might be corrupted
 Error	<error-code>	Backup/Restore: Error on close of backup stream
 #
@@ -238,6 +239,7 @@
 Level	Code	Message
 Error	<error-code>	Query execution was interrupted
 Error	<error-code>	Can't shut down Default restore driver(s)
+Error	<error-code>	Query execution was interrupted
 Warning	<error-code>	Operation aborted - data might be corrupted
 Error	<error-code>	Backup/Restore: Error on close of backup stream
 #

mysqltest: Result content mismatch
[11 Jan 2010 19: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/96549

3052 Hema Sridharan	2010-01-11
      BUG#50165 (backup_intr_errors test fails due to result mismatch
      inshow warnings)
      This patch will fix the mismatch errors and overwrite the 
      result file.
      modified:
        mysql-test/suite/backup/r/backup_intr_errors.result