Bug #8735 Test failure: 'rpl_rotate_logs' (diff. positions, less content) in 'classic'
Submitted: 23 Feb 2005 17:26 Modified: 23 Feb 2005 18:04
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.3-pre OS:All Unix
Assigned to: Sergei Golubchik CPU Architecture:Any

[23 Feb 2005 17:26] Joerg Bruehe
Description:
This is different from bug#8362!

Build based on changeset
 1.1882 05/02/23 00:50:30 lars@mysql.com +2 -0
  After merge fixes

Problem shows up in 'classic' on all platforms (but 'max' passes everywhere, same sources).
Differences are quite long, I truncate to start and finish to show the relevant things:

-------------------------------------------------------
*** r/rpl_rotate_logs.result    Wed Feb 23 14:37:59 2005
--- r/rpl_rotate_logs.reject    Wed Feb 23 17:05:51 2005
***************
*** 102,211 ****
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
  master-bin.000001     4       Format_desc     1       96      Server ver: VERSION, Binlog ver: 4
  master-bin.000001     96      Query   1       197     use `test`; create table t1 (n int) engine=innodb
! master-bin.000001     197     Query   1       266     use `test`; BEGIN
! master-bin.000001     266     Query   1       94      use `test`; insert into t1 values(100 + 4)
! master-bin.000001     360     Query   1       187     use `test`; insert into t1 values(99 + 4)
! master-bin.000001     453     Query   1       280     use `test`; insert into t1 values(98 + 4)
! master-bin.000001     546     Query   1       373     use `test`; insert into t1 values(97 + 4)
.....
! master-bin.000001     9190    Query   1       9016    use `test`; insert into t1 values(4 + 4)
! master-bin.000001     9282    Query   1       9108    use `test`; insert into t1 values(3 + 4)
! master-bin.000001     9374    Query   1       9200    use `test`; insert into t1 values(2 + 4)
! master-bin.000001     9466    Query   1       9292    use `test`; insert into t1 values(1 + 4)
! master-bin.000001     9558    Xid     1       9319    COMMIT /* xid=146 */
! master-bin.000001     9585    Rotate  1       9629    master-bin.000002;pos=4
  show binlog events in 'master-bin.000002';
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
  master-bin.000002     4       Format_desc     1       96      Server ver: VERSION, Binlog ver: 4
! master-bin.000002     96      Query   1       173     use `test`; drop table t1
--- 102,195 ----
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
  master-bin.000001     4       Format_desc     1       96      Server ver: VERSION, Binlog ver: 4
  master-bin.000001     96      Query   1       197     use `test`; create table t1 (n int) engine=innodb
! master-bin.000001     197     Query   1       291     use `test`; insert into t1 values(100 + 4)
! master-bin.000001     291     Query   1       384     use `test`; insert into t1 values(99 + 4)
! master-bin.000001     384     Query   1       477     use `test`; insert into t1 values(98 + 4)
! master-bin.000001     477     Query   1       570     use `test`; insert into t1 values(97 + 4)
.....
! master-bin.000001     3732    Query   1       3825    use `test`; insert into t1 values(62 + 4)
! master-bin.000001     3825    Query   1       3918    use `test`; insert into t1 values(61 + 4)
! master-bin.000001     3918    Query   1       4011    use `test`; insert into t1 values(60 + 4)
! master-bin.000001     4011    Query   1       4104    use `test`; insert into t1 values(59 + 4)
! master-bin.000001     4104    Rotate  1       4148    master-bin.000002;pos=4
  show binlog events in 'master-bin.000002';
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
  master-bin.000002     4       Format_desc     1       96      Server ver: VERSION, Binlog ver: 4
! master-bin.000002     96      Query   1       189     use `test`; insert into t1 values(58 + 4)
! master-bin.000002     189     Query   1       282     use `test`; insert into t1 values(57 + 4)
! master-bin.000002     282     Query   1       375     use `test`; insert into t1 values(56 + 4)
.....
! master-bin.000002     3816    Query   1       3909    use `test`; insert into t1 values(18 + 4)
! master-bin.000002     3909    Query   1       4002    use `test`; insert into t1 values(17 + 4)
! master-bin.000002     4002    Query   1       4095    use `test`; insert into t1 values(16 + 4)
! master-bin.000002     4095    Query   1       4188    use `test`; insert into t1 values(15 + 4)
! master-bin.000002     4188    Rotate  1       4232    master-bin.000003;pos=4
-------------------------------------------------------

This one was from aix43 - yes, there is no '14+4' ... '1+4'  in the 'reject' file reported.

How to repeat:
Build and test 'classic' anywhere.
[23 Feb 2005 18:04] Sergei Golubchik
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html