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

main.derived_opt, main.count_distinct2 failed with timeout in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.0
    • N/A
    • Tests
    • None
    • 5.5.55

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/4472/steps/test/logs/stdio

      main.count_distinct2                     w3 [ fail ]  timeout after 900 seconds
              Test ended at 2017-01-08 18:08:51
       
      Test case timeout after 900 seconds
       
      == /usr/local/mariadb-10.0.29-linux-x86_64/mysql-test/var/3/log/count_distinct2.log == 
      5
      select count(distinct n1), count(distinct n2) from t1;
      count(distinct n1)	count(distinct n2)
      2	3
      select count(distinct n2), n1 from t1 group by n1;
      count(distinct n2)	n1
      1	NULL
      1	1
      3	2
      drop table t1;
      create table t1 (n int default NULL);
      flush status;
      select count(distinct n) from t1;
      count(distinct n)
      5000
      show status like 'Created_tmp_disk_tables';
      Variable_name	Value
      Created_tmp_disk_tables	0
      drop table t1;
      create table t1 (s text);
      

      main.derived_opt                         w1 [ fail ]  timeout after 900 seconds
              Test ended at 2017-01-08 18:13:15
       
      Test case timeout after 900 seconds
       
      == /usr/local/mariadb-10.0.29-linux-x86_64/mysql-test/var/1/log/derived_opt.log == 
      1	a	3	c
      2	b	3	c
      3	c	3	c
      3	c	3	c
      explain select * from t1 as x1, (select * from t1) as x2;
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      1	SIMPLE	x1	ALL	NULL	NULL	NULL	NULL	4	
      1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using join buffer (flat, BNL join)
      drop table if exists  t2,t3;
      CREATE TABLE t2 (a int not null);
      insert into t2 values(1);
      select * from (select t1.*, t2.a as t2a from t1,t2 where t1.a=t2.a) t1;
      a	b	t2a
      1	a	1
      explain select * from (select t1.*, t2.a as t2a from t1,t2 where t1.a=t2.a) t1;
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      1	SIMPLE	t2	system	NULL	NULL	NULL	NULL	1	
      1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using where
      drop table t1, t2;
      create table t1(a int not null, t char(8), index(a));
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.