Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-4121

rocksdb_sys_vars.rocksdb_update_cf_options_basic is unstable

    XMLWordPrintable

    Details

      Description

      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
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                george.lorch George Lorch
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 45 minutes
                  45m