MySQL Bugs: #45576: rpl_row_create

Bug #45576	rpl_row_create_table fails on PB2
Submitted:	18 Jun 2009 5:46	Modified:	18 Jun 2010 1:00
Reporter:	Zhenxing He	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Replication	Severity:	S3 (Non-critical)
Version:	5.1, 5.4	OS:	Any
Assigned to:	Andrei Elkin	CPU Architecture:	Any
Tags:	5.1, 5.4, experimental, pb2, sporadic, test failure, tf54
Triage:	Triaged: D3 (Medium)

Description:
rpl_row_create_tables fail on PB2 like this:

@@ -270,6 +270,7 @@
 ORDER BY TABLE_NAME;
 TABLE_NAME	ENGINE
 t1	MyISAM
+t1	InnoDB
 t2	InnoDB
 t3	InnoDB
 t4	InnoDB

How to repeat:
Search failure of test 'rpl_row_create_tables' on PB2 with output like "+t1%InnoDB".

Suggested fix:
No idea yet.

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

3008 Georgi Kodinov	2009-07-07
      Bug #45578, Bug #46010, Bug #45576 : made the failing tests experimental

The issue relates to selecting from I_S, no to replication.
There is Bug #42190 claiming incorrect results of selecting.

And yet other bugs can retate Bug #29790, Bug #44009.

A new symptom has been observed on mysql-5.1-bugteam recently:

rpl.rpl_row_create_table                 [ exp-fail ]
        Test ended at 2009-11-29 10:27:44

CURRENT_TEST: rpl.rpl_row_create_table
mysqltest: At line 316: query 'CREATE TABLE IF NOT EXISTS bug48506_t1 LIKE t7' failed: 1615: Prepared statement needs to be re-prepared

The result from queries just before the failure was:
< snip >
)
master-bin.000001	#	Table_map	#	#	table_id: # (mysqltest1.with_select)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
DROP DATABASE mysqltest1;
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
CREATE TEMPORARY TABLE t7(c1 INT);
CREATE TABLE t5(c1 INT);
CREATE TABLE t4(c1 INT);
CREATE VIEW bug48506_t1 AS SELECT 1;
CREATE VIEW bug48506_t2 AS SELECT * FROM t4;
CREATE VIEW bug48506_t3 AS SELECT t5.c1 AS A, t4.c1 AS B FROM t5, t4;
CREATE TABLE bug48506_t4(c1 INT);
DROP VIEW bug48506_t1, bug48506_t2, bug48506_t3;
DROP TABLE bug48506_t4;

More results from queries before failure can be found in /export/home2/pb2/test/sb_1-1015432-1259471488.13/mysql-5.1.42-linux-i686-test/mysql-test/var-ps_row/log/rpl_row_create_table.log

 - saving '/export/home2/pb2/test/sb_1-1015432-1259471488.13/mysql-5.1.42-linux-i686-test/mysql-test/var-ps_row/log/rpl.rpl_row_create_table/' to '/export/home2/pb2/test/sb_1-1015432-1259471488.13/mysql-5.1.42-linux-i686-test/mysql-test/var-ps_row/log/rpl.rpl_row_create_table/'

Retrying test, attempt(2/3)...

See:

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2491083

for new failure sample.

Push:

http://pb2.norway.sun.com/web.py?template=push_details&push=716236

Seems to have triggered this new symptom.

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

3233 Georgi Kodinov	2009-12-01
      Bug #45576: moving the test from experimental to disabled.

back to verified : only test disabled.

About: "mysqltest: At line 316: query 'CREATE TABLE IF NOT EXISTS bug48506_t1 
       LIKE t7' failed",
It is a new bug which does not related to the original problem of this bug.
It will be resolved with the bug#47442.

Pushed into 5.1.42 (revid:joro@sun.com-20091202080033-mndu4sxwx19lz2zs) (version source revid:joro@sun.com-20091201092115-m16zdkr4tua9fr6m) (merge vers: 5.1.42) (pib:13)

Pushed into 6.0.14-alpha (revid:alik@sun.com-20091216083311-xorsasf5kopjxshf) (version source revid:alik@sun.com-20091214191830-wznm8245ku8xo702) (merge vers: 6.0.14-alpha) (pib:14)

Pushed into 5.5.0-beta (revid:alik@sun.com-20091216082430-s0gtzibcgkv4pqul) (version source revid:alexey.kopytov@sun.com-20091203204606-yot52u2niq1et8ys) (merge vers: 5.5.0-beta) (pib:14)

