[Support] Linuxserver.io - Nextcloud


Recommended Posts

Posted (edited)

Hi, I have not seen anyone else show how to use mysqldump to generate database backups similar to
https://docs.nextcloud.com/server/latest/admin_manual/maintenance/backup.html
So this is the script I smashed together to make my backups (using User Scripts by Squid) that I run every day
Recap what is does

  • The script sets nextcloud in maintenance mode first
  • Then the backup run (note that I use the utf8mb4 setting) | I compress it a bit (this could be better) and add a timestamp to the file.
  • There is printed a successful or not statement to the terminal/log
  • Nextcloud is taken out of maintenance
  • Then I keep the 7 newest files and delete any older ones in my case keep the last 7 days. (this is due to not bloat my remote backup) It produces an error message here but it works.

The dedicated backup user have these privileges “SELECT, SHOW VIEW, TRIGGER, PROCESS, LOCK TABLES” for the db. I can’t remember where I found the overview of what was necessary. You could use the root user, just don’t, that user is too valuable.

To create a dedicated backup user
Open the mariadb terminal

mysql -uroot -p

enter your root password
run the user create command under. You need to change all {{}} content

CREATE USER '{{Dedicated Backup user}}'@'%' IDENTIFIED by '{{password}}'; GRANT SELECT, PROCESS, LOCK TABLES, TRIGGER, SHOW VIEW ON *.* TO '{{Dedicated Backup user}}'@'%';

This user have access to all DBs on your mariadb instance but can't grant privilege, delete or update content

I hope this is helpful and do you have any feedback let me know.

#!/bin/bash

#description=Run to backup db for nextcloud
#foregroundOnly=false
#backgroundOnly=false
#arrayStarted=true

#turn on maintenacemode
docker exec nextcloud occ maintenance:mode --on

#Backup and compression of db
docker exec MariaDB /usr/bin/mysqldump --single-transaction --default-character-set=utf8mb4 --user={{Dedicated Backup user}} --password={{password}} nextcloud | gzip > /mnt/user/{{full path to backup}}/nextcloudDB/nextcloud-sqlbkp_`date +"%Y%m%d"`.gz
if [ "$?" -eq 0 ]
then
    echo "Mysqldump executed successfully"
else
    echo "Mysqldump encountered a problem"
fi

#turn off maintenacemode
docker exec nextcloud occ maintenance:mode --off

#Keep the 7 newest files, delete the oldest
cd /mnt/user/{{full path to backup}}/nextcloudDB && ls -tp | grep -v '/$' | tail -n +8 | tr '\n' '\0' | xargs -0 rm --

---------------------------------------------------------------------
RESTORE
So my caching drive died, and I needed to recreate my db for nextcloud
This is the steps I used, together with this guide.
https://docs.nextcloud.com/server/latest/admin_manual/maintenance/restore.html
First use the same db creation commands as first time (note that I use the utf8mb4 setting), if you lost your full mariadb install like me you have lost the user accounts as well
write this is in the mariadb terminal

mysql -uroot -p
CREATE DATABASE IF NOT EXISTS nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'nextcloud' IDENTIFIED by 'password';
GRANT ALL PRIVILEGES ON nextcloud.* to 'nextcloud' IDENTIFIED BY 'password';


Find your latesed db backup-file and decompressed it from main terminal
 

gzip -d /path/to/file/nextcloud-sqlbkp_20220601.gz


write this command to restore from dump in mariadb terminal (but not logged into MariaDb commandline, Ctrl+c to logout)
make sure that your file is reachable from your mariadb docker container

mysql --user root --password nextcloud < /path/to/file/nextcloud-sqlbkp_20220601


you will get promted for a password. "nextcloud" above is the database name of target db. 
It will take som time to restore, and your db is back 😄
Be aware that you need a backup of your config files and data also, I do not understand it good enough to write about it here, but I had backups.

Edited by standbymeintothewild
Added create script for backup user and restore guide
Link to comment

Me again, has anyone installed 

Full text search
Full text search - Elasticsearch Platform
Full text search - Files

I am getting mixed messages if it need to be installed as just the three apps listed or if it needs a whole seperate docker container etc.

Link to comment
Posted (edited)

looking at logs for Collabora lately, I see a lot of these: 

 [ websrv_poll ] WRN convert-to: Requesting address is denied:

and then it has my Public IP.. collabora works fine and so does Nextcloud. Is this anything to be concerned about or is it normal?

