Internal server error after crash and new installation of AiO

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
, , , , , ,
1
Support intro

Sorry to hear you’re facing problems. :slightly_frowning_face:

The community help forum (help.nextcloud.com) is for home and non-enterprise users. Support is provided by other community members on a best effort / “as available” basis. All of those responding are volunteering their time to help you.

If you’re using Nextcloud in a business/critical setting, paid and SLA-based support services can be accessed via portal.nextcloud.com where Nextcloud engineers can help ensure your business keeps running smoothly.

Getting help

In order to help you as efficiently (and quickly!) as possible, please fill in as much of the below requested information as you can.

Before clicking submit: Please check if your query is already addressed via the following resources:

(Utilizing these existing resources is typically faster. It also helps reduce the load on our generous volunteers while elevating the signal to noise ratio of the forums otherwise arising from the same queries being posted repeatedly).

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can. :heart:

The Basics

  • Nextcloud Server version (e.g., 29.x.x):
    • 31.0.7 ( Nextcloud AIO v11.5.0)
  • Operating system and version (e.g., Ubuntu 24.04):
    • Raspberry Pi OS
      PRETTY_NAME=“Debian GNU/Linux 11 (bullseye)”
      NAME=“Debian GNU/Linux”
      VERSION_ID=“11”
      VERSION=“11 (bullseye)”
      VERSION_CODENAME=bullseye
      ID=debian
  • Web server and version (e.g, Apache 2.4.25):
    • Apache 2.4.65
  • Reverse proxy and version _(e.g. nginx 1.27.2)
    • no
  • PHP version (e.g, 8.3):
    • PHP 8.3.23
  • Is this the first time you’ve seen this error? (Yes / No):
    • Yes
  • When did this problem seem to first start?
    • After a crash of the Raspberry Pi
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
    • AIO
  • Are you using CloudfIare, mod_security, or similar? (Yes / No)
    • No

Summary of the issue you are facing:

After a crash of Raspberry Pi all docker containers disappeared. After a new installation of docker Nexcloud AIO everything shows healthy but i get the internal server error when accessing my URL of Nextcloud

Steps to replicate it (hint: details matter!):

Today i wanted to do the update of AIO from 31.0.6 to 31.0.7. After stopping the mastercontainer i wanted to update it, but Nextcloud gave me a server connection error and could not start the update. I rebooted the Raspberry Pi and after rebooting it i could not connect to it. Somehow the IP address of the Raspi was gone. I set it again and could access the Raspi. Then i started portainer in the web browser, but no connection was possible. I listed the containers with docker ps, no containers there. I looked for the container files, all was gone. I installed portainer and checked images and volumes, all was gone, not one of them was showing up in portainer (except of portainer itself).

I found the volume folders and overlay2 folders under LOST AND FOUND. So i copied them to /var/lib/docker. I made a new installation of Nextcloud AIO with the suggested command:
sudo docker run --init --sig-proxy=false --name nextcloud-aio-mastercontainer --restart always --publish 80:80 --publish 8080:8080 --publish 8443:8443 --volume nextcloud_aio_mastercontainer:/mnt/docker-aio-config --volume /var/run/docker.sock:/var/run/docker.sock:ro Package all-in-one · GitHub

It worked fine, the installation was completed without any errors and now everything is showing healthy: in portainer and in the Nextloud Admin center.
But i can not access my Nextcloud site. Error message:
“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.”

Log entries

Nextcloud

Please provide the log entries from your Nextcloud log that are generated during the time of problem (via the Copy raw option from Administration settings->Logging screen or from your nextcloud.log located in your data directory). Feel free to use a pastebin/gist service if necessary.

