[MDEV-24632] MariaDB 10.3.27 crash on windows Created: 2021-01-20 Updated: 2023-04-14 Resolved: 2023-04-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.3.27 |
| Fix Version/s: | 10.6.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | srinivas chandolu | Assignee: | Marko Mäkelä |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | Crash | ||
| Environment: |
Microsoft Windows Server 2016 Standard |
||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
MariaDB server is getting crash by throwing the following error in .err file. Attached the .err file, crash dump file, my.ini file and "show variables" output for reference. It would be great if the reason and also the probable fix for the issue has been provided.
|
| Comments |
| Comment by srinivas chandolu [ 2021-02-16 ] |
|
Hi Elena Stepanova, Just curious to know any update on the mentioned issue? As a note, noticed that the MariaDB crash is happening if it has been installed on VM with thin provisioned disk. Not noticed such crashes in prior versions. Any particular reason for this behavior? Please update your findings. Regards, |
| Comment by srinivas chandolu [ 2021-04-20 ] |
|
Hi Marko Mäkelä, Noticed that with MariaDB 10.3.28 few crash issues related to semaphore have been fixed. Upgraded the database from 10.3.27 to 10.3.28. Noticed that the crash is still happening. However prior to crash we have not noticed any query performance issues with 10.3.28. These db query performance issues have been noticed in 10.3.27. Regards, |
| Comment by srinivas chandolu [ 2021-06-10 ] |
|
Hi Marko Mäkelä, |
| Comment by srinivas chandolu [ 2021-06-18 ] |
|
Hi Marko Mäkelä, Is it possible to restart database automatically for such abrupt shutdowns by configuring database or using a database configuration parameter? If so from what version of database this feature is (will be if it is planned) available? Also, any update on the reason of failure on the raised semaphore issue? Regards, |
| Comment by Marko Mäkelä [ 2021-06-28 ] |
|
wlad, can you please check the .dmp files and comment on whether mysqld_safe like functionality is available on Microsoft Windows? |
| Comment by Vladislav Vaintroub [ 2021-06-29 ] |
|
It is possible to restart ay windows service, if it crashes. https://serverfault.com/questions/48600/how-can-i-automatically-restart-a-windows-service-if-it-crashes |
| Comment by Vladislav Vaintroub [ 2021-06-29 ] |
|
I can't load symbols using our official packages. I guess, this is something McAffee compiled themselves, and we'd need the mysqld.exe and mysqld.pdb to analyze |
| Comment by srinivas chandolu [ 2021-06-29 ] |
|
Hi Vladislav Vaintroub, Attached mysqld.exe and mysqld.pdb files of Version 10.3.28 for reference. Also as a note these binary files are downloaded from downloads.mariadb.org website (part of mariadb-10.3.28-winx64.zip) https://downloads.mariadb.org/mariadb/10.3.27/ |
| Comment by Vladislav Vaintroub [ 2021-06-30 ] |
|
marko, the stacks.txt schandol, I suggest to peruse the service configuration to automatically configure restarts on crash. Perhaps, we should be doing this by default, when installing service, if you feel it is a good idea, please comment on it. |
| Comment by Marko Mäkelä [ 2023-04-14 ] |
|
One of the threads in stacks.txt |