Server Good Life ComeBack offers a 50% discount on all hosting packages.Coupon Code

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

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

  • Thursday, 12th September, 2024
  • 12:17pm

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
Back