Bug #32653 rpl_log.test fails randomly
Submitted: 23 Nov 2007 12:43 Modified: 28 Jul 2008 21:00
Reporter: Ingo Strüwing
Status: Closed
Category:Tests: Replication Severity:S2 (Serious)
Version:5.0.54 OS:Any (Windows, Mac)
Assigned to: Serge Kozlov Target Version:5.0+
Tags: pbfail
Triage: D3 (Medium)

[23 Nov 2007 12:43] Ingo Strüwing 
Description:
rpl_log                        [ fail ]

---
/Users/henry/pb/mysql-5.0-engines/181/mysql-5.0.54-pb181/mysql-test/r/rpl_log.result	Wed
Nov 21 23:30:54 2007
+++
/Users/henry/pb/mysql-5.0-engines/181/mysql-5.0.54-pb181/mysql-test/r/rpl_log.reject	Thu
Nov 22 12:53:17 2007
@@ -74,22 +74,14 @@
 start slave;
 show binary logs;
 Log_name	File_size
-slave-bin.000001	1552
+slave-bin.000001	303
 slave-bin.000002	348
 show binlog events in 'slave-bin.000001' from 4;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
 slave-bin.000001	4	Format_desc	2	98	Server ver: VERSION, Binlog ver: 4
-slave-bin.000001	98	Query	1	219	use `test`; create table t1(n int not null
auto_increment primary key)
-slave-bin.000001	219	Intvar	1	247	INSERT_ID=1
-slave-bin.000001	247	Query	1	338	use `test`; insert into t1 values (NULL)
-slave-bin.000001	338	Query	1	414	use `test`; drop table t1
-slave-bin.000001	414	Query	1	517	use `test`; create table t1 (word char(20) not null)
-slave-bin.000001	517	Begin_load_query	1	1121	;file_id=1;block_len=581
-slave-bin.000001	1121	Execute_load_query	1	1271	use `test`; load data INFILE
'../tmp/SQL_LOAD-2-1-1.data' INTO table t1 ignore 1 lines ;file_id=1
-slave-bin.000001	1271	Query	1	1347	use `test`; drop table t1
-slave-bin.000001	1347	Query	1	1433	use `test`; create table t5 (a int)
-slave-bin.000001	1433	Query	1	1509	use `test`; drop table t5
-slave-bin.000001	1509	Rotate	2	1552	slave-bin.000002;pos=4
+slave-bin.000001	98	Query	1	184	use `test`; create table t5 (a int)
+slave-bin.000001	184	Query	1	260	use `test`; drop table t5
+slave-bin.000001	260	Rotate	2	303	slave-bin.000002;pos=4
 show binlog events in 'slave-bin.000002' from 4;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
 slave-bin.000002	4	Format_desc	2	98	Server ver: VERSION, Binlog ver: 4

mysqltest: Result content mismatch

Disabling the test case. Please re-enable after fix.

How to repeat:
See pushbuild, for example
https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-5.0-engines
log
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.0-engines&entry=istruewi...
[28 Nov 2007 11:23] Bugs System 
Pushed into 6.0.4-alpha
[28 Nov 2007 11:25] Bugs System 
Pushed into 5.1.23-rc
[28 Nov 2007 11:27] Bugs System 
Pushed into 5.0.54
[3 Apr 2008 0:01] 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/44817

ChangeSet@1.2611, 2008-04-03 02:00:21+04:00, skozlov@mysql.com +4 -0
  Bug#32653. Added --log-slave-updates because test requires it. 
  The events based on LOAD DATA INFILE masked by --replace_regex instead restarting of
slave
[3 Apr 2008 23:18] 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/44891

ChangeSet@1.2611, 2008-04-04 01:16:55+04:00, skozlov@mysql.com +4 -0
  Bug#32653. 
  Added --log-slave-updates because test requires it. 
  The events based on LOAD DATA INFILE masked by --replace_regex instead restarting of
slave.
  Added waiting start and stop of slave after START|STOP SLAVE statements.
[28 Jul 2008 20:55] Patrick Crews 
Pushed into 5.1.28
Pushed into 6.0.7
[28 Jul 2008 21:00] Paul DuBois 
Test case change. No changelog entry needed.
[14 Sep 2008 4:01] Bugs System 
Pushed into 6.0.6-alpha 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080403211655-25498) (version source
revid:hakan@mysql.com-20080716160034-sdexuyp3qow7zlc6) (pib:3)
[15 Sep 2008 10:13] Bugs System 
Pushed into 5.0.70  (revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080403211655-25498)
(version source revid:vvaintroub@mysql.com-20080901112738-k8dc67kp067pyo7h) (pib:3)
[26 Sep 2008 14:30] 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/54543

2698 He Zhenxing	2008-09-26 [merge]
      Merge 5.1 main -> 5.1-rpl
[1 Oct 2008 18:06] Bugs System 
Pushed into 5.1.28  (revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080403211655-25498)
(version source revid:vvaintroub@mysql.com-20080901100428-cbaww4rp1vdsujk7) (pib:4)
[28 Oct 2008 22:03] Bugs System 
Pushed into 5.1.29-ndb-6.2.17 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080403211655-25498) (version source
revid:tomas.ulin@sun.com-20081028140209-u4emkk1xphi5tkfb) (pib:5)
[28 Oct 2008 23:22] Bugs System 
Pushed into 5.1.29-ndb-6.3.19 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080403211655-25498) (version source
revid:tomas.ulin@sun.com-20081028194045-0353yg8cvd2c7dd1) (pib:5)
[1 Nov 2008 10:47] Bugs System 
Pushed into 5.1.29-ndb-6.4.0 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080403211655-25498) (version source
revid:jonas@mysql.com-20081101082305-qx5a1bj0z7i8ueys) (pib:5)