Bug #103009 Mise à jour de Connector 8.0.20
Submitted: 17 Mar 1:10 Modified: 23 Apr 13:45
Reporter: Mario-C Charest Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:8.0.24 OS:Microsoft Windows (échec de mise à jour)
Assigned to: CPU Architecture:Any
Tags: Mise à jour

[17 Mar 1:10] Mario-C Charest
Description:
Bonjour,
J'essaie d'installer la version 8.0.23 et le connecteur 8.0.20 est toujours en échec. Je me demande si ce n'est pas cela qui m'empêche de créer une connexion utilisant Visual Studio 2017? Voici le log ici:

https://1drv.ms/u/s!At-m4EoTfFlSiMAO4Ytjj3hDSclvmg?e=6xeK6E

Mario CC

How to repeat:
À l'installation
[23 Mar 16:16] Mario-C Charest
Bonjour,
Est-ce que je peux espérer une résolution de ce problème bientôt? J'ai essayé de retirer le connecteur 8.0.20 autant par le paramétrage Windows que par l'application (Remove) sans succès.
[23 Mar 16:19] Mario-C Charest
Log and screen print

Attachment: Problem.pdf (application/pdf, text), 818.62 KiB.

[29 Mar 12:40] MySQL Verification Team
Hello Mario-C Charest,

Thank you for the bug report
I tried to reproduce your issue on windows 10 with MySQL Installer and tried to upgrade connector/net from 8.0.20 to 8.0.23 but I am not seeing any issues at my end. Thanks.

Regards,
Ashwini Patil
[29 Mar 12:41] MySQL Verification Team
8.0.23 test results

Attachment: 103009_test_results.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 15.79 KiB.

[30 Mar 15:10] Mario-C Charest
Hi Ashwini Patil,
It is obvious that you could not reproduced the event. However, still on my computer when I run the update the progression counter goes up to 52%, then back off to 50% before to go to failed.
Even Windows uninstall fails to remove MySQL Connector Net 8.0.20.
The result: I cannot use MySQL.
Can you help?
[31 Mar 18:06] Gustavo Cuatepotzo
Hello Mario,
At this point, the only way to fix the problem is to remove Manually all the entries of "Connector NET" from the windows registry, but keep in mind this action can be very risky, you need to be very careful and if possible take a snapshot of your system that allows you recover in the case of damage.

in some cases you will need to remove an entire group, like
in this case:
Computer\HKEY_CLASSES_ROOT\Installer\Products\5C4BB67B4E04C2D4A881C8583C400D48
, here you need to delete from Products folder the entire key and subkeys for
5C4BB67B4E04C2D4A881C8583C400D48

from all these entries: you also need to remove the entire key and subkeys
which references Connector Net
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installe
r\UserData\S-1-5-18\Components\
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installe
r\UserData\S-1-5-18\Products\
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.5.
50709\AssemblyFoldersEx\MySQL Connector Net 8.0.21 v4.5.1
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVers
ion\Uninstall\{B76BB4C5-40E4-4D2C-8A18-8C85C304D084}
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\MySQL AB\MySQL Connector/Net

in other cases like in
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installe
r\Folders, you only need to remove the entries in the right side which
mention Connector Net, will be something like this:
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.21\
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.21\Assemblies\
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.21\Assemblies\v4.5.2\
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\MySQL\MySQL Connector
Net 8.0.21\

---Some of the mentioned registry entries can have some differences in your
system, to locate them is better to use the "find" option---

After review your log, we found there is missing the log entries where the records are removed from the registry, this probably means those records can not be found in your system registry and that is causing the process to abort,  there can be so many reasons for why these entries are not found, starting from the version of the operative system or even if the files were moved to another location, for that reason it is very important for us to understand what steps you followed to arrive to this point in order to prevent this happen again, if you can provide those details that would be very helpful for us.

We tried different scenarios, for example, installing MySQLInstaller 8.0.20 and doing the upgrades running MySqlInstaller 8.0.23, that worked, we tried also running directly the Connector Net MSI 8.0.20 and then update with the last version and it worked also, I'm attaching our full log to let you compare with yours.

Regards
[31 Mar 18:07] Gustavo Cuatepotzo
Upgrade Connector full log

