NCP re-initialized itself

I am also have this problem. How do I fix it?

I did get a notice from my desktop saying that my rootfs was full but I deleted a bunch of steam games and now that shouldn’t be an issue.

You will have to free up space, and then restore a backup

1 Like

The desktop sync client doesn’t work anymore.Samba also not working anymore.

Via Putty I deleted a backup file:

pi@nextcloudpi:/media $ du -msh
146G    .
pi@nextcloudpi:/media $ ls
nc-backup  USBdrive
pi@nextcloudpi:/media $ du -msh nc-backup
143G    nc-backup
pi@nextcloudpi:/media $ cd nc-backup
pi@nextcloudpi:/media/nc-backup $ ls
nextcloud-bkp_20180915_1536980403.tar  nextcloud-bkp_20180922_1537585204.tar  nextcloud-bkp_20180929_1538190004.tar  nextcloud-bkp_20181001_1538362803.tar
pi@nextcloudpi:/media/nc-backup $ du -msh nextcloud-bkp_20180915_1536980403.tar
36G     nextcloud-bkp_20180915_1536980403.tar
pi@nextcloudpi:/media/nc-backup $ sudo rm -r -v nextcloud-bkp_20180922_1537585204.tar
removed 'nextcloud-bkp_20180922_1537585204.tar'
pi@nextcloudpi:/media/nc-backup $ df -h
Filesystem      Size  Used Avail Use% Mounted on
dev             403M     0  403M   0% /dev
none            344G  309G   19G  95% /
tmpfs           414M     0  414M   0% /dev/shm
tmpfs           414M   12M  403M   3% /run
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs           414M     0  414M   0% /sys/fs/cgroup
/dev/mmcblk0p1  938M   40M  899M   5% /boot
tmpfs            83M     0   83M   0% /run/user/1000

The web-inferface still looks the same. Which backup do I now need to restore? Can I leave the data untouched and just restore settings, calender, contacts etc? Is there an automatic backup that contains this info?

you have a couple options. Your newest backup is nextcloud-bkp_20181001_1538362803.tar (from the first of october).

you are doing backups with data, and that is why they take so much space. I suggest you change your backup limit to 2 instead of four because you don’t have room for so many backups. Also I would check “compress backups” so they take up less space.

The first thing I would try is to extract the file config.php from the latest backup nextcloud-bkp_20181001_1538362803.tar, and restore it to /var/www/nextcloud/config/config.php.

If that doesn’t help, then I would restore the latest backup nextcloud-bkp_20181001_1538362803.tar.

You should be able to get the file with something like

cd /media/USBdrive/ncp-backups
tar -xf  nextcloud-bkp_20181001_1538362803.tar nextcloud/config/config.php
mv nextcloud/config/config.php /var/www/nextcloud/config/
1 Like

Hi, I’m sorry but I’m not sure where to start with this really?

I feel like I need to take a step back and consider more options here.

Currently it seems that I have to either just reinstall everything (which would be simple but also require me to basically recreate all my users, settings, branding etc) or I have to restore from back up. But everything I find online about how to restore from backup seems like a huge deal and I’m not entirely sure I understand why it’s needed? All my files are still on my drive. Nothing is missing. It’s just not working with the client or web interface. Most of my files are actually on separate external drives, but even the stuff that isn’t is still accessible from what I can tell.

Perhaps maybe not for jonaskor but for me I feel like I just need to get the server plugged back into the data etc that’s still on my disk.

Like what exactly caused this to happen when the rootfs got full? Why did it break? what exactly broke? I never got a warning from NextCloud saying I was reaching capacity etc. And shouldn’t it have just stopped syncing or something instead of completely destroying the installation?

Since my issue might be slightly different I’m going to continue to follow this thread but I’m going to move my questions to it’s own thread here: Uh... Nextcloud installation just completely reinitalized?

Any clues on this issue would be a big help. I don’t understand how or why this happened etc.

In your case, if you ran out of space, and ended up with an empty config.php try the above steps to restore it after freeing up some space

Okay, yes sorry I see that now.

