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

main.delete_use_source fails sporadically in buildbot with wrong execution plan

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • 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/2517/steps/mtr/logs/stdio

      main.delete_use_source 'innodb'          w2 [ fail ]
              Test ended at 2017-08-01 13:18:28
       
      CURRENT_TEST: main.delete_use_source
      --- /usr/share/mysql/mysql-test/r/delete_use_source.result	2017-08-01 08:31:50.000000000 -0400
      +++ /dev/shm/var/2/log/delete_use_source.reject	2017-08-01 13:18:27.839087197 -0400
      @@ -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
      

      Reproducible locally by running the test with --repeat=N.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: