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

failed match of signed/unsigned conversions for rocksdb_debug_ttl_rec_ts

    XMLWordPrintable

    Details

    • Type: Admin & Maintenance Task
    • Status: Done
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 5.7.18-14
    • Component/s: MyRocks
    • Labels:
      None

      Description

      Setting this variable to a negative value doesn't work:

      mysql> show variables like 'rocksdb_debug_ttl_rec_ts';
      +--------------------------+-------+
      | Variable_name            | Value |
      +--------------------------+-------+
      | rocksdb_debug_ttl_rec_ts | 0     |
      +--------------------------+-------+
      1 row in set (0.01 sec)
      
      mysql> set global rocksdb_debug_ttl_rec_ts=-100;
      Query OK, 0 rows affected (0.00 sec)
      
      mysql> show variables like 'rocksdb_debug_ttl_rec_ts';
      +--------------------------+------------+
      | Variable_name            | Value      |
      +--------------------------+------------+
      | rocksdb_debug_ttl_rec_ts | 4294967196 |
      +--------------------------+------------+
      1 row in set (0.00 sec)
      

      I don't think this is expected behaviour as even test case [1] expects negative value:

      ```"Trying to set variable @@global.ROCKSDB_DEBUG_TTL_SNAPSHOT_TS to -2400"
      SET @@global.ROCKSDB_DEBUG_TTL_SNAPSHOT_TS   = -2400;
      SELECT @@global.ROCKSDB_DEBUG_TTL_SNAPSHOT_TS;
      @@global.ROCKSDB_DEBUG_TTL_SNAPSHOT_TS
      -2400```
      

      Variables: rocksdb_debug_ttl_read_filter_ts and rocksdb_debug_ttl_snapshot_ts are showing similar behaviour.

      [1] mysql-5.6/mysql-test/suite/rocksdb_sys_vars/r/rocksdb_debug_ttl_snapshot_ts_basic.result

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: