Elena Stepanova added a comment - 2018-06-25 08:05 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

Sergei Petrunia added a comment - 2019-09-11 19:47 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.

Sergei Petrunia added a comment - 2019-09-11 20: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 .