MariaDB service not starting on owncloud

Troubleshooting
1

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:

● 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!

2

Hi,

many thanks for your message. Pls can you post following

systemctl restart mariadb.service
journalctl -u mariadb
cat /var/log/mysql/error.log
readlink /var/lib/mysql
readlink -f /var/lib/mysql
3

At the command

systemctl restart mariadb.service

The system remains stuck and does nothing more.

4

journalctl -u mariadb

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…

5

So you use an external device where you move DietPi users data on?

6

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_eyes: :roll_eyes: :roll_eyes:

7

ok good that it is working again :slight_smile: