[MDEV-30990] MariaDB crashes automatically After Some days Created: 2023-04-03  Updated: 2023-06-02  Resolved: 2023-06-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3.14
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Shubham Nanaware Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Windows Server 2016 Standard, 64 bit, 32GB Ram


Attachments: File ErrorFile.rar    

 Description   

After some days. MySQL service get stopped because of crash.



 Comments   
Comment by Marko Mäkelä [ 2023-04-03 ]

ErrorFile.rar contains a text file that contains the following stack trace of a crashing thread:

mariadb-10.3.14

mysqld.exe!std::locale::_Init()[locale0.cpp:162]
mysqld.exe!std::basic_ios<char,std::char_traits<char> >::init()[ios:164]
mysqld.exe!std::basic_ostringstream<char,std::char_traits<char>,std::allocator<char> >::basic_ostringstream<char,std::char_traits<char>,std::allocator<char> >()[sstream:568]
mysqld.exe!sync_array_print_long_waits_low()[sync0arr.cc:1006]
mysqld.exe!sync_array_print_long_waits()[sync0arr.cc:1073]
mysqld.exe!srv_error_monitor_thread()[srv0srv.cc:1814]

Without a .dmp file of the crash, it is hard to tell what exactly is wrong. There are some preceding messages that indicate that something is holding dict_operation_lock for more than 6 minutes.

Comment by Shubham Nanaware [ 2023-04-03 ]

Let me know where I can find .dmp file or How I can find out what is holding dict_operation_lock.

Also as I checked, I am unable to find above mentioned lines in given file.

Comment by Elena Stepanova [ 2023-05-02 ]

You'll need to run MariaDB server with core-file option. The minidump should be created in the datadir.
See https://mariadb.com/kb/en/enabling-core-dumps/#minidump-files-on-windows for more information.

Generated at Thu Feb 08 10:20:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.