## 5.7.22 - with provided datadir (extract mysql-bug-90711.zip, copy "Data" dir to D:\ushastry\MySQL\mysql-5.7.22-winx64\Data)

-- bring up 5.7.22 server (using init.txt to reset root password so that normal shutdown can be done)

-- init.txt
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

D:\ushastry\MySQL\mysql-5.7.22-winx64>bin\mysqld.exe --init-file="D:\ushastry\MySQL\mysql-5.7.22-winx64\init.txt" --datadir="D:\ushastry\MySQL\mysql-5.7.22-winx64\Data"


-- extract from 5.7.22 error log

2018-05-03T02:33:17.898902Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-03T02:33:17.898902Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-05-03T02:33:17.899902Z 0 [Note] bin\mysqld.exe (mysqld 5.7.22) starting as process 102104 ...
2018-05-03T02:33:17.950905Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-05-03T02:33:17.957905Z 0 [Note] InnoDB: Uses event mutexes
2018-05-03T02:33:17.958905Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-05-03T02:33:17.960906Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-03T02:33:17.962906Z 0 [Note] InnoDB: Number of pools: 1
2018-05-03T02:33:17.966906Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-05-03T02:33:17.988907Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-05-03T02:33:18.002908Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-03T02:33:18.165917Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-03T02:33:19.013966Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-03T02:33:19.024966Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-03T02:33:19.260980Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-05-03T02:33:19.266980Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-03T02:33:19.268980Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-03T02:33:19.272981Z 0 [Note] InnoDB: Waiting for purge to start
2018-05-03T02:33:19.355985Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 6707512068
2018-05-03T02:33:19.358986Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ushastry\MySQL\mysql-5.7.22-winx64\Data\ib_buffer_pool
2018-05-03T02:33:19.358986Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-03T02:33:19.451991Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-05-03T02:33:19.458991Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-05-03T02:33:19.462991Z 0 [Note] IPv6 is available.
2018-05-03T02:33:19.462991Z 0 [Note]   - '::' resolves to '::';
2018-05-03T02:33:19.463992Z 0 [Note] Server socket created on IP: '::'.
2018-05-03T02:33:19.904017Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180503  8:03:19
2018-05-03T02:33:20.009023Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-03T02:33:20.010023Z 0 [Note] Execution of init_file 'D:\ushastry\MySQL\mysql-5.7.22-winx64\init.txt' started.
2018-05-03T02:33:20.029024Z 0 [Note] Execution of init_file 'D:\ushastry\MySQL\mysql-5.7.22-winx64\init.txt' ended.
2018-05-03T02:33:20.031024Z 0 [Note] bin\mysqld.exe: ready for connections.
Version: '5.7.22'  socket: ''  port: 3306  MySQL Community Server (GPL)


-- Shutdown 5.7.22 instance, try to start 8.0.11, point datadir to D:\ushastry\MySQL\mysql-5.7.22-winx64\data

D:\ushastry\MySQL\mysql-5.7.22-winx64>bin\mysql -uroot -pMyNewPass
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.02 sec)

mysql> \q
Bye

D:\ushastry\MySQL\mysql-5.7.22-winx64>bin\mysqladmin -uroot -pMyNewPass shutdown
mysqladmin: [Warning] Using a password on the command line interface can be insecure.

D:\ushastry\MySQL\mysql-5.7.22-winx64>
-- extract from 5.7.22 error log confirming normal shutdown



2018-05-03T02:35:21.325962Z 0 [Note] bin\mysqld.exe: Normal shutdown

2018-05-03T02:35:21.328962Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-05-03T02:35:21.329962Z 0 [Note] Shutting down slave threads
2018-05-03T02:35:21.330962Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-05-03T02:35:21.331962Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-05-03T02:35:21.332962Z 0 [Note] Binlog end
2018-05-03T02:35:21.334962Z 0 [Note] Shutting down plugin 'ngram'
2018-05-03T02:35:21.335962Z 0 [Note] Shutting down plugin 'partition'
2018-05-03T02:35:21.336962Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-05-03T02:35:21.337962Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-05-03T02:35:21.338962Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-05-03T02:35:21.339962Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-05-03T02:35:21.340963Z 0 [Note] Shutting down plugin 'MyISAM'
2018-05-03T02:35:21.341963Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-05-03T02:35:21.342963Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-05-03T02:35:21.343963Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-05-03T02:35:21.344963Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-05-03T02:35:21.345963Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-05-03T02:35:21.346963Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-05-03T02:35:21.347963Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-05-03T02:35:21.347963Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-05-03T02:35:21.348963Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-05-03T02:35:21.349963Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-05-03T02:35:21.350963Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-05-03T02:35:21.351963Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-05-03T02:35:21.352963Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-05-03T02:35:21.353963Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-05-03T02:35:21.354963Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-05-03T02:35:21.355963Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-05-03T02:35:21.357963Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-05-03T02:35:21.357963Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-05-03T02:35:21.358964Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-05-03T02:35:21.360964Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-05-03T02:35:21.361964Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-05-03T02:35:21.362964Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-05-03T02:35:21.363964Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-05-03T02:35:21.412967Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-05-03T02:35:21.413967Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-05-03T02:35:21.414967Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-05-03T02:35:21.415967Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-05-03T02:35:21.416967Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-05-03T02:35:21.417967Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-05-03T02:35:21.418967Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-05-03T02:35:21.418967Z 0 [Note] Shutting down plugin 'InnoDB'
2018-05-03T02:35:21.479970Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-05-03T02:35:21.480971Z 0 [Note] InnoDB: Starting shutdown...
2018-05-03T02:35:21.584976Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ushastry\MySQL\mysql-5.7.22-winx64\Data\ib_buffer_pool
2018-05-03T02:35:21.593977Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180503  8:05:21
2018-05-03T02:35:23.002058Z 0 [Note] InnoDB: Shutdown completed; log sequence number 6707512096
2018-05-03T02:35:23.006058Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-03T02:35:23.008058Z 0 [Note] Shutting down plugin 'MEMORY'
2018-05-03T02:35:23.009058Z 0 [Note] Shutting down plugin 'CSV'
2018-05-03T02:35:23.010058Z 0 [Note] Shutting down plugin 'sha256_password'
2018-05-03T02:35:23.011058Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-05-03T02:35:23.013058Z 0 [Note] Shutting down plugin 'binlog'
2018-05-03T02:35:23.017058Z 0 [Note] bin\mysqld.exe: Shutdown complete


Try to bring up 8.0.11

D:\ushastry\MySQL\mysql-8.0.11-winx64>bin\mysqld.exe --datadir="D:\ushastry\MySQL\mysql-5.7.22-winx64\Data"

D:\ushastry\MySQL\mysql-8.0.11-winx64>

extract from error log


2018-05-03T02:36:59.829596Z 0 [System] [MY-010116] [Server] D:\ushastry\MySQL\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) starting as process 102512
mysqld: Duplicate entry 'innodb_system' for key 'name'
2018-05-03T02:37:04.871884Z 1 [ERROR] [MY-011006] [Server] Got error 168 from SE while migrating tablespaces.
2018-05-03T02:37:04.882885Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-05-03T02:37:04.883885Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-05-03T02:37:06.637985Z 0 [System] [MY-010910] [Server] D:\ushastry\MySQL\mysql-8.0.11-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.