Collabora is latest/code with domain variable removed and Aliasgroup1 added. NC is on 23. 

 

Also, if I try to go to the collabora webui, I get error 400.. I'm using SWAG.

Edited by presence06
Link to comment
Posted (edited)

Hello All,

 

I recently started getting a new error when attempting to access my Nextcloud instance from within the LAN. The domain URL I had did work but now will not resolve. Yielding a "this page can not be reached" from Chrome. Alternatively, typing the IP:port returns a 400 error stating "the plain HTTP request was sent to HTTPS port". 

 

I had this working via a spaceinvader one video and i should also mention that I can reach the instance from outside the LAN, such as from my cell->the cell network/internet-> my server(using the URL and SWAG). Just not from within the LAN. 

 

Nextcloud and SWAG are run within docker on a docker network. Nextcloud shows the following mapping (172.18.0.3:443/TCP <-> 192.168.86.49:444) and SWAG shows the following also ( 172.18.0.2:80/TCP <-> 192.168.86.49:180 AND 172.18.0.2:443/TCP <-> 192.168.86.49:1443 )

 

Any ideas where I should be looking?

Edited by Aerodb
Link to comment
Posted (edited)

cant Update to v24.0.1 by WebUI having errors (504: Gateway time-out) on step 3 or 5  .... (Using Unraid 6.10.1 + NPM +Clouflare)

tryed to add :

 

location ~ \.php(?:$|/) {

fastcgi_read_timeout 600; fastcgi_send_timeout 600; fastcgi_connect_timeout 600; proxy_connect_timeout 600; proxy_send_timeout 600; proxy_read_timeout 600; send_timeout 600;

}

 

but then having error of webdav  and no connection from Cloudflare in update....

 

Edited by Masterwishx
Link to comment

Hi everyone. How did you managed to update this container to version 24. I'm using  received update for 23.0.5 now. Also the ones who installed version 24 do you find it so much better, faster and responsive as it is described I the official Nextcloud site?

Link to comment
cant Update to v24.0.1 by WebUI having errors (504: Gateway time-out) on step 3 or 5  .... (Using Unraid 6.10.1 + NPM +Clouflare)
tryed to add :
 
location ~ \.php(?:$|/) {
fastcgi_read_timeout 600; fastcgi_send_timeout 600; fastcgi_connect_timeout 600; proxy_connect_timeout 600; proxy_send_timeout 600; proxy_read_timeout 600; send_timeout 600;
}
 
but then having error of webdav  and no connection from Cloudflare in update....
 

I have never had luck using the updater. I recommend following the manual update instructions in post 1; they’ve worked for me for… many iterations.
  • Like 2
  • Upvote 1
Link to comment
4 hours ago, blaine07 said:

I have never had luck using the updater

 

i used a lot of time with gui update and every time it was working, but for update 24.0.1 on unraid 6.10.1 not working , 504: Gateway time-out.

also tryed from console step 1 from post 1. 

Link to comment

The problem is fixed , it was becouse of very slow download of of file nextcloud-24.0.1.zip that take about 5-10 min, if waiting for download complete, and back to update window ,then update is going to next step verify and so on ... 

Link to comment
On 5/8/2022 at 1:01 AM, Demet said:

Hello,

 

I keep receiving these errors when uploading my camera phone from my iphone to Nextcloud. Has anyone seen this before or knows a fix?

 

Movie Preview Generation Failed:

 

 

[core] Error: Movie preview generation failed Output: ["ffmpeg version 4.4.1 Copyright (c) 2000-2021 the FFmpeg developers","  built with gcc 10.3.1 (Alpine 10.3.1_git20210424) 20210424","  configuration: --prefix=/usr --enable-avresample --enable-avfilter --enable-gnutls --enable-gpl --enable-libass --enable-libmp3lame --enable-libvorbis --enable-libvpx --enable-libxvid --enable-libx264 --enable-libx265 --enable-libtheora --enable-libv4l2 --enable-libdav1d --enable-postproc --enable-pic --enable-pthreads --enable-shared --enable-libxcb --enable-libsrt --enable-libssh --enable-libvidstab --disable-stripping --disable-static --disable-librtmp --enable-vaapi --enable-vdpau --enable-libopus --enable-vulkan --enable-libsoxr --enable-libwebp --enable-libaom --disable-debug","  libavutil      56. 70.100 / 56. 70.100","  libavcodec     58.134.100 / 58.134.100","  libavformat    58. 76.100 / 58. 76.100","  libavdevice    58. 13.100 / 58. 13.100","  libavfilter     7.110.100 /  7.110.100","  libavresample   4.  0.  0 /  4.  0.  0","  libswscale      5.  9.100 /  5.  9.100","  libswresample   3.  9.100 /  3.  9.100","  libpostproc    55.  9.100 / 55.  9.100","/data/XXXX/files_trashbin/files/18-06-01 14-23-22 28E3.mp4.d1651894617: Invalid data found when processing input"]

