Bug #97407 MySql Workbech Crashes Continuasly on Alter Table Module (Triggers Tap)
Submitted: 29 Oct 2019 8:44 Modified: 30 Oct 2019 5:46
Reporter: abdo abdo Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.17 OS:Microsoft Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[29 Oct 2019 8:44] abdo abdo
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\AJowhar\AppData\Roaming\MySQL\Workbench\log\wb.log]

I was modifying a trigger, and after writing more than 10 lines, I left mySql WB for seconds and when I tried to go back to finish my trigger, WB was no longer working!! it even didn't notify me with any message !!  I opened it again and it retrieved all my open documents that contain queries only, but the ones with altering options were not retrieved!! .

I opened my trigger and all my changes disapeares?
 
yes I didn't apply changes because I wasn't finished yet, but if the app will crash it should save all my progress before so.

Keep In mind that it happened to me twice!! now I have to write my trigger in Notepad and copy paste it when I'am done,  because I no longer trust that module 

I think that is because of one two Reasons :
1. writing a lot of lines in Alter table Module > triggers tab.
2. spending a lot of time in that Module with out clicking Apply 

I hope these tow reasons help you find the bug.
Also to be exact , I was writing a trigger in (After Update) Option...

and the only action I did is (Loose Focus) or (Minimize the WB).

-----------------------------------------------
-----------------------------------------------
-----------------------------------------------
------------------LOG FILE --------------------
-----------------------------------------------
-----------------------------------------------
-----------------------------------------------

10:48:24 [ERR][      Workbench]: Console redirection failed.
10:48:24 [INF][      Workbench]: Starting up Workbench
10:48:24 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 1698027890
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 40833024
10:48:24 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = PROG-AJOWHAR
	USERPROFILE = C:\Users\AJowhar
	HOMEPATH = \Users\AJowhar
	LOCALAPPDATA = C:\Users\AJowhar\AppData\Local
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\Program Files\Java\jdk1.8.0_144\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-StaticC:\Program Files (x86)\Veridis\Biometric SDK\bin\x86;C:\Program Files (x86)\Neurotechnology\FreeFingerprintVerificationSDK 1.0\bin\Win32_x86;C:\Program Files (x86)\NeurotechnologyFF\FreeFingerprintVerificationSDK 1.0\bin\Win32_x86;C:\Program Files (x86)\Neurotechnology\FFV SDK\bin;C:\Program Files (x86)\Neurotechnology\FFV SDK\bin\FPSmm;C:\Program Files (x86)\Nedd\FreeFingerprintVerificationSDK 1.0\bin\Win32_x86;C:\Users\FSharif\Desktop\php-5.6.31-Win32-VC11-x64;C:\Users\FSharif\Desktop\mpdf-6.1.2;C:\Program Files\dotnet\;C:\WINDOWS\System32\OpenSSH\;C:\Users\AJowhar\AppData\Local\Microsoft\WindowsApps;
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\PROG-AJOWHAR
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\WINDOWS
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	DriverData = C:\Windows\System32\Drivers\DriverData
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	APPDATA = C:\Users\AJowhar\AppData\Roaming
	PROCESSOR_REVISION = 3c03
	USERNAME = AJowhar
	CommonProgramW6432 = C:\Program Files\Common Files
	TEMP = C:\Users\AJowhar\AppData\Local\Temp
	OneDrive = C:\Users\AJowhar\OneDrive - Almabani General Contractors
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = PROG-AJOWHAR
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 60 Stepping 3, GenuineIntel
	ComSpec = C:\WINDOWS\system32\cmd.exe
	SystemDrive = C:
	FPS_BROWSER_USER_PROFILE_STRING = Default
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 8
	TMP = C:\Users\AJowhar\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	USERDOMAIN = PROG-AJOWHAR
	PUBLIC = C:\Users\Public
