Bug #104557 MySQL Upgrade issue to 8.0.26 - [Windows]
Submitted: 6 Aug 2021 12:31 Modified: 10 Aug 2021 10:04
Reporter: Avinash Chandani Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:8.0.26 OS:Windows
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: MySQL Upgrade issue to 8.0.26 - [Windows]

[6 Aug 2021 12:31] Avinash Chandani
Description:
MySQL Upgrade issue to 8.0.26 - [Windows]

How to repeat:
Hi Team,

We are still facing the same error pasted below with MySQL 8.0.26 which has MySQL Installer-community veriosn 1.4.38
Can you please tell us What exactly is going on from Past many releases as Our customers are eagerly waiting and pressurizing us for MySQL Upgrade from MySQL 8.0.21 to Latest version as MySQL 8.0.21 has various security vulnerability issues.

c:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe community upgrade server:8.0.26 -silent
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Loading product catalog.
The product catalog has not yet been loaded. Skipping merge operation.
Initializing product requirements.
Loading product catalog.
Checking for product packages in the bundle.
Categorizing product catalog.
Finding all installed packages.
Attempting to update manifest.
Initializing product requirements.
Loading product catalog.
Checking for product packages in the bundle.
Categorizing product catalog.
Finding all installed packages.
Your product catalog was last updated at 7/6/2021 1:22:58 PM
Your product catalog has version number 645.
=================== End Initialization ===================

MySQL Server 8.0.21  has no available upgrade targets.

Its same issue that we are able to upgrade via UI but facing error wh

Looking forward for your reply at the earilest.

Thanks in Advance.

Regards,
Avinash Chandani
[6 Aug 2021 12:55] MySQL Verification Team
Thank you for the bug report. I have no problems to process upgrade to 8.0.26 on Windows 10 Pro.
[6 Aug 2021 15:01] Avinash Chandani
Hi Team,

Thanks for quick response, We dun support Windows10 Pro. We use:-
 Microsoft Windows Server 2016 Standard and Datacenter Edition
 Microsoft Windows Server 2019 Standard and Datacenter Edition

And Facing the mentioned issue. Can you please check the same at your end? and share us the results.

Regards,
Avinash Chandani
[6 Aug 2021 15:04] Avinash Chandani
Hi,

To make it more clear, We are facing NO issue while upgrading via UI its happening smoothly. Issue occurs when we are upgrading it silently via command (c:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe community upgrade server:8.0.26 -silent)

Regards,
Avinash Chandani
[6 Aug 2021 15:29] Avinash Chandani
Hi,

As I already mentioned What OS we support. Still, For Testing Purpose I tried on Windows10 as well as facing same issue:-

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe community upgrade server:8.0.26 -silent                                                                                                                      =================== Start Initialization ===================                                                            MySQL Installer is running in Community mode                                                                                                                                                                                                    Attempting to update manifest.                                                                                          Loading product catalog.                                                                                                Attempting to merge the product catalog.                                                                                The new product catalog has been merged with the existing product catalog.                                              Initializing product requirements.                                                                                      Loading product catalog.                                                                                                Checking for product packages in the bundle.                                                                            Categorizing product catalog.                                                                                           Finding all installed packages.                                                                                         Initializing product requirements.                                                                                      Loading product catalog.                                                                                                Checking for product packages in the bundle.                                                                            Categorizing product catalog.                                                                                           Finding all installed packages.                                                                                         Your product catalog was last updated at 8/6/2021 8:57:50 PM                                                            Your product catalog has version number 645.                                                                            =================== End Initialization ===================                                                                                                                                                                                                                                                                                                                                                                                                                                      MySQL Server 8.0.21  has no available upgrade targets.   

Regards,
Avinash Chandani
[6 Aug 2021 16:29] MySQL Verification Team
Ashwini, please check it. Thanks.
[6 Aug 2021 18:28] MySQL Verification Team
Duplicate of https://bugs.mysql.com/bug.php?id=102526.
[9 Aug 2021 21:11] Jose Ramirez
Hello Avinash,
I can see the following entry in the info you provided: "Your product catalog has version number 645.". This indicates that your installation does not have the latest version of the product catalog which is "648". Running a "MySQLInstallerConsole.exe update" command should get you the latest product catalog. If the reported number is now "648" you should be able to proceed with the upgrade as intended.

If for some reason the execution of the "update" command fails then that is an indication that you have a corrupt product catalog. We can try to identify what caused the corruption by requesting more info if you'd like, but in the meantime the quickest solution is to uninstall MySQL Installer and install it again. The uninstall operation will ensure that the corrupt manifest is removed. Be sure to install the latest MySQL Installer (1.4.38 listed as 8.0.26 in the downloads page). After installation attempt to run the upgrade again and the operation should now be successful.

Note that uninstalling MySQL Installer will not affect other MySQL products. You can uninstall it from the Control Panel. 

Regards,
MySQL Windows Experience Team
[10 Aug 2021 10:04] Avinash Chandani
Hi Jose,

Hope you are doing Well. Below are few pointers I want to Highlight.

a. When I am trying to Upgrade via User Interface I am able to upgrade smoothly from 8.0.21 (Installer 1.4.34.0) to Latest version 8.0.26 (Installer 1.4.38.0).
b. Problem occurs When I am trying to upgrade silently via command prompt.

Approach, Steps which we followed for testing purpose :-
Machine was already installed with MySQL 8.0.21

1. Manually Uninstalled old installer (1.4.34.0) via Control Panel Manually and verified it got successfully Uninstalled.
2. Manually Installed new installer (1.4.38.0) with /qn switch. This went fine verified by checking version in Control Panel as it indicated 1.4.38.0
3. Run the command line c:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe community upgrade server:8.0.26 -silent

As soon as we run above command we got below error in log file:-
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Loading product catalog.
The product catalog has not yet been loaded. Skipping merge operation.
Initializing product requirements.
Loading product catalog.
Checking for product packages in the bundle.
Categorizing product catalog.
Finding all installed packages.
Attempting to update manifest.
Initializing product requirements.
Loading product catalog.
Checking for product packages in the bundle.
Categorizing product catalog.
Finding all installed packages.
Your product catalog was last updated at 7/6/2021 1:22:58 PM
Your product catalog has version number 645.
=================== End Initialization ===================

MySQL Server 8.0.21  has no available upgrade targets.

Can you Please tell us any other Solution to proceed and make it a smooth Upgrade as earlier Upgrades? and If possible we can have a Call or meeting setup ?

Awaiting for Response.

Regards,
Avinash Chandani
[23 Sep 2021 5:41] Avinash Chandani
Hi Team,

Do we have any update here?  Does fix for this bug will be taken care in upcoming MySQL 8.0.27 version?  Can you please tell approximate time frame when MySQL 8.0.27 will be released?

Regards,
Avinash Chandani
[4 Oct 2021 10:28] Avinash Chandani
Hi Team,

Do we have any update here?

Regards,
Avinash Chandani