MariaDB Service = Down

Hello
My Nexcloud (version 18.0.4.2) running on a Raspberry Pi 4 has stopped working…
There seems to be a problem with MariaDB

I’m a total noob to this so any help is much appreciated.

/Peder

log into ssh to yours server then put

sudo systemctl status mariadb

journalctl -xe

And paste this informations

Thank you for quick support !

sudo systemctl status mariadb

  • mariadb.service - MariaDB 10.3.22 database server
    Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
    -ncp-delay-automount.conf Active: activating (start-pre) since Thu 2020-10-22 22:16:17 CEST; 11s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 31788 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 31789 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 31791 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set-environmen Cntrl PID: 31887 (sleep) Tasks: 1 (limit: 4915) CGroup: /system.slice/mariadb.service -31887 /bin/sleep 20

okt 22 22:16:17 nextcloudpi systemd[1]: Starting MariaDB 10.3.22 database server…

journalctl -xe
okt 22 22:22:11 nextcloudpi bash[1305]: #29 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
okt 22 22:22:11 nextcloudpi bash[1305]: #30 /var/www/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘OC\User\Session’)
okt 22 22:22:11 nextcloudpi bash[1305]: #31 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\ServerContainer->query(‘OC\User\Session’)
okt 22 22:22:11 nextcloudpi bash[1305]: #32 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Util
okt 22 22:22:11 nextcloudpi bash[1305]: #33 /var/www/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘UserSession’)
okt 22 22:22:11 nextcloudpi bash[1305]: #34 /var/www/nextcloud/lib/private/Server.php(1542): OC\ServerContainer->query(‘UserSession’)
okt 22 22:22:11 nextcloudpi bash[1305]: #35 /var/www/nextcloud/lib/private/Server.php(802): OC\Server->getUserSession()
okt 22 22:22:11 nextcloudpi bash[1305]: #36 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
okt 22 22:22:11 nextcloudpi bash[1305]: #37 /var/www/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘OC\App\AppManag…’)
okt 22 22:22:11 nextcloudpi bash[1305]: #38 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\ServerContainer->query(‘OC\App\AppManag…’)
okt 22 22:22:11 nextcloudpi bash[1305]: #39 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Util
okt 22 22:22:11 nextcloudpi bash[1305]: #40 /var/www/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘AppManager’)
okt 22 22:22:11 nextcloudpi bash[1305]: #41 /var/www/nextcloud/lib/private/Server.php(1837): OC\ServerContainer->query(‘AppManager’)
okt 22 22:22:11 nextcloudpi bash[1305]: #42 /var/www/nextcloud/lib/private/legacy/app.php(347): OC\Server->getAppManager()
okt 22 22:22:11 nextcloudpi bash[1305]: #43 /var/www/nextcloud/lib/private/legacy/app.php(114): OC_App::getEnabledApps()
okt 22 22:22:11 nextcloudpi bash[1305]: #44 /var/www/nextcloud/lib/base.php(645): OC_App::loadApps(Array)
okt 22 22:22:11 nextcloudpi bash[1305]: #45 /var/www/nextcloud/lib/base.php(1089): OC::init()
okt 22 22:22:11 nextcloudpi bash[1305]: #46 /var/www/nextcloud/console.php(48): require_once(’/var/www/nextcl…’)
okt 22 22:22:11 nextcloudpi bash[1305]: #47 /var/www/nextcloud/occ(11): require_once(’/var/www/nextcl…’)
okt 22 22:22:11 nextcloudpi sudo[1333]: pam_unix(sudo:session): session closed for user www-data
okt 22 22:22:11 nextcloudpi bash[1305]: #48 {main}
okt 22 22:22:11 nextcloudpi systemd[1]: nextcloud-domain.service: Main process exited, code=exited, status=1/FAILURE
– Subject: Unit process exited
– Defined-By: systemd

– An ExecStart= process belonging to unit nextcloud-domain.service has exited.

