Bug #49899 The backup_xpfm_compat_backup_lctn2 failing on Windows PB machines
Submitted: 23 Dec 2009 20:02 Modified: 25 Feb 2010 1:42
Reporter: Chuck Bell Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Backup Severity:S3 (Non-critical)
Version:6.0.14 OS:Windows
Assigned to: Sanjay Manwani CPU Architecture:Any

[23 Dec 2009 20:02] Chuck Bell 
Description:
The test backup_xpfm_compat_backup_lctn2 is failing due to a result mismatch. The result set is a different order of the SHOW GRANTS FOR... command. Sample failure is shown below. Note: This is random but is fairly consistent on Windows PB machines.

@@ -751,8 +751,8 @@
 Grants for bup_user1@%
 GRANT USAGE ON *.* TO 'bup_user1'@'%'
 GRANT ALL PRIVILEGES ON `bup_xpfm_compat_db1`.* TO 'bup_user1'@'%'
-GRANT SELECT (c13) ON `bupxpfmcompat_db3`.`table3` TO 'bup_user1'@'%'
 GRANT SELECT ON `bup_xpfm_compat_db2`.`table2` TO 'bup_user1'@'%'
+GRANT SELECT (c13) ON `bupxpfmcompat_db3`.`table3` TO 'bup_user1'@'%'
 GRANT EXECUTE ON PROCEDURE `bup_xpfm_compat_db1`.`proc1` TO 'bup_user1'@'%'
 GRANT EXECUTE ON FUNCTION `bup_xpfm_compat_db1`.`func1` TO 'bup_user1'@'%'
 SHOW GRANTS FOR 'BUP_USER2';

How to repeat:
See PB2.

Suggested fix:
Add --sorted directive prior to SHOW GRANTS statement.
[7 Jan 2010 15:23] 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/96274

2929 Sanjay Manwani	2010-01-07
      Bug #49899  	The backup_xpfm_compat_backup_lctn2 failing on Windows PB machines
      
      The results of the command "SHOW GRANTS" are reported in a random order.
      Added the directive --sorted_result for each of the "SHOW GRANTS" calls in the include file:
      mysql-test/suite/backup/include/backup_xpfm_compat_backup.inc
       used by the tests :
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.test 
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn1.test
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn2 .test
       
      and modified the corresponding result files.
      
      and modified the 
      Modified the
[7 Jan 2010 15:28] 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/96275

2929 Sanjay Manwani	2010-01-07
      Bug #49899  	The backup_xpfm_compat_backup_lctn2 failing on Windows PB machines
      
      The results of the command "SHOW GRANTS" are reported in a random order.
      Added the directive --sorted_result for each of the "SHOW GRANTS" calls
       in the include file:
       mysql-test/suite/backup/include/backup_xpfm_compat_backup.inc
       used by the tests :
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.test 
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn1.test
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn2 .test
       
      and modified the corresponding result files.
[7 Jan 2010 15:46] Ingo Strüwing 
Approved pending changes. Details by email.
[8 Jan 2010 7:20] Ritheesh Vedire 
Approved pending changes.
[11 Jan 2010 13:51] 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/96490

2932 Sanjay Manwani	2010-01-11
      Bug #49899  	The backup_xpfm_compat_backup_lctn2 failing on Windows PB machines
      
      The results of the command "SHOW GRANTS" are reported in a random order.
      Added the directive --sorted_result for each of the "SHOW GRANTS" calls
       in the include file:
       mysql-test/suite/backup/include/backup_xpfm_compat_backup.inc
       used by the tests :
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.test 
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn1.test
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn2 .test
       
      and modified the corresponding result files.
[12 Jan 2010 7:47] 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/96583

2933 Sanjay Manwani	2010-01-12
      Bug #49899  	The backup_xpfm_compat_backup_lctn2 failing on Windows PB machines
      
      There was a whitespace  problem with the push on the result file:
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.result
[12 Jan 2010 8:30] Ingo Strüwing 
Hi Sanjay, backup_xpfm_compat_backup_lctn0.result contains CRNL line endings (carriage-return, newline) as they are used on Windows. We must not commit such to the repository. Please fix the result file to use UNIX line endings (NL - newline only). (backup_xpfm_compat_backup_lctn0 started to fail on UNIX/Linux platforms after the push of the above patch.)
[13 Jan 2010 12:56] 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/96755

2934 Sanjay Manwani	2010-01-13
      Bug#49899 - The backup_xpfm_compat_backup_lctn2 failing on
                  Windows PB machines
      
      There was a whitespace  problem with the push on 
      the result file:
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.result
      
      Committed this file after generating it on Linux.
     @ mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.result
        Bug#49899 - The backup_xpfm_compat_backup_lctn2 failing on
                    Windows PB machines
[15 Jan 2010 14:19] 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/97093

2935 Sanjay Manwani	2010-01-15
      Bug#49899 - The backup_xpfm_compat_backup_lctn2 failing on
                  Windows PB machines
      
      There was a whitespace  problem with the push on 
      the result file:
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.result
      
      Committed this file after generating it on Linux.
     @ mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.result
        Bug#49899 - The backup_xpfm_compat_backup_lctn2 failing on
                    Windows PB machines
[15 Jan 2010 17:11] 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/97133

3069 Chuck Bell	2010-01-15
      BUG#49899 The backup_xpfm_compat_backup_lctn2 failing on Windows 
                PB machines
      
      The results of the command "SHOW GRANTS" are reported in a random order.
      Added the directive --sorted_result for each of the "SHOW GRANTS" calls
      in the include file:
      
      mysql-test/suite/backup/include/backup_xpfm_compat_backup.inc
      used by the tests :
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn0.test 
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn1.test
      mysql-test/suite/backup/r/backup_xpfm_compat_backup_lctn2 .test
      
      and modified the corresponding result files.
      
      original changeset: 2932 (mysql-6.0-backup)
[20 Feb 2010 9:16] Bugs System 
Pushed into 6.0.14-alpha (revid:ingo.struewing@sun.com-20100218152520-s4v1ld76bif06eqn) (version source revid:ingo.struewing@sun.com-20100121091818-06epm3ua78fdrlom) (merge vers: 6.0.14-alpha) (pib:16)
[25 Feb 2010 1:42] Paul DuBois 
Changes to test cases. No changelog entry needed.