Skip to main content

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

Violet Browning
  • Updated

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

 

Additional resources

How to version lock RPM packages

Related articles