####################################### 5.7.27 -> 8.0.17 #######################################

rm -rf 97295/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/97295 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/97295 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/97295/log.err --log-error-verbosity=3 --secure-file-priv="" 2>&1 &

 bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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> create database test;
Query OK, 1 row affected (0.01 sec)

mysql> use test
Database changed
mysql> create table links(id int not null primary key);
Query OK, 0 rows affected (0.00 sec)

-- To trigger the issue, just delete 
mysql> \! ls -l $PWD/97295/test
total 112
-rw-r----- 1 umshastr common    65 Oct 23 14:48 db.opt
-rw-r----- 1 umshastr common  8556 Oct 23 14:48 links.frm
-rw-r----- 1 umshastr common 98304 Oct 23 14:48 links.ibd
mysql> \! rm -rf $PWD/97295/test
mysql> \q
Bye
[umshastr@xxxxx]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/97295 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/97295/log.err --log-error-verbosity=3 --secure-file-priv="" 2>&1


-- Upgrade to 8.0.17

bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &


^^ Server will fail to start - extract from error log

cat /export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295/log.err
.
.
2019-10-23T12:49:00.123484Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2019-10-23T12:49:00.123531Z 0 [Note] [MY-010949] [Server] Basedir set to /export/umesh/server/binaries/GABuilds/mysql-8.0.17/.
2019-10-23T12:49:00.123547Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld (mysqld 8.0.17) starting as process 23439
2019-10-23T12:49:00.131484Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2019-10-23T12:49:00.131784Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2019-10-23T12:49:00.134547Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2019-10-23T12:49:00.134719Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2019-10-23T12:49:00.134736Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins
2019-10-23T12:49:00.134745Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2019-10-23T12:49:00.134760Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2019-10-23T12:49:00.134786Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2019-10-23T12:49:00.135124Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2019-10-23T12:49:00.135300Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2019-10-23T12:49:00.135949Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './;./;./'
2019-10-23T12:49:00.136034Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2019-10-23T12:49:00.138143Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 20 files.
2019-10-23T12:49:00.139052Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2019-10-23T12:49:00.147674Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2019-10-23T12:49:00.149133Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-23T12:49:00.226581Z 1 [Note] [MY-012529] [InnoDB] Redo log format is v1. The redo log was created before MySQL 8.0.3.
2019-10-23T12:49:00.226607Z 1 [Note] [MY-012557] [InnoDB] Redo log is from an earlier version, v1.
2019-10-23T12:49:00.227380Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2019-10-23T12:49:00.227663Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2019-10-23T12:49:00.227687Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2019-10-23T12:49:00.227800Z 1 [Note] [MY-013041] [InnoDB] Upgrading redo log: 2*50331648 bytes, LSN=2629509
2019-10-23T12:49:00.227991Z 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2019-10-23T12:49:00.234048Z 1 [Note] [MY-012968] [InnoDB] Starting to delete and rewrite log files.
2019-10-23T12:49:00.250928Z 1 [Note] [MY-012887] [InnoDB] Setting log file ./ib_logfile101 size to 48 MB
2019-10-23T12:49:00.311342Z 1 [Note] [MY-012887] [InnoDB] Setting log file ./ib_logfile1 size to 48 MB
2019-10-23T12:49:00.446516Z 1 [Note] [MY-012892] [InnoDB] Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-10-23T12:49:00.446646Z 1 [Note] [MY-012893] [InnoDB] New log files created, LSN=2629644
2019-10-23T12:49:00.446664Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2019-10-23T12:49:00.450150Z 1 [Note] [MY-013040] [InnoDB] Will create 2 new undo tablespaces.
2019-10-23T12:49:00.450727Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2019-10-23T12:49:00.450741Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 10 MB
2019-10-23T12:49:00.450757Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2019-10-23T12:49:00.466430Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2019-10-23T12:49:00.466443Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 10 MB
2019-10-23T12:49:00.466454Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2019-10-23T12:49:00.478837Z 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2019-10-23T12:49:00.479111Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2019-10-23T12:49:00.481992Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2019-10-23T12:49:00.482061Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-23T12:49:00.496872Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2019-10-23T12:49:00.498236Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2019-10-23T12:49:00.530798Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2019-10-23T12:49:00.538536Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2019-10-23T12:49:00.545900Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2019-10-23T12:49:00.614009Z 1 [Note] [MY-012976] [InnoDB] 8.0.17 started; log sequence number 6702796
2019-10-23T12:49:00.660858Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2019-10-23T12:49:00.660874Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2019-10-23T12:49:00.660889Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './test/links.ibd' OS error: 71
2019-10-23T12:49:00.660910Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `test/links` because it could not be opened.
2019-10-23T12:49:00.661169Z 1 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2019-10-23T12:49:00.720960Z 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80017'.
2019-10-23T12:49:00.869613Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295/ib_buffer_pool
2019-10-23T12:49:00.871755Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 191023 14:49:00
2019-10-23T12:49:01.004122Z 1 [Note] [MY-010337] [Server] Created Data Dictionary for upgrade
2019-10-23T12:49:01.007119Z 1 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
2019-10-23T12:49:01.010298Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-10-23T12:49:01.010737Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-23T12:49:01.010817Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2019-10-23T12:49:01.936394Z 0 [Note] [MY-010120] [Server] Binlog end
2019-10-23T12:49:01.937556Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2019-10-23T12:49:01.937575Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2019-10-23T12:49:01.937620Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2019-10-23T12:49:01.937705Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295/ib_buffer_pool
2019-10-23T12:49:01.938012Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 191023 14:49:01
2019-10-23T12:49:01.970426Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2019-10-23T12:49:02.480546Z 0 [Note] [MY-012921] [InnoDB] Deleting 2 new independent undo tablespaces that we just created.
2019-10-23T12:49:02.489804Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 11064877
2019-10-23T12:49:02.492275Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2019-10-23T12:49:02.492306Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2019-10-23T12:49:02.497991Z 0 [System] [MY-010910] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld: Shutdown complete (mysqld 8.0.17)  MySQL Community Server - GPL.



