Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
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
- relates to
-
MDEV-9658 Make MyRocks in MariaDB stable
- Closed
-
MDEV-14892 Porting Rdb_binlog_manager to MariaDB
- Open