[#MDEV-10613] main.subselect, main.subselect_no_exists_to_in, main.subselect_no_mat, main.subselect_no

[MDEV-10613] main.subselect, main.subselect_no_exists_to_in, main.subselect_no_mat, main.subselect_no_opts failed in buildbot Created: 2016-08-20 Updated: 2016-08-20 Resolved: 2016-08-20
Status:	Closed
Project:	MariaDB Server
Component/s:	Tests
Affects Version/s:	10.0
Fix Version/s:	N/A

Type:

Bug

Priority:

Minor

Reporter:

Elena Stepanova

Assignee:

Unassigned

Resolution:

Fixed

Votes:

Labels:

None

Issue Links:

Relates
relates to	MDEV-7069	Fix buildbot failures in main server ...	Stalled

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;

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;

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;

Comments

Comment by Elena Stepanova [ 2016-08-20 ]

Also main.subselect_sj2 – happened last time in March, logs also not available:

main.subselect_sj2 'xtradb'              w4 [ fail ]  timeout after 900 seconds

        Test ended at 2016-03-10 11:29:05

Test 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	Extra

1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	3	Using where

1	PRIMARY	t2	ref	b	b	5	test.t1.a	2	Using index; FirstMatch(t1)

select * from t1;

a	b

1	1

1	1

2	2

select * from t1 where a in (select b from t2);

a	b

1	1

1	1

2	2

drop 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;

Comment by Elena Stepanova [ 2016-08-20 ]

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)

Generated at Thu Feb 08 07:43:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.