Mariadb not starting at all
by kajlaajay from LinuxQuestions.org on (#4Y55B)
Please help me with this issue MariaDB not starting. Its a production server so not able to reinstall and clean the data at all.
(This command executed by me) systemctl -l status mariadb.service
a- mariadb.service - MariaDB 10.1.36 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
a""a"migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Mon 2020-01-20 10:58:08 IST; 3s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 8176 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 8165 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 8158 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 8176 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
2020-01-20 10:58:03 139801831975168 [ERROR] Plugin 'InnoDB' init function returned error.
2020-01-20 10:58:03 139801831975168 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-01-20 10:58:03 139801831975168 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-20 10:58:03 139801831975168 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-01-20 10:58:03 139801831975168 [ERROR] Aborting
Error in my_thread_global_end(): 1 threads didn't exit
mariadb.service: main process exited, code=exited, status=1/FAILURE
Failed to start MariaDB 10.1.36 database server.
Unit mariadb.service entered failed state.
mariadb.service failed.
(This command executed by me) systemctl -l status mariadb.service
a- mariadb.service - MariaDB 10.1.36 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
a""a"migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Mon 2020-01-20 10:58:08 IST; 3s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 8176 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 8165 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 8158 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 8176 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
2020-01-20 10:58:03 139801831975168 [ERROR] Plugin 'InnoDB' init function returned error.
2020-01-20 10:58:03 139801831975168 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-01-20 10:58:03 139801831975168 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-20 10:58:03 139801831975168 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-01-20 10:58:03 139801831975168 [ERROR] Aborting
Error in my_thread_global_end(): 1 threads didn't exit
mariadb.service: main process exited, code=exited, status=1/FAILURE
Failed to start MariaDB 10.1.36 database server.
Unit mariadb.service entered failed state.
mariadb.service failed.