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

main.innodb_icp fails in buildbot with various wrong execution plans

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-x86/builds/18180

      10.4 819c40d694071e56adb62ded97561717

      main.innodb_icp 'innodb'                 w3 [ fail ]
              Test ended at 2019-07-22 18:31:40
       
      CURRENT_TEST: main.innodb_icp
      --- /usr/local/mariadb-10.4.7-linux-i686/mysql-test/main/innodb_icp.result	2019-07-22 16:40:50.000000000 +0300
      +++ /usr/local/mariadb-10.4.7-linux-i686/mysql-test/main/innodb_icp.reject	2019-07-22 18:31:40.171876075 +0300
      @@ -172,7 +172,7 @@
       ORDER BY ts DESC
       LIMIT 2;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	4	Using where
      +1	SIMPLE	t1	index	PRIMARY	PRIMARY	4	NULL	2	Using where
       
       DROP TABLE t1;
       #
       
      mysqltest: Result content mismatch
      

      10.4 f5390eea9a9fa307876c4f78cd876edb

      main.innodb_icp 'innodb'                 w3 [ fail ]
              Test ended at 2019-07-17 12:21:49
       
      CURRENT_TEST: main.innodb_icp
      Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.4.7/mysql-test/std_data/cacert.pem'
      Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.4.7/mysql-test/std_data/client-cert.pem'
      Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.4.7/mysql-test/std_data/client-key.pem'
      Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
      --- /mnt/buildbot/build/mariadb-10.4.7/mysql-test/main/innodb_icp.result	2019-07-17 07:03:53.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.4.7/mysql-test/main/innodb_icp.reject	2019-07-17 12:21:48.789562771 -0400
      @@ -437,7 +437,7 @@
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	3	Using where
       2	DEPENDENT SUBQUERY	it	eq_ref	PRIMARY	PRIMARY	4	func	1	Using where
      -2	DEPENDENT SUBQUERY	t2	index	NULL	PRIMARY	4	NULL	3	Using index; Using join buffer (flat, BNL join)
      +2	DEPENDENT SUBQUERY	t2	index	NULL	PRIMARY	4	NULL	4	Using index; Using join buffer (flat, BNL join)
       SELECT * FROM t1
       WHERE pk IN (SELECT it.pk FROM t2 JOIN t2 AS it ON it.i=it.i WHERE it.pk-t1.i<10);
       pk	i
       
      mysqltest: Result content mismatch
      

      etc.

      Attachments

        Activity

          Another example from buildbot:

          CURRENT_TEST: main.innodb_icp
          --- /usr/local/mariadb-10.4.8-linux-i686/mysql-test/main/innodb_icp.result	2019-09-04 01:36:56.000000000 -0400
          +++ /usr/local/mariadb-10.4.8-linux-i686/mysql-test/main/innodb_icp.reject	2019-09-04 03:08:50.771793071 -0400
          @@ -690,8 +690,8 @@
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 
           HAVING t1.c != 5 ORDER BY t1.c;
           id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
          -1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort
          -1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where
          +1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort
          +1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0
           HAVING t1.c != 5 ORDER BY t1.c;
           b	c
          @@ -701,8 +701,8 @@
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0
           HAVING t1.c != 5 ORDER BY t1.c;
           id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
          -1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort
          -1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where
          +1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort
          +1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0
           HAVING t1.c != 5 ORDER BY t1.c;
           b	c
           
          mysqltest: Result length mismatch
          

          marko Marko Mäkelä added a comment - Another example from buildbot : CURRENT_TEST: main.innodb_icp --- /usr/local/mariadb-10.4.8-linux-i686/mysql-test/main/innodb_icp.result 2019-09-04 01:36:56.000000000 -0400 +++ /usr/local/mariadb-10.4.8-linux-i686/mysql-test/main/innodb_icp.reject 2019-09-04 03:08:50.771793071 -0400 @@ -690,8 +690,8 @@ SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using filesort -1 SIMPLE t2 ref a a 515 test.t1.a 1 Using where +1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using temporary; Using filesort +1 SIMPLE t2 ALL a NULL NULL NULL 5 Using where; Using join buffer (flat, BNL join) SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; b c @@ -701,8 +701,8 @@ SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using filesort -1 SIMPLE t2 ref a a 515 test.t1.a 1 Using where +1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using temporary; Using filesort +1 SIMPLE t2 ALL a NULL NULL NULL 5 Using where; Using join buffer (flat, BNL join) SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; b c   mysqltest: Result length mismatch
          alice Alice Sherepa added a comment -

          http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos8-amd64/builds/1714/steps/mtr/logs/stdio

          main.innodb_icp 'innodb'                 w1 [ fail ]
                  Test ended at 2020-10-22 05:40:32
           
          CURRENT_TEST: main.innodb_icp
          --- /usr/share/mysql-test/main/innodb_icp.result	2020-10-22 03:18:04.000000000 +0000
          +++ /dev/shm/var/1/log/innodb_icp.reject	2020-10-22 05:40:32.615373193 +0000
          @@ -690,8 +690,8 @@
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 
           HAVING t1.c != 5 ORDER BY t1.c;
           id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
          -1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort
          -1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where
          +1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort
          +1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0
           HAVING t1.c != 5 ORDER BY t1.c;
           b	c
          @@ -701,8 +701,8 @@
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0
           HAVING t1.c != 5 ORDER BY t1.c;
           id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
          -1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort
          -1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where
          +1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort
          +1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)
           SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0
           HAVING t1.c != 5 ORDER BY t1.c;
           b	c
           
          mysqltest: Result length mismatch
          

          alice Alice Sherepa added a comment - http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos8-amd64/builds/1714/steps/mtr/logs/stdio main.innodb_icp 'innodb' w1 [ fail ] Test ended at 2020-10-22 05:40:32   CURRENT_TEST: main.innodb_icp --- /usr/share/mysql-test/main/innodb_icp.result 2020-10-22 03:18:04.000000000 +0000 +++ /dev/shm/var/1/log/innodb_icp.reject 2020-10-22 05:40:32.615373193 +0000 @@ -690,8 +690,8 @@ SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using filesort -1 SIMPLE t2 ref a a 515 test.t1.a 1 Using where +1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using temporary; Using filesort +1 SIMPLE t2 ALL a NULL NULL NULL 5 Using where; Using join buffer (flat, BNL join) SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; b c @@ -701,8 +701,8 @@ SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using filesort -1 SIMPLE t2 ref a a 515 test.t1.a 1 Using where +1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 1 Using where; Using temporary; Using filesort +1 SIMPLE t2 ALL a NULL NULL NULL 5 Using where; Using join buffer (flat, BNL join) SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0 HAVING t1.c != 5 ORDER BY t1.c; b c   mysqltest: Result length mismatch

          People

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