MariaDB Cant Start Mariadb

Greetings everyone and @eva2000

Suddenly i cant start my MariaDB server and i get this error on systemctl status mariadb.service

Code:

● mariadb.service - MariaDB 10.3.23 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, openfileslimit.conf, protecthome.conf
   Active: failed (Result: exit-code) since Tue 2020-05-19 14:51:18 UTC; 21s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 4862 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 4581 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: 4577 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 4862 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

May 19 14:51:18 hostname.domain.com mysqld[4862]: 2020-05-19 14:51:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
May 19 14:51:18 hostname.domain.com mysqld[4862]: 2020-05-19 14:51:18 0 [ERROR] Plugin 'InnoDB' init function returned error.
May 19 14:51:18 hostname.domain.com mysqld[4862]: 2020-05-19 14:51:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGI...ailed.
May 19 14:51:18 hostname.domain.com mysqld[4862]: 2020-05-19 14:51:18 0 [Note] Plugin 'FEEDBACK' is disabled.
May 19 14:51:18 hostname.domain.com mysqld[4862]: 2020-05-19 14:51:18 0 [ERROR] Unknown/unsupported storage engine: InnoDB
May 19 14:51:18 hostname.domain.com mysqld[4862]: 2020-05-19 14:51:18 0 [ERROR] Aborting
May 19 14:51:18 hostname.domain.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
May 19 14:51:18 hostname.domain.com systemd[1]: Failed to start MariaDB 10.3.23 database server.
May 19 14:51:18 hostname.domain.com systemd[1]: Unit mariadb.service entered failed state.
May 19 14:51:18 hostname.domain.com systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

/var/mysqld.log is empty

Any help would be appreciated.

---

 

I searched on forums and mainly the fix is to delete these two

rm /var/lib/mysql/ib_logfile0 rm
/var/lib/mysql/ib_logfile1

I deleted them but still the same issue.

 

Sorry the issue has been fixed, i had to delete another file

rm /var/lib/mysql/ibdata1

 

But now i cant access my site,

And when i log in my Phpmyadmin i see the size = inuse Screenshot

 

I think the Innodb engine isnt started, because these are Innodb tables, any help please.

 

And when i click on the table it gives this error Screenshot