mariadb fails to start Topic is solved

Having issues with your DietPi installation or found a bug? Post it here.
Post Reply
RollingDutch
Posts: 3
Joined: Thu Mar 18, 2021 9:08 am

mariadb fails to start

Post by RollingDutch »

Don't know if this is the same problem, but all of a sudden MaraDB isn't working anymore.

Code: Select all

 mariadb.service - MariaDB 10.3.27 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/

Mar 19 23:09:41 DietPi systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Mar 19 23:09:41 DietPi systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 44.
Mar 19 23:09:41 DietPi systemd[1]: Stopped MariaDB 10.3.27 database server.
Mar 19 23:09:41 DietPi systemd[1]: Starting MariaDB 10.3.27 database server...
Mar 19 23:09:42 DietPi mysqld[14479]: 2021-03-19 23:09:42 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) s
tarting as process 14479 ...
Mar 19 23:09:42 DietPi mysqld[14479]: 2021-03-19 23:09:42 0 [Warning] Could not increase number of max_open_files to mor
e than 16384 (request: 32186)
Mar 19 23:09:42 DietPi systemd[1]: mariadb.service: Main process exited, code=killed, status=6/A
BRT
Mar 19 23:09:42 DietPi systemd[1]: mariadb.service: Failed with result 'signal'.
Mar 19 23:09:42 DietPi systemd[1]: Failed to start MariaDB 10.3.27 database server.
Mar 19 23:09:43 DietPi systemd[1]: Stopped MariaDB 10.3.27 database server.
root@DietPi:~# systemctl start mariadb
Job for mariadb.service failed because a fatal signal was delivered to the control process.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@DietPi:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.27 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
   Active: activating (auto-restart) (Result: signal) since Fri 2021-03-19 23:10:15 CET; 4s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 14743 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS
)
  Process: 14744 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCES
S)
  Process: 14746 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/ga
lera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/
SUCCESS)
  Process: 14802 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed
, signal=ABRT)
 Main PID: 14802 (code=killed, signal=ABRT)
User avatar
MichaIng
Site Admin
Posts: 2783
Joined: Sat Nov 18, 2017 6:21 pm

Re: mariadb fails to start

Post by MichaIng »

Please show the error log:

Code: Select all

cat /var/log/mysql/error.log
If it's empty, try again to start the service to create a fresh error log.
User avatar
Joulinar
Posts: 4249
Joined: Sat Nov 16, 2019 12:49 am

Re: mariadb fails to start

Post by Joulinar »

I split the topic into it's own one as usually there are different challenges. Let's check the entire stack

Code: Select all

systemctl restart mariadb.service
journalctl -u mariadb
cat /var/log/mysql/error.log
readlink /var/lib/mysql
readlink -f /var/lib/mysql
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
RollingDutch
Posts: 3
Joined: Thu Mar 18, 2021 9:08 am

Re: mariadb fails to start

Post by RollingDutch »

Atm this is obsulete now, since the Pi did die on me :(
User avatar
Joulinar
Posts: 4249
Joined: Sat Nov 16, 2019 12:49 am

Re: mariadb fails to start

Post by Joulinar »

means the physical device is dead completely? Sorry for that.
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
Post Reply