- 5.7.29

- build

 cat docs/INFO_SRC
commit: d60f2566546f688f5ee92cad35599a967e07c453
date: 2019-12-18 13:49:33 +0100
build-date: 2019-12-18 13:59:54 +0100
short: d60f256
branch: mysql-5.7.29-release

MySQL source 5.7.29


rm -rf 99211/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/99211 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/99211 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/99211/log.err --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve --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 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> create database db_upgrade_test;
Query OK, 1 row affected (0.00 sec)

mysql> use db_upgrade_test;
Database changed
mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB;
Query OK, 0 rows affected (0.00 sec)

mysql>  CREATE TABLE t1 ( c2 text,FULLTEXT idx (c2)) TABLESPACE ts1;
Query OK, 0 rows affected (0.01 sec)

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/99211 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/99211/log.err --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve --performance-schema=ON 2>&1


--- checked with upgrade utility

 bin/mysqlsh root@localhost:3333 -e "util.checkForServerUpgrade();"
Please provide the password for 'root@localhost:3333':
The MySQL server at localhost:3333, version 5.7.29 - MySQL Community Server
(GPL), will now be checked for compatibility issues for upgrade to MySQL
8.0.19...

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) Zero Date, Datetime, and Timestamp values
  No issues found

18) Schema inconsistencies resulting from file removal or corruption
  No issues found

19) Tables recognized by InnoDB that belong to a different engine
  No issues found

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

21) 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:   0
Warnings: 1
Notices:  0

No fatal errors were found that would prevent an upgrade, but some potential issues were detected. Please ensure that the reported issues are not significant before upgrading.


- In place upgrade
- 8.0.19

- build

 cat ../mysql-8.0.19/docs/INFO_SRC
commit: 44e4c6bb51cf478596fce21eb5638557244cbafa
date: 2019-12-09 20:48:18 +0100
build-date: 2019-12-09 20:53:55 +0100
short: 44e4c6b
branch: mysql-8.0.19-release

MySQL source 8.0.19



bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.29/99211 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.29/99211/log.err --mysqlx=0 --log-error-verbosity=3  --secure-file-priv="" --performance-schema=ON 2>&1 &

^^ fail to start and extrats from error log

2020-04-09T06:49:54.144831Z 0 [Warning] [MY-010097] [Server] 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-04-09T06:49:54.144946Z 0 [Note] [MY-010949] [Server] Basedir set to /export/umesh/server/binaries/GABuilds/mysql-8.0.19/.
2020-04-09T06:49:54.144961Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.19/bin/mysqld (mysqld 8.0.19) starting as process 17473
2020-04-09T06:49:54.155106Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2020-04-09T06:49:54.155410Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2020-04-09T06:49:54.155518Z 0 [Note] [MY-010747] [Server] Plugin 'mysqlx' is disabled.
2020-04-09T06:49:54.158567Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2020-04-09T06:49:54.158736Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2020-04-09T06:49:54.158793Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins
2020-04-09T06:49:54.158845Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2020-04-09T06:49:54.158895Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-09T06:49:54.158962Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2020-04-09T06:49:54.163428Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2020-04-09T06:49:54.163674Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2020-04-09T06:49:54.164388Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2020-04-09T06:49:54.164547Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2020-04-09T06:49:54.166823Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 21 files.
2020-04-09T06:49:54.167860Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2020-04-09T06:49:54.176839Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2020-04-09T06:49:54.178468Z 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-04-09T06:49:54.259142Z 1 [Note] [MY-012529] [InnoDB] Redo log format is v1. The redo log was created before MySQL 8.0.3.
2020-04-09T06:49:54.259308Z 1 [Note] [MY-012557] [InnoDB] Redo log is from an earlier version, v1.
2020-04-09T06:49:54.275579Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2020-04-09T06:49:54.275956Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2020-04-09T06:49:54.276067Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2020-04-09T06:49:54.276276Z 1 [Note] [MY-013041] [InnoDB] Upgrading redo log: 2*50331648 bytes, LSN=2657717
2020-04-09T06:49:54.276570Z 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2020-04-09T06:49:54.283668Z 1 [Note] [MY-012968] [InnoDB] Starting to delete and rewrite log files.
2020-04-09T06:49:54.312751Z 1 [Note] [MY-012887] [InnoDB] Setting log file ./ib_logfile101 size to 48 MB
2020-04-09T06:49:54.375825Z 1 [Note] [MY-012887] [InnoDB] Setting log file ./ib_logfile1 size to 48 MB
2020-04-09T06:49:54.569713Z 1 [Note] [MY-012892] [InnoDB] Renaming log file ./ib_logfile101 to ./ib_logfile0
2020-04-09T06:49:54.570014Z 1 [Note] [MY-012893] [InnoDB] New log files created, LSN=2657804
2020-04-09T06:49:54.570149Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2020-04-09T06:49:54.573700Z 1 [Note] [MY-013040] [InnoDB] Will create 2 new undo tablespaces.
2020-04-09T06:49:54.574446Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2020-04-09T06:49:54.574629Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 10 MB
2020-04-09T06:49:54.574770Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2020-04-09T06:49:54.589162Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2020-04-09T06:49:54.589335Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 10 MB
2020-04-09T06:49:54.589479Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2020-04-09T06:49:54.603483Z 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2020-04-09T06:49:54.603941Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2020-04-09T06:49:54.607509Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2020-04-09T06:49:54.607735Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-09T06:49:54.623156Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2020-04-09T06:49:54.624211Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2020-04-09T06:49:54.661966Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2020-04-09T06:49:54.669831Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2020-04-09T06:49:54.677567Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2020-04-09T06:49:54.834273Z 1 [Note] [MY-012976] [InnoDB] 8.0.19 started; log sequence number 6730956
2020-04-09T06:49:54.835960Z 1 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2020-04-09T06:49:54.897804Z 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80017'.
2020-04-09T06:49:55.189563Z 1 [Note] [MY-010337] [Server] Created Data Dictionary for upgrade
2020-04-09T06:49:55.249770Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for db_upgrade_test.t1
2020-04-09T06:49:55.694958Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2020-04-09T06:49:55.695559Z 0 [ERROR] [MY-010119] [Server] Aborting