MySQL Crash dump on AlmaLinux
Posted by:
Sophal Lee
Date: November 22, 2023 08:58PM
I have sent SIGABRT to MySQL process but I am not getting the crash dump file. Server is AlmaLinux 8.8 (4.18.0-477.21.1.el8_8.x86_64 x86_64 x86_64) and MySQL version is 8.0.32.
Set the configuration as follows and restarted to no avail:
```
[mysqld]
core-file
[mysqld_safe]
core-file-size=unlimited
```
Set the core to unlimited
```
$ cat /proc/`pidof -s mysqld`/limits|egrep '(Limit|core)'
Limit Soft Limit Hard Limit Units
Max core file size unlimited unlimited bytes
```
I tried setting these values as below but it is not accepted and result in MySQL failing to boot up.
```
[mysqld]
core-file
core-file-size=unlimited
core-file-path=/home/crash/apps/
```
I tried setting the core dumps in systemd and restarted MySQL. Issue is still there.
```
LimitCORE=infinity
```
It works with gcore but I want to test it when I send SIGABRT to MySQL. MySQL failed last time with SIGABRT and I want to test dump is working as expected.
Subject
Written By
Posted
MySQL Crash dump on AlmaLinux
November 22, 2023 08:58PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.