####################################### 5.7.27 -> 8.0.18 #######################################

rm -rf 97295/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/97295 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/97295 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/97295/log.err --log-error-verbosity=3 --secure-file-priv="" 2>&1 &

 bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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> create database test;
Query OK, 1 row affected (0.01 sec)

mysql> use test
Database changed
mysql> create table links(id int not null primary key);
Query OK, 0 rows affected (0.01 sec)

mysql> \! ls -l $PWD/97295/test
total 112
-rw-r----- 1 umshastr common    65 Oct 23 15:05 db.opt
-rw-r----- 1 umshastr common  8556 Oct 23 15:05 links.frm
-rw-r----- 1 umshastr common 98304 Oct 23 15:05 links.ibd
mysql>
mysql> \! rm -rf $PWD/97295/test
mysql>
mysql> \q
Bye
[umshastr@xxxxx]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/97295 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/97295/log.err --log-error-verbosity=3 --secure-file-priv="" 2>&1


-- Upgrade to 8.0.17

bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &



^^ Server will fail to start - extract from error log

cat /export/umesh/server/binaries/GABuilds/mysql-5.7.27/97295/log.err                                                                                                2019-10-23T13:04:29.842693Z 0 .
.
.
2019-10-23T13:07:01.283661Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2019-10-23T13:07:01.283771Z 0 [Note] [MY-010949] [Server] Basedir set to /export/umesh/server/binaries/GABuilds/mysql-8.0.18/.
2019-10-23T13:07:01.283785Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.18/bin/mysqld (mysqld 8.0.18) starting as process 25080
2019-10-23T13:07:01.291311Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2019-10-23T13:07:01.291669Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2019-10-23T13:07:01.294256Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2019-10-23T13:07:01.294426Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2019-10-23T13:07:01.294479Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins
2019-10-23T13:07:01.294531Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2019-10-23T13:07:01.294578Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2019-10-23T13:07:01.294641Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2019-10-23T13:07:01.295035Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2019-10-23T13:07:01.295266Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2019-10-23T13:07:01.295990Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './;./;./'
2019-10-23T13:07:01.296127Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2019-10-23T13:07:01.298381Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 20 files.
2019-10-23T13:07:01.299417Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2019-10-23T13:07:01.307906Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2019-10-23T13:07:01.309464Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-23T13:07:01.386220Z 1 [Note] [MY-012529] [InnoDB] Redo log format is v1. The redo log was created before MySQL 8.0.3.
2019-10-23T13:07:01.386369Z 1 [Note] [MY-012557] [InnoDB] Redo log is from an earlier version, v1.
2019-10-23T13:07:01.387213Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2019-10-23T13:07:01.387596Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2019-10-23T13:07:01.387720Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2019-10-23T13:07:01.387921Z 1 [Note] [MY-013041] [InnoDB] Upgrading redo log: 2*50331648 bytes, LSN=2629509
2019-10-23T13:07:01.388198Z 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2019-10-23T13:07:01.394491Z 1 [Note] [MY-012968] [InnoDB] Starting to delete and rewrite log files.
2019-10-23T13:07:01.410846Z 1 [Note] [MY-012887] [InnoDB] Setting log file ./ib_logfile101 size to 48 MB
2019-10-23T13:07:01.470164Z 1 [Note] [MY-012887] [InnoDB] Setting log file ./ib_logfile1 size to 48 MB
2019-10-23T13:07:01.693737Z 1 [Note] [MY-012892] [InnoDB] Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-10-23T13:07:01.693989Z 1 [Note] [MY-012893] [InnoDB] New log files created, LSN=2629644
2019-10-23T13:07:01.694117Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2019-10-23T13:07:01.697591Z 1 [Note] [MY-013040] [InnoDB] Will create 2 new undo tablespaces.
2019-10-23T13:07:01.698195Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2019-10-23T13:07:01.698346Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 10 MB
2019-10-23T13:07:01.698478Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2019-10-23T13:07:01.712104Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2019-10-23T13:07:01.712259Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 10 MB
2019-10-23T13:07:01.712412Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2019-10-23T13:07:01.724822Z 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2019-10-23T13:07:01.725219Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2019-10-23T13:07:01.728192Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2019-10-23T13:07:01.728419Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-23T13:07:01.744062Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2019-10-23T13:07:01.745501Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2019-10-23T13:07:01.778268Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2019-10-23T13:07:01.785940Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2019-10-23T13:07:01.793290Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2019-10-23T13:07:01.860077Z 1 [Note] [MY-012976] [InnoDB] 8.0.18 started; log sequence number 6702796
2019-10-23T13:07:01.861365Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2019-10-23T13:07:01.861553Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2019-10-23T13:07:01.861732Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './test/links.ibd' OS error: 71
2019-10-23T13:07:01.861921Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `test/links` because it could not be opened.
2019-10-23T13:07:01.862340Z 1 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2019-10-23T13:07:01.920243Z 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80017'.
2019-10-23T13:07:02.205803Z 1 [Note] [MY-010337] [Server] Created Data Dictionary for upgrade
2019-10-23T13:07:02.211273Z 1 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
2019-10-23T13:07:02.215652Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-10-23T13:07:02.216208Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-23T13:07:02.216291Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2019-10-23T13:07:03.134725Z 0 [Note] [MY-010120] [Server] Binlog end
2019-10-23T13:07:03.136025Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2019-10-23T13:07:03.136076Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2019-10-23T13:07:03.136138Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2019-10-23T13:07:03.230577Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2019-10-23T13:07:03.739262Z 0 [Note] [MY-012921] [InnoDB] Deleting 2 new independent undo tablespaces that we just created.
2019-10-23T13:07:03.747853Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 11064527
2019-10-23T13:07:03.750201Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2019-10-23T13:07:03.750270Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2019-10-23T13:07:03.754912Z 0 [System] [MY-010910] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.18/bin/mysqld: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.

