MySql workbench is crashing

After creating a basic table the application crashed while running a select query.

Translated Report (Full Report Below)

Process:               MySQLWorkbench [1687]

Path:                  /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench

Identifier:            com.oracle.workbench.MySQLWorkbench

Version:               8.0.32.CE (1)

Code Type:             X86-64 (Translated)

Parent Process:        launchd [1]

User ID:               501

Date/Time:             2023-02-02 11:58:46.6293 +0530

OS Version:            macOS 13.2 (22D49)

Report Version:        12

Anonymous UUID:        7B20408B-A4BE-478D-8402-4595E3D3D9C4

Time Awake Since Boot: 880 seconds

System Integrity Protection: enabled

Crashed Thread:        0  Dispatch queue: com.apple.main-thread

Exception Type:        EXC_BAD_INSTRUCTION (SIGILL)

Exception Codes:       0x0000000000000001, 0x0000000000000000

Termination Reason:    Namespace SIGNAL, Code 4 Illegal instruction: 4

Terminating Process:   exc handler [1687]

Application Specific Backtrace 0:

0   CoreFoundation                      0x00007ff8141d3cb3 __exceptionPreprocess + 242

1   libobjc.A.dylib                     0x00007ff813d2210a objc_exception_throw + 48

2   CoreFoundation                      0x00007ff81426abbe -[NSObject(NSObject) __retain_OA] + 0

3   CoreFoundation                      0x00007ff81413eab0 forwarding + 1324

4   CoreFoundation                      0x00007ff81413e4f8 _CF_forwarding_prep_0 + 120

5   WBExtras                            0x0000000109c371a1 -[MResultsetViewer tableView:willDisplayCell:forTableColumn:row:] + 393

6   AppKit                              0x00007ff81753282e -[NSTableView _delegateWillDisplayCell:forColumn:row:] + 104

7   AppKit                              0x00007ff817477676 -[NSTableView preparedCellAtColumn:row:] + 1835

8   MySQLWorkbench                      0x0000000100bdfa98 -[MGridView preparedCellAtColumn:row:] + 54

9   AppKit                              0x00007ff817476e41 -[NSTableView _drawContentsAtRow:column:withCellFrame:] + 42

10  AppKit                              0x00007ff817476ac1 -[NSTableView drawRow:clipRect:] + 1638

11  AppKit                              0x00007ff81747613c -[NSTableView drawRowIndexes:clipRect:] + 707

12  AppKit                              0x00007ff817401cc4 -[NSTableView drawRect:] + 1670

13  AppKit                              0x00007ff817334144 _NSViewDrawRect + 121

14  AppKit                              0x00007ff817b193c3 -[NSView _recursive:displayRectIgnoringOpacity:inContext:stopAtLayerBackedViews:] + 1810

15  AppKit                              0x00007ff817333870 -[NSView(NSLayerKitGlue) _drawViewBackingLayer:inContext:drawingHandler:] + 753

16  QuartzCore                          0x00007ff81c16db59 CABackingStoreUpdate_ + 254

17  QuartzCore                          0x00007ff81c1d13c1 ___ZN2CA5Layer8display_Ev_block_invoke + 53

18  QuartzCore                          0x00007ff81c16cd66 -[CALayer _display] + 2275

19  AppKit                              0x00007ff8173334c5 -[_NSBackingLayer display] + 462

20  AppKit                              0x00007ff8172ab455 -[_NSViewBackingLayer display] + 554

21  QuartzCore                          0x00007ff81c16bd08 _ZN2CA5Layer17display_if_neededEPNS_11TransactionE + 900

22  QuartzCore                          0x00007ff81c2e56c6 _ZN2CA7Context18commit_transactionEPNS_11TransactionEdPd + 648

23  QuartzCore                          0x00007ff81c14cb35 _ZN2CA11Transaction6commitEv + 725

24  AppKit                              0x00007ff81734496f __62+[CATransaction(NSCATransaction) NS_setFlushesWithDisplayLink]_block_invoke + 285

25  AppKit                              0x00007ff817b5c767 ___NSRunLoopObserverCreateWithHandler_block_invoke + 41

26  CoreFoundation                      0x00007ff81415b3e1 CFRUNLOOP_IS_CALLING_OUT_TO_AN_OBSERVER_CALLBACK_FUNCTION + 23

27  CoreFoundation                      0x00007ff81415b309 __CFRunLoopDoObservers + 482

28  CoreFoundation                      0x00007ff81415a866 __CFRunLoopRun + 877

