MySQL Bugs: #99547: mysql-installer-community won't install

Bug #99547	mysql-installer-community won't install
Submitted:	13 May 2020 9:59	Modified:	22 Oct 2020 16:00
Reporter:	Anthony Marston	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S3 (Non-critical)
Version:	8.0.20	OS:	Windows (10 Enterprise)
Assigned to:	MySQL Verification Team	CPU Architecture:	Other (AMD Ryzen 3 3200G)
Tags:	hangs, installer

Description:
When I try to install MySQL by running mysql-installer-community-8.0.20.0.msi the dialog box gets as far as showing the message "Please wait while Windows configures MySQL Installer - Community" and "Time remaining 4 seconds" then it hangs. If I press the CANCEL button it displays "Cancelling" but hangs again. I have tried looking for log files, but I cannot see any.

I also have a Lenovo laptop running Windows 10, but there the same file installs without any problem.

How to repeat:
Run mysql-installer-community-8.0.20.0.msi 

Suggested fix:
Produce some sort of log which shows where it got to before it hangs.

Open an CMD windows command line with administrator privilege and go where the installer file was downloaded, and try:

msiexec /i  mysql-installer-community-8.0.20.0.msi

Windows Installer log file

Attachment: MSIe6ea4.LOG (application/octet-stream, text), 324.38 KiB.

I have tried that, but it still hangs in the same place.

I have managed to find instructions to turn on logging for the Windows Installer, and the latest results are in the attached file.

The last entry is always "Creating scheduled task if doesn't already exist."

I have checked the task scheduler, and the task is there and being run every night at midnight, so I cannot see why this is failing. I have tried deleting the scheduled task so that it can be recreated by the installer, but it still hangs. I have tried exporting the task details from my laptop (which works) into this desktop, but it still fails.

Thank you for the feedback. Looks related to bug: https://bugs.mysql.com/bug.php?id=99484.

I don't see how it is related. Both my PCs, a laptop and a desktop, are running English version of Windows 10. Both of them have the ManifestUpdate task in Task Scheduler running in the LOCAL SERVICE account. The installer on the laptop works while on the desktop if fails. Both scheduled tasks run without error.

Thank you for the feedback. The problem here we are not able to reproduce the issue, looks is something environment factor (anti-virus program i.e) is your computer OS updated with Microsoft Update service?.

Both PCs are running Windows 10 with the latest updates, and both computers are running with Norton 360 antivirus.

It seems that it is hanging when it tries to access the Task Scheduler data for the ManifestUpdate entry. What could be causing this to fail?

I don't know if this is possible, but when accessing the task scheduler details, either reading or writing, and something goes wrong it would be better to output some sort of warning message and continue with the installation process instead of just hanging. The lack of a task scheduler entry may be slightly inconvenient, but it should not be a show-stopper.

Please try latest released version 8.0.21. Thanks.

I have tried the latest release, but it still hangs at the same place.

Hello Anthony,

There are a couple of things you can try that might work.

1. Open Task Scheduler and delete all the directory structure created by MySQL Installer, that is removing the "MySQL/Installer" folders shown under the "Task Scheduler Library" folder. Then try again the installation.

2. There might be a weird permissions issue, if that is the case, opening a cmd window as an administrator and executing the MySQL Installer MSI from there might do the trick.

I haven't been able to reproduce the behavior, but looking through the code and based on the log you provided I can see your installation is getting stucked whenever Installer attempts to validate the existence of the scheduled task by running the schtasks.exe. For some reason it looks as though you are not able to run that exe on your environment.

---------
Jose Ramirez | MySQL Team

I have tried running the installer again, but when I look in the log it skips over the part where it creates the scheduled task so I cannot tell if the problem is fixed. I shall wait for the next update.

I think I have found the issue. I tried to delete the MySQL/Installer entry within the task scheduler but I could not due to a permissions error. I could delete the folder C:\Windows\System32\Tasks\MySQL, but it kept reappearing whenever I ran the task scheduler. It must have been reinstating that folder using information from somewhere else, so I began to suspect the system registry. I ran regedit, navigated to HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Schedule\TaskCache\Tasks, found all entries related to MySQL and deleted them. I then ran task scheduler and imported the task definition, and now all seems to be well. I ran the MySQL Installer and selected the option to "check for updates to the MySQL Installer product catalog", and it worked without hanging as it did before.