Bug #110240 MySQL keeps crashing after SELECT query
Submitted: 28 Feb 2023 20:34 Modified: 1 Mar 2023 19:40
Reporter: R Kilmartin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.32 OS:MacOS
Assigned to: CPU Architecture:ARM
Tags: crash on query

[28 Feb 2023 20:34] R Kilmartin
Description:
I downloaded MySQL yesterday, creating a new schema and added a database of tables. All was going well until I went to run in my first SELECT query and it crashes. 

I have tried uninstalling, installing, reinstalling, downgrading to archived versions of MySQL and it keeps happening. It is incredibly frustrating and I'm at a complete loss as to what to do. I am completely unable to use MySQL at the moment so need this sorted. 

-------------------------------------
Translated Report (Full Report Below)
-------------------------------------

Process:               MySQLWorkbench [15584]
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-28 19:59:08.7518 +0000
OS Version:            macOS 13.2.1 (22D68)
Report Version:        12
Anonymous UUID:        DD37A2CF-2CA8-A1BD-36AA-0615A24EA9B1

Sleep/Wake UUID:       7AF270F3-E57F-484C-B70B-8F4771F4905E

Time Awake Since Boot: 12000 seconds
Time Since Wake:       1521 seconds

System Integrity Protection: enabled

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

Exception Type:        EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:       KERN_INVALID_ADDRESS at 0x0000000000000001
Exception Codes:       0x0000000000000001, 0x0000000000000001

Termination Reason:    Namespace SIGNAL, Code 11 Segmentation fault: 11
Terminating Process:   exc handler [15584]

VM Region Info: 0x1 is not in any region.  Bytes before following region: 140723115311103
      REGION TYPE                    START - END         [ VSIZE] PRT/MAX SHRMOD  REGION DETAIL
      UNUSED SPACE AT START
--->  
      mapped file              7ffca74cc000-7ffcb1f98000 [170.8M] r-x/r-x SM=COW  ...t_id=fb11b40b

Kernel Triage:
VM - pmap_enter retried due to resource shortage

How to repeat:
Open MySQL Workbench, click on schema and type query:

SELECT * FROM [TABLE]

MySQL Workbench crashes.
[1 Mar 2023 11:47] MySQL Verification Team
Hello Kilmartin,

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

Regards,
Ashwini Patil
[1 Mar 2023 19:40] R Kilmartin
The suggested fix for Bug #109671 seems to be to download 8.0.31 which I have done and the bug is still occurring so I still have no solution from referring to that bug report. That one seems to only be affecting 8.0.32, mine seems to be affecting all versions of MySQL.