Pushed into mysql-next-mr (revid:alik@sun.com-20091216083231-rp8ecpnvkkbhtb27) (version source revid:alik@sun.com-20091212203859-fx4rx5uab47wwuzd) (merge vers: 5.6.0-beta) (pib:14)

Bug #29790 forces to avoid I_S selecting in tests relying on deterministic
results.

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

3346 Andrei Elkin	2010-02-18
      Bug #45576  	rpl_row_create_table fails on PB2
      
      The test failed due to Bug #29790.
      However, logics of the failing part does not need I_S selecting.
      
      Fixing to remove the non-deterministic I_S selecting as redundant
      from a part of the test dealing with BUG@22864.
     @ mysql-test/suite/rpl/r/rpl_row_create_table.result
        results updated.
     @ mysql-test/suite/rpl/t/disabled.def
        rpl_row_create_table is re-enabled.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        removed a non-deterministic I_S selecting as redundant
        from a part of the test dealing with BUG@22864.

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

3346 Andrei Elkin	2010-02-19
      bug#45576
      a small cleanup for the 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/100883

3346 Andrei Elkin	2010-02-19
      bug#45576
      a small cleanup for the 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/101607

3346 Andrei Elkin	2010-02-26
      Bug #45576  	rpl_row_create_table fails on PB2
      
      The test failed due to Bug #29790.
      However, logics of the failing part does not need I_S selecting.
      
      Fixing to remove the non-deterministic I_S selecting as redundant
      from a part of the test dealing with BUG@22864.
     @ mysql-test/suite/rpl/r/rpl_row_create_table.result
        results updated.
     @ mysql-test/suite/rpl/t/disabled.def
        rpl_row_create_table is re-enabled.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        removed a non-deterministic I_S selecting as redundant
        from a part of the test dealing with BUG@22864.

Pushed to 5.1-bt, mysql-pe.

Pushed into 6.0.14-alpha (revid:alik@sun.com-20100302142746-u1gxdf5yk2bjrq3e) (version source revid:alik@sun.com-20100301095421-4cz64ibem1h2quve) (merge vers: 6.0.14-alpha) (pib:16)

Changes in test code only. Closed without further action.

Pushed into 5.1.44-ndb-7.0.14 (revid:jonas@mysql.com-20100312135944-t0z8s1da2orvl66x) (version source revid:jonas@mysql.com-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)

Pushed into 5.1.44-ndb-6.2.19 (revid:jonas@mysql.com-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:jonas@mysql.com-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)

Pushed into 5.1.44-ndb-6.3.33 (revid:jonas@mysql.com-20100312135724-xcw8vw2lu3mijrhn) (version source revid:jonas@mysql.com-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)

Closing; see my previous comment.

Pushed into 5.5.4-m3 (revid:alik@sun.com-20100326080914-2pz8ns984e0spu03) (version source revid:alexey.kopytov@sun.com-20100307164059-cri8typa32cypq0l) (merge vers: 5.5.3-m2) (pib:16)

Pushed into mysql-next-mr (revid:alik@sun.com-20100326081116-m3v4l34yhr43mtsv) (version source revid:alik@sun.com-20100325072612-4sds00ix8ajo1e84) (pib:16)

Pushed into 5.1.46 (revid:sergey.glukhov@sun.com-20100405111026-7kz1p8qlzglqgfmu) (version source revid:joro@sun.com-20100301084434-ytctk3ceebjvqo7a) (merge vers: 5.1.45) (pib:16)

Setting back to Closed state; see my comment of 3 March.

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

3046 Andrei Elkin	2010-05-16
      removing disabled line for rpl_row_create_table  due to Bug#45576. Anyway, the test is still there because of Bug#51574

Pushed into 6.0.14-alpha (revid:alik@sun.com-20100520100225-oe4iuu5kuzsx0knq) (version source revid:alik@sun.com-20100520100057-rmn5y3o3ij726bm7) (merge vers: 6.0.14-alpha) (pib:16)

Pushed into 5.5.5-m3 (revid:alik@sun.com-20100520100041-rf8ujv598zf86wjt) (version source revid:alik@sun.com-20100520100041-rf8ujv598zf86wjt) (merge vers: 5.5.5-m3) (pib:16)

Pushed into mysql-next-mr (revid:alik@sun.com-20100520100140-5bzrtadw4w419i3m) (version source revid:alik@sun.com-20100520100049-1njm09rkvnhmysnr) (pib:16)

Changes in test code only. Closed without further action. (See my earlier comments.)

Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:martin.skold@mysql.com-20100609211156-tsac5qhw951miwtt) (merge vers: 5.1.46-ndb-6.2.19) (pib:16)

Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)