- 5.6

rm -rf 110722/
scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/110722
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/110722 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=$PWD/110722/log.err --performance-schema=ON 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 1
Server version: 5.6.51 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, 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> use test
Database changed
mysql> CREATE TEMPORARY TABLE temp(id int);
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like 'tmpdir';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| tmpdir        | /tmp  |
+---------------+-------+
1 row in set (0.00 sec)

mysql> system ls -l /tmp/*.ibd
-rw-rw---- 1 umshastr common 98304 Apr 19 08:40 /tmp/#sql7464_1_0.ibd
mysql> system ls -l /tmp/*.frm
-rw-rw---- 1 umshastr common 8556 Apr 19 08:40 /tmp/#sql7464_1_0.frm


-- kill 5.6 mysqld

umshastr 29796  0.0  0.3 1409440 461576 pts/9  Sl   08:26   0:00 bin/mysqld --no-defaults --basedir=/export/home/tmp/ushastry/mysql-5.6.51 --datadir=/export/home/tmp/ushastry/mysql-5.6.51/110722 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/home/tmp/ushastry/mysql-5.6.51/110722/log.err --performance-schema=ON

kill -9 29796

-- In-place upgrade to 5.7.42

bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-5.6.51/110722/ --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/home/tmp/ushastry/mysql-5.6.51/110722/log.err --log-error-verbosity=3 --secure-file-priv=""  --performance-schema=ON 2>&1 &

 bin/mysql_upgrade -uroot -S /tmp/mysql_ushastry.sock
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.engine_cost                                  OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.gtid_executed                                OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.server_cost                                  OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Upgrading the sys schema.
Checking databases.
sys.sys_config                                     OK
Upgrade process completed successfully.
Checking if update is needed.

-- restart 5.7

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

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

$ bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-5.6.51/110722/ --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/home/tmp/ushastry/mysql-5.6.51/110722/log.err --log-error-verbosity=3 --secure-file-priv=""  --performance-schema=ON 2>&1 &
[1] 2588

 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.42 MySQL Community Server (GPL)

Copyright (c) 2000, 2023, 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> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%';
+----------+------------------+------+--------+-------+-------------+------------+---------------+------------+
| TABLE_ID | NAME             | FLAG | N_COLS | SPACE | FILE_FORMAT | ROW_FORMAT | ZIP_PAGE_SIZE | SPACE_TYPE |
+----------+------------------+------+--------+-------+-------------+------------+---------------+------------+
|       20 | tmp/#sql7464_1_0 |    1 |      4 |     6 | Antelope    | Compact    |             0 | Single     |
+----------+------------------+------+--------+-------+-------------+------------+---------------+------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME LIKE '%#sql%';
+-------+------------------+------+-------------+----------------------+-----------+---------------+------------+---------------+-----------+----------------+
| SPACE | NAME             | FLAG | FILE_FORMAT | ROW_FORMAT           | PAGE_SIZE | ZIP_PAGE_SIZE | SPACE_TYPE | FS_BLOCK_SIZE | FILE_SIZE | ALLOCATED_SIZE |
+-------+------------------+------+-------------+----------------------+-----------+---------------+------------+---------------+-----------+----------------+
|     6 | tmp/#sql7464_1_0 |    0 | Antelope    | Compact or Redundant |     16384 |             0 | Single     |             0 |         0 |              0 |
+-------+------------------+------+-------------+----------------------+-----------+---------------+------------+---------------+-----------+----------------+
1 row in set (0.00 sec)

mysql>


mysql>  system ls -l /tmp/*.ibd
ls: cannot access /tmp/*.ibd: No such file or directory
mysql> system ls -l /tmp/*.frm
ls: cannot access /tmp/*.frm: No such file or directory
mysql>

-- In place upgrade to 8.0.33

bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-5.6.51/110722/ --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=/export/home/tmp/ushastry/mysql-5.6.51/110722/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &



2023-04-19T06:48:44.840137Z 1 [Note] [MY-012976] [InnoDB] 8.0.33 started; log sequence number 5375958
2023-04-19T06:48:44.840925Z 1 [Warning] [MY-012177] [InnoDB] The datafile '/tmp/#sql7464_1_0.ibd' for tablespace tmp/#sql7464_1_0 is in an unprotected location. This file cannot be recovered after a crash until this location is added to innodb_directories.
2023-04-19T06:48:44.840947Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2023-04-19T06:48:44.840955Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2023-04-19T06:48:44.840960Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '/tmp/#sql7464_1_0.ibd' OS error: 71
2023-04-19T06:48:44.840981Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `tmp/#sql7464_1_0` because it could not be opened.
2023-04-19T06:48:44.847142Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-04-19T06:48:44.853826Z 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80023'.
2023-04-19T06:48:45.355099Z 1 [Note] [MY-010337] [Server] Created Data Dictionary for upgrade
2023-04-19T06:48:45.355407Z 1 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
2023-04-19T06:48:45.357215Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-19T06:48:45.357237Z 0 [ERROR] [MY-010119] [Server] Aborting