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

[PS8QA] Cannot add encrypted tables in to encrypted tablespace.

    XMLWordPrintable

    Details

      Description

      Testcase

      8.0.13>CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' ENCRYPTION='Y';
      Query OK, 0 rows affected (0.07 sec)
      
      8.0.13>CREATE TABLE `sbtest1` (
          ->  `id` int(11) DEFAULT NULL,
          ->  `k` int(11) NOT NULL DEFAULT '0',
          ->  `c` char(120) NOT NULL DEFAULT '',
          ->  `pad` char(60) NOT NULL DEFAULT '',
          ->  KEY `k_1` (`k`)
          -> ) ;
      Query OK, 0 rows affected (0.06 sec)
      
      8.0.13>show create table sbtest1\G
      *************************** 1. row ***************************
             Table: sbtest1
      Create Table: CREATE TABLE `sbtest1` (
        `id` int(11) DEFAULT NULL,
        `k` int(11) NOT NULL DEFAULT '0',
        `c` char(120) NOT NULL DEFAULT '',
        `pad` char(60) NOT NULL DEFAULT '',
        KEY `k_1` (`k`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'
      1 row in set (0.02 sec)
      
      8.0.13>alter table sbtest1 tablespace=ts1;
      ERROR 1478 (HY000): InnoDB: Tablespace `ts1` can contain only an ENCRYPTED tables.
      8.0.13>
      
      8.0.13>select name,encryption from information_schema.INNODB_TABLESPACES where name like '%ts%';
      +------+------------+
      | name | encryption |
      +------+------------+
      | ts1  | Y          |
      +------+------------+
      1 row in set (0.00 sec)
      
      8.0.13>
      

      Could not reproduce this issue with upstream build.

        Attachments

          Activity

            People

            Assignee:
            satya.bodapati Satya Bodapati
            Reporter:
            ramesh.sivaraman Ramesh Sivaraman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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 - 4 minutes
                4m

                  Smart Checklist