MySQL Bugs: #98420: Will not start due to System.IO.FileNotFoundException

Bug #98420	Will not start due to System.IO.FileNotFoundException
Submitted:	28 Jan 2020 19:50	Modified:	29 Jan 2020 13:43
Reporter:	Andy Schmidt	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.19	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	x86
Tags:	documentation, installer, Version History

Description:
Updated from 8.0.18 64-bit to 8.0.19. Workbench wouldn't start. Windows Event Log recorded: 
System.IO.FileNotFoundException at MySQL.GUI.Workbench.Program.Main(System.String[])
P1: MySQLWorkbench.exe
P2: 8.0.19.0
P3: 5df6944b
P4: KERNELBASE.dll
P5: 10.0.18362.628
P6: f96f12ee
P7: e0434352
P8: 000000000003a839

I then attempted uninstalling Workbench completely, reinstalling 8.0.19 - same result.

I then uninstalled and reinstalled 8.0.18 64-bit - and it works flawless.

Enclosed the WER file:

Version=1
EventType=APPCRASH
EventTime=132247132342226701
ReportType=2
Consent=1
UploadTime=132247132344075672
ReportStatus=268435456
ReportIdentifier=71ba8950-fd9f-4f82-99e9-5e785317c187
IntegratorReportIdentifier=739d026c-02b3-4d6f-b900-9c0912e1aac8
Wow64Host=34404
NsAppName=MySQLWorkbench.exe
OriginalFilename=MySQLWorkbench.exe
AppSessionGuid=00002864-0001-002a-0ecc-9ff110d6d501
TargetAppId=W:000646bfebf18af1967ac85d1320c9e11de600000000!0000a180fe3383f654b70ce99e8068e82fea580d2940!MySQLWorkbench.exe
TargetAppVer=2019//12//15:20:15:07!0!MySQLWorkbench.exe
BootId=4294967295
ServiceSplit=3576164769
TargetAsId=1023
IsFatal=1
EtwNonCollectReason=4
Response.BucketId=bb1b87d62dc81e1155201a5b11690bd2
Response.BucketTable=4
Response.LegacyBucketId=1522245652487670738
Response.type=4
Sig[0].Name=Application Name
Sig[0].Value=MySQLWorkbench.exe
Sig[1].Name=Application Version
Sig[1].Value=8.0.19.0
Sig[2].Name=Application Timestamp
Sig[2].Value=5df6944b
Sig[3].Name=Fault Module Name
Sig[3].Value=KERNELBASE.dll
Sig[4].Name=Fault Module Version
Sig[4].Value=10.0.18362.628
Sig[5].Name=Fault Module Timestamp
Sig[5].Value=f96f12ee
Sig[6].Name=Exception Code
Sig[6].Value=e0434352
Sig[7].Name=Exception Offset
Sig[7].Value=000000000003a839
DynamicSig[1].Name=OS Version
DynamicSig[1].Value=10.0.18363.2.0.0.256.48
DynamicSig[2].Name=Locale ID
DynamicSig[2].Value=1033
DynamicSig[22].Name=Additional Information 1
DynamicSig[22].Value=6b27
DynamicSig[23].Name=Additional Information 2
DynamicSig[23].Value=6b273dadf2fa6a85cb547f08bab4dfb5
DynamicSig[24].Name=Additional Information 3
DynamicSig[24].Value=68db
DynamicSig[25].Name=Additional Information 4
DynamicSig[25].Value=68db77096dfba2ad025740dc026472c2
UI[2]=C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe
LoadedModule[0]=C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe
LoadedModule[1]=C:\WINDOWS\SYSTEM32\ntdll.dll
LoadedModule[2]=C:\WINDOWS\SYSTEM32\MSCOREE.DLL
LoadedModule[3]=C:\WINDOWS\System32\KERNEL32.dll
LoadedModule[4]=C:\WINDOWS\System32\KERNELBASE.dll
LoadedModule[5]=C:\WINDOWS\System32\ADVAPI32.dll
LoadedModule[6]=C:\WINDOWS\System32\msvcrt.dll
LoadedModule[7]=C:\WINDOWS\System32\sechost.dll
LoadedModule[8]=C:\WINDOWS\System32\RPCRT4.dll
LoadedModule[9]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscoreei.dll
LoadedModule[10]=C:\WINDOWS\System32\SHLWAPI.dll
LoadedModule[11]=C:\WINDOWS\System32\combase.dll
LoadedModule[12]=C:\WINDOWS\System32\ucrtbase.dll
LoadedModule[13]=C:\WINDOWS\System32\bcryptPrimitives.dll
LoadedModule[14]=C:\WINDOWS\System32\GDI32.dll
LoadedModule[15]=C:\WINDOWS\System32\win32u.dll
LoadedModule[16]=C:\WINDOWS\System32\gdi32full.dll
LoadedModule[17]=C:\WINDOWS\System32\msvcp_win.dll
LoadedModule[18]=C:\WINDOWS\System32\USER32.dll
LoadedModule[19]=C:\WINDOWS\System32\IMM32.DLL
LoadedModule[20]=C:\WINDOWS\System32\kernel.appcore.dll
LoadedModule[21]=C:\WINDOWS\SYSTEM32\VERSION.dll
LoadedModule[22]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
LoadedModule[23]=C:\WINDOWS\SYSTEM32\ucrtbase_clr0400.dll
LoadedModule[24]=C:\WINDOWS\SYSTEM32\VCRUNTIME140_CLR0400.dll
LoadedModule[25]=C:\WINDOWS\System32\psapi.dll
LoadedModule[26]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_64\mscorlib\ce65e35ae3e57af12f3515300d00e518\mscorlib.ni.dll
LoadedModule[27]=C:\WINDOWS\System32\ole32.dll
LoadedModule[28]=C:\WINDOWS\system32\uxtheme.dll
LoadedModule[29]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clrjit.dll
LoadedModule[30]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\diasymreader.dll
State[0].Key=Transport.DoneStage1
State[0].Value=1
OsInfo[0].Key=vermaj
OsInfo[0].Value=10
OsInfo[1].Key=vermin
OsInfo[1].Value=0
OsInfo[2].Key=verbld
OsInfo[2].Value=18363
OsInfo[3].Key=ubr
OsInfo[3].Value=628
OsInfo[4].Key=versp
OsInfo[4].Value=0
OsInfo[5].Key=arch
OsInfo[5].Value=9
OsInfo[6].Key=lcid
OsInfo[6].Value=1033
OsInfo[7].Key=geoid
OsInfo[7].Value=244
OsInfo[8].Key=sku
OsInfo[8].Value=48
OsInfo[9].Key=domain
OsInfo[9].Value=0
OsInfo[10].Key=prodsuite
OsInfo[10].Value=256
OsInfo[11].Key=ntprodtype
OsInfo[11].Value=1
OsInfo[12].Key=platid
OsInfo[12].Value=10
OsInfo[13].Key=sr
OsInfo[13].Value=0
OsInfo[14].Key=tmsi
OsInfo[14].Value=421514
OsInfo[15].Key=osinsty
OsInfo[15].Value=3
OsInfo[16].Key=iever
OsInfo[16].Value=11.592.18362.0-11.0.170
OsInfo[17].Key=portos
OsInfo[17].Value=0
OsInfo[18].Key=ram
OsInfo[18].Value=12161
OsInfo[19].Key=svolsz
OsInfo[19].Value=930
OsInfo[20].Key=wimbt
OsInfo[20].Value=0
OsInfo[21].Key=blddt
OsInfo[21].Value=190318
OsInfo[22].Key=bldtm
OsInfo[22].Value=1202
OsInfo[23].Key=bldbrch
OsInfo[23].Value=19h1_release
OsInfo[24].Key=bldchk
OsInfo[24].Value=0
OsInfo[25].Key=wpvermaj
OsInfo[25].Value=0
OsInfo[26].Key=wpvermin
OsInfo[26].Value=0
OsInfo[27].Key=wpbuildmaj
OsInfo[27].Value=0
OsInfo[28].Key=wpbuildmin
OsInfo[28].Value=0
OsInfo[29].Key=osver
OsInfo[29].Value=10.0.18362.628.amd64fre.19h1_release.190318-1202
OsInfo[30].Key=buildflightid
OsInfo[30].Value=2FAFF704-AC88-4B3F-A3D2-11E6A63F0B67.1
OsInfo[31].Key=edition
OsInfo[31].Value=Professional
OsInfo[32].Key=ring
OsInfo[32].Value=RP
OsInfo[33].Key=expid
OsInfo[33].Value=FX:114145DF,FX:116CE96A,FX:152FEEA
OsInfo[34].Key=containerid
OsInfo[35].Key=containertype
OsInfo[36].Key=edu
OsInfo[36].Value=0
FriendlyEventName=Stopped working
ConsentKey=APPCRASH
AppName=MySQL Workbench
AppPath=C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe
NsPartner=windows
NsGroup=windows8
ApplicationIdentity=01C66442A04BF23F87E194DD30EF7390
MetadataHash=132774329