29  CoreFoundation                      0x00007ff814159e7f CFRunLoopRunSpecific + 560

30  HIToolbox                           0x00007ff81dfec766 RunCurrentEventLoopInMode + 292

31  HIToolbox                           0x00007ff81dfec576 ReceiveNextEventCommon + 679

32  HIToolbox                           0x00007ff81dfec2b3 _BlockUntilNextEventMatchingListInModeWithFilter + 70

33  AppKit                              0x00007ff8171e5293 _DPSNextEvent + 909

34  AppKit                              0x00007ff8171e4114 -[NSApplication(NSEvent) _nextEventMatchingEventMask:untilDate:inMode:dequeue:] + 1219

35  AppKit                              0x00007ff8171d6757 -[NSApplication run] + 586

36  AppKit                              0x00007ff8171aa797 NSApplicationMain + 817

37  dyld                                0x0000000200ff6310 start + 2432

Kernel Triage:

VM - pmap_enter retried due to resource shortage

Thread 0 Crashed::  Dispatch queue: com.apple.main-thread

0   AppKit                            0x7ff81754dc26 -[NSApplication _crashOnException:] + 287

1   AppKit                            0x7ff817344bab __62+[CATransaction(NSCATransaction) NS_setFlushesWithDisplayLink]_block_invoke + 857

2   AppKit                            0x7ff817b5c767 ___NSRunLoopObserverCreateWithHandler_block_invoke + 41

3   CoreFoundation                    0x7ff81415b3e1 CFRUNLOOP_IS_CALLING_OUT_TO_AN_OBSERVER_CALLBACK_FUNCTION + 23

4   CoreFoundation                    0x7ff81415b309 __CFRunLoopDoObservers + 482

5   CoreFoundation                    0x7ff81415a866 __CFRunLoopRun + 877

6   CoreFoundation                    0x7ff814159e7f CFRunLoopRunSpecific + 560

7   HIToolbox                         0x7ff81dfec766 RunCurrentEventLoopInMode + 292

8   HIToolbox                         0x7ff81dfec576 ReceiveNextEventCommon + 679

9   HIToolbox                         0x7ff81dfec2b3 _BlockUntilNextEventMatchingListInModeWithFilter + 70

10  AppKit                            0x7ff8171e5293 _DPSNextEvent + 909

11  AppKit                            0x7ff8171e4114 -[NSApplication(NSEvent) _nextEventMatchingEventMask:untilDate:inMode:dequeue:] + 1219

12  AppKit                            0x7ff8171d6757 -[NSApplication run] + 586

13  AppKit                            0x7ff8171aa797 NSApplicationMain + 817

14  dyld                                 0x200ff6310 start + 2432

Thread 1:: com.apple.rosetta.exceptionserver 0   runtime                           0x7ff7ffc73614 0x7ff7ffc6f000 + 17940 1   runtime                           0x7ff7ffc7f530 0x7ff7ffc6f000 + 66864 2   runtime                           0x7ff7ffc80f30 0x7ff7ffc6f000 + 73520

Thread 2: 0   runtime                           0x7ff7ffc9187c 0x7ff7ffc6f000 + 141436

