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

innodb-index sporadic failure on MDEV-15325 test case

    XMLWordPrintable

Details

    Description

      CURRENT_TEST: innodb.innodb-index
      mysqltest: At line 1115: query 'SELECT * FROM t1' failed: 1286: Unknown storage engine 'InnoDB'
       
      The result from queries just before the failure was:
      < snip >
      insert into t1 values(1,1,2),(2,2,1);
      alter table t1 add n1 int not null, drop primary key, add primary key(o1,n1,o2), lock=none;
      drop table t1;
      create table t1(o1 int, o2 int, o3 int, primary key(o1,o2,o3)) engine = innodb;
      insert into t1 values(1,1,2),(2,2,1);
      alter table t1 drop primary key, add primary key(o1), lock=none;
      drop table t1;
      #
      # MDEV-15325 Incomplete validation of missing tablespace during recovery
      #
      CREATE TABLE t1(f1 INT PRIMARY KEY)ENGINE=InnoDB;
      CREATE TABLE t2(f1 INT PRIMARY KEY)ENGINE=InnoDB;
      # Kill the server
      # Wrong space_id in a dirty file and a missing file
      SELECT * FROM INFORMATION_SCHEMA.ENGINES
      WHERE engine = 'innodb'
      AND support IN ('YES', 'DEFAULT', 'ENABLED');
      ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
      # Restore t1 and t2
      SELECT * FROM t1;
       
      More results from queries before failure can be found in /dev/shm/var/4/log/innodb-index.log
       
       - skipping '/dev/shm/var/4/log/innodb.innodb-index-innodb/'
       
      Retrying test innodb.innodb-index, attempt(2/3)...
      

      The failure appears since 2018-08-10 11:34:21 in 10.2, you may check cross-reference by making Limit 1000 and scrolling to the end (it appears to be sorted in chronological order): https://buildbot.mariadb.net/ci/reports/cross_reference#branch=&revision=&platform=&fail_name=innodb.innodb-index&fail_variant=&fail_info_full=Unknown+storage+engine&typ=&info=&dt=&limit=1000&fail_info_short=

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.