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

innodb.innodb_stats_persistent failed in buildbot with wrong result in execution plan

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.2(EOL)
    • N/A
    • Tests, MTR
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3186

      10.2 aaaf6ceb8bcdfec103fd3131ff826113

      innodb.innodb_stats_persistent 'innodb'  w4 [ fail ]
              Test ended at 2019-12-21 11:54:02
       
      CURRENT_TEST: innodb.innodb_stats_persistent
      --- /usr/share/mysql-test/suite/innodb/r/innodb_stats_persistent.result	2019-12-21 10:40:37.000000000 +0000
      +++ /dev/shm/var/4/log/innodb_stats_persistent.reject	2019-12-21 11:54:02.037904709 +0000
      @@ -22,7 +22,7 @@
       # DELETE must not affect statistics before COMMIT.
       EXPLAIN SELECT * FROM t1 WHERE val=4;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	ref	val	val	4	const	1	Using index
      +1	SIMPLE	t1	ref	val	val	4	const	2	Using index
       connection con1;
       COUNT(*)
       0
      @@ -90,11 +90,11 @@
       # ha_innobase::records_in_range() would count the delete-marked records.
       EXPLAIN SELECT * FROM t1;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index	NULL	val	4	NULL	1	Using index
      +1	SIMPLE	t1	index	NULL	val	4	NULL	2	Using index
       ROLLBACK;
       EXPLAIN SELECT * FROM t1;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index	NULL	val	4	NULL	16	Using index
      +1	SIMPLE	t1	index	NULL	val	4	NULL	18	Using index
       SELECT COUNT(*) FROM t1;
       COUNT(*)
       16
       
      mysqltest: Result content mismatch
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.