I don’t think I have a backups tar file like that, because I did my install using an ansible script which created a folder in var called nc-backups

When I look in there I see a file called “config” but it’s not “config.php” and when I open it, it has invalid characters and looks all wonky.

I think you’re right though. When I check my www folder the config.php file I find isn’t empty but it doesn’t have db name etc.

I have 3 nextcloud related folders and I’m not sure what their relationships are as I installed using a slightly custom system using @Reiner_Nippes ansible playbook. I have /var/nc-backups and /var/nc-data and /var/www/nextcloud

I’m thinking that the www folder is the actual web interface etc running on the server, the nc-data is my databases, and nc-backup is supposed to be my backup?

I don’t see any tar files in my nc-backup folder though, and though I do see that config file, as I mentioned, it appears to be corrupted or something.

I tried to restore the config.php but it didn’t help.

pi@nextcloudpi:/media/nc-backup $ ls
nextcloud-bkp_20180915_1536980403.tar  nextcloud-bkp_20180929_1538190004.tar  nextcloud-bkp_20181001_1538362803.tar
pi@nextcloudpi:/media/nc-backup $ sudo tar -xf  nextcloud-bkp_20181001_1538362803.tar nextcloud/config/config.php
pi@nextcloudpi:/media/nc-backup $ sudo mv nextcloud/config/config.php /var/www/nextcloud/config/

I checked the size of the newest backup, which is only 36G:

pi@nextcloudpi:/media/nc-backup $ du -msh nextcloud-bkp_20181001_1538362803.tar
36G     nextcloud-bkp_20181001_1538362803.tar

Does this mean, that there is no data included in the file? If have more then 140G of data stored in the Nextcloud, so the file would have to be much bigger… Samba works now, I am trying to copy of of the files to my computer to check its content before restoring to make sure not to loose any data…

sorry, this thread is about NextCloudPi I did not create that Ansible script and I can’t support it

I suggest you open another thread with the correct tags

Sure thing. Apologies. Will do.

EDIT

Just letting ya’ll know I found a copy of my old config.php in the nc-data folder and was able to fix stuff. The config file was in the nc-data folder because there was a folder there for updating. So I think what happened is with the full rootfs, the system ran out of room to finish the update and screwed up the www/nextcloud installation etc.

not mv config.php /var/www/nextcloud/config/, but mv nextcloud/config/config.php /var/www/nextcloud/config/

I dont know if the restored config.php helps.the web-interface now gives me an 500-http-error.
The config-page shows the following info:

Here is a new report:

NextCloudPi diagnostics

NextCloudPi version  v0.62.6
NextCloudPi image    NextCloudPi_11-12-17
distribution         Raspbian GNU/Linux 9 \n \l
automount            no
USB devices          sda
datadir              /var/www/nextcloud/data
data in SD           yes
data filesystem      aufs
data disk usage      301G/344G
rootfs usage         301G/344G
swapfile             /dev/zram3
dbdir                /var/lib/mysql
Nextcloud check      error
HTTPD service        up
PHP service          up
MariaDB service      down
Redis service        up
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            eth0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         yes
uptime               2:46

Nextcloud configuration

