Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31368

Failed to start MariaDB 10.5.20 database server

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.5
    • N/A
    • Time zones
    • None

    Description

      Hi, I am getting below error after upgrading mysql yo MariaDB

      mariadb.service - MariaDB 10.5.20 database server
         Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
        Drop-In: /etc/systemd/system/mariadb.service.d
                 └─migrated-from-my.cnf-settings.conf
         Active: failed (Result: exit-code) since Tue 2023-05-30 14:45:22 IST; 1min 6s ago
           Docs: man:mariadbd(8)
                 https://mariadb.com/kb/en/library/systemd/
        Process: 2649 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
        Process: 2639 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
        Process: 2635 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
       Main PID: 2649 (code=exited, status=1/FAILURE)
         Status: "MariaDB server is down"
       
      May 30 14:45:22 e2e-66-42 mariadbd[2649]: 2023-05-30 14:45:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      May 30 14:45:22 e2e-66-42 mariadbd[2649]: 2023-05-30 14:45:22 0 [Note] Plugin 'FEEDBACK' is disabled.
      May 30 14:45:22 e2e-66-42 mariadbd[2649]: 2023-05-30 14:45:22 0 [Note] Server socket created on IP: '::'.
      May 30 14:45:22 e2e-66-42 mariadbd[2649]: 2023-05-30 14:45:22 0 [Note] InnoDB: Buffer pool(s) load completed at 230530 14:45:22
      May 30 14:45:22 e2e-66-42 mariadbd[2649]: 2023-05-30 14:45:22 0 [ERROR] Fatal error: Error while loading mysql.time_zone_leap_second table
      May 30 14:45:22 e2e-66-42 mariadbd[2649]: 2023-05-30 14:45:22 0 [ERROR] Aborting
      May 30 14:45:22 e2e-66-42 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
      May 30 14:45:22 e2e-66-42 systemd[1]: Failed to start MariaDB 10.5.20 database server.
      May 30 14:45:22 e2e-66-42 systemd[1]: Unit mariadb.service entered failed state.
      May 30 14:45:22 e2e-66-42 systemd[1]: mariadb.service failed
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            arshi4you Hasan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.