Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4274

tokudb.bugs.5733_tokudb is unstable

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: 5.7.18-14
    • Fix Version/s: None
    • Component/s: TokuDB
    • Labels:

      Description

      23:20:43 tokudb.bugs.5733_tokudb                  w2 [ fail ]
      23:20:43         Test ended at 2017-05-25 23:20:43
      23:20:43 
      23:20:43 CURRENT_TEST: tokudb.bugs.5733_tokudb
      23:20:43 --- /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/mysql-test/suite/tokudb.bugs/r/5733_tokudb.result	2017-05-26 01:59:08.860963000 +0300
      23:20:43 +++ /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/build/mysql-test/var/2/log/5733_tokudb.reject	2017-05-26 02:20:43.535415317 +0300
      23:20:43 @@ -10003,22 +10003,22 @@
      23:20:43  insert into t values (9999,0);
      23:20:43  explain select id from t where id>0 limit 10;
      23:20:43  id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
      23:20:43 -1	SIMPLE	t	range_or_index	range	PRIMARY	PRIMARY	8	#	9999	100.00	Using where; Using index
      23:20:43 +1	SIMPLE	t	range_or_index	range	PRIMARY	PRIMARY	8	#	6488	100.00	Using where; Using index
      23:20:43  Warnings:
      23:20:43  Note	1003	/* select#1 */ select `test`.`t`.`id` AS `id` from `test`.`t` where (`test`.`t`.`id` > 0) limit 10
      23:20:43  explain select * from t where id>0 limit 10;
      23:20:43  id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
      23:20:43 -1	SIMPLE	t	NULL	range	PRIMARY	PRIMARY	8	#	9999	100.00	Using where
      23:20:43 +1	SIMPLE	t	NULL	range	PRIMARY	PRIMARY	8	#	6488	100.00	Using where
      23:20:43  Warnings:
      23:20:43  Note	1003	/* select#1 */ select `test`.`t`.`id` AS `id`,`test`.`t`.`x` AS `x` from `test`.`t` where (`test`.`t`.`id` > 0) limit 10
      23:20:43  explain select id from t where id>1000 limit 10;
      23:20:43  id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
      23:20:43 -1	SIMPLE	t	NULL	range	PRIMARY	PRIMARY	8	#	8999	100.00	Using where; Using index
      23:20:43 +1	SIMPLE	t	NULL	range	PRIMARY	PRIMARY	8	#	5488	100.00	Using where; Using index
      23:20:43  Warnings:
      23:20:43  Note	1003	/* select#1 */ select `test`.`t`.`id` AS `id` from `test`.`t` where (`test`.`t`.`id` > 1000) limit 10
      23:20:43  explain select * from t where id>1000 limit 10;
      23:20:43  id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
      23:20:43 -1	SIMPLE	t	NULL	range	PRIMARY	PRIMARY	8	#	8999	100.00	Using where
      23:20:43 +1	SIMPLE	t	NULL	range	PRIMARY	PRIMARY	8	#	5488	100.00	Using where
      23:20:43  Warnings:
      23:20:43  Note	1003	/* select#1 */ select `test`.`t`.`id` AS `id`,`test`.`t`.`x` AS `x` from `test`.`t` where (`test`.`t`.`id` > 1000) limit 10
      23:20:43  explain select id from t where id>5000 limit 10;
      23:20:43 
      23:20:43 mysqltest: Result content mismatch
      23:20:43 
      23:20:43 safe_process[17978]: Child process: 17979, exit: 1
      23:20:43 
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              george.lorch George Lorch
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: