Nextcloudpi unusable after update to v1.26, Ports 80 and 443 cannot be opened

dl1dby · June 12, 2020, 11:01pm

Hi,
after updating from version 1.25 to 1.26 there is no synchronisation of files possible, either from the ubuntu app or via webdav. You cannot upload any file to the nextcloud anymore. There is also no sync of calendar items anymore. It also says that Ports 80 and 443 are closed, even if the ports are open at my browser and I did run nc-forward-ports with positive results a few times.

nc-info shows this:

Running nc-info
Gathering information…
NextCloudPi version v1.26.0
NextCloudPi image NextCloudPi_03-28-20
distribution Raspbian GNU/Linux 10 \n \l
automount yes
USB devices sda
datadir /media/USBdrive/ncdata
data in SD no
data filesystem btrfs
data disk usage 446G/1,9T
rootfs usage 2,8G/58G
swapfile /var/swap
dbdir /var/lib/mysql
Nextcloud check ok
Nextcloud version 18.0.5.1
HTTPD service up
PHP service up
MariaDB service up
Redis service up
Postfix service up
internet check ok
port check 80 closed
port check 443 closed
IP 192.168.178.38
gateway 192.168.178.1
interface eth0
certificates XXXXXXXXXXXXXXX
NAT loopback yes
uptime 1:01

You should open your ports for Lets Encrypt and external access
Done. Press any key…

Any idea what I can do to solve the problem?

FadeFx · June 13, 2020, 5:30am

Similar issue here, but mine sayed

Nextcloud check error

the reason for that may be that i have the database moved to the hdd as well

Btw, the ports closed issue has been displayed on 1.25 as well, but it wasnt true

dl1dby · June 13, 2020, 6:59am

Same here, the ports are in fact open. It started with v1.26 here.

I hope I can avoid a complete new installation and even that isn’t sure to solve the problem.

OliverV · June 13, 2020, 7:03am

Created bug report for that here Edit: Fixed in v1.26.1 Thanks for pointing out.

No it was there before, just went un-noticed afaik, v1.26 only releases auto-update to NC 18.0.5

FadeFx · June 13, 2020, 8:20am

I have restored a backup and nextcloud was working again until i updated some apps, then it started to go crazy like a messed up theme and stuff. After a while (the backup process was still busy diong the filescan btw) it stopped working once again. Currently i am restoring that backup one more time and will then update the apps one by one to see if it is related to one specific app

dl1dby · June 13, 2020, 10:12am

Maybe a complete new and fresh installation before restoring the backup will help. Maybe I’ll try that, but it is a lot of work.

FadeFx · June 13, 2020, 10:30am

My nextcloud logs after the defect shows this:

