Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0(EOL)
-
None
Description
Timeouts – happened a few times in April, logs not available:
main.subselect w5 [ fail ] timeout after 9000 seconds
|
Test ended at 2016-04-26 22:55:19
|
|
|
Test case timeout after 9000 seconds
|
|
|
== /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/5/log/subselect.log ==
|
set optimizer_switch = 'subquery_cache=off';
|
SELECT * FROM t1 WHERE ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) OR a > 100;
|
a
|
SELECT *, ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) FROM t1;
|
a ( 3, 3 ) NOT IN ( SELECT NULL, NULL )
|
1 NULL
|
2 NULL
|
3 NULL
|
set optimizer_switch=@mdev367_optimizer_switch;
|
DROP TABLE t1;
|
#
|
# MDEV-521 single value subselect transformation problem
|
#
|
CREATE TABLE t1 (f1 char(2), PRIMARY KEY (f1)) ENGINE=MyISAM;
|
INSERT INTO t1 VALUES ('u1'),('u2');
|
SELECT a.* FROM t1 a WHERE ( SELECT EXISTS ( SELECT 1 FROM t1 b WHERE b.f1 = a.f1 ) );
|
f1
|
u1
|
u2
|
FLUSH TABLES;
|
main.subselect w2 [ fail ] timeout after 900 seconds
|
Test ended at 2016-04-26 13:09:12
|
|
|
Test case timeout after 900 seconds
|
|
|
== /usr/local/mariadb-10.0.24-linux-i686/mysql-test/var/2/log/subselect.log ==
|
set optimizer_switch = 'subquery_cache=off';
|
SELECT * FROM t1 WHERE ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) OR a > 100;
|
a
|
SELECT *, ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) FROM t1;
|
a ( 3, 3 ) NOT IN ( SELECT NULL, NULL )
|
1 NULL
|
2 NULL
|
3 NULL
|
set optimizer_switch=@mdev367_optimizer_switch;
|
DROP TABLE t1;
|
#
|
# MDEV-521 single value subselect transformation problem
|
#
|
CREATE TABLE t1 (f1 char(2), PRIMARY KEY (f1)) ENGINE=MyISAM;
|
INSERT INTO t1 VALUES ('u1'),('u2');
|
SELECT a.* FROM t1 a WHERE ( SELECT EXISTS ( SELECT 1 FROM t1 b WHERE b.f1 = a.f1 ) );
|
f1
|
u1
|
u2
|
FLUSH TABLES;
|
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Closed
-
Activity
It turns out to be a bad (broken) build, lots of things failed with timeout that day, apparently it was fixed by the very next commit:
commit b7ad1ba5d121d4fe4b0655e46076b6e50754b4e9 44554d611194e2ac02e5beaf4b88ffe5a349ebb4
|
Author: Monty <monty@mariadb.org>
|
Date: Tue Apr 26 20:11:40 2016 +0300
|
|
|
Fixed mutex that wasn't properly unlocked (typo in last patch)
|
|
Also main.subselect_sj2 – happened last time in March, logs also not available:
main.subselect_sj2 'xtradb' w4 [ fail ] timeout after 900 secondsTest ended at 2016-03-10 11:29:05Test case timeout after 900 seconds== /usr/local/mariadb-10.0.24-linux-x86_64/mysql-test/var/4/log/subselect_sj2.log ==explain select * from t1 where a in (select b from t2);id select_type table type possible_keys key key_len ref rows Extra1 PRIMARY t1 ALL NULL NULL NULL NULL 3 Using where1 PRIMARY t2 ref b b 5 test.t1.a 2 Using index; FirstMatch(t1)select * from t1;a b1 11 12 2select * from t1 where a in (select b from t2);a b1 11 12 2drop table t1, t2, t3;set @save_join_buffer_size = @@join_buffer_size;set join_buffer_size= 8192;create table t1 (a int, filler1 binary(200), filler2 binary(200));insert into t1 select a, 'filler123456', 'filler123456' from t0;insert into t1 select a+10, 'filler123456', 'filler123456' from t0;