Database and Web UI problems after update to NC28

ℹ️ Support
, , ,
1

Nextcloud version: 28.0.1
Operating system and version: FreeBSD 13.1-RELEASE-p9 (Jail on a TrueNAS System)
Apache or nginx version: nginx 1.24.0
PHP version: 8.1.25
Update: Performed by Webupdater (previously used for 2 minor updates without issues)

The issue you are facing:
I updated today from Nextcloud 27 to 28 and parts of the webinterface (e.g. viewing of the Logs or the viewing of recent activities) aren’t working anymore and there are errors generated in the log.
The general file system seems to work and the sync is currently not broken
There seems to be a problem with the database connection but I am not able to find the reason.
I can normally connect to the mysql databse with username and passwort and the database “nextcloud” is there.

Is this the first time you’ve seen this error? :Y

Steps to replicate it:

The issue is always there. A restart of the system doesn’t help.

The output of your Nextcloud log in Admin > Logging: (Not available, added the last lines of nextcloud.log)

{"reqId":"bP3vJD7XcmHiHOy4CfiG","level":2,"time":"2024-01-19T18:20:48+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Error while generating metadata for fileid 2852","userAgent":"--","version":"28.0.1.1","exception":{"Exception":"RedisException","Message":"Redis server localhost:6379 went away","Code":0,"Trace":[{"file":"/usr/local/www/nextcloud/lib/private/Memcache/Redis.php","line":137,"function":"incrBy","class":"Redis","type":"->","args":["8ba50b7840db7c9315f02d11f89d8c3e/lockfiles/72f950a35a2d8623cf263149f9b48978",1]},{"file":"/usr/local/www/nextcloud/lib/private/Lock/MemcacheLockingProvider.php","line":61,"function":"inc","class":"OC\\Memcache\\Redis","type":"->","args":["files/72f950a35a2d8623cf263149f9b48978"]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Storage/Common.php","line":765,"function":"acquireLock","class":"OC\\Lock\\MemcacheLockingProvider","type":"->","args":["files/72f950a35a2d8623cf263149f9b48978",1,"home::ncadmin::files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg"]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php","line":607,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg",1,["OC\\Lock\\MemcacheLockingProvider"]]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php","line":607,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg",1,["OC\\Lock\\MemcacheLockingProvider"]]},{"file":"/usr/local/www/nextcloud/lib/private/Files/View.php","line":1938,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg",1,["OC\\Lock\\MemcacheLockingProvider"]]},{"file":"/usr/local/www/nextcloud/lib/private/Files/View.php","line":2048,"function":"lockPath","class":"OC\\Files\\View","type":"->","args":["/ncadmin/files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg",1,false]},{"file":"/usr/local/www/nextcloud/lib/private/Files/View.php","line":1141,"function":"lockFile","class":"OC\\Files\\View","type":"->","args":["/ncadmin/files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg",1]},{"file":"/usr/local/www/nextcloud/lib/private/Files/View.php","line":987,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["fopen","/ncadmin/files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg",["read"],"r"]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Node/File.php","line":116,"function":"fopen","class":"OC\\Files\\View","type":"->","args":["/ncadmin/files/Bilder/2019/Einsatzbilder/191018_Bauwagen/Karl Rehfu\u00df.jpg","r"]},{"file":"/usr/local/www/nextcloud/apps/photos/lib/Listener/ExifMetadataProvider.php","line":63,"function":"fopen","class":"OC\\Files\\Node\\File","type":"->","args":["rb"]},{"file":"/usr/local/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\Photos\\Listener\\ExifMetadataProvider","type":"->","args":[["OCP\\FilesMetadata\\Event\\MetadataLiveEvent"]]},{"file":"/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\FilesMetadata\\Event\\MetadataLiveEvent"],"OCP\\FilesMetadata\\Event\\MetadataLiveEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"],["Closure"],["Closure"],["Closure"]],"OCP\\FilesMetadata\\Event\\MetadataLiveEvent",["OCP\\FilesMetadata\\Event\\MetadataLiveEvent"]]},{"file":"/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\FilesMetadata\\Event\\MetadataLiveEvent"],"OCP\\FilesMetadata\\Event\\MetadataLiveEvent"]},{"file":"/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\FilesMetadata\\Event\\MetadataLiveEvent",["OCP\\FilesMetadata\\Event\\MetadataLiveEvent"]]},{"file":"/usr/local/www/nextcloud/lib/private/FilesMetadata/FilesMetadataManager.php","line":115,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\FilesMetadata\\Event\\MetadataLiveEvent"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":110,"function":"refreshMetadata","class":"OC\\FilesMetadata\\FilesMetadataManager","type":"->","args":[["OC\\Files\\Node\\File"],3]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":92,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\LazyUserFolder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":83,"function":"scanFilesForUser","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":["ncadmin"]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/usr/local/www/nextcloud/lib/private/Memcache/Redis.php","Line":137,"message":"Error while generating metadata for fileid 2852","exception":{},"CustomMessage":"Error while generating metadata for fileid 2852"}}
{"reqId":"bP3vJD7XcmHiHOy4CfiG","level":2,"time":"2024-01-19T18:20:48+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Error while generating metadata for fileid 1446","userAgent":"--","version":"28.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\PDOException","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":"HY000","Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":137,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\PDOException","type":"::","args":[["PDOException",["HY000",2006,"MySQL server has gone away"]]]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1516,"function":"rollBack","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":162,"function":"rollBack","class":"Doctrine\\DBAL\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/FilesMetadata/Service/IndexRequestService.php","line":83,"function":"rollBack","class":"OC\\DB\\ConnectionAdapter","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/FilesMetadata/FilesMetadataManager.php","line":199,"function":"updateIndex","class":"OC\\FilesMetadata\\Service\\IndexRequestService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/nextcloud/lib/private/FilesMetadata/FilesMetadataManager.php","line":116,"function":"saveMetadata","class":"OC\\FilesMetadata\\FilesMetadataManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":110,"function":"refreshMetadata","class":"OC\\FilesMetadata\\FilesMetadataManager","type":"->","args":[["OC\\Files\\Node\\File"],3]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":92,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\LazyUserFolder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":83,"function":"scanFilesForUser","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":["ncadmin"]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/PDOException.php","Line":20,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":"HY000","Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":135,"function":"rollBack","class":"PDO","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1516,"function":"rollBack","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":162,"function":"rollBack","class":"Doctrine\\DBAL\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/FilesMetadata/Service/IndexRequestService.php","line":83,"function":"rollBack","class":"OC\\DB\\ConnectionAdapter","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/FilesMetadata/FilesMetadataManager.php","line":199,"function":"updateIndex","class":"OC\\FilesMetadata\\Service\\IndexRequestService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/nextcloud/lib/private/FilesMetadata/FilesMetadataManager.php","line":116,"function":"saveMetadata","class":"OC\\FilesMetadata\\FilesMetadataManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":110,"function":"refreshMetadata","class":"OC\\FilesMetadata\\FilesMetadataManager","type":"->","args":[["OC\\Files\\Node\\File"],3]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":92,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\LazyUserFolder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":83,"function":"scanFilesForUser","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":["ncadmin"]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","Line":135},"message":"Error while generating metadata for fileid 1446","exception":{"errorInfo":["HY000",2006,"MySQL server has gone away"]},"CustomMessage":"Error while generating metadata for fileid 1446"}}
{"reqId":"bP3vJD7XcmHiHOy4CfiG","level":3,"time":"2024-01-19T18:20:48+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"Error while running background job (class: OC\\Core\\BackgroundJobs\\GenerateMetadataJob, arguments: )","userAgent":"--","version":"28.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1938,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1880,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1105,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `oc_files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE `filecache`.`parent` = ? ORDER BY `name` ASC",[9962],[1]]},{"file":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `oc_files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE `filecache`.`parent` = ? ORDER BY `name` ASC",[9962],[1],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `oc_files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE `filecache`.`parent` = :dcValue1 ORDER BY `name` ASC",[9962],[1],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php","line":248,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/Files/View.php","line":1457,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Cache","type":"->","args":[9962]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Node/Folder.php","line":102,"function":"getDirectoryContent","class":"OC\\Files\\View","type":"->","args":["/ncadmin/files/Bilder/2019/Einsatzbilder/191114_VU_Stockach","",["OC\\Files\\FileInfo"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":101,"function":"getDirectoryListing","class":"OC\\Files\\Node\\Folder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":92,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\LazyUserFolder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":83,"function":"scanFilesForUser","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":["ncadmin"]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":104,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["HY000",2006,"MySQL server has gone away"]]]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1098,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `oc_files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE `filecache`.`parent` = ? ORDER BY `name` ASC",[9962],[1],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `oc_files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE `filecache`.`parent` = :dcValue1 ORDER BY `name` ASC",[9962],[1],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php","line":248,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/Files/View.php","line":1457,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Cache","type":"->","args":[9962]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Node/Folder.php","line":102,"function":"getDirectoryContent","class":"OC\\Files\\View","type":"->","args":["/ncadmin/files/Bilder/2019/Einsatzbilder/191114_VU_Stockach","",["OC\\Files\\FileInfo"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":101,"function":"getDirectoryListing","class":"OC\\Files\\Node\\Folder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":92,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\LazyUserFolder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":83,"function":"scanFilesForUser","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":["ncadmin"]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":"HY000","Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1098,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `oc_files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE `filecache`.`parent` = ? ORDER BY `name` ASC",[9962],[1],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `oc_files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE `filecache`.`parent` = :dcValue1 ORDER BY `name` ASC",[9962],[1],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php","line":248,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/Files/View.php","line":1457,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Cache","type":"->","args":[9962]},{"file":"/usr/local/www/nextcloud/lib/private/Files/Node/Folder.php","line":102,"function":"getDirectoryContent","class":"OC\\Files\\View","type":"->","args":["/ncadmin/files/Bilder/2019/Einsatzbilder/191114_VU_Stockach","",["OC\\Files\\FileInfo"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":101,"function":"getDirectoryListing","class":"OC\\Files\\Node\\Folder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":103,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\Folder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":92,"function":"scanFolder","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[["OC\\Files\\Node\\LazyUserFolder"]]},{"file":"/usr/local/www/nextcloud/core/BackgroundJobs/GenerateMetadataJob.php","line":83,"function":"scanFilesForUser","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":["ncadmin"]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OC\\Core\\BackgroundJobs\\GenerateMetadataJob","type":"->","args":[null]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/usr/local/www/nextcloud/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"Error while running background job (class: OC\\Core\\BackgroundJobs\\GenerateMetadataJob, arguments: )","exception":{},"CustomMessage":"Error while running background job (class: OC\\Core\\BackgroundJobs\\GenerateMetadataJob, arguments: )"}}
{"reqId":"bP3vJD7XcmHiHOy4CfiG","level":3,"time":"2024-01-19T18:20:48+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Exception thrown: Doctrine\\DBAL\\Exception","userAgent":"--","version":"28.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Exception","Message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","Code":2002,"Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1654,"function":"connect","class":"OC\\DB\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":865,"function":"getWrappedConnection","class":"Doctrine\\DBAL\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/Expression/ExpressionBuilder.php","line":321,"function":"quote","class":"Doctrine\\DBAL\\Connection","type":"->","args":[0,1]},{"file":"/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/ExpressionBuilder/ExpressionBuilder.php","line":422,"function":"literal","class":"Doctrine\\DBAL\\Query\\Expression\\ExpressionBuilder","type":"->","args":[0,1]},{"file":"/usr/local/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":366,"function":"literal","class":"OC\\DB\\QueryBuilder\\ExpressionBuilder\\ExpressionBuilder","type":"->","args":[0,1]},{"file":"/usr/local/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":356,"function":"unlockJob","class":"OC\\BackgroundJob\\JobList","type":"->","args":[["OC\\Core\\BackgroundJobs\\GenerateMetadataJob"]]},{"file":"/usr/local/www/nextcloud/cron.php","line":158,"function":"setLastJob","class":"OC\\BackgroundJob\\JobList","type":"->","args":[["OC\\Core\\BackgroundJobs\\GenerateMetadataJob"]]}],"File":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","Line":139,"CustomMessage":"Exception thrown: Doctrine\\DBAL\\Exception"}}
{"reqId":"0VlnnjifGrUflwgopUkG","level":3,"time":"2024-01-19T18:26:25+00:00","remoteAddr":"46.5.221.2","user":"--","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications","message":"Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory at /usr/local/www/nextcloud/lib/private/DB/Connection.php#139","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36","version":"28.0.1.1","data":{"app":"PHP"}}
{"reqId":"Lwn6hHXQ0D3oujt7QuCn","level":3,"time":"2024-01-19T18:26:29+00:00","remoteAddr":"46.5.221.2","user":"--","app":"index","method":"GET","url":"/index.php/204","message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Exception","Message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","Code":2002,"Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1654,"function":"connect","class":"OC\\DB\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1081,"function":"getWrappedConnection","class":"Doctrine\\DBAL\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":418,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":184,"function":"loadConfigValues","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":374,"function":"getApps","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/App/AppManager.php","line":128,"function":"getValues","class":"OC\\AppConfig","type":"->","args":[false,"enabled"]},{"file":"/usr/local/www/nextcloud/lib/private/App/AppManager.php","line":149,"function":"getInstalledAppsValues","class":"OC\\App\\AppManager","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/legacy/OC_App.php","line":231,"function":"getInstalledApps","class":"OC\\App\\AppManager","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppFramework/Bootstrap/Coordinator.php","line":90,"function":"getEnabledApps","class":"OC_App","type":"::","args":[]},{"file":"/usr/local/www/nextcloud/lib/base.php","line":700,"function":"runInitialRegistration","class":"OC\\AppFramework\\Bootstrap\\Coordinator","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/base.php","line":1200,"function":"init","class":"OC","type":"::","args":[]},{"file":"/usr/local/www/nextcloud/index.php","line":37,"args":["/usr/local/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","Line":139,"message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","exception":{},"CustomMessage":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory"}}
{"reqId":"Lwn6hHXQ0D3oujt7QuCn","level":3,"time":"2024-01-19T18:26:35+00:00","remoteAddr":"46.5.221.2","user":"--","app":"core","method":"GET","url":"/index.php/204","message":"Exception thrown: Doctrine\\DBAL\\Exception","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Exception","Message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","Code":2002,"Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1654,"function":"connect","class":"OC\\DB\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1081,"function":"getWrappedConnection","class":"Doctrine\\DBAL\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":418,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":184,"function":"loadConfigValues","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":374,"function":"getApps","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/App/AppManager.php","line":128,"function":"getValues","class":"OC\\AppConfig","type":"->","args":[false,"enabled"]},{"file":"/usr/local/www/nextcloud/lib/private/App/AppManager.php","line":149,"function":"getInstalledAppsValues","class":"OC\\App\\AppManager","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/legacy/OC_App.php","line":231,"function":"getInstalledApps","class":"OC\\App\\AppManager","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppFramework/Bootstrap/Coordinator.php","line":90,"function":"getEnabledApps","class":"OC_App","type":"::","args":[]},{"file":"/usr/local/www/nextcloud/lib/base.php","line":700,"function":"runInitialRegistration","class":"OC\\AppFramework\\Bootstrap\\Coordinator","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/base.php","line":1200,"function":"init","class":"OC","type":"::","args":[]},{"file":"/usr/local/www/nextcloud/index.php","line":37,"args":["/usr/local/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","Line":139,"CustomMessage":"Exception thrown: Doctrine\\DBAL\\Exception"}}
{"reqId":"Lwn6hHXQ0D3oujt7QuCn","level":3,"time":"2024-01-19T18:26:35+00:00","remoteAddr":"46.5.221.2","user":"--","app":"core","method":"GET","url":"/index.php/204","message":"Exception thrown: Doctrine\\DBAL\\Exception","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Exception","Message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","Code":2002,"Trace":[{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1654,"function":"connect","class":"OC\\DB\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1081,"function":"getWrappedConnection","class":"Doctrine\\DBAL\\Connection","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":418,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":184,"function":"loadConfigValues","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/AppConfig.php","line":374,"function":"getApps","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/legacy/OC_App.php","line":734,"function":"getValues","class":"OC\\AppConfig","type":"->","args":[false,"installed_version"]},{"file":"/usr/local/www/nextcloud/lib/private/TemplateLayout.php","line":236,"function":"getAppVersions","class":"OC_App","type":"::","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/legacy/OC_Template.php","line":142,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["error",""]},{"file":"/usr/local/www/nextcloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/lib/private/legacy/OC_Template.php","line":291,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/usr/local/www/nextcloud/index.php","line":104,"function":"printExceptionErrorPage","class":"OC_Template","type":"::","args":[["Doctrine\\DBAL\\Exception"],500]}],"File":"/usr/local/www/nextcloud/lib/private/DB/Connection.php","Line":139,"CustomMessage":"Exception thrown: Doctrine\\DBAL\\Exception"}}
{"reqId":"SxhrQizw28dtd1JyYxhA","level":3,"time":"2024-01-19T22:48:42+00:00","remoteAddr":"84.151.165.146","user":"--","app":"PHP","method":"PROPFIND","url":"/remote.php/dav/files/PC-Zentrale-1/","message":"Error: Class \"OCA\\DAV\\Connector\\Sabre\\ExceptionLoggerPlugin\" not found at /usr/local/www/nextcloud/remote.php#62","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","data":{"app":"PHP"}}
{"reqId":"DgBbumHJuYqvjk88M5Kd","level":3,"time":"2024-01-19T22:50:12+00:00","remoteAddr":"84.151.165.146","user":"--","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status?format=json","message":"Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory at /usr/local/www/nextcloud/lib/private/DB/Connection.php#139","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","data":{"app":"PHP"}}
{"reqId":"X5iNdb67FdbOIROirml0","level":3,"time":"2024-01-19T22:50:12+00:00","remoteAddr":"84.151.165.146","user":"--","app":"PHP","method":"PROPFIND","url":"/remote.php/dav/files/PC-Zentrale-1/","message":"Error: Class \"OCA\\DAV\\Connector\\Sabre\\ExceptionLoggerPlugin\" not found at /usr/local/www/nextcloud/remote.php#62","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","data":{"app":"PHP"}}
{"reqId":"YxjdivD7hh44OYKoZh1c","level":3,"time":"2024-01-19T22:50:12+00:00","remoteAddr":"84.151.165.146","user":"--","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory at /usr/local/www/nextcloud/lib/private/DB/Connection.php#139","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","data":{"app":"PHP"}}
{"reqId":"FO8I8LwhaV8rR3eed3lP","level":3,"time":"2024-01-19T22:50:13+00:00","remoteAddr":"84.151.165.146","user":"--","app":"PHP","method":"PROPFIND","url":"/remote.php/dav/files/PC-Zentrale-1/","message":"Error: Class \"OCA\\DAV\\Connector\\Sabre\\ExceptionLoggerPlugin\" not found at /usr/local/www/nextcloud/remote.php#62","userAgent":"Mozilla/5.0 (Windows) mirall/3.11.0stable-Win64 (build 20231211) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.1.1","data":{"app":"PHP"}}

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

{
    "system": {
        "apps_paths": [
            {
                "path": "\/usr\/local\/www\/nextcloud\/apps",
                "url": "\/apps",
                "writable": true
            },
            {
                "path": "\/usr\/local\/www\/nextcloud\/apps-pkg",
                "url": "\/apps-pkg",
                "writable": false
            }
        ],
        "logfile": "\/var\/log\/nextcloud\/nextcloud.log",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "one-click-instance": true,
        "one-click-instance.user-limit": 100,
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***"
        },
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
       ***REMOVED SENSITIVE VALUE***
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "28.0.1.1",
        "overwrite.cli.url": "http:\/\/localhost",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "loglevel": 2,
        "maintenance": false,
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "default_phone_region": "DE",
        "mail_smtpsecure": "ssl",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "opcache.interned_strings_buffer": 16,
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

The output of your Apache/nginx/system log in /var/log/____:
Checked nginx and mysql log, both don’t show any obvious error

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.

Filtering not available but pasted the nextcloud.log on the top.

If there is something else I can provide, please let me know.

2

This problem is caused by your Nginx config not being up-to-date. Please check the Admin Manual to review the example config. Specifically you’re missing the mjs line

1 Like
3

Thank you very much. Yes, I have not noticed this change in the nginx config.
I checked shortly and noticed that this change was stated in the “Upgrade to NC27”. It seems I had luck not to encounter this earlier.

I added the following lines to my nginx config:

    # Add .mjs as a file extension for javascript
    # Either include it in the default mime.types list
    # or include you can include that list explicitly and add the file extension
    # only for Nextcloud like below:
    include mime.types;
    types {
        text/javascript js mjs;
    }

The activities and the Logging are now working again and the SQL errors are gone.

There is now one remaining error, but I think this is related to me removing the Talk app after creating user accounts and not the update to NC28.

1 Like
4

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.