MySQL released an update which started to fail
2024-07-02T14:19:49.913510Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-02T14:19:50.799335Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-02T14:19:50Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=539914406f129270c6bd39a48640d0f1eeecc1af
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x213f031]
/usr/sbin/mysqld(print_fatal_signal(int)+0x397) [0xffa557]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xffa615]
/lib64/libpthread.so.0(+0x12d20) [0x7faa359afd20]
/usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x909) [0x218ddb9]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, std::function<void (__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)>, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, /lib64/libstdc++.so.6(+0xc2b23) [0x7faa34730b23]
/lib64/libpthread.so.0(+0x81ca) [0x7faa359a51ca]
/lib64/libc.so.6(clone+0x43) [0x7faa33d378d3]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
So to fix this we have to downgrade the mysql.
Solution:
Our operating system is Almalinux 8. So we will downgrade the mysql to previous sub-version
yum downgrade mysql-community-*But our system has auto-update enabled. So we will also lock the MySQL to version 8.0.37
dnf install python3-dnf-plugin-versionlock
yum versionlock mysql-community-server
yum versionlock mysql-community-libs
yum versionlock mysql-community-client
yum versionlock mysql-community-common
yum versionlock mysql-community-icu-data
yum versionlock mysql-community-icu-data-files
yum versionlock mysql-community-devel
yum versionlock mysql-community-client-plugins
yum versionlock mysql-community-common