rm -rf 86125
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/86125 -v
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/86125 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/86125/log.err 2>&1 &

root@localhost [test]> Create table test.x(id int)engine=blackhole;
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]> show create table test.x\G
*************************** 1. row ***************************
       Table: x
Create Table: CREATE TABLE `x` (
  `id` int(11) DEFAULT NULL
) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1
1 row in set (0.01 sec)

root@localhost [test]> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.7.18                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| tls_version             | TLSv1,TLSv1.1,TLSv1.2                                   |
| version                 | 5.7.18-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)

## shutdown, rename table

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18: mv 86125/test/x.frm 86125/test/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.frm
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18: ls -l 86125/test/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.frm
-rw-r----- 1 umshastr common 8556 Apr 28 11:53 86125/test/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.frm
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18:

## Start, confirm table exists

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18: bin/mysql -uroot -S /tmp/mysql.sock -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.18-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2017, 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.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> show tables;
+------------------------------------------------------------------+
| Tables_in_test                                                   |
+------------------------------------------------------------------+
| xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
+------------------------------------------------------------------+
1 row in set (0.00 sec)

root@localhost [test]> show create table xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\G
ERROR 1146 (42S02): Table 'test.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' doesn't exist
root@localhost [test]>
root@localhost [test]> select * from xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;
ERROR 1146 (42S02): Table 'test.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' doesn't exist
root@localhost [test]>
root@localhost [test]>


## 8.0

bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18/86125 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.18/86125/log.err 2>&1 &

-- Startup fails with

2017-04-28T09:59:47.570134Z 1 [Note] Created Data Dictionary for upgrade
2017-04-28T09:59:47.798332Z 3 [ERROR] bin/mysqld: Failed to update tables dictionary object.
2017-04-28T09:59:47.798384Z 3 [ERROR] Error in Creating DD entry for test.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

.
2017-04-28T09:59:47.870947Z 3 [ERROR] Unable to drop the DD tables during clean up after upgrade failure
2017-04-28T09:59:47.876392Z 0 [ERROR] Failed to Populate DD tables.
2017-04-28T09:59:47.876412Z 0 [ERROR] Aborting

## after removing test.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

2017-04-28T10:03:53.490383Z 1 [ERROR] InnoDB: Operating system error number 17 in a file operation.
2017-04-28T10:03:53.490414Z 1 [ERROR] InnoDB: Error number 17 means 'File exists'
2017-04-28T10:03:53.490423Z 1 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/8.0/en/operating-system-error-codes.html
2017-04-28T10:03:53.490429Z 1 [ERROR] InnoDB: Cannot create file './mysql/table_stats.ibd'
2017-04-28T10:03:53.490447Z 1 [ERROR] InnoDB: The file './mysql/table_stats.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file './mysql/table_stats.ibd' under the 'datadir' of MySQL.
2017-04-28T10:03:53.490487Z 1 [ERROR] bin/mysqld: Tablespace '`mysql`.`table_stats`' exists.
2017-04-28T10:03:53.490503Z 1 [ERROR] bin/mysqld: Got error 184 - 'Tablespace already exists' from storage engine
2017-04-28T10:03:53.509148Z 0 [ERROR] Data Dictionary initialization failed.
2017-04-28T10:03:53.509167Z 0 [ERROR] Aborting