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

restarting server overwrites column family options on default column family

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Invalid
    • Affects Version/s: 8.0.12-2rc1, 5.7.23-23
    • Fix Version/s: None
    • Component/s: MyRocks

      Description

      mysql> select cf_name, option_type, value from information_schema.rocksdb_cf_options where cf_name='default' and option_type like 'COMPRESSION%' order by option_type;
      +---------+-----------------------+-----------------+
      | cf_name | option_type           | value           |
      +---------+-----------------------+-----------------+
      | default | COMPRESSION_OPTS      | -14:-1:0        |
      | default | COMPRESSION_PER_LEVEL | NUL             |
      | default | COMPRESSION_TYPE      | kLZ4Compression |
      +---------+-----------------------+-----------------+
      3 rows in set (0.00 sec)
      mysql> set global rocksdb_update_cf_options="default={compression=kZlibCompression}";
      Query OK, 0 rows affected (0.01 sec)mysql> select cf_name, option_type, value from information_schema.rocksdb_cf_options where cf_name='default' and option_type like 'COMPRESSION%' order by option_type;
      +---------+-----------------------+------------------+
      | cf_name | option_type           | value            |
      +---------+-----------------------+------------------+
      | default | COMPRESSION_OPTS      | -14:-1:0         |
      | default | COMPRESSION_PER_LEVEL | NUL              |
      | default | COMPRESSION_TYPE      | kZlibCompression |
      +---------+-----------------------+------------------+
      

      Restart server

      3 rows in set (0.00 sec)mysql> select cf_name, option_type, value from information_schema.rocksdb_cf_options where cf_name='default' and option_type like 'COMPRESSION%' order by option_type;
      ERROR 2006 (HY000): MySQL server has gone away
      No connection. Trying to reconnect...
      Connection id:    2
      Current database: *** NONE ***+---------+-----------------------+-----------------+
      | cf_name | option_type           | value           |
      +---------+-----------------------+-----------------+
      | default | COMPRESSION_OPTS      | -14:-1:0        |
      | default | COMPRESSION_PER_LEVEL | NUL             |
      | default | COMPRESSION_TYPE      | kLZ4Compression |
      +---------+-----------------------+-----------------+
      3 rows in set (0.00 sec)
      

      I believe this may be due to the way we set up our 'default' value for rockadb_default_cf_options.

        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 - 0 minutes
                  0m
                  Logged:
                  Time Spent - 7 hours, 45 minutes
                  7h 45m