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

SET PERSIST should do validation when switching default_table_encryption modes

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: 8.0.20-11
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      SET PERSIST should do validation when switching default_table_encryption modes.

      Currently this can lead to:

      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 7
      Server version: 8.0.21-12-debug Source distribution
      
      Copyright (c) 2009-2020 Percona LLC and/or its affiliates
      Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
      
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
      
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      
      mysql> CREATE DATABASE test;
      Query OK, 1 row affected (0.01 sec)
      
      mysql> USE test;
      Database changed
      mysql> CREATE TABLE t1(id INT UNSIGNED KEY,title CHAR (1),body TEXT,FULLTEXT (title));
      Query OK, 0 rows affected (0.25 sec)
      
      mysql> SET PERSIST default_table_encryption=ONLINE_TO_KEYRING;
      Query OK, 0 rows affected (0.00 sec)
      
      mysql> CREATE FULLTEXT INDEX idx_t ON t1(title);
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      

      For more information see PS-7338.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              oleksandr.kachan Oleksandr Kachan
              Reporter:
              hrvoje.matijakovic Hrvoje Matijakovic
              Votes:
              0 Vote for this issue
              Watchers:
              2 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 - 2 hours
                  2h

                    Smart Checklist