10:48:24 [INF][      Workbench]: Current version given by meta info is: 8.0.17
10:48:24 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files\Java\jdk1.8.0_144\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-StaticC:\Program Files (x86)\Veridis\Biometric SDK\bin\x86;C:\Program Files (x86)\Neurotechnology\FreeFingerprintVerificationSDK 1.0\bin\Win32_x86;C:\Program Files (x86)\NeurotechnologyFF\FreeFingerprintVerificationSDK 1.0\bin\Win32_x86;C:\Program Files (x86)\Neurotechnology\FFV SDK\bin;C:\Program Files (x86)\Neurotechnology\FFV SDK\bin\FPSmm;C:\Program Files (x86)\Nedd\FreeFingerprintVerificationSDK 1.0\bin\Win32_x86;C:\Users\FSharif\Desktop\php-5.6.31-Win32-VC11-x64;C:\Users\FSharif\Desktop\mpdf-6.1.2;C:\Program Files\dotnet\;C:\WINDOWS\System32\OpenSSH\;C:\Users\AJowhar\AppData\Local\Microsoft\WindowsApps;
10:48:24 [INF][ mforms managed]: Initializing mforms wrapper
10:48:25 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	user data dir: C:\Users\AJowhar\AppData\Roaming\MySQL\Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
10:48:25 [INF][      WBContext]: WbContext::init
10:48:25 [INF][            WBA]: Looking for extension modules for WBA...
10:48:25 [INF][            WBA]: 0 extension modules found
10:48:25 [WRN][            grt]: C:\Users\AJowhar\AppData\Roaming\MySQL\Workbench\connections.xml:25: link '{CB3DD00E-AF28-456D-AF11-39C01F215561}' <object GrtObject> key=owner could not be resolved
10:48:25 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.17 CE build 14960816 (64 bit)
	Configuration Directory: C:\Users\AJowhar\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Pro
	CPU: 8x Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz, 16.0 GiB RAM
	Active video adapter AMD Radeon HD 5450
	Installed video RAM: -2048 MB
	Current video mode: 1920 x 1200 x 4294967296 colors
	Used bit depth: 32
	Driver version: 15.201.1151.1008
	Installed display drivers: aticfx64.dll,aticfx64.dll,aticfx64.dll,amdxc64.dll
	Current user language: English (United States)

10:48:25 [INF][    WQE backend]: Found auto-save workspace C:\Users\AJowhar\AppData\Roaming\MySQL\Workbench\sql_workspaces\myLocalDB-1.autosave
10:48:25 [INF][      Workbench]: UI is up
10:48:25 [INF][      Workbench]: Running the application
10:48:33 [INF][SQL Editor Form]: Opened connection 'myLocalDB' to SUSE MySQL package version 5.5.47
10:48:34 [ERR][      WBContext]: Unsupported server version: SUSE MySQL package 5.5.47
10:48:34 [INF][        WQE.net]: Launching SQL IDE
10:48:35 [INF][        WQE.net]: SQL IDE UI is ready

How to repeat:

1.Create an after-update trigger that contains one line which updates another table. (from alter table module)

2.save changes 

3.close the alter table module.

4.open it again and modify it by adding a lot of lines and if conditions 

5.each if condition updates on the same table referenced above 

6.do 5 if conditions each on validates 4 cases, for example :

if (new.col <> old.col and new.col = 1) 
   or (new.col2 <> old.col2 and new.col2 = 1)
   or(new.col3 <> old.col3 and new.col3 = 1)
then 
 update table2 set ... 
end if ;

now repeat above lines three or four times .... 

then leave WB without applying changes ,, spend less than a minute in any other program , and you will notice WB has crashed.

Suggested fix:
nothing in mind....

but I hope you don't have anything happening when focus is lost,
any thing that may affect the opened documents.
[30 Oct 2019 5:46] Umesh Shastry
Hello abdo abdo,

Thank you for the report and feedback.
Imho this is no longer reproducible after Bug #95742 fixed in WB 8.0.18. 
I tried to repeat this issue at my end using WB 8.0.18 with dummy test case and confirmed that it is not reproducible. Please upgrade to latest WB 8.0.18 https://dev.mysql.com/downloads/workbench/ and report us back if you are still seeing this issue. If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.  

Thank you for your interest in MySQL.

regards,
Umesh