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()

[8 Aug 2024 11:54] Przemyslaw Malkowski
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.
[8 Aug 2024 12:22] MySQL Verification Team
Hello Przemyslaw,

Thank you for the report and feedback. 

Thanks,
Umesh
[8 Aug 2024 12:24] MySQL Verification Team
-- 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
[18 Sep 2024 9:50] Edward Gilmore
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.
[18 Sep 2024 9:51] Edward Gilmore
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.