[MDEV-32835] MySQL Crash when rebooted the VM everything works fine Created: 2023-11-18 Updated: 2024-01-16 Resolved: 2024-01-16 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | N/A |
| Affects Version/s: | 10.11.6 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Muhammad Areeb Ali | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | crash, innodb, mariadb, repair, serverdown | ||
| Environment: |
Windows Server 2022 on proxmox VM 40gb RAM with AMD EPYCAMD EPYC™ 7502P 20 vCPU core |
||
| Description |
|
Dear Support Team, I trust this message finds you well. I am reaching out to bring your attention to a critical issue encountered with my dedicated MariaDB node this morning. The MariaDB server unexpectedly ceased operations, resulting in a complete server shutdown. Upon inspection, the logs revealed the following error: 231118 8:30:25 [ERROR] mysqld got exception 0xc0000005; To restore this, I promptly restarted the VM. However, after the complete reboot of my vm everything works fine now. Here are pertinent details about the environment: Server Version: MariaDB 10.11.5
Given the nature of the error message and the recent forced VM stop, I am seeking your guidance on how to prevent this issue from reoccurring and ensure the stability of our MariaDB instance. Thank you for your prompt attention to this matter. I look forward to your assistance in resolving this critical issue. |
| Comments |
| Comment by Daniel Black [ 2023-11-19 ] |
|
Can you include the full backtrace of information and some information around the queries? Can you install the debug symbols - https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/#installing-debugging-symbols-with-the-zip-package-on-windows. Why did you make this block |
| Comment by Vladislav Vaintroub [ 2023-11-19 ] |
|
danblack, the debug symbols for the server(only) are also part of normal package. The crashing thread backtrace is usually good quality, perhaps Areeb can attach the error log. If mariadb.dmp or mysqld.dmp was produced in the data directory, you can attach it as well, it can be analyzed here. |
| Comment by Daniel Black [ 2023-11-23 ] |
|
Areeb please provide the full error log and we might be able to correct this. There isn't sufficient information here to even guess as to what might be the cause. |