[MDEV-7907] tokudb.cluster_filter_unpack_varchar_hidden fails sporadically in buildbot Created: 2015-04-05  Updated: 2016-02-26  Resolved: 2016-02-26

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0, 10.1
Fix Version/s: 10.0.25, 10.1.13

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None

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

 Description   

http://buildbot.askmonty.org/buildbot/builders/bld-dan-release/builds/2379/steps/test/logs/stdio

CURRENT_TEST: tokudb.cluster_filter_unpack_varchar_hidden
--- /opt/buildbot-slave/mariadb/dan_demeter2/build/storage/tokudb/mysql-test/tokudb/r/cluster_filter_unpack_varchar_hidden.result	2015-03-24 18:33:33.114247391 +0200
+++ /opt/buildbot-slave/mariadb/dan_demeter2/build/storage/tokudb/mysql-test/tokudb/r/cluster_filter_unpack_varchar_hidden.reject	2015-04-04 21:49:08.159777079 +0300
@@ -182,14 +182,14 @@
 3	30	200	2000	20000	200000
 explain select * from t1 where b > "0";
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	index	b	b	NULL	NULL	NULL;	Using where; Using index
+1	SIMPLE	t1	range	b	b	NULL	NULL	NULL;	Using where; Using index
 select * from t1 where b > "0";
 a	b	c	d	e	f
 2	20	100	1000	10000	100000
 3	30	200	2000	20000	200000
 explain select * from t1 where d > "0";
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	index	d	d	NULL	NULL	NULL;	Using where; Using index
+1	SIMPLE	t1	range	d	d	NULL	NULL	NULL;	Using where; Using index
 select * from t1 where d > "0";
 a	b	c	d	e	f
 2	20	100	1000	10000	100000
 
mysqltest: Result content mismatch

So far it happened twice, on dan* builders (debug and non-debug, ps-protocol and normal).
The change of plan doesn't look scary, but the test needs to be fixed eventually.



 Comments   
Comment by Elena Stepanova [ 2015-08-07 ]

4 times now, last two times on 10.0. Still only on dan* builders.

Comment by Elena Stepanova [ 2016-02-22 ]

Still happens http://buildbot.askmonty.org/buildbot/builders/bld-dan-release/builds/3150

Comment by Elena Stepanova [ 2016-02-25 ]

If I run it long enough, I can get in on my machine too. On some reason, it happens faster when runs on 10.1 with ps-protocol, although according to cross-reference 10.0 and non-ps-protocol are also affected.

Comment by Elena Stepanova [ 2016-02-26 ]

https://github.com/MariaDB/server/commit/e7d50efc458b95d5fad92f6020758d7c63b0dc0b

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