MariaDB service not starting on owncloud Topic is solved

Having issues with your DietPi installation or found a bug? Post it here.
Post Reply
Fabio
Posts: 38
Joined: Fri Dec 18, 2020 2:43 pm

MariaDB service not starting on owncloud

Post by Fabio »

Hello all!
my MariaDB service is not working anymore...
I don't know why, this is my best christmas present...
Here i copy my log:

Code: Select all

● mariadb.service - MariaDB 10.3.27 database server                                                                  │
   │    Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)                            │
   │    Active: failed (Result: exit-code) since Sat 2020-12-26 17:51:49 GMT; 10min ago                                   │
   │      Docs: man:mysqld(8)                                                                                             │
   │            https://mariadb.com/kb/en/library/systemd/                                                                │
   │   Process: 485 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited,                │
   │ status=0/SUCCESS)                                                                                                    │
   │   Process: 486 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited,               │
   │ status=0/SUCCESS)                                                                                                    │
   │   Process: 490 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: 551 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited,      │
   │ status=1/FAILURE)                                                                                                    │
   │  Main PID: 551 (code=exited, status=1/FAILURE)                                                                       │
   │    Status: "MariaDB server is down"                                                                                  │
   │                                                                                                                      │
   │ Dec 26 17:46:34 DietPi systemd[1]: Starting MariaDB 10.3.27 database server...                                       │
   │ Dec 26 17:47:18 DietPi mysqld[551]: 2020-12-26 17:47:18 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) │
   │ starting as process 551 ...                                                                                          │
   │ Dec 26 17:47:18 DietPi mysqld[551]: 2020-12-26 17:47:18 0 [Warning] Could not increase number of max_open_files to   │
   │ more than 16384 (request: 32186)                                                                                     │
   │ Dec 26 17:50:18 DietPi mysqld[551]: 2020-12-26 17:50:18 0 [Warning] Can't create test file                           │
   │ /var/lib/mysql/DietPi.lower-test                                                                                     │
   │ Dec 26 17:51:49 DietPi mysqld[551]: [87B blob data]                                                                  │
   │ Dec 26 17:51:49 DietPi mysqld[551]: 2020-12-26 17:51:49 0 [ERROR] Aborting                                           │
   │ Dec 26 17:51:49 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE               │
   │ Dec 26 17:51:49 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.                                  │
   │ Dec 26 17:51:49 DietPi systemd[1]: Failed to start MariaDB 10.3.27 database server. 
Someone is able to tell me what to do?
Thanks in advance!
User avatar
Joulinar
Posts: 4170
Joined: Sat Nov 16, 2019 12:49 am

Re: MariaDB service not starting on owncloud

Post by Joulinar »

Hi,

many thanks for your message. Pls can you post following

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
Fabio
Posts: 38
Joined: Fri Dec 18, 2020 2:43 pm

Re: MariaDB service not starting on owncloud

Post by Fabio »

At the command

Code: Select all

systemctl restart mariadb.service
The system remains stuck and does nothing more.
Fabio
Posts: 38
Joined: Fri Dec 18, 2020 2:43 pm

Re: MariaDB service not starting on owncloud

Post by Fabio »

journalctl -u mariadb

Code: Select all

root@DietPi:~# journalctl -u mariadb
-- Logs begin at Sat 2020-12-26 17:45:34 GMT, end at Sat 2020-12-26 22:39:03 GMT
. --
Dec 26 17:46:34 DietPi systemd[1]: Starting MariaDB 10.3.27 database server...
Dec 26 17:47:18 DietPi mysqld[551]: 2020-12-26 17:47:18 0 [Note] /usr/sbin/mysql
d (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 551 ...
Dec 26 17:47:18 DietPi mysqld[551]: 2020-12-26 17:47:18 0 [Warning] Could not in
crease number of max_open_files to more than 16384 (request: 32186)
Dec 26 17:50:18 DietPi mysqld[551]: 2020-12-26 17:50:18 0 [Warning] Can't create
 test file /var/lib/mysql/DietPi.lower-test
Dec 26 17:51:49 DietPi mysqld[551]: [87B blob data]
Dec 26 17:51:49 DietPi mysqld[551]: 2020-12-26 17:51:49 0 [ERROR] Aborting
Dec 26 17:51:49 DietPi systemd[1]: mariadb.service: Main
 process exited, code=exited, status=1/FAILURE
Dec 26 17:51:49 DietPi systemd[1]: mariadb.service: Fail
ed with result 'exit-code'.
Dec 26 17:51:49 DietPi systemd[1]: Failed to start Maria
DB 10.3.27 database server.
Dec 26 22:24:09 DietPi systemd[1]: Starting MariaDB 10.3.27 database server...
Dec 26 22:25:39 DietPi mysqld[1742]: 2020-12-26 22:25:39 0 [Note] /usr/sbin/mysq
ld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 1742 ...
Dec 26 22:25:39 DietPi mysqld[1742]: 2020-12-26 22:25:39 0 [Warning] Could not i
ncrease number of max_open_files to more than 16384 (request: 32186)
Dec 26 22:28:40 DietPi mysqld[1742]: 2020-12-26 22:28:40 0 [Warning] Can't creat
e test file /var/lib/mysql/DietPi.lower-test
Dec 26 22:30:10 DietPi mysqld[1742]: [87B blob data]
Dec 26 22:30:10 DietPi mysqld[1742]: 2020-12-26 22:30:10 0 [ERROR] Aborting
Dec 26 22:30:10 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

Dec 26 22:30:10 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 26 22:30:10 DietPi systemd[1]: Failed to start MariaDB 10.3.27 database server.
root@DietPi:~# cat /var/log/mysql/error.log
root@DietPi:~# readlink /var/lib/mysql
/mnt/dietpi_userdata/mysql
root@DietPi:~# readlink -f /var/lib/mysql

Here again get stuck...
User avatar
Joulinar
Posts: 4170
Joined: Sat Nov 16, 2019 12:49 am

Re: MariaDB service not starting on owncloud

Post by Joulinar »

So you use an external device where you move DietPi users data on?
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
Fabio
Posts: 38
Joined: Fri Dec 18, 2020 2:43 pm

Re: MariaDB service not starting on owncloud

Post by Fabio »

Yes, I’ve a shitty external hard disk...
I've rebooted the hard drive and now it’s working again...
Ordered a new one from WD... Hope it’s better... :roll: :roll: :roll:
User avatar
Joulinar
Posts: 4170
Joined: Sat Nov 16, 2019 12:49 am

Re: MariaDB service not starting on owncloud

Post by Joulinar »

ok good that it is working again :)
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
Post Reply