Bug #59084 rpl_do_grant started to fail on FreeBSD (presumably after BUG#49978)
Submitted: 21 Dec 2010 9:50 Modified: 27 Jan 2011 20:34
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.6 OS:FreeBSD
Assigned to: Sven Sandberg CPU Architecture:Any
Tags: pb2, test failure

[21 Dec 2010 9:50] Alexander Nozdrin 
Description:
rpl_do_grant started to fail on all FreeBSD boxes on 2010-12-20
in daily-trunk-bugfixing with the following symptoms:

Last_Errno	1396
Last_Error	Error 'Operation DROP USER failed for 'create_rout_db'@'localhost'' on query. Default database: ''. Query: 'DROP USER 'create_rout_db'@'localhost''

mysqltest: In included file "./include/rpl_sync.inc": At line 149: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 4610, 300)' returned NULL indicating slave SQL thread failure

Full log is attached.

How to repeat:
Log: http://pb2.norway.sun.com/web.py?action=archive_download&archive_id=2699302&pretty=please
[21 Dec 2010 9:51] Alexander Nozdrin 
rpl_do_grant failure log

Attachment: rpl_do_grant.log (text/x-log), 20.42 KiB.
[21 Dec 2010 12:08] 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/127404

3530 Sven Sandberg	2010-12-21
      BUG#59084: rpl_do_grant started to fail on FreeBSD (presumably after BUG#49978)
      Problem: master executed a statement that would fail on slave
      (namely, DROP USER 'create_rout_db'@'localhost').
      Then the test did:
        --let $rpl_only_running_threads= 1
        --source include/rpl_reset.inc
      rpl_reset.inc calls rpl_sync.inc, which first checks which of
      the threads are running and then syncs those threads that are
      running. If the SQL thread fails after the check, the sync will
      fail. So there was a race in the test and it failed on some
      slow hosts.
      Fix: Don't replicate the failing statement.
[22 Dec 2010 21:30] Bugs System 
Pushed into mysql-trunk 5.6.1 (revid:alexander.nozdrin@oracle.com-20101222212842-y0t3ibtd32wd9qaw) (version source revid:alexander.nozdrin@oracle.com-20101222212842-y0t3ibtd32wd9qaw) (merge vers: 5.6.1) (pib:24)
[29 Dec 2010 12:51] Bugs System 
Pushed into mysql-5.1 5.1.55 (revid:alexander.nozdrin@oracle.com-20101229113432-o0c3f1pqklek1txm) (version source revid:alexander.nozdrin@oracle.com-20101229113109-ft3q9tewyueopxgf) (merge vers: 5.1.55) (pib:24)
[29 Dec 2010 12:52] Bugs System 
Pushed into mysql-5.5 5.5.9 (revid:alexander.nozdrin@oracle.com-20101229113652-km2v993aurv7h79j) (version source revid:alexander.nozdrin@oracle.com-20101229113132-uonlbcc2uopff8yb) (merge vers: 5.5.9) (pib:24)
[14 Jan 2011 10:24] Sven Sandberg 
patch was pushed to 5.1 and up on 2010-12-20
[27 Jan 2011 20:34] Jon Stephens 
Change in test code only; closed without any further action.