-- build used cat docs/INFO_SRC commit: 5213d6a67df504e4b36f2219c8e103487752713d date: 2021-04-23 17:00:38 +0200 build-date: 2021-04-23 15:07:39 +0000 short: 5213d6a67df branch: mysql-8.0.25-release MySQL source 8.0.25 -- Env (Doesn't look platform dependent but just including my env on which I attempted to repro) cat /etc/*release Oracle Linux Server release 7.8 NAME="Oracle Linux Server" VERSION="7.8" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="7.8" PRETTY_NAME="Oracle Linux Server 7.8" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:8:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.8 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.8 Red Hat Enterprise Linux Server release 7.8 (Maipo) Oracle Linux Server release 7.8 cat /etc/*release Oracle Linux Server release 7.8 NAME="Oracle Linux Server" VERSION="7.8" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="7.8" PRETTY_NAME="Oracle Linux Server 7.8" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:8:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.8 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.8 Red Hat Enterprise Linux Server release 7.8 (Maipo) Oracle Linux Server release 7.8 -- No, conf provided and hence assuming server is up with default conf rm -rf 103743/ rm -rf keyring/ mkdir keyring bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/103743 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/103743 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/103743/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ --early-plugin-load='keyring_file.so' --keyring_file_data=$PWD/keyring/keyring 2>&1 & - create 15K encrypted tables - tried silly way to create cat k.sh #!/bin/bash cat << EOF DROP DATABASE IF EXISTS test; CREATE DATABASE test; use test; EOF for i in {0..15000} do cat << EOF CREATE TABLE t${i}(doi varchar(50) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 ENCRYPTION='Y'; EOF done - bash k.sh >> 103743.sql - import bin/mysql -uroot -S /tmp/mysql_ushastry.sock < 103743.sql -- restart bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.25 MySQL Community Server - GPL Copyright (c) 2000, 2021, Oracle and/or its affiliates. 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> shutdown; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye - from error log 2021-05-20T08:15:15.265624Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2021-05-20T08:15:15.267249Z 1 [Note] [MY-012976] [InnoDB] 8.0.25 started; log sequence number 229247191 2021-05-20T08:15:15.276262Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2021-05-20T08:15:15.293293Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'. 2021-05-20T08:15:15.933232Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2021-05-20T08:15:16.422300Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t0.ibd successfully, encryption of this tablespace enabled. . . 2021-05-20T08:22:05.828394Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14992.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:05.878949Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14993.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:05.929267Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14994.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:05.979932Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14995.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:06.030260Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14996.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:06.081801Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14997.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:06.132236Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14998.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:06.183143Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t14999.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:06.234322Z 0 [Note] [MY-012227] [InnoDB] Read encryption metadata from ./test/t15000.ibd successfully, encryption of this tablespace enabled. 2021-05-20T08:22:06.281618Z 1 [Note] [MY-012356] [InnoDB] Scanned 15007 tablespaces. Validated 15007. 2021-05-20T08:22:06.352607Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'. 2021-05-20T08:22:06.484187Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2021-05-20T08:22:06.535556Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33330' 2021-05-20T08:22:06.584978Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysql_x_ushastry.sock'' 2021-05-20T08:22:06.637066Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33330, socket: /tmp/mysql_x_ushastry.sock 2021-05-20T08:22:06.724004Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege. 2021-05-20T08:22:06.799747Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2021-05-20T08:22:06.848294Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2021-05-20T08:22:06.898245Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /home/umshastr/work/binaries/ga/mysql-8.0.25/103743/ib_buffer_pool 2021-05-20T08:22:06.948708Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2021-05-20T08:22:07.087460Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation. 2021-05-20T08:22:07.193136Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-05-20T08:22:07.242679Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-05-20T08:22:07.295956Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2021-05-20T08:22:07.345490Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2021-05-20T08:22:07.394727Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory. 2021-05-20T08:22:07.443123Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. 2021-05-20T08:22:07.494899Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3333 2021-05-20T08:22:07.544486Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2021-05-20T08:22:07.594409Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2021-05-20T08:22:07.644221Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2021-05-20T08:22:07.751896Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''. 2021-05-20T08:22:07.803154Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5 2021-05-20T08:22:07.870016Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server' 2021-05-20T08:22:07.872650Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections' 2021-05-20T08:22:07.872879Z 0 [System] [MY-010931] [Server] /home/umshastr/work/binaries/ga/mysql-8.0.25/bin/mysqld: ready for connections. Version: '8.0.25' socket: '/tmp/mysql_ushastry.sock' port: 3333 MySQL Community Server - GPL. 2021-05-20T08:22:09.857804Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 210520 10:22:09 ## Workaround - As Sunny suggested use --innodb-validate-tablespace-paths=OFF bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/103743 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/103743/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ --early-plugin-load='keyring_file.so' --keyring_file_data=$PWD/keyring/keyring --innodb-validate-tablespace-paths=OFF 2>&1 & . No issues observed