MySQL Bugs: #38369: rpl_ndb.rpl_row_basic

Bug #38369	rpl_ndb.rpl_row_basic_7ndb fails
Submitted:	25 Jul 2008 10:24	Modified:	1 Oct 2008 14:47
Reporter:	Georgi Kodinov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Replication	Severity:	S7 (Test Cases)
Version:	5.1	OS:	Any
Assigned to:	Zhenxing He	CPU Architecture:	Any

Description:
The test rpl_ndb.row_basic_7ndb fails in 5.1-bzr:

rpl_ndb.rpl_row_basic_7ndb     [ fail ]

--- /data0/pushbuild/pb/bzr_mysql-5.1-bugteam/82/bzr_mysql-5.1-bugteam-exp/mysql-test/suite/rpl_ndb/r/rpl_row_basic_7ndb.result	2008-07-24 23:59:04.000000000 +0300
+++ /data0/pushbuild/pb/bzr_mysql-5.1-bugteam/82/bzr_mysql-5.1-bugteam-exp/mysql-test/suite/rpl_ndb/r/rpl_row_basic_7ndb.reject	2008-07-25 01:20:44.000000000 +0300
@@ -437,7 +437,7 @@
 COUNT(*)	0
 set @@global.slave_exec_mode= default;
 Last_SQL_Error
-0
+
 SELECT COUNT(*) FROM t1 ORDER BY c1,c2;
 COUNT(*)	0
 **** Test for BUG#37076 ****
@@ -451,3 +451,79 @@
 a	b	c
 2005-11-14 01:01:01	2005-11-14 01:01:02	2005-11-14
 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8;
+CREATE TABLE t1 (i INT NOT NULL,
+c CHAR(16) CHARACTER SET utf8 NOT NULL,
+j INT NOT NULL);
+CREATE TABLE t2 (i INT NOT NULL,
+c CHAR(16) CHARACTER SET utf8 NOT NULL,
+j INT NOT NULL);
+ALTER TABLE t2 MODIFY c CHAR(128) CHARACTER SET utf8 NOT NULL;
+CREATE TABLE t3 (i INT NOT NULL,
+c CHAR(128) CHARACTER SET utf8 NOT NULL,
+j INT NOT NULL);
+ALTER TABLE t3 MODIFY c CHAR(16) CHARACTER SET utf8 NOT NULL;
+CREATE TABLE t4 (i INT NOT NULL,
+c CHAR(128) CHARACTER SET utf8 NOT NULL,
+j INT NOT NULL);
+CREATE TABLE t5 (i INT NOT NULL,
+c CHAR(255) CHARACTER SET utf8 NOT NULL,
+j INT NOT NULL);
+ALTER TABLE t5 MODIFY c CHAR(16) CHARACTER SET utf8 NOT NULL;
+CREATE TABLE t6 (i INT NOT NULL,
+c CHAR(255) CHARACTER SET utf8 NOT NULL,
+j INT NOT NULL);
+ALTER TABLE t6 MODIFY c CHAR(128) CHARACTER SET utf8 NOT NULL;
+CREATE TABLE t7 (i INT NOT NULL,
+c CHAR(255) CHARACTER SET utf8 NOT NULL,
+j INT NOT NULL);
+[expecting slave to replicate correctly]
+INSERT INTO t1 VALUES (1, "", 1);
+INSERT INTO t1 VALUES (2, repeat(_utf8'a', 16), 2);
+Comparing tables master:test.t1 and slave:test.t1
+[expecting slave to replicate correctly]
+INSERT INTO t2 VALUES (1, "", 1);
+INSERT INTO t2 VALUES (2, repeat(_utf8'a', 16), 2);
+Comparing tables master:test.t2 and slave:test.t2
+[expecting slave to stop]
+INSERT INTO t3 VALUES (1, "", 1);
+INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2);
+"Failed while waiting for slave SQL thread to stop"
+SHOW SLAVE STATUS;
+Slave_IO_State	Waiting for master to send event
+Master_Host	127.0.0.1
+Master_User	root
+Master_Port	11110
+Connect_Retry	1
+Master_Log_File	master-bin.000001
+Read_Master_Log_Pos	2931
+Relay_Log_File	slave-relay-bin.000003
+Relay_Log_Pos	3077
+Relay_Master_Log_File	master-bin.000001
+Slave_IO_Running	Yes
+Slave_SQL_Running	Yes
+Replicate_Do_DB	
+Replicate_Ignore_DB	
+Replicate_Do_Table	
+Replicate_Ignore_Table	
+Replicate_Wild_Do_Table	
+Replicate_Wild_Ignore_Table	
+Last_Errno	0
+Last_Error	
+Skip_Counter	0
+Exec_Master_Log_Pos	2931
+Relay_Log_Space	3232
+Until_Condition	None
+Until_Log_File	
+Until_Log_Pos	0
+Master_SSL_Allowed	No
+Master_SSL_CA_File	
+Master_SSL_CA_Path	
+Master_SSL_Cert	
+Master_SSL_Cipher	
+Master_SSL_Key	
+Seconds_Behind_Master	0
+Master_SSL_Verify_Server_Cert	No
+Last_IO_Errno	0
+Last_IO_Error	
+Last_SQL_Errno	0
+Last_SQL_Error	

mysqltest: In included file "./include/wait_for_slave_sql_to_stop.inc": Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

How to repeat:
Run the test suite

Suggested fix:
n/a

Thank you for the report.

Verified as described using main 5.1 tree.

This failed, e.g., here:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-bugteam&order=83 sapsrv1/n_mix

See also xref: http://tinyurl.com/5ojuf9

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/51586

2675 He Zhenxing	2008-08-12
      Apply tomas's patch to fix rpl_row_basic.test, this can fix BUG#37884, 
      BUG#38369, enable rpl_row_basic_7ndb test

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/51587

2675 He Zhenxing	2008-08-12
      Apply tomas's patch to fix rpl_row_basic.test, this can fix BUG#37884, 
      BUG#38369, enable rpl_row_basic_7ndb test

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/51600

2677 He Zhenxing	2008-08-14 [merge]
      Merge with mysql-5.1-rpl-testfixes

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/51605

2685 He Zhenxing	2008-08-14 [merge]
      Merge 5.1-rpl-testfixes -> 6.0-rpl-testfixes

Pushed into 6.0.7-alpha  (revid:hezx@mysql.com-20080812090936-17an4ltmsgprp3ys) (version source revid:sven@mysql.com-20080818175803-c1nutd5773r6b4gd) (pib:3)

Released in 6.0.7

Setting report to NDI pending push into 5.1.x.

Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)

Setting report to NDI pending push into 5.1.x.

Test case changes only

Setting report to NDI pending push into 5.1.x.

Pushed into 6.0.7-alpha  (revid:hezx@mysql.com-20080812090936-17an4ltmsgprp3ys) (version source revid:sven@mysql.com-20080818195835-r615g9zz6xphmkzg) (pib:3)

Setting report to NDI pending push into 5.1.x.

test case fixes only, closing bug.

Pushed into 6.0.6-alpha  (revid:tomas.ulin@sun.com-20080808081039-vzle9vy71rq35sdv) (version source revid:jonas@mysql.com-20080812185642-1nevjb94zj621dqx) (pib:5)