- workaround, use  Upgrade Checker Utility before upgrade - which points the issue

 bin/mysqlsh
MySQL Shell 8.0.18

Copyright (c) 2016, 2019, 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 '\?' for help; '\quit' to exit.
 MySQL  JS > \c root@localhost:3333
Creating a session to 'root@localhost:3333'
Please provide the password for 'root@localhost:3333':
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 4
Server version: 5.7.27 MySQL Community Server (GPL)
No default schema selected; type \use <schema> to set one.
 MySQL  localhost:3333  JS >
 MySQL  localhost:3333  JS > util.checkForServerUpgrade()
The MySQL server at localhost:3333, version 5.7.27 - MySQL Community Server
(GPL), will now be checked for compatibility issues for upgrade to MySQL
8.0.18...

1) Usage of old temporal type
  No issues found

2) Usage of db objects with names conflicting with new reserved keywords
  No issues found

3) Usage of utf8mb3 charset
  No issues found

4) Table names in the mysql schema conflicting with new tables in 8.0
  No issues found

5) Partitioned tables using engines with non native partitioning
  No issues found

6) Foreign key constraint names longer than 64 characters
  No issues found

7) Usage of obsolete MAXDB sql_mode flag
  No issues found

8) Usage of obsolete sql_mode flags
  No issues found

9) ENUM/SET column definitions containing elements longer than 255 characters
  No issues found

10) Usage of partitioned tables in shared tablespaces
  No issues found

11) Circular directory references in tablespace data file paths
  No issues found

12) Usage of removed functions
  No issues found

13) Usage of removed GROUP BY ASC/DESC syntax
  No issues found

14) Removed system variables for error logging to the system log configuration
  To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary
  More information:
    https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-13.html#mysqld-8-0-13-logging

15) Removed system variables
  To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary
  More information:
    https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed

16) System variables with new default values
  To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary
  More information:
    https://mysqlserverteam.com/new-defaults-in-mysql-8-0/

17) Schema inconsistencies resulting from file removal or corruption
  Error: Following tables show signs that either table datadir directory or frm
    file was removed/corrupted. Please check server logs, examine datadir to
    detect the issue and fix it before upgrade

  test.links - present in INFORMATION_SCHEMA's INNODB_SYS_TABLES table but
    missing from TABLES table

18) Issues reported by 'check table x for upgrade' command
  No issues found

19) New default authentication plugin considerations
  Warning: The new default authentication plugin 'caching_sha2_password' offers
    more secure password hashing than previously used 'mysql_native_password'
    (and consequent improved client connection authentication). However, it also
    has compatibility implications that may affect existing MySQL installations.
    If your MySQL installation must serve pre-8.0 clients and you encounter
    compatibility issues after upgrading, the simplest way to address those
    issues is to reconfigure the server to revert to the previous default
    authentication plugin (mysql_native_password). For example, use these lines
    in the server option file:

    [mysqld]
    default_authentication_plugin=mysql_native_password

    However, the setting should be viewed as temporary, not as a long term or
    permanent solution, because it causes new accounts created with the setting
    in effect to forego the improved authentication security.
    If you are using replication please take time to understand how the
    authentication plugin changes may impact you.
  More information:
    https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-compatibility-issues
    https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-replication

Errors:   1
Warnings: 1
Notices:  0

1 errors were found. Please correct these issues before upgrading to avoid compatibility issues.