Auth.php","line":179,"function":"isLoggedIn","class":"OC\\User\\Session","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Auth.php","line":105,"function":"auth","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":179,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":135,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php","line":456,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["beforeMethod:PROPFIND",[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Server.php","line":49,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/apps/dav/lib/Server.php","line":401,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->","args":[]},{"file":"/var/www/html/apps/dav/appinfo/v2/remote.php","line":21,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/remote.php","line":145,"args":["/var/www/html/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","Code":"58P01","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = ?) AND (\"lazy\" = ?)",["aw",0],[2,1],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = :dcValue1) AND (\"lazy\" = :dcValue2)",{"dcValue1":"aw","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)",{"dcValue1":"aw","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":1720,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":153,"function":"loadConfig","class":"OC\\Config\\UserConfig","type":"->","args":["aw",false]},{"file":"/var/www/html/lib/private/AllConfig.php","line":282,"function":"hasKey","class":"OC\\Config\\UserConfig","type":"->","args":["aw","core","enabled"]},{"file":"/var/www/html/lib/private/User/User.php","line":463,"function":"getUserValue","class":"OC\\AllConfig","type":"->","args":["aw","core","enabled","true"]},{"file":"/var/www/html/lib/private/User/User.php","line":471,"function":"OC\\User\\{closure}","class":"OC\\User\\User","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":226,"function":"isEnabled","class":"OC\\User\\User","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Auth.php","line":179,"function":"isLoggedIn","class":"OC\\User\\Session","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Auth.php","line":105,"function":"auth","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":179,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":135,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php","line":456,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["beforeMethod:PROPFIND",[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Server.php","line":49,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/apps/dav/lib/Server.php","line":401,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->","args":[]},{"file":"/var/www/html/apps/dav/appinfo/v2/remote.php","line":21,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/remote.php","line":145,"args":["/var/www/html/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","exception":{"query":"SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)"},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory"}}
{"reqId":"37O7IPZxT0aCiiMVtsrT","level":3,"time":"2025-08-15T18:12:20+00:00","remoteAddr":"81.16.105.199","user":"aw","app":"webdav","method":"PROPFIND","url":"/remote.php/dav/files/aw/","message":"OC\\DB\\Exceptions\\DbalException: An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","userAgent":"Mozilla/5.0 (Linux) mirall/3.13.4git (Nextcloud, mageia-6.6.101-desktop-1.mga9 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"31.0.7.1","clientReqId":"59140091-2ce3-4c38-8ee6-6d0d6d5768f3","exception":{"Exception":"Sabre\\DAV\\Exception\\ServiceUnavailable","Message":"OC\\DB\\Exceptions\\DbalException: An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":179,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":135,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php","line":456,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["beforeMethod:PROPFIND",[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Server.php","line":49,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/apps/dav/lib/Server.php","line":401,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->","args":[]},{"file":"/var/www/html/apps/dav/appinfo/v2/remote.php","line":21,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/remote.php","line":145,"args":["/var/www/html/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/apps/dav/lib/Connector/Sabre/Auth.php","Line":112,"message":"OC\\DB\\Exceptions\\DbalException: An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","exception":{},"CustomMessage":"OC\\DB\\Exceptions\\DbalException: An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory"}}
{"reqId":"QVkPACmQ6GqQ46A75Rxf","level":3,"time":"2025-08-15T18:12:38+00:00","remoteAddr":"81.16.105.199","user":"--","app":"index","method":"GET","url":"/index.php/apps/notify_push/uid","message":"An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","userAgent":"--","version":"31.0.7.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","Code":7,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":53,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\DriverException"},"","SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)"]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":1720,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":153,"function":"loadConfig","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AllConfig.php","line":282,"function":"hasKey","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled"]},{"file":"/var/www/html/lib/private/User/User.php","line":463,"function":"getUserValue","class":"OC\\AllConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled","true"]},{"file":"/var/www/html/lib/private/User/User.php","line":471,"function":"OC\\User\\{closure}","class":"OC\\User\\User","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":318,"function":"isEnabled","class":"OC\\User\\User","type":"->","args":[]},{"file":"/var/www/html/lib/private/User/Session.php","line":619,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":305,"function":"loginWithToken","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":405,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":544,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1125,"function":"tryBasicAuthLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1029,"function":"handleLogin","class":"OC","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":56,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1111,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = ?) AND (\"lazy\" = ?)",["*** sensitive parameters replaced ***",0],[2,1]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = ?) AND (\"lazy\" = ?)",["*** sensitive parameters replaced ***",0],[2,1],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = :dcValue1) AND (\"lazy\" = :dcValue2)",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":1720,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":153,"function":"loadConfig","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AllConfig.php","line":282,"function":"hasKey","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled"]},{"file":"/var/www/html/lib/private/User/User.php","line":463,"function":"getUserValue","class":"OC\\AllConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled","true"]},{"file":"/var/www/html/lib/private/User/User.php","line":471,"function":"OC\\User\\{closure}","class":"OC\\User\\User","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":318,"function":"isEnabled","class":"OC\\User\\User","type":"->","args":[]},{"file":"/var/www/html/lib/private/User/Session.php","line":619,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":305,"function":"loginWithToken","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":405,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":544,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1125,"function":"tryBasicAuthLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1029,"function":"handleLogin","class":"OC","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":87,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["58P01",7,"ERROR:  could not open file \"base/16384/18100\": No such file or directory"]}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = ?) AND (\"lazy\" = ?)",["*** sensitive parameters replaced ***",0],[2,1],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = :dcValue1) AND (\"lazy\" = :dcValue2)",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":1720,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":153,"function":"loadConfig","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AllConfig.php","line":282,"function":"hasKey","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled"]},{"file":"/var/www/html/lib/private/User/User.php","line":463,"function":"getUserValue","class":"OC\\AllConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled","true"]},{"file":"/var/www/html/lib/private/User/User.php","line":471,"function":"OC\\User\\{closure}","class":"OC\\User\\User","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":318,"function":"isEnabled","class":"OC\\User\\User","type":"->","args":[]},{"file":"/var/www/html/lib/private/User/Session.php","line":619,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":305,"function":"loginWithToken","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":405,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":544,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1125,"function":"tryBasicAuthLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1029,"function":"handleLogin","class":"OC","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","Code":"58P01","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = ?) AND (\"lazy\" = ?)",["*** sensitive parameters replaced ***",0],[2,1],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"appid\", \"configkey\", \"configvalue\", \"type\", \"flags\" FROM \"oc_preferences\" WHERE (\"userid\" = :dcValue1) AND (\"lazy\" = :dcValue2)",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":0},{"dcValue1":2,"dcValue2":1}]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":1720,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Config/UserConfig.php","line":153,"function":"loadConfig","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AllConfig.php","line":282,"function":"hasKey","class":"OC\\Config\\UserConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled"]},{"file":"/var/www/html/lib/private/User/User.php","line":463,"function":"getUserValue","class":"OC\\AllConfig","type":"->","args":["*** sensitive parameters replaced ***","core","enabled","true"]},{"file":"/var/www/html/lib/private/User/User.php","line":471,"function":"OC\\User\\{closure}","class":"OC\\User\\User","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":318,"function":"isEnabled","class":"OC\\User\\User","type":"->","args":[]},{"file":"/var/www/html/lib/private/User/Session.php","line":619,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":305,"function":"loginWithToken","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":405,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":544,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1125,"function":"tryBasicAuthLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/base.php","line":1029,"function":"handleLogin","class":"OC","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory","exception":{"query":"SELECT `appid`, `configkey`, `configvalue`, `type`, `flags` FROM `*PREFIX*preferences` WHERE (`userid` = :dcValue1) AND (`lazy` = :dcValue2)"},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[58P01]: Undefined file: 7 ERROR:  could not open file \"base/16384/18100\": No such file or directory"}}

