Upstream issue: MySQL 8.0.38-39 does not start (Segmentation Fault)

Symptoms

MySQL has released an update to 8.0.38-39, which fails to start.

2024-06-30T20:01:02.824793Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-30T20:01:04.845922Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-30T20:01:06Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

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...

Description 

MySQL 8.0.38 and 8.0.39 were released upstream. After automatic updates, there are multiple reports that MySQL is not starting.

Workaround

RHEL-based servers

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Downgrade to the previous subversion of MySQL 8.
   • CentOS 7, CloudLinux 7

     yum downgrade mysql-community-*

   • CloudLinux 7 with MySQL Governor

     yum downgrade cl-MySQL*

   • AlmaLinux 8/9, CloudLinux 8/9, Rocky Linux 8/9

     dnf downgrade mysql-community-*

   • CloudLinux 8/9 with MySQL Governor

     dnf downgrade cl-MySQL*

Ubuntu servers

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Create a new "mysqldown" directory in the root folder and change into this directory.

   mkdir -v /root/mysqldown && cd /root/mysqldown

3. Download the following archive for the 8.0.37 version of MySQL.
   • Ubuntu 20.04

     wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_8.0.37-1ubuntu20.04_amd64.deb-bundle.tar

   • Ubuntu 22.04

     wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_8.0.37-1ubuntu22.04_amd64.deb-bundle.tar

4. Extract this archive.
   • Ubuntu 20.04

     tar xvf mysql-server_8.0.37-1ubuntu20.04_amd64.deb-bundle.tar

   • Ubuntu 22.04

     tar xvf mysql-server_8.0.37-1ubuntu22.04_amd64.deb-bundle.tar

5. Remove the following packages from the current directory.  The server does not require these, nor does it have the necessary dependencies.
   • Ubuntu 20.04

     rm -rvf ./mysql-community-test-debug_8.0.37-1ubuntu20.04_amd64.deb ./mysql-community-test_8.0.37-1ubuntu20.04_amd64.deb ./mysql-testsuite_8.0.37-1ubuntu20.04_amd64.deb

   • Ubuntu 22.04

     rm -rvf ./mysql-community-test-debug_8.0.37-1ubuntu22.04_amd64.deb ./mysql-community-test_8.0.37-1ubuntu22.04_amd64.deb ./mysql-testsuite_8.0.37-1ubuntu22.04_amd64.deb

6. Install all of the packages in the current directory.

   dpkg -i *mysql*.deb

7. Confirm that the MySQL service is now running.

   /scripts/restartsrv_mysql --status

Please note that you can version lock this to prevent the update from occurring again. However, we advise removing the lock once the upstream issue is resolved.

• RHEL-based servers

  yum versionlock mysql-community-server

• CloudLinux servers with MySQL Governor

  yum versionlock cl-MySQL80-server

• Ubuntu

  apt-mark hold mysql-client mysql-common mysql-community-client-core mysql-community-client-plugins mysql-community-client mysql-community-server-core mysql-community-server-debug mysql-community-server mysql-server mysql-shell