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: | |
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 |
[18 Jun 2009 5:46]
Zhenxing He
[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)