Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18384

rocksdb.index_merge_rocksdb2 test fails

    XMLWordPrintable

    Details

      Description

      rocksdb.index_merge_rocksdb2 is failing in MariaDB 10.2.21 (but the fail was also seen in previous versions) for x86_64 architecture. See logs below for more information.

      Logging: ./mysql-test-run  rocksdb.index_merge_rocksdb2
      vardir: /usr/share/mysql-test/var
      Removing old var directory...
      Creating var directory '/usr/share/mysql-test/var'...
      Checking supported features...
      Can't exec "patch": No such file or directory at ./mysql-test-run line 1979.
      MariaDB Version 10.2.21-MariaDB
       - SSL connections supported
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
      rocksdb.index_merge_rocksdb2 'write_prepared' [ fail ]
              Test ended at 2019-01-25 22:26:51
       
      CURRENT_TEST: rocksdb.index_merge_rocksdb2
      --- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/index_merge_rocksdb2.result	2018-12-31 00:29:21.000000000 +0100
      +++ /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/index_merge_rocksdb2.reject	2019-01-25 22:26:51.250437614 +0100
      @@ -26,7 +26,7 @@
       test.t0	analyze	status	OK
       explain select * from t0 where key1 < 3 or key1 > 1020;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t0	range	i1	i1	4	NULL	2	Using index condition; Using where
      +1	SIMPLE	t0	range	i1	i1	4	NULL	4	Using index condition; Using where
       explain
       select * from t0 where key1 < 3 or key2 > 1020;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      @@ -260,33 +260,33 @@
       explain
       select * from t0,t1 where (t0.key1=t1.key1) and ( t0.key1=3 or t0.key2=4);
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t0	index_merge	i1,i2	i1,i2	4,4	NULL	#	Using union(i1,i2); Using where
      -1	SIMPLE	t1	ref	i1	i1	4	test.t0.key1	#	
      +1	SIMPLE	t1	ALL	i1	NULL	NULL	NULL	#	
      +1	SIMPLE	t0	ref	i1,i2	i1	4	test.t1.key1	#	Using where
       explain
       select * from t0,t1 where (t0.key1=t1.key1) and
       (t0.key1=3 or t0.key2<4) and t1.key1=2;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	SIMPLE	t0	ref	i1,i2	i1	4	const	2	Using where
      -1	SIMPLE	t1	ref	i1	i1	4	const	1	
      +1	SIMPLE	t1	ref	i1	i1	4	const	2	
       explain select * from t0,t1 where t0.key1 = 5 and
       (t1.key1 = t0.key1 or t1.key8 = t0.key1);
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t0	ref	i1	i1	4	const	1	
      -1	SIMPLE	t1	index_merge	i1,i8	i1,i8	4,4	NULL	2	Using union(i1,i8); Using where; Using join buffer (flat, BNL join)
      +1	SIMPLE	t1	ALL	i1,i8	NULL	NULL	NULL	0	Using where
      +1	SIMPLE	t0	ref	i1	i1	4	const	2	
       explain select * from t0,t1 where t0.key1 < 3 and
       (t1.key1 = t0.key1 or t1.key8 = t0.key1);
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t0	range	i1	i1	4	NULL	#	Using index condition
      -1	SIMPLE	t1	ALL	i1,i8	NULL	NULL	NULL	#	Range checked for each record (index map: 0x81)
      +1	SIMPLE	t1	ALL	i1,i8	NULL	NULL	NULL	#	
      +1	SIMPLE	t0	range	i1	i1	4	NULL	#	Using index condition; Using where; Using join buffer (flat, BNL join)
       explain select * from t1 where key1=3 or key2=4
       union select * from t1 where key1<4 or key3=5;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	PRIMARY	t1	index_merge	i1,i2	i1,i2	4,4	NULL	4	Using union(i1,i2); Using where
      -2	UNION	t1	index_merge	i1,i3	i1,i3	4,4	NULL	4	Using sort_union(i1,i3); Using where
      +1	PRIMARY	t1	ALL	i1,i2	NULL	NULL	NULL	0	Using where
      +2	UNION	t1	ALL	i1,i3	NULL	NULL	NULL	0	Using where
       NULL	UNION RESULT	<union1,2>	ALL	NULL	NULL	NULL	NULL	NULL	
       explain select * from (select * from t1 where key1 = 3 or key2 =3) as Z where key8 >5;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index_merge	i1,i2,i8	i1,i2	4,4	NULL	2	Using union(i1,i2); Using where
      +1	SIMPLE	t1	range	i1,i2,i8	i8	4	NULL	2	Using index condition; Using where
       create table t3 like t0;
       insert into t3 select * from t0;
       alter table t3 add key9 int not null, add index i9(key9);
      @@ -392,10 +392,10 @@
       8704
       explain select * from t1 WHERE cola = 'foo' AND colb = 'bar';
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index_merge	cola,colb	cola,colb	3,3	NULL	#	Using intersect(cola,colb); Using where
      +1	SIMPLE	t1	ref	cola,colb	cola	3	const	#	Using index condition; Using where
       explain select * from t1 force index(cola,colb) WHERE cola = 'foo' AND colb = 'bar';
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index_merge	cola,colb	cola,colb	3,3	NULL	#	Using intersect(cola,colb); Using where
      +1	SIMPLE	t1	ref	cola,colb	cola	3	const	#	Using index condition; Using where
       drop table t1;
       CREATE TABLE t1(a INT);
       INSERT INTO t1 VALUES(1);
      @@ -517,9 +517,8 @@
       where t2.a=t1.a and (t3.a=t2.b or t3.b=t2.b or t3.b=t2.b+1));
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	#	
      -1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	#	
      -2	MATERIALIZED	t2	ALL	NULL	NULL	NULL	NULL	#	
      -2	MATERIALIZED	t3	ALL	a,b	NULL	NULL	NULL	#	Range checked for each record (index map: 0x3)
      +1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	#	Using where
      +1	PRIMARY	t3	ALL	a,b	NULL	NULL	NULL	#	Range checked for each record (index map: 0x3); FirstMatch(t1)
       select * from t1 
       where exists (select 1 from t2, t3 
       where t2.a=t1.a and (t3.a=t2.b or t3.b=t2.b or t3.b=t2.b+1));
      @@ -603,7 +602,7 @@
       64801
       explain select key1,key2 from t1 where key1=100 and key2=100;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index_merge	key1,key2	key2,key1	5,5	NULL	#	Using intersect(key2,key1); Using where; Using index
      +1	SIMPLE	t1	index_merge	key1,key2	key1,key2	5,5	NULL	#	Using intersect(key1,key2); Using where; Using index
       select key1,key2 from t1 where key1=100 and key2=100;
       key1	key2
       100	100
      @@ -789,7 +788,7 @@
       Level	Code	Message
       explain select pk from t1 where key1 = 1 and key2 = 1;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	ref	key1,key2	key1	5	const	2	Using where
      +1	SIMPLE	t1	index_merge	key1,key2	key2,key1	4,5	NULL	1	Using intersect(key2,key1); Using where; Using index
       select pk from t1 where key2 = 1 and key1 = 1;
       pk
       26
      @@ -1057,7 +1056,7 @@
       FROM t1
       WHERE c = 1 AND b = 1 AND d = 1;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	ref	c,bd	c	5	const	2	Using where
      +1	SIMPLE	t1	index_merge	c,bd	c,bd	5,10	NULL	1	Using intersect(c,bd); Using where; Using index
       CREATE TABLE t2 ( a INT )
       SELECT a
       FROM t1
      @@ -1110,7 +1109,7 @@
       (((pk BETWEEN 141 AND 141) OR col_varchar_key <> 'l') 
       AND ((pk BETWEEN 141 AND 141) OR (col_int_key > 141)));
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index	PRIMARY,col_int_key,col_varchar_key	col_varchar_key	7	NULL	2	Using where; Using index
      +1	SIMPLE	t1	index	PRIMARY,col_int_key,col_varchar_key	col_varchar_key	7	NULL	4	Using where; Using index
       SELECT col_int_key
       FROM t1
       WHERE col_varchar_key >= 'l' OR 
      @@ -1288,7 +1287,7 @@
       );
       explain select * from t1 where pk1 = 1 and pk2 < 80  and key1=0;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	range	PRIMARY,key1	key1	12	NULL	ROWS	Using index condition
      +1	SIMPLE	t1	range	PRIMARY,key1	PRIMARY	8	NULL	ROWS	Using where
       select * from t1 where pk1 = 1 and pk2 < 80  and key1=0;
       pk1	pk2	key1	key2	pktail1ok	pktail2ok	pktail3bad	pktail4bad	pktail5bad	pk2copy	badkey	filler1	filler2
       1	10	0	0	0	0	0	0	0	10	0	filler-data-10	filler2
      @@ -1321,13 +1320,13 @@
       1	SIMPLE	t1	ref	key1	key1	4	const	ROWS	Using where
       explain select * from t1 where pk1 < 7500 and key1 = 10;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	range	PRIMARY,key1	key1	8	NULL	ROWS	Using index condition
      +1	SIMPLE	t1	range	PRIMARY,key1	PRIMARY	4	NULL	ROWS	Using where
       explain select * from t1 where pktail1ok=1 and key1=10;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index_merge	key1,pktail1ok	key1,pktail1ok	4,4	NULL	1	Using intersect(key1,pktail1ok); Using where
      +1	SIMPLE	t1	ref	key1,pktail1ok	key1	4	const	2	Using where
       explain select * from t1 where pktail2ok=1 and key1=10;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index_merge	key1,pktail2ok	key1,pktail2ok	4,4	NULL	1	Using intersect(key1,pktail2ok); Using where
      +1	SIMPLE	t1	ref	key1,pktail2ok	key1	4	const	2	Using where
       explain select * from t1 where (pktail2ok=1 and pk1< 50000) or key1=10;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	SIMPLE	t1	index_merge	PRIMARY,key1,pktail2ok	PRIMARY,key1	4,4	NULL	ROWS	Using union(PRIMARY,key1); Using where
      @@ -1393,7 +1392,7 @@
       WHERE (SELECT COUNT(*) FROM t2 WHERE t2.f3 = 'h' AND t2.f2 = t1.f1) = 0 AND t1.f1 = 2;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	t1	const	PRIMARY	PRIMARY	4	const	1	Using index
      -2	SUBQUERY	t2	ref	f2,f3	f2	5	const	1	Using where
      +2	SUBQUERY	t2	index_merge	f2,f3	f3,f2	2,5	NULL	1	Using intersect(f3,f2); Using where; Using index
       DROP TABLE t1,t2;
       set global rocksdb_force_flush_memtable_now=1;
       #
      @@ -1412,5 +1411,5 @@
       INSERT INTO t1 SELECT id + 16, 7, 0 FROM t1;
       EXPLAIN SELECT SQL_NO_CACHE count(*) FROM t1 WHERE id2=7 AND id3=0;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	ref	id2,id3,covering_index	covering_index	8	const,const	1	Using index
      +1	SIMPLE	t1	ref	id2,id3,covering_index	covering_index	8	const,const	2	Using index
       DROP TABLE t1;
       
      mysqltest: Result length mismatch
       
       - saving '/usr/share/mysql-test/var/log/rocksdb.index_merge_rocksdb2-write_prepared/' to '/usr/share/mysql-test/var/log/rocksdb.index_merge_rocksdb2-write_prepared/'
       
      Only  1  of 2 completed.
      --------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 0.000 of 42 seconds executing testcases
       
      Failure: Failed 1/1 tests, 0.00% were successful.
       
      Failing test(s): rocksdb.index_merge_rocksdb2
      

        Attachments

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            kstreitova Kristyna Streitova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: