Bug #115979 MySQl crash under Windows / extensive memory usage
Submitted: 2 Sep 2024 7:40 Modified: 2 Sep 2024 13:09
Reporter: Espen Corneliussen Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:8.4.2 OS:Windows (Server 2022)
Assigned to: MySQL Verification Team CPU Architecture:x86

[2 Sep 2024 7:40] Espen Corneliussen
Description:
In a week the MySQL-service have crashed three times, without coming back up again. The server run for 12 days before the issue appared.

The error log tell me to "submit a detailed bug report", and that "Most likely, you have hit a bug", but I'm not sure. Here is MySQL the error log: https://pastebin.com/7M5qE6d3

The Windows Event log reports the following upon crash:

Application event:
Faulting application name: mysqld.exe, version: 8.4.2.0, time stamp: 0x6691bf39
Faulting module name: mysqld.exe, version: 8.4.2.0, time stamp: 0x6691bf39
Exception code: 0x80000003
Fault offset: 0x000000000108d762
Faulting process id: 0x3534
Faulting application start time: 0x01daf916f1677db1
Faulting application path: C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqld.exe
Faulting module path: C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqld.exe
Report Id: b73b5ee2-f41e-416d-a23a-93061ff970af
Faulting package full name: 
Faulting package-relative application ID: 

System event:
Windows successfully diagnosed a low virtual memory condition. The following programs consumed the most virtual memory: mysqld.exe (13620) consumed 15181479936 bytes, MsMpEng.exe (3812) consumed 304406528 bytes, and rdpclip.exe (3012) consumed 253304832 bytes.

Here's the content of the my.ini-file: https://pastebin.com/4bSbM5Vz

How to repeat:
Installed MySQL and believe I only changed innodb_buffer_pool_size=12G innodb_buffer_pool_instances=8
[2 Sep 2024 12:59] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Your server ran out of RAM
2024-08-26T13:25:31.123811Z 1172186 [ERROR] [MY-010934] [Server] Out of memory (Needed 75888 bytes)
2024-08-26T13:25:31.124104Z 1172195 [ERROR] [MY-010934] [Server] Out of memory (Needed 75888 bytes)

check your config to see if mysql is requesting more memory than you have.

Thank you for your interest in MySQL.
[2 Sep 2024 13:09] Espen Corneliussen
Hi.

Thanks for your answer.

I realise this is no place to ask for help, that's why I didn't. I'm aware MySQL-server reported "Out of memory", but the logs also show that it consumed about 14GB out of 24GB at that time. That's why I chose to let you know about the issue, and figure out for your self, if this was a bug you needed to look into.

Feel free to delete the report. Thanks.