[SOLVED] Failed to start MariaDB

noreset · 2020-10-14 15:42:28

Hi everyone,

I have some problem figuring out why MariaDB doens't start, looking around on the net I did read that it was a storage space issue, though, even if I moved a lot of stuff the error still appears. Here is the status of mariadb.service

systemctl status mariadb.service 
● mariadb.service - MariaDB 10.5.6 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Wed 2020-10-14 17:35:06 CEST; 17s ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 1454 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 1455 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && sy>
    Process: 1464 ExecStart=/usr/bin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 1464 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"

Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.>
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [Note] InnoDB: Starting shutdown...
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Aborting
Oct 14 17:35:06 argon systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 14 17:35:06 argon systemd[1]: mariadb.service: Failed with result 'exit-code'.
Oct 14 17:35:06 argon systemd[1]: Failed to start MariaDB 10.5.6 database server.

Journal entries

journalctl -xe | grep mariadb
Oct 14 17:31:12 argon mariadbd[506]: 2020-10-14 17:31:12 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Oct 14 17:31:12 argon mariadbd[506]: 2020-10-14 17:31:12 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 14 17:31:12 argon mariadbd[506]: 2020-10-14 17:31:12 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Oct 14 17:31:12 argon mariadbd[506]: 2020-10-14 17:31:12 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.6.
Oct 14 17:31:12 argon mariadbd[506]: 2020-10-14 17:31:12 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Oct 14 17:31:12 argon mariadbd[506]: 2020-10-14 17:31:12 0 [Note] InnoDB: Starting shutdown...
Oct 14 17:31:13 argon mariadbd[506]: 2020-10-14 17:31:13 0 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 14 17:31:13 argon mariadbd[506]: 2020-10-14 17:31:13 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 14 17:31:13 argon mariadbd[506]: 2020-10-14 17:31:13 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 14 17:31:13 argon mariadbd[506]: 2020-10-14 17:31:13 0 [ERROR] Aborting
Oct 14 17:31:13 argon systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ An ExecStart= process belonging to unit mariadb.service has exited.
Oct 14 17:31:13 argon systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
░░ Subject: A start job for unit mariadb.service has failed
░░ A start job for unit mariadb.service has finished with a failure.
Oct 14 17:31:13 argon audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed'
Oct 14 17:35:05 argon polkitd[540]: Operator of unix-session:3 successfully authenticated as unix-user:zero to gain TEMPORARY authorization for action org.freedesktop.systemd1.manage-units for system-bus-name::1.93 [systemctl restart mariadb.service] (owned by unix-user:zero)
░░ Subject: A start job for unit mariadb.service has begun execution
░░ A start job for unit mariadb.service has begun execution.
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] /usr/bin/mariadbd (mysqld 10.5.6-MariaDB) starting as process 1464 ...
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32186)
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] InnoDB: Using Linux native AIO
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] InnoDB: Uses event mutexes
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] InnoDB: Number of pools: 1
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
Oct 14 17:35:05 argon mariadbd[1464]: 2020-10-14 17:35:05 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.6.
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [Note] InnoDB: Starting shutdown...
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 14 17:35:06 argon mariadbd[1464]: 2020-10-14 17:35:06 0 [ERROR] Aborting
Oct 14 17:35:06 argon systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ An ExecStart= process belonging to unit mariadb.service has exited.
Oct 14 17:35:06 argon systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
░░ Subject: A start job for unit mariadb.service has failed
░░ A start job for unit mariadb.service has finished with a failure.
Oct 14 17:35:06 argon audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed'
Oct 14 17:35:06 argon kernel: audit: type=1130 audit(1602689706.617:142): pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed'

Last edited by noreset (2020-10-15 18:30:43)

dakota · 2020-10-14 18:04:44

mariadb.service - MariaDB 10.5.6 database server

Oct 14 17:31:12 argon mariadbd[506]: 2020-10-14 17:31:12 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.6.

edit: Arch Wiki => MariaDB

Last edited by dakota (2020-10-15 15:40:53)

Arch Linux

#1 2020-10-14 15:42:28

[SOLVED] Failed to start MariaDB

#2 2020-10-14 18:04:44

Re: [SOLVED] Failed to start MariaDB

Board footer