Attachment: Bug103009.log (application/octet-stream, text), 23.76 KiB.

[2 Apr 20:11] Mario-C Charest
1) did not find Computer\HKEY_CLASSES_ROOT\Installer\Products\5C4BB67B4E04C2D4A881C8583C400D48
2)renamed Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installe
r\UserData\S-1-5-18\Components\
3)Renamed Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installe
r\UserData\S-1-5-18\Products\
4) Dis not find Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.5.
50709\AssemblyFoldersEx\MySQL Connector Net 8.0.21 v4.5.1

but
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.5.
50709\AssemblyFoldersEx\MySQL Connector Net 8.0.20 v4.5.1
Renamed
5) Did not find
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVers
ion\Uninstall\{B76BB4C5-40E4-4D2C-8A18-8C85C304D084}
6)Did not find Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\MySQL AB\MySQL Connector/Net
but
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\MySQL AB\MySQL Connector/ODBC 8.0
Renamed
7)Closed regedit and ran install
[2 Apr 20:34] Mario-C Charest
Installation of the connector/Net 8.0.23 failed again (see screen capture)
8)Removed the entire product and re-install (Developer default), Same result.
I'll try the second type of "deletion" tomorrow...
[3 Apr 14:38] Mario-C Charest
9) Did not exist:
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.21\
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.21\Assemblies\
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.21\Assemblies\v4.5.2\
but
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0\
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0\Assemblies\
C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0\Assemblies\v4.5.2\ 
Deleted

10)Did not find C:\ProgramData\Microsoft\Windows\Start Menu\Programs\MySQL\MySQL Connector Net 8.0.21\
only 
MySQL Installer for Windows - Community
Done nothing
11) re-install...
[3 Apr 15:12] Mario-C Charest
12) Same failiure. I removed the product.
13) Start over but removing the folders I renamed at first (those I could find)
14) Re-install again.
15) Failed again.
I suspect the folders I did not find. Your references were with 8.0.21 while I have to look for 8.0.20.
:)
[5 Apr 1:37] Gustavo Cuatepotzo
Hi Mario,
we can have differences in the paths and in the registry entries, is better if you use the option "find" in the windows registry and search all entries of "Connector Net", then you can start removing those from your registry, and also you need to delete the folder were the connector is installed, when you have done this properly you won't see the connector net in the windows option "add or remove programs", then you can reinstall any version again
[7 Apr 2:14] Gustavo Cuatepotzo
still there is another way to uninstall the connector without manipulating the registry directly, you can download "The Program Install and Uninstall troubleshooter", it is available directly in Windows support pages, I tested and it worked, can you give it a try and let me know if it works?
[8 Apr 20:17] Mario-C Charest
16) I deleted every thing I found with "Connector Net"
17) Reinstalled, Same failure.
18) Ran Windows troubleshooting program using Installation option
19) There was no entry about "Connector Net"
20) I removed the MySQL product
21) Ran troubleshooting using Uninstall.
22) The only MySQL thing shown was the Community Installer. I select Uninstall
23) 2 messages, One saying key corrected, two impossible to install or uninstall a program.
24) Ran again MySQL installer, guest what: same result... :(
[9 Apr 14:06] Gustavo Cuatepotzo
Hi Mario,
we still can not replicate the scenario you mention,

we tried using Windows 10 x64 (French) and we already did many combinations installing MySQL Installer 8.0.20 and upgrading to 8.0.23, we tried also using only the Connector Net MSI's but we can't reach that point that you have, we are missing some steps or some actions in the middle that maybe caused this scenario, if you can provide more details about how you get into this point that would be helpful for us
[9 Apr 16:38] Mario-C Charest
I downloaded the installer for 8.0.20, but automatically it searches for update toward 8.0.23
:)
[23 Apr 12:55] Mario-C Charest
Hi
I just install 8.0.24 and the connector failure remains.
[23 Apr 12:58] Mario-C Charest
I'm following MySQL for Visual studio
https://dev.mysql.com/doc/visual-studio/en/visual-studio-what-is-new-20.html
and the connection to MySQL connection is not available.
[23 Apr 13:45] Mario-C Charest
And the documentation in
https://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html
mention that Connector/Net is required for Entity Framework Designer.
It is my case...