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

warning message does not format the string properly

    Details

      Description

      On 5.7, while testing PR-4556 when the server is started with default value of innodb_redo_log_encrypt (i.e OFF) and below SQL is executed

      SET GLOBAL innodb_redo_log_encrypt=1;

      Following warning message is displayed

      Warning 3236 InnoDB:  Redo log encryption mode can't be switched without stopping the server and recreating the redo logs. Current mode is %s, requested %s.

      SET GLOBAL innodb_redo_log_encrypt=ON;
      ERROR 1231 (42000): Variable 'innodb_redo_log_encrypt' can't be set to the value of 'ON'

      On 5.7, setting the value to 
      1=>master_key
      2=>keyring_key
      0=>OFF

      So ideally, setting the value to 1 should have set the value to MASTER_KEY. But at the moment the behvaiour is:

      mysql> select @@innodb_redo_log_encrypt;
      ---------------------------

      @@innodb_redo_log_encrypt

      ---------------------------

      OFF

      ---------------------------
      1 row in set (0.00 sec)

      mysql> SET GLOBAL innodb_redo_log_encrypt=1;
      Query OK, 0 rows affected, 1 warning (0.00 sec)

      mysql> show warnings;
      ------------------------------------------------------------------------------------------------------------------------------------------------------------

      Level Code Message

      ------------------------------------------------------------------------------------------------------------------------------------------------------------

      Warning 3236 InnoDB: Redo log encryption mode can't be switched without stopping the server and recreating the redo logs. Current mode is %s, requested %s.

      ------------------------------------------------------------------------------------------------------------------------------------------------------------
      1 row in set (0.00 sec)

      mysql> select @@innodb_redo_log_encrypt;
      ---------------------------

      @@innodb_redo_log_encrypt

      ---------------------------

      OFF

      ---------------------------
      1 row in set (0.00 sec)

       

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  zsolt.parragi Zsolt Parragi
                  Reporter:
                  mohit.joshi Mohit Joshi
                • 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 - 1 hour
                    1h