Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17230

encryption_key_id from alter is ignored by encryption threads

Details

    Description

      Although it is possible to specify encryption key id in alter statement for not encrypted tables (innodb_encrypt_tables = off): ALTER TABLE t1 ENCRYPTION_KEY_ID=X. The encryption threads when encrypting such table (innodb_encrypt_tables = on) will use key id 0 instead of X specified.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18601 Can't create table with ENCRYPTED=DEFAULT when innodb_default_encryption_key_id!=1

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19086 Make InnoDB background encryption threads read encryption key ID from FRM

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            robgolebiowski Robert Golebiowski created issue -
            robgolebiowski Robert Golebiowski made changes -
            Field Original Value New Value
            Affects Version/s 10.2 [ 14601 ]
            elenst Elena Stepanova made changes -
            Component/s Encryption [ 11200 ]
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Assignee Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Comment [ Did you check show warnings ? Used key_id should be ignored if tables has no ENCRYPTION='Y'; ]
            jplindst Jan Lindström (Inactive) added a comment -

            https://github.com/MariaDB/server/commit/0bafdc478c4ab8c577331b950dc7719abd6781c1

            jplindst Jan Lindström (Inactive) added a comment - https://github.com/MariaDB/server/commit/0bafdc478c4ab8c577331b950dc7719abd6781c1
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä added a comment -

            Looks otherwise OK, but I would clarify the error message.

            marko Marko Mäkelä added a comment - Looks otherwise OK, but I would clarify the error message.
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Jan Lindström [ jplindst ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            Component/s Storage Engine - XtraDB [ 10135 ]
            Fix Version/s 10.1 [ 16100 ]
            Affects Version/s 10.1 [ 16100 ]
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2018-11-06 08:24:19.0 2018-11-06 08:24:19.703
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.3.11 [ 23141 ]
            Fix Version/s 10.1.38 [ 23209 ]
            Fix Version/s 10.2.20 [ 23212 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 89654 ] MariaDB v4 [ 154951 ]

            People

              jplindst Jan Lindström (Inactive)
              robgolebiowski Robert Golebiowski
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.