-- env

cat /etc/*release
Oracle Linux Server release 6.7
NAME="Oracle Linux Server"
VERSION="6.7"
ID="ol"
VERSION_ID="6.7"
PRETTY_NAME="Oracle Linux Server 6.7"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:6:7"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 6"
ORACLE_BUGZILLA_PRODUCT_VERSION=6.7
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=6.7
Red Hat Enterprise Linux Server release 6.7 (Santiago)
Oracle Linux Server release 6.7


umshastr@helios03.no.oracle.com's password:
Last login: Wed Feb  5 14:15:46 2020 from dhcp-10-191-229-155.vpn.oracle.com
[umshastr@helios03]~: raw -qa
/dev/raw/raw1:  bound to major 8, minor 48
[umshastr@helios03]~: ls -lR /dev/raw*
/dev/raw:
total 0
crw-rw---- 1 root disk 162, 1 Feb  5 13:40 raw1
crw-rw---- 1 root disk 162, 0 May  6  2019 rawctl
[umshastr@helios03]~:

-- 8.0.19 build

rm -rf 98091/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/98091 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98091 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=$PWD/98091/log.err --mysqlx=0 --log-error-verbosity=3  --secure-file-priv=/tmp/ --innodb_data_home_dir= --innodb_data_file_path=/dev/raw/raw1:2Gnewraw 2>&1 &

--
 cat 98091/log.err
2020-02-05T13:49:28.308831Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2020-02-05T13:49:28.308953Z 0 [Note] [MY-010949] [Server] Basedir set to /home/umshastr/mysql-8.0.19-linux-glibc2.12-x86_64/.
2020-02-05T13:49:28.308967Z 0 [System] [MY-010116] [Server] /home/umshastr/mysql-8.0.19-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.19) starting as process 1900
2020-02-05T13:49:28.365451Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2020-02-05T13:49:28.365848Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2020-02-05T13:49:28.365943Z 0 [Note] [MY-010747] [Server] Plugin 'mysqlx' is disabled.
2020-02-05T13:49:28.369996Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2020-02-05T13:49:28.370103Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins
2020-02-05T13:49:28.370186Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2020-02-05T13:49:28.370267Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2020-02-05T13:49:28.370369Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2020-02-05T13:49:28.377512Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2020-02-05T13:49:28.377855Z 1 [Note] [MY-012951] [InnoDB] Not using CPU crc32 instructions
2020-02-05T13:49:28.378751Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2020-02-05T13:49:28.379349Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2020-02-05T13:49:28.413368Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files.
2020-02-05T13:49:28.414468Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2020-02-05T13:49:28.426755Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2020-02-05T13:49:28.428929Z 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().
2020-02-05T13:49:28.429192Z 1 [ERROR] [MY-012224] [InnoDB] Header page consists of zero bytes in datafile: /dev/raw/raw1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2020-02-05T13:49:28.429397Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile '/dev/raw/raw1' could not be found in the doublewrite buffer.
2020-02-05T13:49:28.429621Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2020-02-05T13:49:28.929572Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-02-05T13:49:28.929974Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-02-05T13:49:28.930334Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-02-05T13:49:28.930398Z 0 [Note] [MY-010120] [Server] Binlog end
2020-02-05T13:49:28.930808Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2020-02-05T13:49:28.930865Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2020-02-05T13:49:28.930920Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2020-02-05T13:49:28.931514Z 0 [System] [MY-010910] [Server] /home/umshastr/mysql-8.0.19-linux-glibc2.12-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.

- 5.7.29 build

rm -rf 98091/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/98091 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98091 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/98091/log.err --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve --innodb_data_home_dir= --innodb_data_file_path=/dev/raw/raw1:2Gnewraw 2>&1 &

-
 98091/log.err
2020-02-05T13:57:29.288651Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-02-05T13:57:29.289034Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2020-02-05T13:57:29.289123Z 0 [Note] bin/mysqld (mysqld 5.7.29) starting as process 2069 ...
2020-02-05T13:57:29.299262Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-02-05T13:57:29.299293Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-02-05T13:57:29.299299Z 0 [Note] InnoDB: Uses event mutexes
2020-02-05T13:57:29.299305Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-02-05T13:57:29.299311Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-02-05T13:57:29.299316Z 0 [Note] InnoDB: Using Linux native AIO
2020-02-05T13:57:29.299627Z 0 [Note] InnoDB: Number of pools: 1
2020-02-05T13:57:29.299757Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-02-05T13:57:29.301566Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-02-05T13:57:29.313112Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-02-05T13:57:29.315839Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-02-05T13:57:29.326348Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: /dev/raw/raw1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2020-02-05T13:57:29.326412Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '/dev/raw/raw1' could not be found in the doublewrite buffer.
2020-02-05T13:57:29.326449Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2020-02-05T13:57:29.926952Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-02-05T13:57:29.926964Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-02-05T13:57:29.926973Z 0 [ERROR] Failed to initialize builtin plugins.
2020-02-05T13:57:29.926982Z 0 [ERROR] Aborting

2020-02-05T13:57:29.926997Z 0 [Note] Binlog end
2020-02-05T13:57:29.927073Z 0 [Note] Shutting down plugin 'CSV'
2020-02-05T13:57:29.927180Z 0 [Note] Shutting down plugin 'MyISAM'
2020-02-05T13:57:29.927792Z 0 [Note] bin/mysqld: Shutdown complete

--
rm -rf 98091/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/98091 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98091 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/98091/log.err --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve 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.29 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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> \q
Bye

 bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdow -p
Enter password:
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98091 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/98091/log.err --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve 2>&1


-- restart with --innodb_data_home_dir= --innodb_data_file_path=/dev/raw/raw1:2Gnewraw

bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98091 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/98091/log.err --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve --innodb_data_home_dir= --innodb_data_file_path=/dev/raw/raw1:2Gnewraw 2>&1 &

2020-02-07T05:17:15.718897Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-02-07T05:17:15.719400Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2020-02-07T05:17:15.719510Z 0 [Note] bin/mysqld (mysqld 5.7.29) starting as process 29464 ...
2020-02-07T05:17:15.731444Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-02-07T05:17:15.731485Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-02-07T05:17:15.731494Z 0 [Note] InnoDB: Uses event mutexes
2020-02-07T05:17:15.731502Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-02-07T05:17:15.731510Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-02-07T05:17:15.731518Z 0 [Note] InnoDB: Using Linux native AIO
2020-02-07T05:17:15.731929Z 0 [Note] InnoDB: Number of pools: 1
2020-02-07T05:17:15.732103Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-02-07T05:17:15.734328Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-02-07T05:17:15.748250Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-02-07T05:17:15.750952Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-02-07T05:17:15.762954Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: /dev/raw/raw1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2020-02-07T05:17:15.763023Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '/dev/raw/raw1' could not be found in the doublewrite buffer.
2020-02-07T05:17:15.763059Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2020-02-07T05:17:16.363565Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-02-07T05:17:16.363577Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-02-07T05:17:16.363586Z 0 [ERROR] Failed to initialize builtin plugins.
2020-02-07T05:17:16.363595Z 0 [ERROR] Aborting

2020-02-07T05:17:16.363610Z 0 [Note] Binlog end
2020-02-07T05:17:16.363690Z 0 [Note] Shutting down plugin 'CSV'
2020-02-07T05:17:16.363705Z 0 [Note] Shutting down plugin 'MyISAM'
2020-02-07T05:17:16.364362Z 0 [Note] bin/mysqld: Shutdown complete