How to repeat:
Install 8.0.19 and attempt to start

I just reproduced the problem on a different Win 10 system, different hardware/manufacturer, at a different location. 8.0.13 had been working - installing 8.0.19 resulted in same exception:

Faulting application name: MySQLWorkbench.exe, version: 8.0.19.0, time stamp: 0x5df6944b
Faulting module name: KERNELBASE.dll, version: 10.0.18362.535, time stamp: 0x50cc8d5a
Exception code: 0xe0434352
Fault offset: 0x000000000003a839
Faulting application path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll

Hello Andy Schmidt,

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

Regards,
Ashwini Patil

Turns out that 8.0.19 requires VisualStudio 2019 runtime.

This is a major bug, because:

a) this critical change is NOT identified in the version history (I always check.)

b) the INSTALLER does NOT do a proper "prerequisite" check and/or include the VS 2019 runtime installer.

Thank you for your feedback.
Imho this is documented https://dev.mysql.com/doc/workbench/en/wb-installing-windows.html and even in the download page 

Also here https://dev.mysql.com/downloads/workbench/

MySQL Workbench Windows Prerequisites:

To be able to install and run MySQL Workbench on Windows your system needs to have libraries listed below installed. The listed items are provided as links to the corresponding download pages where you can fetch the necessary files.

    Microsoft .NET Framework 4.5
    Visual C++ Redistributable for Visual Studio 2019
    Visual C++ Redistributable for Visual Studio 2019 (for Japanese)
    Visual C++ Redistributable for Visual Studio 2019 (for Traditional Chinese)
    Visual C++ Redistributable for Visual Studio 2019 (for Korean)

But agree, installer should warn you and guide you to the runtime download location if the required prerequisites are not available.

regards,
Umesh

If I was a NEW customer, yes, I should and would read all the "prerequisites". 

But as an EXISTING customer, I don't have to scour around the website trying to play before/after comparisons of what pages might have new information, or where little "(i)" icons may have been added.

That's PRECISELY WHY you have a version history. It's express purpose is to list major changes in behavior, deprecations, new limitations, new requirements for UPGRADING users. 
For a minor BUILD step (from ..18 to ..19) you can't just sneak-in a completely different installation requirement and then omit that crucial information from the version history page!

FWIW, This install does not apparently check for those pre-reqs: https://dev.mysql.com/get/Downloads/MySQLGUITools/ mysql-workbench-community-8.0.19-winx64.msi

This one DOES check (at least it did for me) and install the 2019 redistributable pre-req: https://dev.mysql.com/get/Downloads/MySQLInstaller/ mysql-installer-web-community-8.0.19.0.msi

I had the same problem on a new computer. Installed workbench without an issue and then starting it and nothing would happen. I witnessed this happen on another person's computer and they had an older version of MySqlWorkbench previously installed and running.

Installing the VCRedist from:https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads fixed it for me!