*[ Externe Seiten](https://nextcloud.mydomain.tld/settings/admin/external)
* [![](https://nextcloud.mydomain.tld/apps/workflowengine/img/app-dark.svg) Ablauf](https://nextcloud.mydomain.tld/settings/admin/workflow)
* [![](https://nextcloud.mydomain.tld/apps/cms_pico/img/pico_cms.svg) Pico CMS](https://nextcloud.mydomain.tld/settings/admin/cms_pico)
* [![](https://nextcloud.mydomain.tld/apps/survey_client/img/app-dark.svg) Nutzungsbericht](https://nextcloud.mydomain.tld/settings/admin/survey_client)
* [![](https://nextcloud.mydomain.tld/core/img/actions/settings-dark.svg) App-Reihenfolge](https://nextcloud.mydomain.tld/settings/admin/apporder)
* [![](https://nextcloud.mydomain.tld/apps/groupfolders/img/app-dark.svg) Gruppen-Ordner](https://nextcloud.mydomain.tld/settings/admin/groupfolders)
* [![](https://nextcloud.mydomain.tld/apps/logreader/img/app-dark.svg) Protokollierung](https://nextcloud.mydomain.tld/settings/admin/logging)
* [![](https://nextcloud.mydomain.tld/apps/serverinfo/img/app-dark.svg) System](https://nextcloud.mydomain.tld/settings/admin/serverinfo)
* [![](https://nextcloud.mydomain.tld/core/img/actions/settings-dark.svg) Zusätzliche Einstellungen](https://nextcloud.mydomain.tld/settings/admin/additional)

Level

Error

PHP

vor 5 Minuten

filesize(): stat failed for /media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/settings/47cd-7604-settings.css.deps at /var/www/nextcloud/lib/private/LargeFileHelper.php#172

Error

PHP

vor 5 Minuten

stat(): stat failed for /media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/settings/47cd-7604-settings.css.deps at /var/www/nextcloud/lib/private/Files/Storage/Local.php#144

Error

PHP

vor 5 Minuten

file_get_contents(/media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/settings/47cd-7604-settings.css.deps): failed to open stream: No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#218

Error

PHP

vor 10 Minuten

RedisException: NOAUTH Authentication required. at /var/www/nextcloud/lib/private/Memcache/Redis.php#54

Error

PHP

vor 13 Minuten

filesize(): stat failed for /media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/core/7681-7604-results.css.gzip at /var/www/nextcloud/lib/private/LargeFileHelper.php#172

Error

PHP

vor 13 Minuten

stat(): stat failed for /media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/core/7681-7604-results.css.gzip at /var/www/nextcloud/lib/private/Files/Storage/Local.php#144

Error

PHP

vor 13 Minuten

file_get_contents(/media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/core/7681-7604-results.css.gzip): failed to open stream: No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#218

Error

PHP

vor 13 Minuten

filesize(): stat failed for /media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/core/7681-7604-css-variables.css.gzip at /var/www/nextcloud/lib/private/LargeFileHelper.php#172

Error

PHP

vor 13 Minuten

stat(): stat failed for /media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/core/7681-7604-css-variables.css.gzip at /var/www/nextcloud/lib/private/Files/Storage/Local.php#144

Error

PHP

vor 13 Minuten

file_get_contents(/media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/core/7681-7604-css-variables.css.gzip): failed to open stream: No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#218

Error

PHP

vor 13 Minuten

filesize(): stat failed for /media/myCloudDrive/ncdata/appdata_oc1lgek82p77/css/core/7681-7604-server.css.gzip at /var/www/nextcloud/lib/private/

FadeFx · June 13, 2020, 12:52pm

And this loops after the restore, so there is something wrong already:

Doctrine\DBAL\Exception\LockWaitTimeoutException: An exception occurred while executing 'UPDATE oc_filecacheSETmtime= ?,size= ?,etag= ?,storage_mtime= ?,checksum = ? WHERE (fileid = ?) AND (((mtime <> ?) OR (mtime IS NULL)) OR ((size <> ?) OR (size IS NULL)) OR ((etag <> ?) OR (etag IS NULL)) OR ((storage_mtime <> ?) OR (storage_mtime IS NULL)) OR ((checksum <> ?) OR (checksum IS NULL)))' with params [1592052355, 5, "bb458a3dab427c0ad83e83e2471079ab", 1592052355, "", 582146, 1592052355, 5, "bb458a3dab427c0ad83e83e2471079ab", 1592052355, ""]: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

dl1dby · June 13, 2020, 3:33pm

There is now a fix for the problem of the closed ports 443 and 80 (v1.26.1.), but it does not solve the problems I have since updating to v1.26. Still no WebDav and Caldav possible.

When trying to upload a file through the web interface I get:

Expected filesize of 38190 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 8192 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.

The Ubuntu Nextcloud Client does not sync either.

edit: There seems to be another new fix. v1.26.2. I’ll try this. So please disregard the above.

FadeFx · June 13, 2020, 3:34pm

Did you try to fix permissions from nc webui?

dl1dby · June 13, 2020, 3:38pm

I’ll try the now available second fix v.1.26.2., fix the permissions, recheck everything and report later, if it works. Thanks so far.

dl1dby · June 13, 2020, 4:02pm

After installing v1.26.2 still the situation that nothing works. No CalDav, no Webdav, no uploading through Web server, no sync with the Ubuntu Nextcloud app. Rebooting and Fixing permissions didn’t change anything.

Downloading, web server and ssh work, though.

I guess it is time again to start from scratch and build a new complete Nextcloudpi installation.

FadeFx · June 14, 2020, 4:30am

My issues are solved by restoring the backup and updating to 18.0.5 immediately after that. But it looks like for me it had to do with css onlyafter first restore, because webdav seemed to work as intended then. Seems i have hijacked your thread with a different problem then, sorry for that…

dl1dby · June 14, 2020, 10:25am

My issues are also solved. I did restore a backup - but not the newest one but one from 3 days ago, that surely wasn’t affected by the bug.

I also did a few reboots, as the web server wasn’t properly working, and now everything is back to normal.