An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/nextcloud/lib/private/DB/ConnectionFactory.php(152): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/nextcloud/lib/private/Server.php(628): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#9 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OCP\\IDBConnecti...')
#10 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\IDBConnecti...')
#11 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OCP\\IDBConnecti...')
#12 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#13 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('DatabaseConnect...')
#14 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#15 /var/www/nextcloud/lib/private/Server.php(1511): OC\ServerContainer->query('DatabaseConnect...')
#16 /var/www/nextcloud/lib/private/Server.php(332): OC\Server->getDatabaseConnection()
#17 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#18 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\Authenticati...')
#19 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#20 /var/www/nextcloud/lib/private/Server.php(336): OC\ServerContainer->query('OC\\Authenticati...')
#21 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\Authenticati...')
#23 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#24 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\\Authenticati...')
#25 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#26 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\Authenticati...')
#27 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#28 /var/www/nextcloud/lib/private/Server.php(352): OC\ServerContainer->query('OC\\Authenticati...')
#29 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#30 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OCP\\IUserSessio...')
#31 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\IUserSessio...')
#32 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OCP\\IUserSessio...')
#33 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#34 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('UserSession')
#35 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('UserSession')
#36 /var/www/nextcloud/lib/private/Server.php(1387): OC\ServerContainer->query('UserSession')
#37 /var/www/nextcloud/lib/private/Server.php(1020): OC\Server->getSession()
#38 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#39 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\Security\\CSR...')
#40 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Security\\CSR...')
#41 /var/www/nextcloud/lib/private/Server.php(1016): OC\ServerContainer->query('OC\\Security\\CSR...')
#42 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#43 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('CsrfTokenManage...')
#44 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('CsrfTokenManage...')
#45 /var/www/nextcloud/lib/private/Server.php(1859): OC\ServerContainer->query('CsrfTokenManage...')
#46 /var/www/nextcloud/lib/private/Server.php(820): OC\Server->getCsrfTokenManager()
#47 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#48 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OCP\\IRequest')
#49 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\IRequest')
#50 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OCP\\IRequest')
#51 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#52 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('Request')
#53 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('Request')
#54 /var/www/nextcloud/lib/private/Server.php(1254): OC\ServerContainer->query('Request')
#55 /var/www/nextcloud/lib/private/Server.php(452): OC\Server->getRequest()
#56 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#57 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OCP\\L10N\\IFacto...')
#58 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\L10N\\IFacto...')
#59 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OCP\\L10N\\IFacto...')
#60 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#61 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('L10NFactory')
#62 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('L10NFactory')
#63 /var/www/nextcloud/lib/private/Server.php(1440): OC\ServerContainer->query('L10NFactory')
#64 /var/www/nextcloud/lib/private/Server.php(1451): OC\Server->getL10NFactory()
#65 /var/www/nextcloud/lib/base.php(228): OC\Server->getL10N('lib')
#66 /var/www/nextcloud/lib/base.php(667): OC::checkConfig()
#67 /var/www/nextcloud/lib/base.php(1081): OC::init()
#68 /var/www/nextcloud/console.php(46): require_once('/var/www/nextcl...')
#69 /var/www/nextcloud/occ(11): require_once('/var/www/nextcl...')
#70 {main}
HTTPd logs

[Sun Oct 07 21:45:22.842743 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.057046 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.516382 2018] [proxy_fcgi:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01071: Got error 'PHP message: NACHO auto\n - [_auto_,en,de,es,zh]\n\nPHP message: NACHO en\n - [_auto_,en,de,es,zh]\n\nPHP message: NACHO de\n - [_auto_,en,de,es,zh]\n\nPHP message: NACHO es\n - [_auto_,en,de,es,zh]\n\nPHP message: NACHO zh\n - [_auto_,en,de,es,zh]\n\n'
[Sun Oct 07 21:45:23.526168 2018] [authz_host:error] [pid 4057:tid 1725080624] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /ncp.css failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.527027 2018] [authz_host:error] [pid 4057:tid 1683096624] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /ncp.js failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.527499 2018] [authz_host:error] [pid 4057:tid 1716683824] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/loading-small.gif failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.527988 2018] [authz_host:error] [pid 4057:tid 1708287024] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/ncp-logo.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.535678 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /minified.js failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.899098 2018] [authz_host:error] [pid 4057:tid 1725080624] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/reboot.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.899715 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/poweroff.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.961183 2018] [authz_host:error] [pid 4057:tid 1725080624] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/nc-button.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.960752 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /core/img/actions/triangle-s.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.973231 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/dashboard.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.985177 2018] [authz_host:error] [pid 4057:tid 1725080624] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/wizard.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.985778 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/settings-white.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:23.987794 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /img/info-white.svg failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:24.014568 2018] [authz_host:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /ncp-output.php failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:24.058174 2018] [authz_host:error] [pid 4057:tid 1725080624] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sun Oct 07 21:45:25.243426 2018] [proxy_fcgi:error] [pid 4057:tid 1699890224] [client 192.168.1.51:56343] AH01071: Got error 'PHP message: PHP Warning:  touch(): Utime failed: Permission denied in /var/www/ncp-web/ncp-output.php on line 81\n'
[Sun Oct 07 21:45:30.837636 2018] [authz_host:error] [pid 4057:tid 1725080624] [client 192.168.1.51:56343] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name