Web Browser

If the problem is related to the Web interface, open your browser inspector Console and Network tabs while refreshing (reloading) and reproducing the problem. Provide any relevant output/errors here that appear.

PASTE

Web server / Reverse Proxy

The output of your Apache/nginx/system log in /var/log/____:

PASTE HERE

Configuration

Nextcloud

The output of occ config:list system or similar is best, but, if not possible, the contents of your config.php file from /path/to/nextcloud is fine (make sure to remove any identifiable information!):

{
    "system": {
        "one-click-instance": true,
        "one-click-instance.user-limit": 100,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "appsallowlist": false,
        "check_data_directory_permissions": false,
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "overwritehost": "mynextcloud.net",
        "overwriteprotocol": "https",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "mynextcloud.net"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "31.0.7.1",
        "overwrite.cli.url": "https:\/\/mynextcloud.net\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "updatedirectory": "\/nc-updater",
        "loglevel": 2,
        "log_type": "file",
        "logfile": "\/var\/www\/html\/data\/nextcloud.log",
        "log_rotate_size": 10485760,
        "log.condition": {
            "apps": [
                "admin_audit"
            ]
        },
        "preview_max_x": 2048,
        "preview_max_y": 2048,
        "jpeg_quality": 60,
        "enabledPreviewProviders": {
            "1": "OC\\Preview\\Image",
            "2": "OC\\Preview\\MarkDown",
            "3": "OC\\Preview\\MP3",
            "4": "OC\\Preview\\TXT",
            "5": "OC\\Preview\\OpenDocument",
            "6": "OC\\Preview\\Movie",
            "7": "OC\\Preview\\Krita",
            "0": "OC\\Preview\\Imaginary",
            "23": "OC\\Preview\\ImaginaryPDF"
        },
        "enable_previews": true,
        "upgrade.disable-web": true,
        "mail_smtpmode": "smtp",
        "trashbin_retention_obligation": "auto, 30",
        "versions_retention_obligation": "auto, 30",
        "activity_expire_days": 30,
        "simpleSignUpLink.shown": false,
        "share_folder": "\/Shared",
        "one-click-instance.link": "https:\/\/nextcloud.com\/all-in-one\/",
        "upgrade.cli-upgrade-link": "https:\/\/github.com\/nextcloud\/all-in-one\/discussions\/2726",
        "maintenance_window_start": 100,
        "allow_local_remote_servers": true,
        "davstorage.request_timeout": 3600,
        "htaccess.RewriteBase": "\/",
        "dbpersistent": false,
        "auth.bruteforce.protection.enabled": true,
        "ratelimit.protection.enabled": true,
        "files_external_allow_create_new_local": false,
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "preview_imaginary_url": "***REMOVED SENSITIVE VALUE***",
        "preview_imaginary_key": "***REMOVED SENSITIVE VALUE***",
        "documentation_url.server_logs": "https:\/\/github.com\/nextcloud\/all-in-one\/discussions\/5425",
        "updatechecker": false,
        "DOMAIN": "mynextcloud.net"
    }
}

