Bug #22438 Different position in binary log makes test fail
Submitted: 18 Sep 2006 10:53 Modified: 2 Mar 2008 19:31
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.0.25 OS:Any (Various Unix)
Assigned to: Serge Kozlov CPU Architecture:Any

[18 Sep 2006 10:53] Joerg Bruehe
Description:
Build of 5.0.25,
never seen in previous versions (for this test).

-------------------------------------------------------
*** r/mysqldump.result
--- r/mysqldump.reject
***************
*** 2917,2923
  mysqldump: Couldn't execute 'SHOW MASTER STATUS': Access denied; you need the SUPER,REPLICATION CLIENT privilege for this
 operation (1227)
  mysqldump: Couldn't execute 'SHOW MASTER STATUS': Access denied; you need the SUPER,REPLICATION CLIENT privilege for this
 operation (1227)
  grant REPLICATION CLIENT on *.* to mysqltest_1@localhost;
! CHANGE MASTER TO MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=537;
  CREATE TABLE `t1` (
    `a` int(11) default NULL,
    `b` varchar(34) default NULL
--- 2917,2923
  mysqldump: Couldn't execute 'SHOW MASTER STATUS': Access denied; you need the SUPER,REPLICATION CLIENT privilege for this
 operation (1227)
  mysqldump: Couldn't execute 'SHOW MASTER STATUS': Access denied; you need the SUPER,REPLICATION CLIENT privilege for this
 operation (1227)
  grant REPLICATION CLIENT on *.* to mysqltest_1@localhost;
! CHANGE MASTER TO MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=418;
  CREATE TABLE `t1` (
    `a` int(11) default NULL,
    `b` varchar(34) default NULL
-------------------------------------------------------

Occured:
hp3750-64bit-5.0-debug.log   normal
hpita2-64bit-5.0-max.log   NDB
sol10-x86-5.0-max.log   ps
sol10-x86-5.0-standard.log   normal
sunfire100a-64bit-5.0-debug.log   ps
sunfire100a-64bit-5.0-max.log   ps
butch-64bit-5.0-cluster.log   normal
butch-64bit-5.0-pro-gpl.log   ps
butch-64bit-5.0-pro.log   ps
sol10-x86-5.0-cluster.log   NDB
sunfire100a-64bit-5.0-cluster.log   ps
sunfire100a-64bit-5.0-pro-gpl.log   normal
sunfire100a-64bit-5.0-pro-gpl.log   ps
sunfire100c-5.0-cluster.log   NDB

How to repeat:
Occurred during release builds + test run.
[2 Mar 2008 18:21] 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/43279

ChangeSet@1.2589, 2008-03-02 21:20:36+03:00, skozlov@mysql.com +2 -0
  Bug#22438
[25 Mar 2008 11:21] Bugs System
Pushed into 5.0.60
[25 Mar 2008 11:22] Bugs System
Pushed into 5.1.24-rc
[26 Mar 2008 19:00] Bugs System
Pushed into 6.0.5-alpha
[29 Mar 2008 23:58] Jon Stephens
Test failure only, no end-user changes to document. Closed.