Database logs


2018-10-07 21:45:58 1988833280 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-07 21:45:58 1988833280 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-10-07 21:45:58 1988833280 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Using Linux native AIO
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Using generic crc32 instructions
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Completed initialization of buffer pool
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-07 21:45:58 1988833280 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-07 21:45:58 1988833280 [Note] InnoDB: Waiting for purge to start
2018-10-07 21:45:58 1988833280 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1149935359
2018-10-07 21:45:58 1420763968 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-10-07 21:45:58 1988833280 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-07 21:45:58 1988833280 [Note] Recovering after a crash using tc.log
2018-10-07 21:45:58 1988833280 [ERROR] Can't init tc log
2018-10-07 21:45:58 1988833280 [ERROR] Aborting


Nextcloud logs

{"reqId":"W7UEHX8AAQEAAEWfUQ0AAAAL","level":2,"time":"2018-10-03T18:02:05+00:00","remoteAddr":"212.129.50.159","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"212.129.50.159\" tried to access using \"77.177.65.134\" as host.","userAgent":"--","version":"13.0.6.1"}
{"reqId":"W7UNvH8AAQEAAEWfUVsAAAAB","level":2,"time":"2018-10-03T18:43:08+00:00","remoteAddr":"198.108.66.240","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"198.108.66.240\" tried to access using \"77.177.65.134\" as host.","userAgent":"Mozilla\/5.0 zgrab\/0.x","version":"13.0.6.1"}
{"reqId":"W7UYZX8AAQEAAEWgu8AAAABK","level":2,"time":"2018-10-03T19:28:38+00:00","remoteAddr":"139.162.116.133","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"139.162.116.133\" tried to access using \"77.177.65.134\" as host.","userAgent":"Go-http-client\/1.1","version":"13.0.6.1"}
{"reqId":"W7U2aX8AAQEAAEWfUz0AAAAY","level":2,"time":"2018-10-03T21:36:41+00:00","remoteAddr":"60.191.38.77","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"60.191.38.77\" tried to access using \"77.177.65.134\" as host.","userAgent":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko\/20100101 Firefox\/47.0","version":"13.0.6.1"}
{"reqId":"W7VUO38AAQEAAEWgvU4AAABR","level":2,"time":"2018-10-03T23:43:55+00:00","remoteAddr":"123.186.216.170","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"123.186.216.170\" tried to access using \"77.177.65.134\" as host.","userAgent":"Mozilla\/5.0 (Windows NT 6.1) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/38.0.2125.122 Safari\/537.36 SE 2.X MetaSr 1.0","version":"13.0.6.1"}
{"reqId":"W7Wcw38AAQEAAEWfVJEAAAAM","level":2,"time":"2018-10-04T04:53:23+00:00","remoteAddr":"60.191.38.77","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"60.191.38.77\" tried to access using \"77.176.133.217\" as host.","userAgent":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko\/20100101 Firefox\/47.0","version":"13.0.6.1"}
{"reqId":"xXAxNiomvp4Vz3rGa0zw","level":3,"time":"2018-10-04T07:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"Kp9yKQDFdJZkTzlApzld","level":3,"time":"2018-10-04T07:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"Dh6E6VNV456Ui35J9s9H","level":3,"time":"2018-10-04T07:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":{"reqId":"jj36nqrEqNEadBcXENkX","level":3,"time":"2018-10-07T16:00:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"PHvmGPrFz3sPZcbB1CUT","level":3,"time":"2018-10-07T16:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"Sn2eTybQ2YIjuhgh7kuM","level":3,"time":"2018-10-07T16:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"GzmhuXSSrUsywhxCUMLA","level":3,"time":"2018-10-07T16:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"8HBvT6h1FJyyArsnYaPz","level":3,"time":"2018-10-07T17:00:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"pMOfsbzCMFBb31DJ3prr","level":3,"time":"2018-10-07T17:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"IWg3GDd9FVXHni5z2UTa","level":3,"time":"2018-10-07T17:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"1GLAy8UPTsKIqwLVHMjz","level":3,"time":"2018-10-07T17:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"bp9KpiagTLkJLnC7qcwu","level":3,"time":"2018-10-07T18:00:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"dIkzyUva83u0aTB9UlhF","level":3,"time":"2018-10-07T18:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"HATFU3KOuFqzlQGzRCn3","level":3,"time":"2018-10-07T18:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"tQ420nRKkGvGKzCpZF6U","level":3,"time":"2018-10-07T18:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}

Any idea what to try next? I fear to loose data if I restore an (incomplete?) backup. The backup file ist only 36G while the data on the drive is more than 140G…

your database crashed at some point. Delete the log file /var/lib/mysql/tc.log and start the database

systemctl start mysqld
1 Like

That worked, the database is running now (had to use sudo systemctl start mysqld).
But the NC is in maintenance mode now, even after reboot. How can I exit maintenance mode?

Log:

NextCloudPi diagnostics

Nextcloud is in maintenance mode - no apps have been loaded

NextCloudPi version  v0.62.6
NextCloudPi image    NextCloudPi_11-12-17
distribution         Raspbian GNU/Linux 9 \n \l
automount            no
USB devices          sda
datadir              /var/www/nextcloud/data
data in SD           yes
data filesystem      aufs
data disk usage      301G/344G
rootfs usage         301G/344G
swapfile             /dev/zram3
dbdir                /var/lib/mysql
Nextcloud check      ok
Nextcloud version    13.0.6.1
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            eth0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         yes
uptime               1:27

Nextcloud configuration

Nextcloud is in maintenance mode - no apps have been loaded

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": {
            "0": "localhost",
            "1": "192.168.1.24",
            "5": "nextcloudpi.local",
            "2": "--removed----.ddns.net",
            "4": "--removed---.ddns.net"
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/---removed---.ddns.net",
        "dbtype": "mysql",
        "version": "13.0.6.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "overwriteprotocol": "https",
        "loglevel": "2",
        "log_type": "file",
        "maintenance": true,
        "theme": ""
    }
}

HTTPd logs

[Mon Oct 08 08:59:03.397145 2018] [authz_host:error] [pid 1090:tid 1708868656] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:03.610794 2018] [authz_host:error] [pid 1090:tid 1708868656] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:07.722314 2018] [proxy_fcgi:error] [pid 1090:tid 1708868656] [client 192.168.1.51:59016] AH01071: Got error 'PHP message: NACHO auto\n - en\n\nPHP message: NACHO en\n - en\n\nPHP message: NACHO de\n - en\n\nPHP message: NACHO es\n - en\n\nPHP message: NACHO zh\n - en\n\n'
[Mon Oct 08 08:59:07.732980 2018] [authz_host:error] [pid 1090:tid 1692075056] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /ncp.js failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:07.733512 2018] [authz_host:error] [pid 1090:tid 1750852656] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/loading-small.gif failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:07.734251 2018] [authz_host:error] [pid 1090:tid 1700471856] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/ncp-logo.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:07.736845 2018] [authz_host:error] [pid 1090:tid 1708868656] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /minified.js failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:07.736745 2018] [authz_host:error] [pid 1090:tid 1683678256] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /ncp.css failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.139093 2018] [authz_host:error] [pid 1090:tid 1708868656] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/reboot.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.139093 2018] [authz_host:error] [pid 1090:tid 1683678256] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/poweroff.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.195266 2018] [authz_host:error] [pid 1090:tid 1708868656] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /core/img/actions/triangle-s.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.195926 2018] [authz_host:error] [pid 1090:tid 1683678256] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/nc-button.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.201122 2018] [authz_host:error] [pid 1090:tid 1692075056] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/wizard.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.201148 2018] [authz_host:error] [pid 1090:tid 1700471856] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/info-white.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.201191 2018] [authz_host:error] [pid 1090:tid 1708868656] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/settings-white.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.202247 2018] [authz_host:error] [pid 1090:tid 1683678256] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /img/dashboard.svg failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.291328 2018] [authz_host:error] [pid 1090:tid 1683678256] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /ncp-output.php failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:08.316831 2018] [authz_host:error] [pid 1090:tid 1700471856] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Oct 08 08:59:09.539620 2018] [proxy_fcgi:error] [pid 1090:tid 1683678256] [client 192.168.1.51:59016] AH01071: Got error 'PHP message: PHP Warning:  touch(): Utime failed: Permission denied in /var/www/ncp-web/ncp-output.php on line 81\n'
[Mon Oct 08 08:59:14.001980 2018] [authz_host:error] [pid 1090:tid 1700471856] [client 192.168.1.51:59016] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name

