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

Upgrade to 8.0.16-7 breaks on innodb_dynamic_metadata with encrypted tablespace

    Details

      Description

      2019-08-19T09:33:44.637753Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16-7) starting as process 22924
      2019-08-19T09:33:45.782022Z 1 [System] [MY-011090] [Server] Data dictionary upgrading from version '80014' to '80016'.
      2019-08-19T09:33:45.796459Z 1 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'CREATE TABLE innodb_dynamic_metadata(
        table_id BIGINT UNSIGNED NOT NULL,
        version BIGINT UNSIGNED NOT NULL,
        metadata BLOB NOT NULL,
        PRIMARY KEY (table_id)
      ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC STATS_PERSISTENT=0 TABLESPACE=mysql' failed with error code = 3825, error message = 'Request to create 'unencrypted' table while using an 'encrypted' tablespace.'.
      2019-08-19T09:33:45.796782Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
      2019-08-19T09:33:45.796970Z 0 [ERROR] [MY-010119] [Server] Aborting
      2019-08-19T09:33:47.723286Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16-7)  Percona Server (GPL), Release 7, Revision 613e312.
      

      Settings from config:

      innodb-temp-tablespace-encrypt=ON
      innodb-encrypt-tables=FORCE
      binlog_encryption=ON
      encrypt-tmp-files=ON
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  robert.golebiowski Robert Golebiowski
                  Reporter:
                  ceri.williams Ceri Williams
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 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 week, 2 days, 3 hours, 42 minutes
                    1w 2d 3h 42m