Post not yet marked as solved Up vote post of anshgupta Down vote post of anshgupta
20k views
Posted by
anshgupta
Reply

  • I just did the recommended rollback to 8.0.31 and mine stopped crashing.

    —
    teewizzle179

  • february 2024 and they haven't fixed the bug :'(

    —
    GreciaCC
Add a Comment

Replies

MySql workbench is crashing

Is this an app you’re developing?

Share and Enjoy
—
Quinn “The Eskimo!” @ Developer Technical Support @ Apple
let myEmail = "eskimo" + "1" + "@" + "apple.com"

Posted by
eskimo
Post not yet marked as solved Up vote reply of eskimo Down vote reply of eskimo
Add a Comment

Mine is doing the same thing. Would love to know the answer on how to fix this.

Posted by
AmberQuinci
Up vote reply of AmberQuinci Down vote reply of AmberQuinci
Add a Comment

Found a temporary fix on reddit which is to bump back to version 8.0.31: https://downloads.mysql.com/archives/workbench/ But I'm hopeful this bug will be fixed soon, I always prefer running the latest version of any software.

Posted by
aquabluewater
Post not yet marked as solved Up vote reply of aquabluewater Down vote reply of aquabluewater

  • Same issue. This worked for me

    —
    montellmuturi

  • After googling the issue, this thread was the first thing I clicked on, and you made it worth my while. Thank you!

    —
    StardustForeverAtLE

  • I would like to say thank you as well because I was wondering why Workbench kept crashing. I downloaded the 8.0.31 and now it works. When would we know when this bug is fixed so that we can download the latest version?

    —
    meeka

Thank you for this information. I'm new to SQL and it took me quite awhile to figure out what to do to move forward.

Posted by
Cheryl-Lynn
Up vote reply of Cheryl-Lynn Down vote reply of Cheryl-Lynn
Add a Comment

Bumping back to 8.0.31 fixed for me. If worth mentioning, am running 13.1 on an M1 Max.

Posted by
copyjosh
Post not yet marked as solved Up vote reply of copyjosh Down vote reply of copyjosh

  • Great, this worked for me. Thanks!

    —
    Stranger_RV

  • Running M1 with the same issue. This works.

    —
    emmaroland
Add a Comment

I've experienced the same. Simply trying to open a table's data view via one of the shortcut icons in the sidebar, crashes MySQL Workbench. I'm on Macbook Air M2, Macos 13.2.1

Downgrading MySQL Workbench to 8.0.31 works.

Posted by
Boogey1
Post not yet marked as solved Up vote reply of Boogey1 Down vote reply of Boogey1

  • Same

    —
    rmkeene

  • I am facing same issue too.

    —
    Rubab_Azim

  • same Air M2, using Sonoma, but i still cant solve it with 8.0.31

    —
    justsofia
Add a Comment

Downgrade to 8.0.31: https://downloads.mysql.com/archives/workbench/

Posted by
miglcesp
Post not yet marked as solved Up vote reply of miglcesp Down vote reply of miglcesp
Add a Comment

Same issue here, select query instantly crashes workbench.

Posted by
Alex_Pena
Up vote reply of Alex_Pena Down vote reply of Alex_Pena
Add a Comment

Great!! Thanks for this Post. I downgrade to v.8.0.31, This work for me I use Mac Air M1 Ventura.

Posted by
ptucky
Post not yet marked as solved Up vote reply of ptucky Down vote reply of ptucky
Add a Comment

I AM SO CONFUSED... SOMEONE HELP!

You're all saying you've downgraded to version 8.0.31... yet there isn't any newer version available on the site. The latest version is the one you're all referring too... so how could you possibly have downgraded from a newer version when it doesn't exist?

Posted by
M-Birk
Up vote reply of M-Birk Down vote reply of M-Birk

  • M-Birk, the Latest version of MySQL Workbench is 8.0.32, so 8.0.31 would be downgrading it. M.0ake sure you're downloading workbench 8.0.31 and not 8.0.32

    —
    SoPy

  • you must be in the Archives page, that's why you're seeing 8.0.31 as the latest version. go here to see 8.0.32 https://dev.mysql.com/downloads/workbench/ click Archives to choose 8.0.31.

    —
    fullstack_spiderman
Add a Comment

I downgraded to v.8.0.31 as well, but MySQL Workbench is still crashing when I try to run SELECT command for an imported table. Anyone else having this problem?

Posted by
Ty_Humphrey
Up vote reply of Ty_Humphrey Down vote reply of Ty_Humphrey

  • It's not crashing but the results pane disappears every time I execute a query. Can bring it back with EXPLAIN but that's kinda annoying.

    —
    macsofjupiter
Add a Comment

Yes, I face this problem with MySQL Workbench version 8.0.32. However, downgrading it to 8.0.31 works. https://downloads.mysql.com/archives/workbench/

Posted by
fullstack_spiderman
Up vote reply of fullstack_spiderman Down vote reply of fullstack_spiderman
Add a Comment

As per the suggestions above, I was facing the same issue for Workbench version 8.0.32. Downgrading to the previous version 8.0.31 did the trick for me. I'm using an M1 macbook pro, MacOS version 13.2.1

Posted by
eezhar
Up vote reply of eezhar Down vote reply of eezhar
Add a Comment

The issue is still ongoing, I downgraded to version 8.0.32 and it fixed the crash issue. I'm on M1 chip

Posted by
rajatm3hta
Post not yet marked as solved Up vote reply of rajatm3hta Down vote reply of rajatm3hta
Add a Comment

Same issue here. I had to downgrade to the version to 8.0.31

Posted by
fernando_silvasc
Post not yet marked as solved Up vote reply of fernando_silvasc Down vote reply of fernando_silvasc

  • Thanks for creating a post here, and helping with a workaround, 8.0.31 is working with Mac OS - Ventura - 13.3.1 (22E261)

    —
    pvssvikas
Add a Comment