[MDEV-31368] Failed to start MariaDB 10.5.20 database server Created: 2023-05-30  Updated: 2023-06-20  Resolved: 2023-06-20

Status: Closed
Project: MariaDB Server
Component/s: Time zones
Affects Version/s: 10.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Hasan Assignee: Sergei Golubchik
Resolution: Won't Fix Votes: 0
Labels: 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



 Comments   
Comment by Sergei Golubchik [ 2023-06-20 ]

2023-05-30 14:45:22 0 [ERROR] Fatal error: Error while loading mysql.time_zone_leap_second table

This suggests the table mysql.time_zone_leap_second is somehow corrupted. Remove it (or move out of datadir) and try again. May be safer would be to remove all time_zone tables, start the server and load time zone data again from scratch.

Generated at Thu Feb 08 10:23:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.