at 2022-05-07T22:52:12+00:00

 

I have exactly the same Problem and don't know how to fix...

 

Movie preview generation failed Output: {"0":"ffmpeg version 4.4.1 Copyright (c) 2000-2021 the FFmpeg developers","1":" built with gcc 10.3.1 (Alpine 10.3.1_git20210424) 20210424","2":" configuration: --prefix=/usr --enable-avresample --enable-avfilter --enable-gnutls --enable-gpl --enable-libass --enable-libmp3lame --enable-libvorbis --enable-libvpx --enable-libxvid --enable-libx264 --enable-libx265 --enable-libtheora --enable-libv4l2 --enable-libdav1d --enable-postproc --enable-pic --enable-pthreads --enable-shared --enable-libxcb --enable-libsrt --enable-libssh --enable-libvidstab --disable-stripping --disable-static --disable-librtmp --enable-vaapi --enable-vdpau --enable-libopus --enable-vulkan --enable-libsoxr --enable-libwebp --enable-libaom --disable-debug","3":" libavutil 56. 70.100 / 56. 70.100","4":" libavcodec 58.134.100 / 58.134.100","5":" libavformat 58. 76.100 / 58. 76.100","6":" libavdevice 58. 13.100 / 58. 13.100","7":" libavfilter 7.110.100 / 7.110.100","8":" libavresample 4. 0. 0 / 4. 0. 0","9":" libswscale 5. 9.100 / 5. 9.100","10":" libswresample 3. 9.100 / 3. 9.100","11":" libpostproc 55. 9.100 / 55. 9.100","12":"Input #0, mov,mp4,m4a,3gp,3g2,mj2

Link to comment
Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

sometimes when i reboot the nextcloud will show this.

i am so confused about ti.

the sql is postgresql14

wish somebody can help me

thank you

  • Upvote 1
Link to comment
On 4/16/2021 at 3:07 PM, johnwhicker said:

WebUI.  I am doing a CLI now,    docker exec -it nextcloud updater.phar

 

So now is tuck again:

 

root@NAS-UNRAID:~#

root@NAS-UNRAID:~# docker exec -it nextcloud updater.phar

Nextcloud Updater - version: v20.0.0beta4-11-g68fa0d4

 

Current version is 21.0.0.

 

Update to Nextcloud 21.0.1 available. (channel: "stable")

Following file will be downloaded automatically: https://download.nextcloud.com/server/releases/nextcloud-21.0.1.zip

Open changelog ↗

 

Steps that will be executed:

[✔] Check for expected files

[✔] Check for write permissions

[✔] Create backup

[✔] Downloading

[✔] Verify integrity

[✔] Extracting

[✔] Enable maintenance mode

[✔] Replace entry points

[✔] Delete old files

[ ] Move new files in place

[ ] Done

 

I am so glade I found this. I just got stuck in the WebUI trying to do an update.

Link to comment

After upgrading to 24.01 I'm getting this Integrity error ( see below )

 

Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results
=======
- openotp_auth
	- INVALID_HASH
		- vendor/autoload.php
		- vendor/composer/autoload_real.php
		- vendor/composer/autoload_static.php
		- vendor/composer/installed.php

Raw output
==========
Array
(
    [openotp_auth] => Array
        (
            [INVALID_HASH] => Array
                (
                    [vendor/autoload.php] => Array
                        (
                            [expected] => f5a41293b34793060b5e6060a297c706445208d97e5c90de46ed2c1e1df6c424e2907bf5207eb530c71ddf00478b812efd219e155cf5fcdc38e6d65ea428637a
                            [current] => 660a73bf37427c5545c93edd8f8f46c25adbbf4c8584a2b5655ea0ae149ce09a67d9e831ccbe7ac2ece39386e8aa44ce4ee12de30f8e924523278b6b8d883d4d
                        )

                    [vendor/composer/autoload_real.php] => Array
                        (
                            [expected] => 6a47d948441204a61bc1672c1f1b3182e0754a780273f477bae7e08115a0ad5039e111c373a27c3676d5734f5bb0da0fac710f33008ea01d38face8fd6d567d9
                            [current] => c2ec4555396b06b813b920c1ae756344265af2e2c81209c1ef92d9fd5c30f07d87736e8fb5c486b6a18654a1e0801eafce2572a7c7d0238a38665f0145913e9d
                        )

                    [vendor/composer/autoload_static.php] => Array
                        (
                            [expected] => ff928dc7f4a797a8cb4b546815ec34594b0a3609265b5c40e52aae40ab364c3a55a7872bcd1dac8e05eab6c041fa354a658dbe76ea4379d333c6cdfc655fea28
                            [current] => dd57695a595bd4f142fc8944d96aba5c5aa92169421c287c7e5b588b9c2f81b8ed92e0b77c056f6b6f08a5d35f2301e703e1e8f8514c363db02dd2716b3d5306
                        )

                    [vendor/composer/installed.php] => Array
                        (
                            [expected] => fad34430e38eca6338a4b6d45da117c5c43b5f8926066b6589d5fa6825bfaaa56855b384b43a9a3056280d647c4f2332c3f3618c48ed515750e1ad14b41bdee6
                            [current] => 352f51f9e3c25a8497e2bd0b936dbfea4823355eb298ab857b87ec98fae2db69b0460048fe341e620e44c07437aa3df4b40d5961e216d13c353aea0c92118079

 

Anyone have any ideas on how I can square this away? I checked the documentation but all it posted ws about /index.php and /version.php. I'm not sure how to fix the above ones I have.

 

Thanks in advance.

Link to comment
Posted (edited)
On 5/5/2022 at 2:39 PM, Zeze21 said:

Hi Guys,

i tried updating my Nextcloud via the integrated Updater, but unfortunately I ran into several problems I was not able to solve myself. I have checked this thread, several other sources (like the Nextcloud forums) and unfortunately I get stuck at every solution I was able to find. But first things first, here's what happened:

1.) I started the web based updater: I get until step 3 then I get the following Error:

<html>
<head><title>504 Gateway Time-out</title></head>
<body>
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->

On clicking Retry Update I get:

Step 3 is currently in process. Please reload this page later.

If i delete the .step file I get back to the first problem.

2.) So I tried: 

docker exec -it nextcloud sudo -u abc php /config/www/nextcloud/updater/updater.phar

I get an error at Point 6

[✔] Check for expected files
[✔] Check for write permissions
[✔] Create backup
[✔] Downloading
[✔] Verify integrity
[ ] Extracting ...PHP Warning:  require(/config/www/nextcloud/updater/../version.php): failed to open stream: No such file or directory in phar:///config/www/nextcloud/updater/updater.phar/lib/Updater.php on line 658
PHP Fatal error:  require(): Failed opening required '/config/www/nextcloud/updater/../version.php' (include_path='.:/usr/share/php7') in phar:///config/www/nextcloud/updater/updater.phar/lib/Updater.php on line 658

I tried copying the version.php into that folder but that did not work either

3.) The occ command does not work at all at least I can't get it to work

 

SOLUTION (i found while typing this - i am leaving everything so others with the same error can find it easier)

I copied the missing file (version.php) from the nextcloud/update_somerandomstring/downloads/nextcloud/ to the  appdata/nextcloud/www/nextcloud/ folder and also the shipped.json to the /core/ subfolder. Then 

docker exec -it nextcloud sudo -u abc php /config/www/nextcloud/updater/updater.phar

works just fine...

 

Hey I am unable to figure out where shipped.json should be moved to. I found it in the "nextcloud/update_somerandomstring/downloads/nextcloud/core" folder but dont know where it needs to be copied to. Appreciate any help.

 

edit: i figured it out. you make a new folder called core and move the shipped.json file into it at appdata/nextcloud/www/nextcloud

Edited by hmoney007
Link to comment

I've just finished setting up nextcloud as per the latest tutorial from Spaceinvador One, and I have everything working, except that my router does not support NAT loopback. This means I cannot access nextcloud via the domain name I set up from within my local network, but can still use the local ip address along with port 444. This obviously creates problems with devices that move in and out of my local network as I cannot have both addresses setup on them (as far as I know).

 

Does anyone here know of a workaround for no NAT loopback?  (Other than buying a new router as this isn't an option right now)

 

From my research on it people have been able to get around this issue by running a local DNS which resolves the domain name used for external access into a local IP address, so the router never has to deal with it. I installed pihole to see if I could do this, but DNS doesn't resolve an IP address with a port number, just an IP. So this would only get me as far as having my domain name point to my server IP, but not to the nextcloud docker on port 444. I saw one or two people on other forums mention SRV records as a way to include ports, but information on that starts getting very technical and quickly goes over my head.

 

Any help/suggestions would be great!

 

 

Link to comment
Posted (edited)

Tried updating to 24.0.1 using docker exec -it nextcloud updater.phar in a terminal.

 

All seemed to run ok and then I get the following error about an unhandled exception when the occ upgrade is executed

 

Update of code successful.

Should the "occ upgrade" command be executed? [Y/n] 
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Setting log level to debug
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Repair SQLite autoincrement
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Updating database schema
Updated database
An unhandled exception has been thrown:
TypeError: fwrite() expects parameter 1 to be resource, bool given in /config/www/nextcloud/lib/private/Security/CertificateManager.php:161
Stack trace:
#0 /config/www/nextcloud/lib/private/Security/CertificateManager.php(161): fwrite()
#1 /config/www/nextcloud/lib/private/Security/CertificateManager.php(247): OC\Security\CertificateManager->createCertificateBundle()
#2 /config/www/nextcloud/lib/private/Http/Client/Client.php(127): OC\Security\CertificateManager->getAbsoluteBundlePath()
#3 /config/www/nextcloud/lib/private/Http/Client/Client.php(74): OC\Http\Client\Client->getCertBundle()
#4 /config/www/nextcloud/lib/private/Http/Client/Client.php(218): OC\Http\Client\Client->buildRequestOptions()
#5 /config/www/nextcloud/lib/private/App/AppStore/Fetcher/Fetcher.php(120): OC\Http\Client\Client->get()
#6 /config/www/nextcloud/lib/private/App/AppStore/Fetcher/AppFetcher.php(87): OC\App\AppStore\Fetcher\Fetcher->fetch()
#7 /config/www/nextcloud/lib/private/App/AppStore/Fetcher/Fetcher.php(192): OC\App\AppStore\Fetcher\AppFetcher->fetch()
#8 /config/www/nextcloud/lib/private/App/AppStore/Fetcher/AppFetcher.php(188): OC\App\AppStore\Fetcher\Fetcher->get()
#9 /config/www/nextcloud/lib/private/Installer.php(422): OC\App\AppStore\Fetcher\AppFetcher->get()
#10 /config/www/nextcloud/lib/private/Updater.php(413): OC\Installer->isUpdateAvailable()
#11 /config/www/nextcloud/lib/private/Updater.php(274): OC\Updater->upgradeAppStoreApps()
#12 /config/www/nextcloud/lib/private/Updater.php(133): OC\Updater->doUpgrade()
#13 /config/www/nextcloud/core/Command/Upgrade.php(235): OC\Updater->upgrade()
#14 /config/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Upgrade->execute()
#15 /config/www/nextcloud/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run()
#16 /config/www/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
#17 /config/www/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
#18 /config/www/nextcloud/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run()
#19 /config/www/nextcloud/console.php(99): OC\Console\Application->run()
#20 /config/www/nextcloud/occ(11): require_once('/config/www/nex...')
#21 {main}
Keep maintenance mode active? [y/N] 
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Maintenance mode disabled

Maintenance mode is disabled

 

Then when trying to log into the web UI I get:

Quote

 

Nextcloud will be updated to version 24.0.1

Please make sure that the database, the config folder and the data folder have been backed up before proceeding.

 

 

Where do I even begin?

 

EDIT:

Tried the OCC Upgrade command and have the same error

Also tried sudo -u abc php occ maintenance:repair and running upgrade again but still getting the same error

 

 

Edited by Yak
Updates to actions taken
Link to comment

@Yak What happens if you just run the command again? I have found that in most cases, it should just resume from where it left off.

 

For the web interface message, is there not a button to continue or accept?

 

Just having a look at that error part, you may want to make sure php is up to date, just run `php occ updater.phar` in terminal and see if php is up to date, then give the update another try. I find when I get issues to try running the update again as sometimes a spotty network can cause issues.

Link to comment
On 8/8/2020 at 12:16 PM, Serenity_Duck said:

Hi,

 

did someone found a solution for this Error?

Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		36 minutes ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		13 hours ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		a day ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		2 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		2 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		3 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		3 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		4 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		4 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		5 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		5 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		6 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		6 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		7 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		7 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158		8 days ago
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#158

I have it multiple times a day, it's always exactly the same Error.

I already tried to fix it, but I can't figure it out.

 

Can someone help me out? Thank you

Did anyone find a solution to this? It doesn't seem that anyone has answered/fixed this...

 

I'm having the same issue:

Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 22855560 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T23:40:07+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 19880320 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T23:35:06+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 26600048 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T23:33:42+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 24337880 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T23:10:07+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 25542576 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T23:08:49+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 25456520 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:45:05+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 28203736 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:40:10+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 25581824 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:35:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 24426640 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:30:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 24615896 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:25:08+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 25445312 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:20:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 22121840 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:15:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 65536 bytes) at /config/www/nextcloud/apps/maps/lib/Service/PhotofilesService.php#380		2022-06-09T22:10:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 23537504 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T22:05:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 65536 bytes) at /config/www/nextcloud/apps/maps/lib/Service/PhotofilesService.php#380		2022-06-09T22:00:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 24188184 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:55:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 19824288 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:50:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 25270688 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:45:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 21466912 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:40:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 22498872 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:35:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 16384 bytes) at /config/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php#92		2022-06-09T21:30:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 21053904 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:25:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20654040 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:20:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20363784 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:15:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 65536 bytes) at /config/www/nextcloud/apps/maps/lib/Service/PhotofilesService.php#380		2022-06-09T21:10:08+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 21279744 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:05:08+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 22897184 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T21:00:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 20482400 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:50:10+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 18536088 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:45:10+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 23697816 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:40:10+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 26471248 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:35:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 26551456 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:30:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 26054920 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:25:10+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 26136152 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:20:09+0200
Error	PHP	Allowed memory size of 536870912 bytes exhausted (tried to allocate 29632704 bytes) at /config/www/nextcloud/lib/private/Files/Storage/Local.php#291		2022-06-09T20:15:09+0200

 

I set up Nextcloud using Spaceinvader Ones new two-part videos:

 

 

 

I'm using the dockers cloudflare ddns, mariadb, swag, and obviously nextcloud.

 

/etc/php/php.ini setting "memory_limit = 2G" didn't help

/appdata/nextcloud/www/nextcloud/.htaccess setting this didn't help either:

# PHP 7.x
<IfModule mod_php7.c>
  php_value mbstring.func_overload 0
  php_value default_charset 'UTF-8'
  php_value output_buffering 0
  php_value memory_limit 2G
  php_value upload_max_filesize 16G
  php_value post_max_size 16G
  php_value max_input_time 3600
  php_value max_execution_time 3600
  <IfModule mod_env.c>
    SetEnv htaccessWorking true
  </IfModule>
</IfModule>

# PHP 8+
<IfModule mod_php.c>
  php_value mbstring.func_overload 0
  php_value default_charset 'UTF-8'
  php_value output_buffering 0
  php_value memory_limit 2G
  php_value upload_max_filesize 16G
  php_value post_max_size 16G
  php_value max_input_time 3600
  php_value max_execution_time 3600
  <IfModule mod_env.c>
    SetEnv htaccessWorking true
  </IfModule>
</IfModule>

 

This didn't help either:

/appdata/swag/nginx/proxy-confs/nextcloud.subdomain.conf "proxy_max_temp_file_size 2048m;"

 

I'm going out of ideas to fix this and can't find any other place to  check. Is there something in Cloudflare that I must set up differently?

Link to comment

Hello all,

I'm unable to get this image running. I can get to the setup page of Nextcloud but after entering the info I get a 504 error and then redirected to the setup page. I have to manually clear the AppData for nextcloud each time because if I keep trying it tells me the user already exists. The logs have this repeating message:

 

Exception: Not installed in /config/www/nextcloud/lib/base.php:282
Stack trace:
#0 /config/www/nextcloud/lib/base.php(663): OC::checkInstalled()
#1 /config/www/nextcloud/lib/base.php(1104): OC::init()
#2 /config/www/nextcloud/cron.php(43): require_once('/config/www/nex...')
#3 {main}

 

I've searched and haven't come up with any solutions. I did notice the download from Community Applications was quite slow but maybe the servers are just under load. Thanks!

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.