Database logs

2018-10-08  7:29:12 1639236416 [Note] /usr/sbin/mysqld: Shutdown complete

2018-10-08  7:33:55 1988546560 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-08  7:33:55 1988546560 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-08  7:33:55 1988546560 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-10-08  7:33:55 1988546560 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-10-08  7:33:55 1988546560 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-10-08  7:33:55 1988546560 [Note] InnoDB: Using Linux native AIO
2018-10-08  7:33:55 1988546560 [Note] InnoDB: Using generic crc32 instructions
2018-10-08  7:33:56 1988546560 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-10-08  7:33:56 1988546560 [Note] InnoDB: Completed initialization of buffer pool
2018-10-08  7:33:56 1988546560 [Note] InnoDB: Highest supported file format is Barracuda.
2018-10-08  7:33:57 1988546560 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-08  7:33:57 1988546560 [Note] InnoDB: Waiting for purge to start
2018-10-08  7:33:58 1988546560 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1149946641
2018-10-08  7:33:58 1412825920 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-10-08  7:33:58 1988546560 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-08  7:33:58 1988546560 [Note] Server socket created on IP: '127.0.0.1'.
2018-10-08  7:33:58 1988546560 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.23-MariaDB-9+deb9u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Raspbian 9.0

Nextcloud logs

