MySQL Bugs: #115798: util.checkForServerUpgrade() claims upgrade version 8.0.x to 8.4.x not supported

Bug #115798	util.checkForServerUpgrade() claims upgrade version 8.0.x to 8.4.x not supported
Submitted:	8 Aug 2024 11:54	Modified:	18 Sep 2024 9:51
Reporter:	Przemyslaw Malkowski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Shell Upgrade Checker	Severity:	S2 (Serious)
Version:	8.4.1	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	util.checkForServerUpgrade()

Description:
According to the documentation:
https://dev.mysql.com/doc/refman/8.4/en/upgrade-paths.html
One of the upgrade paths is "From an LTS or Bugfix series to the next LTS series", path examples "8.0.37 to 8.4.x LTS", including methods of in-place, logical, etc.

Now, the upgrade checker claims something different:

WARNING: Upgrading MySQL Server from version 8.0.39 to 8.4.1 is not supported.
Please consider running the check using the following option: targetVersion=8.0

How to repeat:
Install any "bugfix" 8.0 release (8.0.34+), and the latest MySQL Shell 8.4.1, then run the upgrade check utility. I have the same warning regardless of the minor version, always 8.0.x -> 8.4.x raises the confusing warning:

MySQL Shell 8.4.1

 MySQL  localhost:33060+ ssl  JS > util.checkForServerUpgrade()
The MySQL server at localhost:33060, version 8.0.39 - MySQL Community Server -
GPL, will now be checked for compatibility issues for upgrade to MySQL 8.4.1.
To check for a different target server version, use the targetVersion option.

WARNING: Upgrading MySQL Server from version 8.0.39 to 8.4.1 is not supported.
Please consider running the check using the following option: targetVersion=8.0

-------------------

 MySQL  localhost:8054 ssl  JS > util.checkForServerUpgrade('root:msandbox@localhost:8055',{"targetVersion":"8.4.1"})
The MySQL server at localhost:8055, version 8.0.37 - MySQL Community Server -
GPL, will now be checked for compatibility issues for upgrade to MySQL 8.4.1.

WARNING: Upgrading MySQL Server from version 8.0.37 to 8.4.1 is not supported.
Please consider running the check using the following option: targetVersion=8.0

-------------------

 MySQL  localhost:33060+ ssl  JS > util.checkForServerUpgrade('root:password@localhost',{"targetVersion":"8.4.0"})
The MySQL server at localhost:33060, version 8.0.39 - MySQL Community Server -
GPL, will now be checked for compatibility issues for upgrade to MySQL 8.4.0.

WARNING: Upgrading MySQL Server from version 8.0.39 to 8.4.0 is not supported.
Please consider running the check using the following option: targetVersion=8.0

etc.

Suggested fix:
Please make sure the checkForServerUpgrade util gives consistent information about the upgrade with the upgrade paths documentation.

Hello Przemyslaw,

Thank you for the report and feedback. 

Thanks,
Umesh

-- 8.4.1

bin/mysqlsh
MySQL Shell 8.4.1

Copyright (c) 2016, 2024, 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 '\?' for help; '\quit' to exit.
 MySQL  SQL > \c root@localhost:3306
Creating a session to 'root@localhost:3306'
Please provide the password for 'root@localhost:3306':
Save password for 'root@localhost:3306'? [Y]es/[N]o/Ne[v]er (default No):
Fetching global names for auto-completion... Press ^C to stop.
Your MySQL connection id is 8
Server version: 8.0.39 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
 MySQL  localhost:3306 ssl  SQL >
 
 MySQL  localhost:3306 ssl  SQL > \js
Switching to JavaScript mode...
 MySQL  localhost:3306 ssl  JS > util.checkForServerUpgrade()
The MySQL server at localhost:3306, version 8.0.39 - MySQL Community Server -
GPL, will now be checked for compatibility issues for upgrade to MySQL 8.4.1.
To check for a different target server version, use the targetVersion option.

WARNING: Upgrading MySQL Server from version 8.0.39 to 8.4.1 is not supported.
Please consider running the check using the following option: targetVersion=8.0

Posted by developer:
 
Added the following note to the MySQL Shell 8.0.40, 8.4.3, and 9.1.0 release notes:
  
The upgrade checker utility returned an error claiming that it
was not possible to upgrade from MySQL 8.0.x to MySQL 8.4.x.
This upgrade path is possible.
See https://dev.mysql.com/doc/refman/en/upgrade-paths.html.

Thank you for the bug report.

Added the following note to the MySQL Shell 8.0.40, 8.4.3, and 9.1.0 release notes:
  
The upgrade checker utility returned an error claiming that it
was not possible to upgrade from MySQL 8.0.x to MySQL 8.4.x.
This upgrade path is possible.
See https://dev.mysql.com/doc/refman/en/upgrade-paths.html.

Thank you for the bug report.