mysqld / MariaDB server is down. Got error when turn it on again. How to fix?

H

Horse

Verified User
Joined
Aug 23, 2020
Messages
11
System services screenshot :

System Services.jpg





Try click restart button, got this error message :
Failed to start service
Click to expand...




Try run this command on ssh, here is the result:
root@server1:~# service mysqld restart
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xeu mysqld.service" for details.
root@server1:~# ^C
root@server1:~# systemctl status mysqld.service
× mysqld.service - MySQL database server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; preset: enabled)
Active: failed (Result: exit-code) since Wed 2026-02-25 23:51:24 WIB; 44s ago
Process: 5712 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (cod>
Process: 5714 ExecStartPre=/bin/sh -c [ ! -e /usr/local/mysql/bin/galera_recovery ] && VAR= >
Process: 5733 ExecStart=/usr/local/mysql/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP>
Main PID: 5733 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 325ms

Feb 25 23:51:24 server1 mysqld[5733]: 2026-02-25 23:51:24 0 [ERROR] InnoDB: Plugin initializatio>
Feb 25 23:51:24 server1 mysqld[5733]: 2026-02-25 23:51:24 0 [Note] InnoDB: Starting shutdown...
Feb 25 23:51:24 server1 mysqld[5733]: 2026-02-25 23:51:24 0 [ERROR] Plugin 'InnoDB' registration>
Feb 25 23:51:24 server1 mysqld[5733]: 2026-02-25 23:51:24 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 25 23:51:24 server1 mysqld[5733]: 2026-02-25 23:51:24 0 [ERROR] Could not open mysql.plugin >
Feb 25 23:51:24 server1 mysqld[5733]: 2026-02-25 23:51:24 0 [ERROR] Failed to initialize plugins.
Feb 25 23:51:24 server1 mysqld[5733]: 2026-02-25 23:51:24 0 [ERROR] Aborting
Feb 25 23:51:24 server1 systemd[1]: mysqld.service: Main process exited, code=exited, status=1/F>
Feb 25 23:51:24 server1 systemd[1]: mysqld.service: Failed with result 'exit-code'.
Feb 25 23:51:24 server1 systemd[1]: Failed to start mysqld.service - MySQL database server.
lines 1-20/20 (END)
Click to expand...




Reads another similar threads, but no one works yet

OS : Ubuntu 24
Please help, let me know if you need other infos
 
Aar said:
What is this reporting?
journalctl -xeu mysqld.service
Click to expand...
I dont know
If anyone know, please share


Ohm J said:
Your disk is still safe ?

Look like some raids are broken.
Click to expand...
Its a vps, looks like its save

the other services is working, only mysqld / MariaDB that not working




Please help what can i do, like reinstall mysqld / MariaDB, or command to fix this
 
What is this reporting?
Bash: 
journalctl -xeu mysqld.service

We can only wait until you give us the correct answer. So, try entering that command.
 
LFD is broken too, then I'm sure something wrong with Disk.


For recovery process, required the disk space to copy old data, incase... something not correctly.

First thing, backup the directory before do any recovery process.
Code: 
stat /var/lib/mysql/
cp -rf /var/lib/mysql/ /root/mysql_backup/

check if backup is done.
Code: 
stat /root/mysql_backup



### Process to recovery

#remove any "ib_logfil"
Code: 
rm -f /var/lib/mysql/ib_logfile*

#try start again.
Code: 
systemctl start mysqld
systemctl status mysqld -l
 
Aar said:
What is this reporting?
Bash: 
journalctl -xeu mysqld.service

We can only wait until you give us the correct answer. So, try entering that command.
Click to expand...

Here is the result
root@server1:~# journalctl -xeu mysqld.service
Feb 26 16:23:21 server1 (mysqld)[7248]: mysqld.service: Referenced but unset environment variable evaluates to an empty stri>
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] Starting MariaDB 10.6.19-MariaDB source revision 8f020508>
Feb 26 16:23:21 server1 mysqld[7248]: Cannot find checkpoint record at LSN (1,0x9ffd5)
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on >
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Number of pools: 1
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Using Linux native AIO
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728,>
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=20766>
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] InnoDB: Tablespace 230 was not found at ./myusername_hb5>
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and t>
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] InnoDB: Plugin initialization aborted with error Tablesp>
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] InnoDB: Starting shutdown...
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engi>
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] Failed to initialize plugins.
Feb 26 16:23:21 server1 mysqld[7248]: 2026-02-26 16:23:21 0 [ERROR] Aborting
Feb 26 16:23:21 server1 systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ An ExecStart= process belonging to unit mysqld.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Feb 26 16:23:21 server1 systemd[1]: mysqld.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ The unit mysqld.service has entered the 'failed' state with result 'exit-code'.
Feb 26 16:23:21 server1 systemd[1]: Failed to start mysqld.service - MySQL database server.
░░ Subject: A start job for unit mysqld.service has failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ A start job for unit mysqld.service has finished with a failure.
░░
░░ The job identifier is 11058 and the job result is failed.
Click to expand...










