MariaDB Server is down

I have a big problem mit UCS 4.2-5 Server.

  • I cannot login at Univention Portal as administrator. After Username and Password, nothing happen for a long time

  • I just use UCS with OwnCloud. (No AD, no other Apps)

  • I don’t know what happen, but after a reboot, the owncloud is not working anymore. I want to make a Database Backup and install owncloud on a new server, but I think there is also a problem with starting the SQL Server…

Maybe someone can first help me with that problem:

root@ocde:~# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2019-08-05 22:49:16 CEST; 6min ago
Process: 943 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILUR
Process: 751 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery; [ $? -eq
Process: 745 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 737 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 943 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”
CPU: 344ms

Aug 05 22:49:09 ocde systemd[1]: Starting MariaDB database server…
Aug 05 22:49:11 ocde mysqld[943]: 2019-08-05 22:49:11 139909586002496 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1)
Aug 05 22:49:16 ocde systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Aug 05 22:49:16 ocde systemd[1]: Failed to start MariaDB database server.
Aug 05 22:49:16 ocde systemd[1]: mariadb.service: Unit entered failed state.
Aug 05 22:49:16 ocde systemd[1]: mariadb.service: Failed with result ‘exit-code’.
…skipping…
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2019-08-05 22:49:16 CEST; 6min ago
Process: 943 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILUR
Process: 751 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery; [ $? -eq
Process: 745 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 737 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 943 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”
CPU: 344ms

Aug 05 22:49:09 ocde systemd[1]: Starting MariaDB database server…
Aug 05 22:49:11 ocde mysqld[943]: 2019-08-05 22:49:11 139909586002496 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1)
Aug 05 22:49:16 ocde systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Aug 05 22:49:16 ocde systemd[1]: Failed to start MariaDB database server.
Aug 05 22:49:16 ocde systemd[1]: mariadb.service: Unit entered failed state.
Aug 05 22:49:16 ocde systemd[1]: mariadb.service: Failed with result ‘exit-code’.

Looking forward for your help and if I forgot any information, please let me know.

Thanks and best,
Benny

I fixed the problem with this Link: https://help.nextcloud.com/t/100-disk-mariadb-wont-start-again/28697

Thanks!

Mastodon