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)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.120 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.