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

[25 Jul 2008 10:24] Georgi Kodinov
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
[25 Jul 2008 10:34] Sveta Smirnova
Thank you for the report.

Verified as described using main 5.1 tree.
[6 Aug 2008 14:38] Sven Sandberg
This failed, e.g., here:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-bugteam&order=83 sapsrv1/n_mix
[6 Aug 2008 14:39] Sven Sandberg
See also xref: http://tinyurl.com/5ojuf9
[14 Aug 2008 2:17] 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/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
[14 Aug 2008 2:17] 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/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
[14 Aug 2008 7:17] 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/51600

2677 He Zhenxing	2008-08-14 [merge]
      Merge with mysql-5.1-rpl-testfixes
[14 Aug 2008 8:20] 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/51605

2685 He Zhenxing	2008-08-14 [merge]
      Merge 5.1-rpl-testfixes -> 6.0-rpl-testfixes
[19 Aug 2008 19:52] Bugs System
Pushed into 6.0.7-alpha  (revid:hezx@mysql.com-20080812090936-17an4ltmsgprp3ys) (version source revid:sven@mysql.com-20080818175803-c1nutd5773r6b4gd) (pib:3)
[25 Aug 2008 21:06] Chuck Bell
Released in 6.0.7
[27 Aug 2008 1:18] Paul Dubois
Setting report to NDI pending push into 5.1.x.
[28 Aug 2008 20:17] Bugs System
Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)
[29 Aug 2008 0:49] Paul Dubois
Setting report to NDI pending push into 5.1.x.
[1 Sep 2008 7:46] Zhenxing He
Test case changes only
[2 Sep 2008 18:16] Paul Dubois
Setting report to NDI pending push into 5.1.x.
[14 Sep 2008 2:13] Bugs System
Pushed into 6.0.7-alpha  (revid:hezx@mysql.com-20080812090936-17an4ltmsgprp3ys) (version source revid:sven@mysql.com-20080818195835-r615g9zz6xphmkzg) (pib:3)
[15 Sep 2008 19:12] Paul Dubois
Setting report to NDI pending push into 5.1.x.
[1 Oct 2008 14:47] Sven Sandberg
test case fixes only, closing bug.
[12 Dec 2008 23:25] Bugs System
Pushed into 6.0.6-alpha  (revid:tomas.ulin@sun.com-20080808081039-vzle9vy71rq35sdv) (version source revid:jonas@mysql.com-20080812185642-1nevjb94zj621dqx) (pib:5)