[MDEV-16560] [counter] rocksdb.ttl_primary_read_filtering, rocksdb.ttl_secondary_read_filtering fail in buildbot with wrong result Created: 2018-06-25  Updated: 2019-09-11  Resolved: 2019-09-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB, Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.28, 10.3.19, 10.4.9

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-20490 rocksdb.ttl_primary_read_filtering fa... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/562/steps/mtr/logs/stdio

rocksdb.ttl_secondary_read_filtering     w2 [ fail ]
        Test ended at 2018-06-16 00:09:47
 
CURRENT_TEST: rocksdb.ttl_secondary_read_filtering
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/ttl_secondary_read_filtering.result	2018-06-15 14:23:26.000000000 +0000
+++ /dev/shm/var/2/log/ttl_secondary_read_filtering.reject	2018-06-16 00:09:46.967278093 +0000
@@ -170,13 +170,13 @@
 a
 select variable_value-@c from information_schema.global_status where variable_name='rocksdb_rows_expired';
 variable_value-@c
-0
+16
 set global rocksdb_debug_ttl_ignore_pk = 1;
 set global rocksdb_compact_cf='default';
 set global rocksdb_debug_ttl_ignore_pk = 0;
 select variable_value-@c from information_schema.global_status where variable_name='rocksdb_rows_expired';
 variable_value-@c
-8
+16
 DROP TABLE t1;
 # Attempt to update expired value, should filter out
 set global rocksdb_force_flush_memtable_now=1;
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2018-06-25 ]

Similar issue with rocksdb.ttl_primary_read_filtering:

rocksdb.ttl_primary_read_filtering       w2 [ fail ]
        Test ended at 2018-06-13 14:50:50
 
CURRENT_TEST: rocksdb.ttl_primary_read_filtering
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/ttl_primary_read_filtering.result	2018-06-13 12:37:49.000000000 +0000
+++ /dev/shm/var/2/log/ttl_primary_read_filtering.reject	2018-06-13 14:50:49.940639854 +0000
@@ -120,7 +120,7 @@
 a
 select variable_value-@c from information_schema.global_status where variable_name='rocksdb_rows_expired';
 variable_value-@c
-0
+8
 set global rocksdb_compact_cf='default';
 select variable_value-@c from information_schema.global_status where variable_name='rocksdb_rows_expired';
 variable_value-@c
 
mysqltest: Result content mismatch

http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/550/steps/mtr/logs/stdio

Comment by Sergei Petrunia [ 2019-09-11 ]

The failure for ttl_secondary_read_filtering still shows up. For example:

rocksdb.ttl_secondary_read_filtering 'write_prepared' w4 [ fail ]
        Test ended at 2019-09-11 02:18:04
 
CURRENT_TEST: rocksdb.ttl_secondary_read_filtering
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/ttl_secondary_read_filtering.result	2019-09-10 23:18:49.000000000 +0000
+++ /dev/shm/var/4/log/ttl_secondary_read_filtering.reject	2019-09-11 02:18:04.182609803 +0000
@@ -170,13 +170,13 @@
 a
 select variable_value-@c from information_schema.global_status where variable_name='rocksdb_rows_expired';
 variable_value-@c
-0
+16
 set global rocksdb_debug_ttl_ignore_pk = 1;
 set global rocksdb_compact_cf='default';
 set global rocksdb_debug_ttl_ignore_pk = 0;
 select variable_value-@c from information_schema.global_status where variable_name='rocksdb_rows_expired';
 variable_value-@c
-8
+16
 DROP TABLE t1;
 # Attempt to update expired value, should filter out
 set global rocksdb_force_flush_memtable_now=1;
 
mysqltest: Result length mismatch
 
 - saving '/dev/shm/var/4/log/rocksdb.ttl_secondary_read_filtering-write_prepared/' to '/dev/shm/var/log/rocksdb.ttl_secondary_read_filtering-write_prepared/'
 
Retrying test rocksdb.ttl_secondary_read_filtering, attempt(2/3)...
 
worker[4] > Restart  - not started

The result difference is always at the same place, line 170.

Comment by Sergei Petrunia [ 2019-09-11 ]

Let's assume MDEV-20490 fixed ttl_primary_read_filtering and the scope of this issue is limited to ttl_secondary_read_filtering.

Pushed a fix for ttl_secondary_read_filtering.

Generated at Thu Feb 08 08:29:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.