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

main.delete_use_source fails in buildbot and outside with wrong plan

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.3
    • Fix Version/s: 10.3.1
    • Component/s: Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/2583/steps/mtr/logs/stdio

      main.delete_use_source 'innodb'          w1 [ fail ]
              Test ended at 2017-07-08 01:42:52
       
      CURRENT_TEST: main.delete_use_source
      --- /usr/local/mariadb-10.2.7-linux-x86_64/mysql-test/r/delete_use_source.result	2017-07-07 23:42:11.000000000 +0300
      +++ /usr/local/mariadb-10.2.7-linux-x86_64/mysql-test/r/delete_use_source.reject	2017-07-08 01:42:52.427051960 +0300
      @@ -44,8 +44,8 @@
       start transaction;
       explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	PRIMARY	t1	range	c1	c1	4	NULL	550	Using where
      -2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	82	Using index
      +1	PRIMARY	t1	ALL	c1	NULL	NULL	NULL	472	Using where
      +2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	113	Using index
       delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;
       affected rows: 1
       delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;
      @@ -60,8 +60,8 @@
       start transaction;
       explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	PRIMARY	t1	ALL	c1	NULL	NULL	NULL	717	Using where
      -2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	82	Using index
      +1	PRIMARY	t1	ALL	c1	NULL	NULL	NULL	472	Using where
      +2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	113	Using index
       delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 ;
       affected rows: 500
       select count(*) from v1 where c1=0;
       
      mysqltest: Result length mismatch
      

      The test has been failing in buildbot ever since it was pushed to bb-10.2-ext here:
      https://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/6431/steps/test/logs/stdio . As of now, there are 1263 recorded failures.

      It also failed for me when I ran it locally on the current 10.3 tree.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: