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)

[18 Jun 2009 5:46] Zhenxing He
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.
[7 Jul 2009 14:11] 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/78139

3008 Georgi Kodinov	2009-07-07
      Bug #45578, Bug #46010, Bug #45576 : made the failing tests experimental
[28 Aug 2009 16:01] Andrei Elkin
The issue relates to selecting from I_S, no to replication.
There is Bug #42190 claiming incorrect results of selecting.
[28 Aug 2009 16:06] Andrei Elkin
And yet other bugs can retate Bug #29790, Bug #44009.
[30 Nov 2009 1:27] Luis Soares
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)...
[30 Nov 2009 1:30] Luis Soares
See:

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

for new failure sample.
[30 Nov 2009 1:33] Luis Soares
Push:

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

Seems to have triggered this new symptom.
[1 Dec 2009 9:21] 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/92228

3233 Georgi Kodinov	2009-12-01
      Bug #45576: moving the test from experimental to disabled.
[1 Dec 2009 9:22] Georgi Kodinov
back to verified : only test disabled.
[2 Dec 2009 4:50] Libing Song
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.
[2 Dec 2009 8:04] Bugs System
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)
[16 Dec 2009 8:39] Bugs System
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)
[16 Dec 2009 8:46] Bugs System
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)
[16 Dec 2009 8:53] Bugs System
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)
[8 Jan 2010 15:06] Andrei Elkin
Bug #29790 forces to avoid I_S selecting in tests relying on deterministic
results.
[18 Feb 2010 18:33] 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/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.
[19 Feb 2010 10:00] 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/100834

3346 Andrei Elkin	2010-02-19
      bug#45576
      a small cleanup for the test
[19 Feb 2010 15:04] 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/100883

3346 Andrei Elkin	2010-02-19
      bug#45576
      a small cleanup for the test
[26 Feb 2010 12: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/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.
[27 Feb 2010 15:13] Andrei Elkin
Pushed to 5.1-bt, mysql-pe.
[2 Mar 2010 14:33] Bugs System
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)
[3 Mar 2010 4:47] Jon Stephens
Changes in test code only. Closed without further action.
[12 Mar 2010 14:14] Bugs System
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)
[12 Mar 2010 14:29] Bugs System
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)
[12 Mar 2010 14:46] Bugs System
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)
[15 Mar 2010 4:21] Jon Stephens
Closing; see my previous comment.
[26 Mar 2010 8:21] Bugs System
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)
[26 Mar 2010 8:25] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100326081116-m3v4l34yhr43mtsv) (version source revid:alik@sun.com-20100325072612-4sds00ix8ajo1e84) (pib:16)
[6 Apr 2010 7:58] Bugs System
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)
[6 Apr 2010 10:35] Jon Stephens
Setting back to Closed state; see my comment of 3 March.
[16 May 2010 19:29] 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/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
[20 May 2010 10:03] Bugs System
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)
[20 May 2010 10:04] Bugs System
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)
[20 May 2010 10:06] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100520100140-5bzrtadw4w419i3m) (version source revid:alik@sun.com-20100520100049-1njm09rkvnhmysnr) (pib:16)
[20 May 2010 14:21] Jon Stephens
Changes in test code only. Closed without further action. (See my earlier comments.)
[17 Jun 2010 11:57] Bugs System
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)
[17 Jun 2010 12:36] Bugs System
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)
[17 Jun 2010 13:23] Bugs System
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)