– The process’ exit code is ‘exited’ and its exit status is 1.
okt 22 22:22:11 nextcloudpi systemd[1]: nextcloud-domain.service: Failed with result ‘exit-code’.
– Subject: Unit failed
– Defined-By: systemd

– The unit nextcloud-domain.service has entered the ‘failed’ state with result ‘exit-code’.
okt 22 22:22:15 nextcloudpi systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
okt 22 22:22:15 nextcloudpi systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 34838.
– Subject: Automatic restarting of a unit has been scheduled
– Defined-By: systemd

– Automatic restarting of the unit mariadb.service has been scheduled, as the result for
– the configured Restart= setting for the unit.
okt 22 22:22:15 nextcloudpi systemd[1]: Stopped MariaDB 10.3.22 database server.
– Subject: A stop job for unit mariadb.service has finished
– Defined-By: systemd

– A stop job for unit mariadb.service has finished.

– The job identifier is 4246268 and the job result is done.
okt 22 22:22:15 nextcloudpi systemd[1]: Starting MariaDB 10.3.22 database server…
– Subject: A start job for unit mariadb.service has begun execution
– Defined-By: systemd

– A start job for unit mariadb.service has begun execution.

– The job identifier is 4246268.
okt 22 22:22:16 nextcloudpi systemd[1]: nextcloud-domain.service: Service RestartSec=5s expired, scheduling restart.
okt 22 22:22:16 nextcloudpi systemd[1]: nextcloud-domain.service: Scheduled restart job, restart counter is at 34771.
– Subject: Automatic restarting of a unit has been scheduled
– Defined-By: systemd

– Automatic restarting of the unit nextcloud-domain.service has been scheduled, as the result for
– the configured Restart= setting for the unit.
okt 22 22:22:16 nextcloudpi systemd[1]: Stopped Register Current IP as Nextcloud trusted domain.
– Subject: A stop job for unit nextcloud-domain.service has finished
– Defined-By: systemd

– A stop job for unit nextcloud-domain.service has finished.

– The job identifier is 4246328 and the job result is done.

There seems to be a problem also with “nextcloud-domain.service”
Is this caused by MariaDB not running ?

systemctl status nextcloud-domain.service

  • nextcloud-domain.service - Register Current IP as Nextcloud trusted domain
    Loaded: loaded (/usr/lib/systemd/system/nextcloud-domain.service; enabled; vendor preset: enabled)
    Active: inactive (dead) (Result: exit-code) since Sun 2020-10-25 21:12:54 CET; 11s ago
    Process: 8344 ExecStart=/bin/bash /usr/local/bin/nextcloud-domain.sh (code=exited, status=1/FAILURE)
    Main PID: 8344 (code=exited, status=1/FAILURE)

okt 25 21:12:54 nextcloudpi systemd[1]: nextcloud-domain.service: Service RestartSec=5s expired, scheduling restart.
okt 25 21:12:54 nextcloudpi systemd[1]: nextcloud-domain.service: Scheduled restart job, restart counter is at 48.
okt 25 21:12:54 nextcloudpi systemd[1]: Stopped Register Current IP as Nextcloud trusted domain.

Trying to start mariadb givs fatal error:

sudo service mariadb start
-Job for mariadb.service failed because a fatal signal was delivered to the control process.

But when I look in /var/log/mysql there is just an empty error.log file…
Is this the correct location for MariaDB error log ?

Looking in /media/myCloudDrive/data/nextcloud.log i have 200 MB files with the same error repeating…

“user”:"–",“app”:“PHP”,“method”:"",“url”:"–",“message”:“Interface ‘OCA\Recommendations\Service\IRecommendationSource’ not found at /var/www/nextcloud/apps/recommendations/lib/Service/RecentlyCommentedFilesSource.php#63”,“userAgent”:"–",“version”:“18.0.4.2”}

I guess that this a concequence of MariaDB beeing down ?

Sometimes only there is no space on file system because of big log files.

sudo df -h

I’m using a 32G SD-card

29G available with 24G free