{"reqId":"W7UEHX8AAQEAAEWfUQ0AAAAL","level":2,"time":"2018-10-03T18:02:05+00:00","remoteAddr":"212.129.50.159","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"212.129.50.159\" tried to access using \"77.177.65.134\" as host.","userAgent":"--","version":"13.0.6.1"}
{"reqId":"W7UNvH8AAQEAAEWfUVsAAAAB","level":2,"time":"2018-10-03T18:43:08+00:00","remoteAddr":"198.108.66.240","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"198.108.66.240\" tried to access using \"77.177.65.134\" as host.","userAgent":"Mozilla\/5.0 zgrab\/0.x","version":"13.0.6.1"}
{"reqId":"W7UYZX8AAQEAAEWgu8AAAABK","level":2,"time":"2018-10-03T19:28:38+00:00","remoteAddr":"139.162.116.133","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"139.162.116.133\" tried to access using \"77.177.65.134\" as host.","userAgent":"Go-http-client\/1.1","version":"13.0.6.1"}
{"reqId":"W7U2aX8AAQEAAEWfUz0AAAAY","level":2,"time":"2018-10-03T21:36:41+00:00","remoteAddr":"60.191.38.77","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"60.191.38.77\" tried to access using \"77.177.65.134\" as host.","userAgent":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko\/20100101 Firefox\/47.0","version":"13.0.6.1"}
{"reqId":"W7VUO38AAQEAAEWgvU4AAABR","level":2,"time":"2018-10-03T23:43:55+00:00","remoteAddr":"123.186.216.170","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"123.186.216.170\" tried to access using \"77.177.65.134\" as host.","userAgent":"Mozilla\/5.0 (Windows NT 6.1) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/38.0.2125.122 Safari\/537.36 SE 2.X MetaSr 1.0","version":"13.0.6.1"}
{"reqId":"W7Wcw38AAQEAAEWfVJEAAAAM","level":2,"time":"2018-10-04T04:53:23+00:00","remoteAddr":"60.191.38.77","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"60.191.38.77\" tried to access using \"77.176.133.217\" as host.","userAgent":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko\/20100101 Firefox\/47.0","version":"13.0.6.1"}
{"reqId":"xXAxNiomvp4Vz3rGa0zw","level":3,"time":"2018-10-04T07:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"Kp9yKQDFdJZkTzlApzld","level":3,"time":"2018-10-04T07:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"Dh6E6VNV456Ui35J9s9H","level":3,"time":"2018-10-04T07:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":{"reqId":"jj36nqrEqNEadBcXENkX","level":3,"time":"2018-10-07T16:00:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"PHvmGPrFz3sPZcbB1CUT","level":3,"time":"2018-10-07T16:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"Sn2eTybQ2YIjuhgh7kuM","level":3,"time":"2018-10-07T16:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"GzmhuXSSrUsywhxCUMLA","level":3,"time":"2018-10-07T16:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"8HBvT6h1FJyyArsnYaPz","level":3,"time":"2018-10-07T17:00:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"pMOfsbzCMFBb31DJ3prr","level":3,"time":"2018-10-07T17:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"IWg3GDd9FVXHni5z2UTa","level":3,"time":"2018-10-07T17:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"1GLAy8UPTsKIqwLVHMjz","level":3,"time":"2018-10-07T17:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"bp9KpiagTLkJLnC7qcwu","level":3,"time":"2018-10-07T18:00:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"dIkzyUva83u0aTB9UlhF","level":3,"time":"2018-10-07T18:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"HATFU3KOuFqzlQGzRCn3","level":3,"time":"2018-10-07T18:30:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}
{"reqId":"tQ420nRKkGvGKzCpZF6U","level":3,"time":"2018-10-07T18:45:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"Not installed\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(668): OC::checkInstalled()\\n#1 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(1081): OC::init()\\n#2 \\\/var\\\/www\\\/nextcloud\\\/cron.php(41): require_once('\\\/var\\\/www\\\/nextcl...')\\n#3 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php\",\"Line\":266}","userAgent":"--","version":""}

I was able to exit maintenance mode using the following command:

pi@nextcloudpi:~ $ sudo -u www-data php /var/www/nextcloud/occ maintenance:mode --off
Nextcloud is in maintenance mode - no apps have been loaded

Maintenance mode disabled

Now everything works again! Thanks a lot for your help, @nachoparker!
Is there any method to stop this from happening again?

Just be careful not to run out of space again. You can compress backups, and keep just a couple instead of four to start with.

Also you can do dataless backups and backup the data by other means, such as nc-rsync or nc-snapshots

Okay, apparently when I enabled backups again (limited to 2) NCP didn’t delete the old backups and therefore everything crashed again. After repairing the system using the method above,
I now went through all the folders using the sudo du -msh command to see what is using up all the space.

25GB are used by the folder /var/www/nextcloud/data/ncp-update-backups with the two files
nextcloud-bkp_20180620_1529476021-13.0.2.1.tar.gz and
nextcloud-bkp_20180726_1532586352-13.0.4.0.tar.gz. Why are they being kept? Is it save to delete these files?

Most of the rest of the space was used by personal files (about 160GB) and backup files. These files where about 36GB each! Why are they so huge? Is that normal? What do they contain (apparently not all the data, they would be much bigger)?

[ nc-backup ]
check free space…
Maintenance mode enabled
backup database…
backup base files…
compressing backup file…
backup /media/nc-backup/nextcloud-bkp_20181009_1539101020.tar.gz generated
Nextcloud is in maintenance mode - no apps have been loaded

Maintenance mode disabled

The old backups are only deleted after a successful backup. Also, the backup tool checks if there is space available, but that might not be true if there’s compression, because the compression is not in-place. I just realized that, it needs to be improved.

You can safely remove the old backups in ncp-update-backups. Those are there in case something goes wrong with the update and you want to go back. They are surprisingly big though, can you check what is the size of your previews? (they will be in a path similar to /media/myCloudDrive/ncdata/appdata_oc65v9pdw1g0/preview)

Well, we found a couple details to work on :smiley: