Bug #80925 MySQL 5.6 has"unknown" architecture
Submitted: 31 Mar 2016 15:02 Modified: 2 Aug 2019 15:40
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:5.6.29 OS:Windows (10/64bit)
Assigned to: Gustavo Cuatepotzo CPU Architecture:Any

[31 Mar 2016 15:02] Peter Laursen
Description:
MySQL Installer for Windows cannot detect architecture/bit_depth of MySQL 5.6. No such problem with 5.5 and 5.7

It *is* 64 bit.

How to repeat:
See image

Suggested fix:
No clue
[31 Mar 2016 15:03] Peter Laursen
screenshot

Attachment: inst.PNG (image/png, text), 34.15 KiB.

[31 Mar 2016 19:02] MySQL Verification Team
Thank you for the bug report.
[15 Apr 2016 6:13] Simon Bayes
Hi Miguel - I have exactly the same issue showing in my Windows installation.
Unfortunately it prevents the upgrade to 5.6.30 - because the MySQL Installer does not know that 5.6.30 is a valid upgrade from the "Architecture UNKNOWN" install of 5.6.29
[3 May 2016 20:28] William Graber
Trying to upgrade from 5.6.29 to 5.7, but the installer won't upgrade. It says no eligible upgrades, but the 5.6.29 should be eligible. I think the problem is that the Architecture is "Unknown" so it doesn't have an upgrade path (i.e., not 5.7 x86 or 5.7 x64).

Is there any workaround for this?
[13 May 2016 10:04] Peter Laursen
Is there any workaround for this (like editing an XML file, a registry key or whatever)? 

I am stuck at 5.6.29 due to this. 

Please share whatever workaround is possible.
[2 Jun 2016 14:52] Peter Laursen
Workaround:

1) From inside the Installer interface remove MySQL 5.6. Be sure to reply NO when asked if files in "Program Data" should be deleted (if you miss this you will delete your data)

2) Update manifest when online version has 5.6.31 added or (hat I did) upgrade installer with the new 5.6.31 release. It comes with an updated manifest.

3) From inside the Installer interface select 'add' -option and select MySQL 5.6 server. Accept the selected the old /datadir (there will be a warning). Accept what other configuration settings are proposed (as the Installer reads it from existing my.ini).

After installing 5.6.31 like this the architecuree is now correctly displayed as "x64".
[14 Aug 2016 23:45] Simon Bayes
[2 Jun 14:52] Peter Laursen - workaround worked just fine for me ! I installed 5.6.32 with no issue, and it's now showing correctly "Architecture X64".

Thanks !
[15 Nov 2018 14:04] James Boman
I am having a similar issue with 5.6.42. First, 5.6.42 is not available via the MySQL Installer online catalog (rather, it shows 5.6.41 as the latest version). When I update through extracting the zip file on top of my existing binaries, MySQL Installer still picks up the old version as being installed currently. When I update through the MSI installer and run MySQL Installer after, then update the catalog, it shows the architecture is unknown. I'm needing to update to 5.6.42 as soon as possible due to security vulnerabilities patched in that release, but due to these issues I am hesitant to do anything on my production server.
[8 Jul 2019 20:21] Gustavo Cuatepotzo
Posted by developer:
 
There was a data mistmatch between Manifest product codes and MSI's product codes, the problem was resolved updating manifest with the right values of product code
[2 Aug 2019 15:40] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Installer 1.4.31 release, and here's the changelog entry:

A product-code mismatch between the manifest file and the MSI file caused
some versions of MySQL Server 5.6 to omit the 64-bit product from the
product catalog or to misidentify the version as unknown after MySQL
Installer was restarted.

Thank you for the bug report.