-
Type:
Bug
-
Status: Done
-
Priority:
Low
-
Resolution: Fixed
-
Affects Version/s: 8.0.12-2rc1, 5.7.18-14
-
Component/s: MyRocks
Run this test with mtr option --repeat=3, second iteration will fail with:
============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 rocksdb_sys_vars.rocksdb_update_cf_options_basic [ pass ] 617 rocksdb_sys_vars.rocksdb_update_cf_options_basic [ fail ] Test ended at 2017-07-19 18:07:14 CURRENT_TEST: rocksdb_sys_vars.rocksdb_update_cf_options_basic --- /ssd/percona/myrocks/facebook-mysql-install-5.6/mysql-test/suite/rocksdb_sys_vars/r/rocksdb_update_cf_options_basic.result 2017-07-08 19:22:36.000000000 +0300 +++ /ssd/percona/myrocks/facebook-mysql-install-5.6/mysql-test/var/log/rocksdb_update_cf_options_basic.reject 2017-07-20 04:07:14.267548425 +0300 @@ -38,10 +38,10 @@ NULL SELECT * FROM ROCKSDB_CF_OPTIONS WHERE CF_NAME='default' AND OPTION_TYPE='WRITE_BUFFER_SIZE'; CF_NAME OPTION_TYPE VALUE -default WRITE_BUFFER_SIZE 67108864 +default WRITE_BUFFER_SIZE 8388608 SELECT * FROM ROCKSDB_CF_OPTIONS WHERE CF_NAME='default' AND OPTION_TYPE='TARGET_FILE_SIZE_BASE'; CF_NAME OPTION_TYPE VALUE -default TARGET_FILE_SIZE_BASE 67108864 +default TARGET_FILE_SIZE_BASE 2097152 SET @@global.rocksdb_update_cf_options = 'default={write_buffer_size=8m;target_file_size_base=2m};'; SELECT @@global.rocksdb_update_cf_options; @@global.rocksdb_update_cf_options @@ -54,19 +54,19 @@ default TARGET_FILE_SIZE_BASE 2097152 SELECT * FROM ROCKSDB_CF_OPTIONS WHERE CF_NAME='cf1' AND OPTION_TYPE='WRITE_BUFFER_SIZE'; CF_NAME OPTION_TYPE VALUE -cf1 WRITE_BUFFER_SIZE 67108864 +cf1 WRITE_BUFFER_SIZE 8388608 SELECT * FROM ROCKSDB_CF_OPTIONS WHERE CF_NAME='cf1' AND OPTION_TYPE='TARGET_FILE_SIZE_BASE'; CF_NAME OPTION_TYPE VALUE -cf1 TARGET_FILE_SIZE_BASE 67108864 +cf1 TARGET_FILE_SIZE_BASE 25165824 SELECT * FROM ROCKSDB_CF_OPTIONS WHERE CF_NAME='cf2' AND OPTION_TYPE='WRITE_BUFFER_SIZE'; CF_NAME OPTION_TYPE VALUE -cf2 WRITE_BUFFER_SIZE 67108864 +cf2 WRITE_BUFFER_SIZE 16777216 SELECT * FROM ROCKSDB_CF_OPTIONS WHERE CF_NAME='cf2' AND OPTION_TYPE='MAX_BYTES_FOR_LEVEL_MULTIPLIER'; CF_NAME OPTION_TYPE VALUE -cf2 MAX_BYTES_FOR_LEVEL_MULTIPLIER 10.000000 +cf2 MAX_BYTES_FOR_LEVEL_MULTIPLIER 8.000000 SELECT * FROM ROCKSDB_CF_OPTIONS WHERE CF_NAME='cf3' AND OPTION_TYPE='TARGET_FILE_SIZE_BASE'; CF_NAME OPTION_TYPE VALUE -cf3 TARGET_FILE_SIZE_BASE 67108864 +cf3 TARGET_FILE_SIZE_BASE 25165824 SET @@global.rocksdb_update_cf_options = 'cf1={write_buffer_size=8m;target_file_size_base=2m};cf2={write_buffer_size=16m;max_bytes_for_level_multiplier=8};cf3={target_file_size_base=4m};'; SELECT @@global.rocksdb_update_cf_options; @@global.rocksdb_update_cf_options mysqltest: Result content mismatch - saving '/ssd/percona/myrocks/facebook-mysql-install-5.6/mysql-test/var/log/rocksdb_sys_vars.rocksdb_update_cf_options_basic/' to '/ssd/percona/myrocks/facebook-mysql-install-5.6/mysql-test/var/log/rocksdb_sys_vars.rocksdb_update_cf_options_basic/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.617 of 9 seconds executing testcases Completed: Failed 1/2 tests, 50.00% were successful. Failing test(s): rocksdb_sys_vars.rocksdb_update_cf_options_basic