diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/rocksdb_checksums.result')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/rocksdb_checksums.result | 128 |
1 files changed, 128 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/rocksdb_checksums.result b/storage/rocksdb/mysql-test/rocksdb/r/rocksdb_checksums.result new file mode 100644 index 00000000000..aae6de12f6a --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/rocksdb_checksums.result @@ -0,0 +1,128 @@ +set @save_rocksdb_store_row_debug_checksums=@@global.rocksdb_store_row_debug_checksums; +set @save_rocksdb_verify_row_debug_checksums=@@global.rocksdb_verify_row_debug_checksums; +set @save_rocksdb_checksums_pct=@@global.rocksdb_checksums_pct; +show variables like 'rocksdb_%checksum%'; +Variable_name Value +rocksdb_checksums_pct 100 +rocksdb_store_row_debug_checksums OFF +rocksdb_verify_row_debug_checksums OFF +create table t1 (pk int primary key, a int, b int, key(a), key(b)) engine=rocksdb; +insert into t1 values (1,1,1),(2,2,2),(3,3,3); +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +CHECKTABLE t1: Checking table t1 +CHECKTABLE t1: Checking index a +CHECKTABLE t1: ... 3 index entries checked (0 had checksums) +CHECKTABLE t1: Checking index b +CHECKTABLE t1: ... 3 index entries checked (0 had checksums) +CHECKTABLE t1: 0 table records had checksums +drop table t1; +set session rocksdb_store_row_debug_checksums=on; +create table t2 (pk int primary key, a int, b int, key(a), key(b)) engine=rocksdb; +insert into t2 values (1,1,1),(2,2,2),(3,3,3); +check table t2; +Table Op Msg_type Msg_text +test.t2 check status OK +CHECKTABLE t2: Checking table t2 +CHECKTABLE t2: Checking index a +CHECKTABLE t2: ... 3 index entries checked (3 had checksums) +CHECKTABLE t2: Checking index b +CHECKTABLE t2: ... 3 index entries checked (3 had checksums) +CHECKTABLE t2: 3 table records had checksums +# Now, make a table that has both rows with checksums and without +create table t3 (pk int primary key, a int, b int, key(a), key(b)) engine=rocksdb; +insert into t3 values (1,1,1),(2,2,2),(3,3,3); +set session rocksdb_store_row_debug_checksums=off; +update t3 set b=3 where a=2; +set session rocksdb_store_row_debug_checksums=on; +check table t3; +Table Op Msg_type Msg_text +test.t3 check status OK +CHECKTABLE t3: Checking table t3 +CHECKTABLE t3: Checking index a +CHECKTABLE t3: ... 3 index entries checked (3 had checksums) +CHECKTABLE t3: Checking index b +CHECKTABLE t3: ... 3 index entries checked (2 had checksums) +CHECKTABLE t3: 2 table records had checksums +set session rocksdb_store_row_debug_checksums=on; +set session rocksdb_checksums_pct=5; +create table t4 (pk int primary key, a int, b int, key(a), key(b)) engine=rocksdb; +check table t4; +Table Op Msg_type Msg_text +test.t4 check status OK +4000 index entries had around 200 checksums +4000 index entries had around 200 checksums +Around 200 table records had checksums +set session rocksdb_checksums_pct=100; +# +# Ok, table t2 has all rows with checksums. Simulate a few checksum mismatches. +# +insert into mtr.test_suppressions values +('Checksum mismatch in key of key-value pair for index'), +('Checksum mismatch in value of key-value pair for index'), +('Data with incorrect checksum'); +# 1. Start with mismatch in key checksum of the PK. +set session debug_dbug= "+d,myrocks_simulate_bad_pk_checksum1"; +set session rocksdb_verify_row_debug_checksums=off; +select * from t3; +pk a b +1 1 1 +2 2 3 +3 3 3 +set session rocksdb_verify_row_debug_checksums=on; +select * from t3; +ERROR HY000: Internal error: Record checksum mismatch +select * from t4; +ERROR HY000: Internal error: Record checksum mismatch +set session debug_dbug= "-d,myrocks_simulate_bad_pk_checksum1"; +# 2. Continue with mismatch in pk value checksum. +set session debug_dbug= "+d,myrocks_simulate_bad_pk_checksum2"; +set session rocksdb_verify_row_debug_checksums=off; +select * from t3; +pk a b +1 1 1 +2 2 3 +3 3 3 +set session rocksdb_verify_row_debug_checksums=on; +select * from t3; +ERROR HY000: Internal error: Record checksum mismatch +select * from t4; +ERROR HY000: Internal error: Record checksum mismatch +set session debug_dbug= "-d,myrocks_simulate_bad_pk_checksum2"; +# 3. Check if we catch checksum mismatches for secondary indexes +explain +select * from t3 force index(a) where a<4; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t3 range a a 5 NULL # Using index condition +select * from t3 force index(a) where a<4; +pk a b +1 1 1 +2 2 3 +3 3 3 +set session debug_dbug= "+d,myrocks_simulate_bad_key_checksum1"; +select * from t3 force index(a) where a<4; +ERROR HY000: Internal error: Record checksum mismatch +select * from t4 force index(a) where a<1000000; +ERROR HY000: Internal error: Record checksum mismatch +set session debug_dbug= "-d,myrocks_simulate_bad_key_checksum1"; +# 4. The same for index-only reads? +explain +select a from t3 force index(a) where a<4; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t3 range a a 5 NULL # Using where; Using index +select a from t3 force index(a) where a<4; +a +1 +2 +3 +set session debug_dbug= "+d,myrocks_simulate_bad_key_checksum1"; +select a from t3 force index(a) where a<4; +ERROR HY000: Internal error: Record checksum mismatch +select a from t4 force index(a) where a<1000000; +ERROR HY000: Internal error: Record checksum mismatch +set session debug_dbug= "-d,myrocks_simulate_bad_key_checksum1"; +set @@global.rocksdb_store_row_debug_checksums=@save_rocksdb_store_row_debug_checksums; +set @@global.rocksdb_verify_row_debug_checksums=@save_rocksdb_verify_row_debug_checksums; +set @@global.rocksdb_checksums_pct=@save_rocksdb_checksums_pct; +drop table t2,t3,t4; |