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

Fix and enable rocksdb.information_schema test

    XMLWordPrintable

Details

    Description

      This is about enabling rocksdb.information_schema test. Currently, it is disabled because it fails like so:

      CURRENT_TEST: rocksdb.information_schema
      --- /home/psergey/dev-git/10.2/storage/rocksdb/mysql-test/rocksdb/r/information_schema.result   2017-09-21 10:40:03.019962115 +0000
      +++ /home/psergey/dev-git/10.2/storage/rocksdb/mysql-test/rocksdb/r/information_schema.reject   2017-11-13 03:52:04.509919990 +0000
      @@ -3,26 +3,22 @@
       DROP TABLE IF EXISTS t3;
       select * from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       TYPE   NAME    VALUE
      -MAX_INDEX_ID   MAX_INDEX_ID    max_index_id
       CF_FLAGS       0       default [0]
       CF_FLAGS       1       __system__ [0]
       select count(*) from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       count(*)
      -3
      +2
       select VALUE into @keysIn from INFORMATION_SCHEMA.ROCKSDB_COMPACTION_STATS where CF_NAME = 'default' and LEVEL = 'Sum' and TYPE = 'KeyIn';
       CREATE TABLE t1 (i1 INT, i2 INT, PRIMARY KEY (i1)) ENGINE = ROCKSDB;
       INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);
       select * from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       TYPE   NAME    VALUE
      -BINLOG FILE    master-bin.000001
      -BINLOG POS     1066
      -BINLOG GTID    uuid:5
      -MAX_INDEX_ID   MAX_INDEX_ID    max_index_id
      +MAX_INDEX_ID   MAX_INDEX_ID    256
       CF_FLAGS       0       default [0]
       CF_FLAGS       1       __system__ [0]
       select count(*) from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       count(*)
      -6
      +3
       set global rocksdb_force_flush_memtable_now = true;
       set global rocksdb_compact_cf='default';
       select case when VALUE-@keysIn >= 3 then 'true' else 'false' end from INFORMATION_SCHEMA.ROCKSDB_COMPACTION_STATS where CF_NAME = 'default' and LEVEL = 'Sum' and TYPE = 'KeyIn';
      @@ -66,7 +62,7 @@
       Variable_name  Value
       rocksdb_pause_background_work  ON
       DROP TABLE t3;
      -cf_id:0,index_id:267
      +cf_id:0,index_id:263
       SET GLOBAL ROCKSDB_PAUSE_BACKGROUND_WORK=0;
       SHOW GLOBAL VARIABLES LIKE 'ROCKSDB_PAUSE_BACKGROUND_WORK';
       Variable_name  Value
      

      Attachments

        Issue Links

          Activity

            People

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