Bug #53621 check_testcase fails for rpl_do_grant in mysql-5.1-bugteam
Submitted: 13 May 2010 15:25 Modified: 14 Oct 2010 12:31
Reporter: Luis Soares Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.1, !trunk+ OS:Any
Assigned to: Luis Soares CPU Architecture:Any

[13 May 2010 15:25] Luis Soares
Description:
MTR sometimes reports that rpl_do_grant is not cleaning up properly:

+NULL   bug42217_db     latin1  latin1_swedish_ci       NULL
 NULL   mtr     latin1  latin1_swedish_ci       NULL
 NULL   mysql   latin1  latin1_swedish_ci       NULL
 NULL   test    latin1  latin1_swedish_ci       NULL
@@ -504,7 +505,7 @@
 mysql.help_keyword     0
 mysql.help_relation    0
 mysql.host     0
-mysql.proc     652076103
+mysql.proc     2320595515
 mysql.procs_priv       0
 mysql.tables_priv      0
 mysql.time_zone        2420313365

mysqltest: Result content mismatch

not ok

How to repeat:
mysql-test$ perl mtr rpl_do_grant

Suggested fix:
backport BUG#50984 fix.
[13 May 2010 15:41] 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/108257

3382 Luis Soares	2010-05-13
      BUG#53621: check_testcase fails for rpl_do_grant in mysql-5.1-bugteam
      
      MTR sporadically reported that rpl_do_grant does not
      clean up after itself.
      
      We fix this by backporting BUG 50984 fix. This deploys
      missing synchronization between master and slave.
      
      Additionally, it also fixes the check_testcase for
      rpl_tmp_table_and_DDL.
[20 May 2010 1:23] Luis Soares
Queued in mysql-5.1-bugteam and mysql-pe:
  - http://pb2.norway.sun.com/web.py?template=push_details&push=1270678
  - http://pb2.norway.sun.com/web.py?template=push_details&push=1270677
[28 May 2010 6:01] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (pib:16)
[28 May 2010 6:30] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:alik@sun.com-20100524190409-5w4l7mje1wk1c90l) (merge vers: 6.0.14-alpha) (pib:16)
[28 May 2010 6:57] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:alexey.kopytov@sun.com-20100523204118-0tl3goawu658rxh6) (merge vers: 5.5.5-m3) (pib:16)
[29 May 2010 2:57] Paul DuBois
Changes to test case. No changelog entry needed.
[2 Jun 2010 8:49] Bugs System
Pushed into 5.1.48 (revid:georgi.kodinov@oracle.com-20100602084411-2yu607bslbmgufl3) (version source revid:luis.soares@sun.com-20100519235203-c5j0gzxssjx3as9b) (merge vers: 5.1.47) (pib:16)
[2 Jun 2010 9:10] Jon Stephens
Returning to Closed status per Paul's comment above.
[14 Oct 2010 8:30] Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:martin.skold@mysql.com-20101014082627-jrmy9xbfbtrebw3c) (version source revid:vasil.dimov@oracle.com-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)
[14 Oct 2010 8:45] Bugs System
Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:martin.skold@mysql.com-20101014083757-5qo48b86d69zjvzj) (version source revid:vasil.dimov@oracle.com-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)
[14 Oct 2010 9:00] Bugs System
Pushed into mysql-5.1-telco-6.2 5.1.51-ndb-6.2.19 (revid:martin.skold@mysql.com-20101014084420-y54ecj85j5we27oa) (version source revid:vasil.dimov@oracle.com-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)
[14 Oct 2010 12:31] Jon Stephens
Setting back to Closed state.

See previous comments.