MySQL Bugs: #102526: MySQL Server 5.7.33 Silent Command Upgrade Failure

Bug #102526	MySQL Server 5.7.33 Silent Command Upgrade Failure
Submitted:	8 Feb 2021 9:57	Modified:	19 May 2021 18:18
Reporter:	Valliappan S	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.7.33, 8.0.24, 8.0.27	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Team,

We are currently installed MySQL server version 5.7.32 (Windows) and it is working fine. To address security vulnerabilities decided to perform upgrade to the latest MySQL Version 5.7.33 (Windows) through silent command as the
script.

During the time of upgrade, it fails with following error:

"MySQL Server 5.7.32 has no available upgrade targets."

But if i am trying the same upgrade via GUI mode, it went through fine without
any issues.

Kindly address this issue on high priority, due to this critical upgrade bug
our product is exposed for security vulnerability.

How to repeat:
Steps:

1. Install MySQL Community Installer 5.7.32
2. Then silently install the MySQL server 5.7.22 through following command,

C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole.exe> community install server;5.7.32;x64:*:type=config;openfirewall=true;generallog=true;enable_tcpip=true;port=3306;datadir="C:\ProgramData\NetApp\SnapCenter\MySQL Data" -silent

3. Upgrade MySQL Community Installer 5.7.33 version
4. Then silently upgrades the MySQL Server 5.7.33 through following command,

community upgrade server:5.7.33

Upgrade will fail with the error, 

"MySQL Server 5.7.32 has no available upgrade targets."

Suggested fix:
Resolve the upgrade issue whatever we are facing during the silent installation.

Hello Valliappan S,

Thank you for the bug report.
Imho this is duplicate of Bug #86683, please see Bug #86683.

Regards,
Ashwini Patil

Hi Team,

This is not a duplicate issue. (id=86683)

In the bug_86683, they discussed about the"-silent" command usage. 

But whatever i reported over here is the different problem, regardless of silent command - the upgrade operation fails with following error,

"MySQL Server 5.7.32 has no available upgrade targets."

Note: I verified your existing bug database and this issue never reported. 

Thanks
Valliappan S

Can the status be changed back from Duplicate to New to investigate this failure at the earliest?

Reiterating the steps to reproduce:
----------------------------------

1. Install MySQL Community Installer 5.7.32
2. Then install the MySQL server 5.7.22 through following command via command prompt,

C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole.exe> community install server;5.7.32;x64:*:type=config;openfirewall=true;generallog=true;enable_tcpip=true;port=3306;datadir="C:\ProgramData\NetApp\SnapCenter\MySQL Data" -silent

3. Upgrade MySQL Community Installer 5.7.33 version
4. Then upgrades the MySQL Server 5.7.33 through following command via command prompt,

"community upgrade server:5.7.33"  - Upgrade is failing with error 'MySQL Server 5.7.32 has no available upgrade targets.'

Executed the same command with silent option,

"community upgrade server:5.7.33 -silent"  - Upgrade is failing with same error 'MySQL Server 5.7.32 has no available upgrade targets.'
----------------------------------

So, failure is same regardless of "-silent" parameter. We never faced this issue during the 5.7.30 -> 5.7.32 upgrade.

And it concludes this issue is not a duplicate entry of Bug #86683.

Thanks
Valli

Hello Valliappan S,

Thank you for the valuable feedback.
Verified as described.

Regards,
Ashwini Patil

Pls advise what is the next step on this. is this acknowledged that this is a bug . if so, can you pls let us know the fix availability?

Bug #103457 marked as duplicate of this one.

Hi Team,

I got may be that's the Duplicate issue as mentioned.
But What's the SOLUTION?

Any you please prioritize it and respond ASAP.

Regards,
Avinash Chandani

Here is issue that I am facing :-

When I am trying Upgrade MySQL 8.0.21 to MySQL 8.0.24 via command line :-

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe community upgrade server:8.0.24 -silent

I am getting below error in the command prompt:-
=================== Start Initialization ===================
MySQL Installer is running in Community mode

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 4/23/2021 10:22:21 AM
=================== End Initialization ===================

MySQL Server 8.0.21  has no available upgrade targets.

Can you please throw some light here that What is missing here.
Looking forward for your response.

Regards,
Avinash Chandani