Apps

The output of occ app:list (if possible).

  • activity: 4.0.0
  • admin_audit: 1.21.0
  • bruteforcesettings: 4.0.0
  • calendar: 5.3.6
  • circles: 31.0.0
  • cloud_federation_api: 1.14.0
  • comments: 1.21.0
  • contacts: 7.2.0
  • contactsinteraction: 1.12.0
  • dashboard: 7.11.0
  • dav: 1.33.0
  • deck: 1.15.1
  • federatedfilesharing: 1.21.0
  • federation: 1.21.0
  • files: 2.3.1
  • files_downloadlimit: 4.0.0
  • files_pdfviewer: 4.0.0
  • files_reminders: 1.4.0
  • files_sharing: 1.23.1
  • files_trashbin: 1.21.0
  • files_versions: 1.24.0
  • firstrunwizard: 4.0.0
  • logreader: 4.0.0
  • lookup_server_connector: 1.19.0
  • nextcloud-aio: 0.8.0
  • nextcloud_announcements: 3.0.0
  • notes: 4.12.2
  • notifications: 4.0.0
  • notify_push: 1.1.1
  • oauth2: 1.19.1
  • password_policy: 3.0.0
  • photos: 4.0.0
  • privacy: 3.0.0
  • profile: 1.0.0
  • provisioning_api: 1.21.0
  • recommendations: 4.0.0
  • related_resources: 2.0.0
  • richdocuments: 8.7.3
  • serverinfo: 3.0.0
  • settings: 1.14.0
  • sharebymail: 1.21.0
  • spreed: 21.1.3
  • support: 3.0.0
  • survey_client: 3.0.0
  • systemtags: 1.21.1
  • tasks: 0.16.1
  • text: 5.0.0
  • theming: 2.6.1
  • twofactor_backupcodes: 1.20.0
  • twofactor_totp: 13.0.0-dev.0
  • updatenotification: 1.21.0
  • user_migration: 8.0.0
  • user_status: 1.11.0
  • viewer: 4.0.0
  • weather_status: 1.11.0
  • webhook_listeners: 1.2.0
  • whiteboard: 1.1.2
  • workflowengine: 2.13.0
    Disabled:
  • app_api: 5.0.2 (installed 4.0.5)
  • encryption: 2.19.0
  • files_external: 1.23.0
  • suspicious_login: 9.0.1
  • twofactor_nextcloud_notification: 5.0.0
  • user_ldap: 1.22.0

I see a lot of database errors … but don’t know what to do with them.
Any ideas if and how i could fix the access to my site?
Would a

php occ files:scan --all

help?

Thanks a lot!

Best regards
egc

Tips for increasing the likelihood of a response

  • Use the preformatted text formatting option in the editor for all log entries and configuration output.
  • If screenshots are useful, feel free to include them.
    • If possible, also include key error output in text form so it can be searched for.
  • Try to edit log output only minimally (if at all) so that it can be ran through analyzers / formatters by those trying to help you.
4

For database conflicts and issues, there are repair mechanisms. I’m not using the docker setup, so I don’t know in which container it is and how you execute commands there, but you should find in the documentation. You should put the NC in maintenance mode first, so it does not access the database.

Normally, there shouldn’t be problems in the database, it can happen if it has to shut down suddenly (system crash, running out of memory, …). For RPi, if you have no suitable power supply, there might be just power shortage, or if you request too much power via connected USB devices (normally, this should show on connected screens and probably log somewhere). Also on aging disks with dying sectors can cause such problems, especially if the setup has run without problem in similar conditions before. Especially the problems right after a new install are a warning sign here. And finally, the RaspberryPi is a tiny device, if you use more and more your Nextcloud, or if you invite more and more users, you drive the system to its limits.

5

This looks like you have a problem with your raspi purging your files on the disk. The database cannot load its Data.

In AIO there is the Borg- Backup- Option. If you have - use a backup on a fresh AIO (remove your Volumes from Docker and recreate them to get an initial AIO- Setup, where you can get your Files from. (you should always do backups regularly, especially before Update!)

Otherwise you may check where you PG-Data is gone, maybe lost and found too.

But more important would be to find out, why your docker volume were trashed to lost and found. This looks like serioues filesystem troubles.