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.
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.