Hello Avinash,
can you check what Installer version is being used to attempt the upgrade
from server 8.0.21 to 8.0.24?
I'd recommend uninstalling the current Installer and installing Installer
1.4.37 (listed as 8.0.24 in the downloads page).
If running the upgrade command ("community upgrade server:8.0.24
-silent") continues to show the no updates available error, run the update
command ("update") and once complete attempt to upgrade the server once more.

Ideally, you could simply install Installer 1.4.37 on top of your current
installation, however there is a bug that will prevent the product catalog
from being updated and is being fixed until the next version (1.4.38).

Both issues reported when upgrading server 5.7 and 8.0 as well as using or not using the -silent option are all caused by this bug.

Note that Installer not finding products to upgrade is expected if the configured number of days since the last product catalog have not yet passed (by default set to every 7 days but can be configured in Installer options via the UI interface).

It's also possible to manually trigger a product catalog update by running the "update" command. Ideally this should make the latest products available, however this bug is preventing the update from completing successfully.

As mentioned in an earlier comment, the best workaround is to simply uninstall your current Installer via the control panel (no need to uninstall other MySQL Products) and install the latest Installer (5.7.34/8.0.24). This will force the old product catalog to be removed and re-downloaded with the new installation. This should allow for the latest products to be available and the upgrade to be applied.

Finally, also as part of this bug, some user visible messages and log messages will be updated to better communicate what happens when executing the "update" and "upgrade" commands.

Hi Jose,

To be in sync and clarify we are trying to upgrade from 8.0.21 to 8.0.24

First Approach, Steps which we followed for testing purpose :-

1. Manually Uninstalled old installer (1.4.34.0).
2. Manually Installed new installer (1.4.37.0) with /qn switch. This went fine verified by checking version in Control Panel.
3. Run the command line "C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole.exe" "community update server:8.0.24 -silent" C:\ProgramData\NetApp\OnCommandAppData\ocum\log\mysql_installer_console.log.

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

There was an error encountered while loading the configuration and product catalog: Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it.
Initialization failed. Please check the logs for more information.

Second Approach, Steps which we followed for testing purpose :-

1. Manually Uninstalled old installer (1.4.34.0).
2. Manually Installed new installer (1.4.37.0) with /qn switch. This went fine verified by checking version in Control Panel.
3. Run the command line "C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole.exe" "community upgrade server:8.0.24 -silent" C:\ProgramData\NetApp\OnCommandAppData\ocum\log\mysql_installer_console.log.

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

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 4/7/2021 7:29:06 AM
=================== End Initialization ===================

MySQL Server 8.0.21  has no available upgrade targets.

Next step I took as mentioned by MySQL team I executed "C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole.exe" "community update server:8.0.24 -silent" C:\ProgramData\NetApp\OnCommandAppData\ocum\log\mysql_installer_console.log.

and ended up with below error :-

=================== Start Initialization ===================
MySQL Installer is running in Community mode

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 4/7/2021 7:29:06 AM
=================== End Initialization ===================

Unable to connect to remote host.  Catalog download has failed.

Resolution told to manually Uninstall and Install MySQL 8.0.24, But in Our Product we Support ZERO USER interaction and Bundle MySQL with Our Product.

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

Hi Jose,

As MySQL 8.0.25 is available now, I tried to upgrade from MySQL 8.0.21 to 8.0.25 via below command line:-

"C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole.exe" "community upgrade server:8.0.25 -silent" C:\ProgramData\mysql_installer_console.log

and Still facing the same below issue:-

=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Attempting to merge manifest...
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 5/12/2021 10:34:19 AM
=================== End Initialization ===================

MySQL Server 8.0.21  has no available upgrade targets.

Can you please update solution to this ?

Regards,
Avinash Chandani

Fixed as of the upcoming MySQL Installer 1.4.38 release, and here's the proposed changelog entry from the documentation team:

A server upgrade initiated from the command line emitted an error
indicating that no targets were available for the installed version,
however, the same server version could be upgraded by using the graphical
MySQL Installer application.

Thank you for the bug report.

Hi Christine Cole,

Can you please tell any approximate time frame when we can expect MySQL Installer 1.4.38 to be released ?

Thanks,
Avinash Chandani

Hi,

Is this issue will get fix in MySQL 8.0.26? What's the time frame of MySQL 8.0.26 to be released?

Thanks,
Avinash Chandani

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

Posted by developer:
 
Hello Avinash,
First of all, the latest version of MySQL Installer is 1.4.39. It can be obtained by running a catalog update from the Main Dashboard when running Installer in GUI mode. Optionally, the update file can be obtained from http://cdn.mysql.com/Downloads/MySQLInstaller/mysql-installer-update-1.4.39.0-Community.ms.... I recommend upgrading to this version since it has some additional fixes related to CLI. To install it, simply close Installer (if open) and run the downloaded file.

In the provided info, I continue to see that the product catalog version number is listed as "645", currently the latest version is "651".
Has the "MySQLInstallerConsole.exe update" command been executed as I have recommended in a couple of my previous comments? Note that it is likely that no upgrades are found because the product catalog has not yet been updated.

Can you provide the output that results from the execution of the "MySQLInstallerConsole.exe update" command? If the command executes correctly and you are able to see "651" or greater as the version number then you can proceed to run the "upgrade" command. If the command fails to update to the latest product catalog, please provide a copy of the "Manifest" folder usually located at "C:\ProgramData\MySQL\MySQL Installer for Windows" as I believe there may be an issue with said files.

Regards.

Bug #105404 marked as duplicate of this one.

Posted by developer:
 
Latest version of Installer is currently 1.6.1 (included in the 8.0.28 Installer bundles). I recommend proceeding as indicated in my previous comment but using this version.

Posted by developer:
 
Closing since no reply has been received from latest user and other user has confirmed issue has been fixed.