| Bug #103009 | Mise à jour de Connector 8.0.20 | ||
|---|---|---|---|
| Submitted: | 17 Mar 2021 1:10 | Modified: | 23 Apr 2021 13:45 |
| Reporter: | Mario C Charest | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S3 (Non-critical) |
| Version: | 8.0.24 | OS: | Windows (échec de mise à jour) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Mise à jour | ||
[17 Mar 2021 1:10]
Mario C Charest
[23 Mar 2021 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 2021 16:19]
Mario C Charest
Log and screen print
Attachment: Problem.pdf (application/pdf, text), 818.62 KiB.
[29 Mar 2021 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 2021 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 2021 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 2021 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 2021 18:07]
Gustavo Cuatepotzo
Upgrade Connector full log
Attachment: Bug103009.log (application/octet-stream, text), 23.76 KiB.
[2 Apr 2021 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 2021 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 2021 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 2021 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 2021 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 2021 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 2021 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 2021 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 2021 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 2021 12:55]
Mario C Charest
Hi I just install 8.0.24 and the connector failure remains.
[23 Apr 2021 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 2021 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...