Ohm J said:
LFD is broken too, then I'm sure something wrong with Disk.


For recovery process, required the disk space to copy old data, incase... something not correctly.

First thing, backup the directory before do any recovery process.
Code: 
stat /var/lib/mysql/
cp -rf /var/lib/mysql/ /root/mysql_backup/

check if backup is done.
Code: 
stat /root/mysql_backup



### Process to recovery

#remove any "ib_logfil"
Code: 
rm -f /var/lib/mysql/ib_logfile*

#try start again.
Code: 
systemctl start mysqld
systemctl status mysqld -l
Click to expand...

Here is the result

root@server1:~# rm -f /var/lib/mysql/ib_logfile*
root@server1:~# systemctl start mysqld
systemctl status mysqld -l
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xeu mysqld.service" for details.
× mysqld.service - MySQL database server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; preset: enabled)
Active: failed (Result: exit-code) since Thu 2026-02-26 16:29:34 WIB; 21ms ago
Process: 7879 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 7881 ExecStartPre=/bin/sh -c [ ! -e /usr/local/mysql/bin/galera_recovery ] && VAR= || VAR=`cd /usr/local/mysq>
Process: 7899 ExecStart=/usr/local/mysql/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION --datadir=/v>
Main PID: 7899 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 322ms

Feb 26 16:29:34 server1 mysqld[7899]: 2026-02-26 16:29:34 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Feb 26 16:29:34 server1 mysqld[7899]: 2026-02-26 16:29:34 0 [Note] InnoDB: 10.6.19 started; log sequence number 0; transacti>
Feb 26 16:29:34 server1 mysqld[7899]: 2026-02-26 16:29:34 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buf>
Feb 26 16:29:34 server1 mysqld[7899]: 2026-02-26 16:29:34 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 26 16:29:34 server1 mysqld[7899]: 2026-02-26 16:29:34 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engi>
Feb 26 16:29:34 server1 mysqld[7899]: 2026-02-26 16:29:34 0 [ERROR] Failed to initialize plugins.
Feb 26 16:29:34 server1 mysqld[7899]: 2026-02-26 16:29:34 0 [ERROR] Aborting
Feb 26 16:29:34 server1 systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Feb 26 16:29:34 server1 systemd[1]: mysqld.service: Failed with result 'exit-code'.
Feb 26 16:29:34 server1 systemd[1]: Failed to start mysqld.service - MySQL database server.
lines 1-20/20 (END)






root@server1:~# ^C
root@server1:~# systemctl status mysqld -l
× mysqld.service - MySQL database server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; preset: enabled)
Active: failed (Result: exit-code) since Thu 2026-02-26 16:41:24 WIB; 14s ago
Process: 8479 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 8482 ExecStartPre=/bin/sh -c [ ! -e /usr/local/mysql/bin/galera_recovery ] && VAR= || VAR=`cd /usr/local/mysq>
Process: 8499 ExecStart=/usr/local/mysql/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION --datadir=/v>
Main PID: 8499 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 277ms

Feb 26 16:41:23 server1 mysqld[8499]: 2026-02-26 16:41:23 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Feb 26 16:41:23 server1 mysqld[8499]: 2026-02-26 16:41:23 0 [Note] InnoDB: 10.6.19 started; log sequence number 147713533084>
Feb 26 16:41:23 server1 mysqld[8499]: 2026-02-26 16:41:23 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 26 16:41:23 server1 mysqld[8499]: 2026-02-26 16:41:23 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buf>
Feb 26 16:41:23 server1 mysqld[8499]: 2026-02-26 16:41:23 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engi>
Feb 26 16:41:23 server1 mysqld[8499]: 2026-02-26 16:41:23 0 [ERROR] Failed to initialize plugins.
Feb 26 16:41:23 server1 mysqld[8499]: 2026-02-26 16:41:23 0 [ERROR] Aborting
Feb 26 16:41:24 server1 systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Feb 26 16:41:24 server1 systemd[1]: mysqld.service: Failed with result 'exit-code'.
Feb 26 16:41:24 server1 systemd[1]: Failed to start mysqld.service - MySQL database server.
lines 1-20/20 (END)
Click to expand...





Let me know if there are other things i can try again
Last option, will just reinstall the Ubuntu OS & Directadmin again from scratch. I already made backup
 
Last edited:
Ok, thanks for more detail. I just found relate to the plugin "aria".

Last try,
Code: 
mv /var/lib/mysql/aria_log_control /var/lib/mysql/aria_log_control.orig
systemctl start mysqld
systemctl status mysqld -l
 
You must log in or register to reply here.
Back
Top