PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/lib/private/Files/Storage/Local.php on line 190

Nextcloud version (eg, 29.0.5): 29.0.2 docker https://hub.docker.com/_/nextcloud
Operating system and version (eg, Ubuntu 29.04): Docker(Debian 12)
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.59 (Debian)
PHP version (eg, 8.3): 8.2.20 (cli)

The issue you are facing:
occ scan leads to fatal error

Is this the first time you’ve seen this error? (Y/N):
yes

Steps to replicate it:

  1. sudo docker exec -u 33 nextcloud-app-1 php occ files:scan USERNAME
  2. see error

The output of your Nextcloud log in Admin > Logging:

{"reqId":"iL4fucMUzPZoRB5VeddD","level":0,"time":"2024-06-19T08:00:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","userAgent":"--","version":"29.0.2.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1",[1718740801,1718784001,1],[1,1,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":230,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/cron.php","line":163,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->","args":[true]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_talk_internalsignaling","oc_comments","oc_talk_proxy_messages","oc_deck_sessions"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1"}}
{"reqId":"iL4fucMUzPZoRB5VeddD","level":0,"time":"2024-06-19T08:00:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Survey_Client\\BackgroundJobs\\MonthlyReport (id: 31637, arguments: null)","userAgent":"--","version":"29.0.2.2","data":{"app":"cron"}}
{"reqId":"iL4fucMUzPZoRB5VeddD","level":0,"time":"2024-06-19T08:00:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","userAgent":"--","version":"29.0.2.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1",[1718740801,1718784001,1],[1,1,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":230,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/cron.php","line":163,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->","args":[true]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_talk_internalsignaling","oc_comments","oc_talk_proxy_messages","oc_deck_sessions"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1"}}
{"reqId":"7yOCGqla5bESyG33FK98","level":0,"time":"2024-06-19T08:00:31+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"dav","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status?format=json","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","data":{"app":"dav","user":"Haui"}}
{"reqId":"UopMibkUBv1vyzRNvvgH","level":0,"time":"2024-06-19T08:00:49+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications","message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0","version":"29.0.2.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)",["Haui",1718783929],[2,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Service/ClientService.php","line":54,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Controller/EndpointController.php","line":107,"function":"hasTalkDesktop","class":"OCA\\Notifications\\Service\\ClientService","type":"->","args":["Haui",1718783929]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"listNotifications","class":"OCA\\Notifications\\Controller\\EndpointController","type":"->","args":["v2"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Notifications\\Controller\\EndpointController","listNotifications",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["v2","ocs.notifications.endpoint.listnotifications"]]},{"file":"/var/www/html/ocs/v1.php","line":66,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/notifications/api/v2/notifications"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","tables":["oc_authtoken"],"reads":["oc_authtoken"],"exception":{},"CustomMessage":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)"}}
{"reqId":"uNo3b9IfKnD6v0v1JMZ5","level":0,"time":"2024-06-19T08:01:31+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"dav","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status?format=json","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","data":{"app":"dav","user":"Haui"}}
{"reqId":"zZMDgxpt64BGKCkYj0uB","level":0,"time":"2024-06-19T08:02:20+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications","message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0","version":"29.0.2.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)",["Haui",1718784020],[2,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Service/ClientService.php","line":54,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Controller/EndpointController.php","line":107,"function":"hasTalkDesktop","class":"OCA\\Notifications\\Service\\ClientService","type":"->","args":["Haui",1718784020]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"listNotifications","class":"OCA\\Notifications\\Controller\\EndpointController","type":"->","args":["v2"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Notifications\\Controller\\EndpointController","listNotifications",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["v2","ocs.notifications.endpoint.listnotifications"]]},{"file":"/var/www/html/ocs/v1.php","line":66,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/notifications/api/v2/notifications"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","tables":["oc_authtoken"],"reads":["oc_authtoken"],"exception":{},"CustomMessage":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)"}}
{"reqId":"Eyk4nbJN3ZgldHgn9SHA","level":0,"time":"2024-06-19T08:02:31+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"dav","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status?format=json","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","data":{"app":"dav","user":"Haui"}}
{"reqId":"dY5SE4KmfLHeC5sLaB4T","level":0,"time":"2024-06-19T08:03:19+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"dav","method":"PUT","url":"/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0","version":"29.0.2.2","data":{"app":"dav","user":"Haui"}}
{"reqId":"MniDe4H7Isi2R2JuWR9W","level":0,"time":"2024-06-19T08:03:31+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","userAgent":"Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)",["Haui",1718784091],[2,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Service/ClientService.php","line":54,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Controller/EndpointController.php","line":107,"function":"hasTalkDesktop","class":"OCA\\Notifications\\Service\\ClientService","type":"->","args":["Haui",1718784091]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"listNotifications","class":"OCA\\Notifications\\Controller\\EndpointController","type":"->","args":["v2"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Notifications\\Controller\\EndpointController","listNotifications",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["v2","ocs.notifications.endpoint.listnotifications"]]},{"file":"/var/www/html/ocs/v1.php","line":66,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/notifications/api/v2/notifications"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","tables":["oc_authtoken","oc_user_status"],"reads":["oc_authtoken"],"exception":{},"CustomMessage":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)"}}
{"reqId":"pSIhIba3NWXImYf8fPOo","level":0,"time":"2024-06-19T08:03:31+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"dav","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status?format=json","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","data":{"app":"dav","user":"Haui"}}
{"reqId":"SViZuLzAelfidNJDu1oq","level":0,"time":"2024-06-19T08:03:50+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications","message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0","version":"29.0.2.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)",["Haui",1718784110],[2,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Service/ClientService.php","line":54,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/notifications/lib/Controller/EndpointController.php","line":107,"function":"hasTalkDesktop","class":"OCA\\Notifications\\Service\\ClientService","type":"->","args":["Haui",1718784110]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"listNotifications","class":"OCA\\Notifications\\Controller\\EndpointController","type":"->","args":["v2"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Notifications\\Controller\\EndpointController","listNotifications",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["v2","ocs.notifications.endpoint.listnotifications"]]},{"file":"/var/www/html/ocs/v1.php","line":66,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/notifications/api/v2/notifications"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)","tables":["oc_authtoken"],"reads":["oc_authtoken"],"exception":{},"CustomMessage":"dirty table reads: SELECT `name` FROM `*PREFIX*authtoken` WHERE (`uid` = :dcValue1) AND (`last_activity` >= :dcValue2)"}}
{"reqId":"R4GcHKavurprEQkWVitA","level":0,"time":"2024-06-19T08:04:31+00:00","remoteAddr":"192.168.178.65","user":"Haui","app":"dav","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status?format=json","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","data":{"app":"dav","user":"Haui"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"Optional parameter $userId declared before required parameter $path is implicitly treated as a required parameter at /var/www/html/custom_apps/deck/lib/Service/ConfigService.php#234","userAgent":"--","version":"29.0.2.2","data":{"app":"PHP"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Files_Sharing\\BackgroundJob\\FederatedSharesDiscoverJob (id: 3, arguments: null)","userAgent":"--","version":"29.0.2.2","data":{"app":"cron"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","userAgent":"--","version":"29.0.2.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1",[1718741102,1718784302,1],[1,1,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":230,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/cron.php","line":163,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->","args":[true]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","tables":["oc_appconfig","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Text\\Cron\\Cleanup (id: 4, arguments: null)","userAgent":"--","version":"29.0.2.2","data":{"app":"cron"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OCA\\Text\\Cron\\Cleanup (id: 4, arguments: null)","userAgent":"--","version":"29.0.2.2","data":{"app":"cron"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"text","method":"","url":"--","message":"Run cleanup job for text documents","userAgent":"--","version":"29.0.2.2","data":{"app":"text"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"text","method":"","url":"--","message":"did not reset document for 431393","userAgent":"--","version":"29.0.2.2","data":{"app":"text"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"text","method":"","url":"--","message":"did not reset document for 435316","userAgent":"--","version":"29.0.2.2","data":{"app":"text"}}
{"reqId":"WceHbku3YstOLd5qlHFc","level":0,"time":"2024-06-19T08:05:02+00:00","remoteAddr":"","user":"--","app":"text","method":"","url":"--","message":"did not reset document for 448250","userAgent":"--","version":"29.0.2.2","data":{"app":"text"}

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'htaccess.RewriteBase' => '/',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'apps_paths' => 
  array (
    0 => 
    array (
      'path' => '/var/www/html/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 => 
    array (
      'path' => '/var/www/html/custom_apps',
      'url' => '/custom_apps',
      'writable' => true,
    ),
  ),
  'instanceid' => '****',
  'passwordsalt' => '****',
  'secret' => '****',
  'trusted_domains' => 
  array (
    0 => '****:8081',
    1 => '****:81',
    2 => '****',
    3 => 'cloud.****.com',
    4 => 'nextcloud-app-1',
    5 => 'localhost',
    6 => '172.27.0.12',
    7 => '127.0.0.1',
    8 => '127.0.1.1',
  ),
  'datadirectory' => '/var/www/html/data',
  'dbtype' => 'mysql',
  'version' => '29.0.2.2',
  'dbname' => 'nextcloud',
  'dbhost' => 'db',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => '****',
  'installed' => true,
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'overwrite.cli.url' => 'https://cloud.****.com',
  'trusted_proxies' => 
  array (
    0 => '172.27.0.11/16',
  ),
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => '****',
  'mail_domain' => '****',
  'mail_smtphost' => 'smtp.****',
  'mail_smtpport' => '465',
  'mail_smtpauth' => 1,
  'mail_smtpname' => '****',
  'mail_smtppassword' => '****',
  'default_phone_region' => 'DE',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => 'redis',
    'password' => '****',
    'port' => 6379,
  ),
  'maintenance_window_start' => 1,
);

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

172.27.0.12 - - [19/Jun/2024:10:19:38 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:19:44 +0200] "PUT /ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:19:48 +0200] "PUT /ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:19:48 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:19:54 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:19:58 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:20:01 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:20:08 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:20:19 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:20:19 +0200] "PUT /ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:20:24 +0200] "PUT /ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:20:25 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:20:29 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:20:31 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 784 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:20:31 +0200] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:20:31 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:20:40 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:20:50 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:20:55 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:21:00 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:21:01 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:21:11 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:21:22 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:21:25 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:21:31 +0200] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:21:31 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:21:31 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 784 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:21:33 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:21:43 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:21:54 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:21:55 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:22:01 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:22:06 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:22:17 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:22:26 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:22:28 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:22:31 +0200] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:22:31 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 784 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:22:31 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:22:38 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:22:49 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:22:53 +0200] "POST /index.php/apps/bookmarks/public/rest/v2/lock HTTP/1.1" 200 1794 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:22:53 +0200] "GET /index.php/apps/bookmarks/public/rest/v2/folder?root=-1&layers=0 HTTP/1.1" 200 1849 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:22:53 +0200] "GET /index.php/apps/bookmarks/public/rest/v2/folder/2/hash HTTP/1.1" 200 1841 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:22:53 +0200] "GET /index.php/apps/bookmarks/public/rest/v2/folder/2/children?layers=1 HTTP/1.1" 200 12408 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:22:53 +0200] "DELETE /index.php/apps/bookmarks/public/rest/v2/lock HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:22:56 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:23:00 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:23:01 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:23:10 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:23:21 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:23:26 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:23:31 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 784 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:23:31 +0200] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 940 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - Haui [19/Jun/2024:10:23:31 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:23:32 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:23:43 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:23:54 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:23:56 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 784 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - Haui [19/Jun/2024:10:24:01 +0200] "PROPFIND /remote.php/dav/files/Haui/ HTTP/1.1" 207 1093 "-" "Mozilla/5.0 (Linux) mirall/3.11.0 (build 19196) (Nextcloud, debian-6.1.0-21-amd64 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
172.27.0.12 - - [19/Jun/2024:10:24:04 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
172.27.0.12 - - [19/Jun/2024:10:24:15 +0200] "GET /index.php/apps/logreader/api/poll?lastReqId=wkoGfsN2v0jm3OVPY3NM HTTP/1.1" 200 812 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /var/www/html/lib/private/Files/Storage/Local.php#190
"19.06.2024, 09:55:28"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /var/www/html/lib/private/Files/Storage/Local.php#190
"19.06.2024, 09:55:28"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /var/www/html/lib/private/Files/Storage/Local.php#190
"19.06.2024, 09:40:19"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /var/www/html/lib/private/Files/Storage/Local.php#190
"19.06.2024, 09:40:19"	
Fehler	PHP	
Optional parameter $userId declared before required parameter $path is implicitly treated as a required parameter at /var/www/html/custom_apps/deck/lib/Service/ConfigService.php#234
"19.06.2024, 09:36:29"	
Fehler	PHP	
Optional parameter $userId declared before required parameter $path is implicitly treated as a required parameter at /var/www/html/custom_apps/deck/lib/Service/ConfigService.php#234
"19.06.2024, 09:36:29"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /var/www/html/lib/private/Files/Storage/Local.php#190
"19.06.2024, 09:18:44"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /var/www/html/lib/private/Files/Storage/Local.php#190
"19.06.2024, 09:18:44"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:10:37"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:10:37"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:10:36"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:10:36"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:48"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:48"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:44"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:44"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:42"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:42"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:42"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:42"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:25"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:25"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:22"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:07:22"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:04:04"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:04:04"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:04:03"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 09:04:03"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:59:22"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:59:22"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:59:22"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:59:22"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 655360 bytes) at /var/www/html/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php#88
"19.06.2024, 08:56:06"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 655360 bytes) at /var/www/html/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php#88
"19.06.2024, 08:56:06"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 655360 bytes) at /var/www/html/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php#88
"19.06.2024, 08:56:02"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 655360 bytes) at /var/www/html/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php#88
"19.06.2024, 08:56:02"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 655360 bytes) at /var/www/html/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php#88
"19.06.2024, 08:55:51"	
Fehler	PHP	
Allowed memory size of 536870912 bytes exhausted (tried to allocate 655360 bytes) at /var/www/html/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php#88
"19.06.2024, 08:55:51"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:53:00"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:53:00"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:53:00"	
Fehler	no app in context	
RuntimeException No provider found for id files
"19.06.2024, 08:53:00"	
Warnung	mail	
itinerary file doesn't exist
"19.06.2024, 09:49:00"	
Warnung	mail	
itinerary file doesn't exist
"19.06.2024, 09:49:00"

What is your question? The log already tells you what the problem is :slightly_smiling_face:

You need more memory/RAM…

You can try adding -vvv to the command to get more verbose output[1]. This may help pinpoint what file is triggering this.

It’s also possible you can fix the issue but bumping up your PHP_MEMORY_LIMIT a bit. It defaults to 512M in that image. You could try 1024M[2].

[1] Using the occ command — Nextcloud latest Administration Manual latest documentation
[2] GitHub - nextcloud/docker: ⛴ Docker image of Nextcloud

2 Likes

Thank you very much for this great and concise answer! :slight_smile:

I tried the verbose output and the moment I reached the photos, it broke down. After upping the memory limit (to 1024M) through compose, it went through without issue.