| Bug #105387 | work bench crashes when trying to create a new model | ||
|---|---|---|---|
| Submitted: | 29 Oct 2021 14:52 | Modified: | 11 Nov 2021 18:58 |
| Reporter: | mark edwards | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Workbench: Modeling | Severity: | S2 (Serious) |
| Version: | 8.0.27 | OS: | Windows (Microsoft Windows 10 Home) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[29 Oct 2021 19:47]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat this issue, please attach screenshots of step by step to repeat the issue (use the tab Files to attach the screenshots files).
[29 Oct 2021 23:50]
mark edwards
step one
Attachment: error-1.png (image/png, text), 255.06 KiB.
[29 Oct 2021 23:51]
mark edwards
step two
Attachment: error-2.png (image/png, text), 157.33 KiB.
[29 Oct 2021 23:51]
mark edwards
step three
Attachment: error-3.png (image/png, text), 212.35 KiB.
[31 Oct 2021 14:30]
mark edwards
ER Builder seems to be a good drop-in replacement for the Workbench modeling tool.
[31 Oct 2021 14:31]
mark edwards
https://soft-builder.com/erbuilder-data-modeler/
[2 Nov 2021 8:37]
MySQL Verification Team
Hello mark edwards, Thank you for the feedback and details. I tried to reproduce your issue on windows 10 with workbench 8.0.27 and followed exact steps but I am not seeing any issues at my end. Regards, Ashwini Patil
[2 Nov 2021 16:22]
mark edwards
ok i see four options: 1) you send me a special mysql-workbench "debug" version that captures a lot more errors 2) you screen-share with me & i demonstrate the problem 3) i send you the results of mysqldump (minus the data) & you try it 4) we forget the whole thing and i use that er-model tool. fwiw, this has now happened on a couple different computers.
[11 Nov 2021 17:42]
mark edwards
no replies - so i am going to assume this will not be fixed anytime soon. fwiw, i tried to reload the db WITHOUT any data, then DROPPED each table individually, yet even with an empty DB (no data no tables) it still happened. so my idea of uploading up a mysqldump file proving the problem is obviously not going to work. and removing/reinstall did not help either. this all started when workbench started enforcing the SSL rule.
[11 Nov 2021 17:51]
mark edwards
i still think the workbench developers should send me some sort of special diagnostic version that has more comprehensive error trapping.
[11 Nov 2021 18:58]
mark edwards
ok i figured out what i was doing wrong - i was selecting Database-->connectToDatabase rather than Database-->reverseEngineer. HOWEVER, it still seems odd that this would crash workbench.
Description: 07:40:05 [ERR][ Workbench]: Console redirection failed. 07:40:05 [INF][ Workbench]: Starting up Workbench 07:40:05 [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: 173961890 UserInteractive: True Version: 4.0.30319.42000 WorkingSet: 41975808 07:40:05 [INF][ Workbench]: Environment variables: COMPUTERNAME = LAPTOP-7V576VAK USERPROFILE = C:\Users\Mark HOMEPATH = \Users\Mark LOCALAPPDATA = C:\Users\Mark\AppData\Local PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules PROCESSOR_ARCHITECTURE = AMD64 Path = C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\PuTTY\;C:\Users\Mark\AppData\Local\Microsoft\WindowsApps; CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files ProgramFiles(x86) = C:\Program Files (x86) PROCESSOR_LEVEL = 23 LOGONSERVER = \\LAPTOP-7V576VAK 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\Mark\AppData\Roaming PROCESSOR_REVISION = 6001 USERNAME = Mark CommonProgramW6432 = C:\Program Files\Common Files TEMP = C:\Users\Mark\AppData\Local\Temp OneDrive = C:\Users\Mark\OneDrive CommonProgramFiles = C:\Program Files\Common Files OS = Windows_NT USERDOMAIN_ROAMINGPROFILE = LAPTOP-7V576VAK PROCESSOR_IDENTIFIER = AMD64 Family 23 Model 96 Stepping 1, AuthenticAMD ComSpec = C:\WINDOWS\system32\cmd.exe SystemDrive = C: FPS_BROWSER_USER_PROFILE_STRING = Default ProgramFiles = C:\Program Files NUMBER_OF_PROCESSORS = 6 TMP = C:\Users\Mark\AppData\Local\Temp ProgramData = C:\ProgramData ProgramW6432 = C:\Program Files windir = C:\WINDOWS USERDOMAIN = LAPTOP-7V576VAK PUBLIC = C:\Users\Public 07:40:05 [INF][ Workbench]: Current version given by meta info is: 8.0.27 07:40:05 [INF][ Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\PuTTY\;C:\Users\Mark\AppData\Local\Microsoft\WindowsApps; 07:40:05 [INF][ mforms managed]: Initializing mforms wrapper 07:40:05 [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\Mark\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 07:40:05 [INF][ WBContext]: WbContext::init 07:40:06 [INF][ WBA]: Looking for extension modules for WBA... 07:40:06 [INF][ WBA]: 0 extension modules found 07:40:06 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils). 07:40:06 [WRN][ grt]: C:\Users\Mark\AppData\Roaming\MySQL\Workbench\connections.xml:25: link '{BC1306D2-C5A7-4D93-92B5-F0B9F473D2A9}' <object GrtObject> key=owner could not be resolved 07:40:06 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils). 07:40:06 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 8.0.27 CE build 1228725 (64 bit) Configuration Directory: C:\Users\Mark\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE Cairo Version: 1.17.4 OS: Microsoft Windows 10 Home CPU: 6x AMD Ryzen 5 4500U with Radeon Graphics , 7.4 GiB RAM Active video adapter AMD Radeon(TM) Graphics Installed video RAM: 512 MB Current video mode: 1920 x 1080 x 4294967296 colors Used bit depth: 32 Driver version: 27.20.21020.3 Installed display drivers: C:\WINDOWS\System32\DriverStore\FileRepository\u0368330.inf_amd64_2a773f4c46cdd019\B367597\aticfx64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\u0368330.inf_amd64_2a773f4c46cdd019\B367597\aticfx64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\u0368330.inf_amd64_2a773f4c46cdd019\B367597\aticfx64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\u0368330.inf_amd64_2a773f4c46cdd019\B367597\amdxc64.dll Current user language: English (United States) 07:40:06 [INF][ WQE backend]: Found auto-save workspace C:\Users\Mark\AppData\Roaming\MySQL\Workbench\sql_workspaces\kvm289-1.autosave 07:40:06 [INF][ Workbench]: UI is up 07:40:06 [INF][ Workbench]: Running the application How to repeat: click model click the "database" tab click "connect to database" (database is already accessable under "scmema" click the "OK" button mysql-workbench just disappears.