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

main.subselect_innodb fails sporadically in buildbot

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.0(EOL), 10.1(EOL)
    • N/A
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar/builds/1458/steps/test/logs/stdio

      main.subselect_innodb 'innodb_plugin'    w2 [ fail ]
              Test ended at 2016-08-17 11:40:56
       
      CURRENT_TEST: main.subselect_innodb
      --- /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/r/subselect_innodb.result	2016-08-17 10:03:04.482303275 -0400
      +++ /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/r/subselect_innodb.reject	2016-08-17 11:40:55.362804745 -0400
      @@ -545,5 +545,5 @@
       t1;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	#	
      -2	DEPENDENT SUBQUERY	t2	ref	key1	key1	5	test.t1.a	#	Using where; Using filesort
      +2	DEPENDENT SUBQUERY	t2	index	key1	key2	5	NULL	#	Using where
       drop table t1,t2;
       
      mysqltest: Result length mismatch
      

      Attachments

        Issue Links

          Activity

            Fresh occurrence on 10.1:
            http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles12-amd64/builds/3935/steps/mtr/logs/stdio

            main.subselect_innodb 'xtradb'           w3 [ fail ]
                    Test ended at 2017-12-07 15:51:41
             
            CURRENT_TEST: main.subselect_innodb
            --- /usr/share/mysql-test/r/subselect_innodb.result	2017-12-07 10:25:32.000000000 -0500
            +++ /dev/shm/var/3/log/subselect_innodb.reject	2017-12-07 15:51:41.713298499 -0500
            @@ -574,7 +574,7 @@
             t1;
             id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
             1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	#	
            -2	DEPENDENT SUBQUERY	t2	ref	key1	key1	5	test.t1.a	#	Using where; Using filesort
            +2	DEPENDENT SUBQUERY	t2	index	key1	key2	5	NULL	#	Using where
             drop table t1,t2;
             #
             
             # mdev-12931: semi-join in ON expression of STRAIGHT_JOIN 
             
            mysqltest: Result length mismatch
            

            elenst Elena Stepanova added a comment - Fresh occurrence on 10.1: http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles12-amd64/builds/3935/steps/mtr/logs/stdio main.subselect_innodb 'xtradb' w3 [ fail ] Test ended at 2017-12-07 15:51:41   CURRENT_TEST: main.subselect_innodb --- /usr/share/mysql-test/r/subselect_innodb.result 2017-12-07 10:25:32.000000000 -0500 +++ /dev/shm/var/3/log/subselect_innodb.reject 2017-12-07 15:51:41.713298499 -0500 @@ -574,7 +574,7 @@ t1; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL # -2 DEPENDENT SUBQUERY t2 ref key1 key1 5 test.t1.a # Using where; Using filesort +2 DEPENDENT SUBQUERY t2 index key1 key2 5 NULL # Using where drop table t1,t2; #   # mdev-12931: semi-join in ON expression of STRAIGHT_JOIN   mysqltest: Result length mismatch

            People

              psergei Sergei Petrunia
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.