circles [Bug]: Upgrade to 28.0.5 broken my nextcloud

⚠️ This issue respects the following points: ⚠️

[X] This is a bug, not a question or a configuration/webserver/proxy issue.
[X] This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
[X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
[X] I agree to follow Nextcloud's Code of Conduct.

Bug description

After upgrade to 28.0.5, my nextcloud is broken, I can't see any files in files, can't see any data in dashboard, files always jump to url apps/files/files.

Many error logs:

[index] Error: SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)
	POST /nextcloud/contactsmenu/contacts

Steps to reproduce

Upgrade from 28.0.4 to 28.0.5.
Open nextcloud after upgrade finished.
See dashboard and files if it's normal.

Expected behavior

Is everything is ok.

Installation method

Other Community project

Nextcloud Server version

28

Operating system

Other

PHP engine version

PHP 8.1

Web server

Nginx

Database engine version

SQlite

Is this bug present after an update or on a fresh install?

Upgraded to a MAJOR version (ex. 22 to 23)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

[X] Default user-backend (database)
[ ] LDAP/ Active Directory
[ ] SSO - SAML
[ ] Other

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "xxx.xxx.net:2443"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "sqlite3",
        "version": "28.0.5.1",
        "overwrite.cli.url": "https:\/\/xxx.xxx.net:2443\/nextcloud",
        "installed": true,
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "dbindex": 1
        },
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "maintenance": false,
        "loglevel": 2,
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "ssl",
        "theme": "",
        "filesystem_check_changes": 1,
        "trashbin_retention_obligation": "auto,30",
        "proxy": "socks5:\/\/192.168.4.4:7891",
        "maintenance_window_start": 1,
        "default_phone_region": "CN",
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - audioplayer: 3.4.1
  - checksum: 1.2.4
  - circles: 28.0.0
  - cloud_federation_api: 1.11.0
  - comments: 1.18.0
  - contactsinteraction: 1.9.0
  - dashboard: 7.8.0
  - dav: 1.29.1
  - federatedfilesharing: 1.18.0
  - federation: 1.18.0
  - files: 2.0.0
  - files_external: 1.20.0
  - files_pdfviewer: 2.9.0
  - files_reminders: 1.1.0
  - files_sharing: 1.20.0
  - files_trashbin: 1.18.0
  - files_versions: 1.21.0
  - firstrunwizard: 2.17.0
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - nextcloud_announcements: 1.17.0
  - notes: 4.10.0
  - notifications: 2.16.0
  - oauth2: 1.16.3
  - password_policy: 1.18.0
  - photos: 2.4.0
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - recommendations: 2.0.0
  - related_resources: 1.3.0
  - serverinfo: 1.18.0
  - settings: 1.10.1
  - sharebymail: 1.18.0
  - support: 1.11.1
  - survey_client: 1.16.0
  - text: 3.9.1
  - theming: 2.3.0
  - twofactor_backupcodes: 1.17.0
  - updatenotification: 1.18.0
  - user_status: 1.8.1
  - viewer: 2.2.0
  - weather_status: 1.8.0
  - workflowengine: 2.10.0
Disabled:
  - admin_audit: 1.18.0
  - bruteforcesettings: 2.8.0
  - encryption: 2.16.0
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - metadata: 0.19.0 (installed 0.19.0)
  - suspicious_login: 6.0.0
  - systemtags: 1.18.0 (installed 1.18.0)
  - twofactor_totp: 10.0.0-beta.2
  - user_ldap: 1.19.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"cdCFsWKBAF12oNs8mLRm","level":3,"time":"2024-04-26T08:02:48+00:00","remoteAddr":"111.39.248.17","user":"pader","app":"no app in context","method":"PUT","url":"/nextcloud/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json","message":"Exception thrown: Exception","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0","version":"28.0.5.1","exception":{"Exception":"Exception","Message":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)","Code":0,"Trace":[{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Db/CircleRequest.php","line":432,"function":"getItemFromRequest","class":"OCA\\Circles\\Db\\CircleRequestBuilder","type":"->","args":[["OCA\\Circles\\Db\\CoreQueryBuilder"]]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":1028,"function":"getSingleCircle","class":"OCA\\Circles\\Db\\CircleRequest","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"]]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":995,"function":"getSingleCircle","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"],true]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":543,"function":"fillSingleCircleId","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"],true]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":273,"function":"getLocalFederatedUser","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":["pader"]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Api/v1/Circles.php","line":145,"function":"setLocalCurrentUserId","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":["pader"]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/Connector/Sabre/Principal.php","line":603,"function":"joinedCircles","class":"OCA\\Circles\\Api\\v1\\Circles","type":"::","args":["pader",true]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":384,"function":"getCircleMembership","class":"OCA\\DAV\\Connector\\Sabre\\Principal","type":"->","args":["principals/users/pader"]},{"file":"/usr/local/www/public/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":455,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/CalDAV/CalendarProvider.php","line":57,"function":"getCalendarsForUser","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["principals/users/pader"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Calendar/Manager.php","line":191,"function":"getCalendars","class":"OCA\\DAV\\CalDAV\\CalendarProvider","type":"->","args":["principals/users/pader",[]]},{"function":"OC\\Calendar\\{closure}","class":"OC\\Calendar\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Calendar/Manager.php","line":192,"function":"array_map","args":[["Closure"],["*** sensitive parameters replaced ***"]]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/CalDAV/Status/StatusService.php","line":144,"function":"getCalendarsForPrincipal","class":"OC\\Calendar\\Manager","type":"->","args":["principals/users/pader"]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/CalDAV/Status/StatusService.php","line":70,"function":"getCalendarEvents","class":"OCA\\DAV\\CalDAV\\Status\\StatusService","type":"->","args":[["OC\\User\\User"]]},{"file":"/usr/local/www/public/nextcloud/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":73,"function":"processCalendarStatus","class":"OCA\\DAV\\CalDAV\\Status\\StatusService","type":"->","args":["pader"]},{"file":"/usr/local/www/public/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent"]},{"file":"/usr/local/www/public/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/usr/local/www/public/nextcloud/apps/user_status/lib/Controller/HeartbeatController.php","line":100,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->","args":["online"]},{"file":"/usr/local/www/public/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/usr/local/www/public/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\UserStatus\\Controller\\HeartbeatController","heartbeat",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["ocs.user_status.Heartbeat.heartbeat"]]},{"file":"/usr/local/www/public/nextcloud/ocs/v1.php","line":65,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/user_status/api/v1/heartbeat"]},{"file":"/usr/local/www/public/nextcloud/ocs/v2.php","line":23,"args":["/usr/local/www/public/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/usr/local/www/public/nextcloud/apps/circles/lib/Db/CircleRequestBuilder.php","Line":114,"CustomMessage":"Exception thrown: Exception"}}
{"reqId":"5Jmb4QFVNyy98rwsGWrw","level":3,"time":"2024-04-26T08:03:18+00:00","remoteAddr":"111.39.248.17","user":"pader","app":"webdav","method":"PROPFIND","url":"/nextcloud/remote.php/dav/files/pader/","message":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.4.4git (build 9585) (Nextcloud, osx-22.6.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.5.1","exception":{"Exception":"Exception","Message":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)","Code":0,"Trace":[{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Db/CircleRequest.php","line":432,"function":"getItemFromRequest","class":"OCA\\Circles\\Db\\CircleRequestBuilder","type":"->","args":[["OCA\\Circles\\Db\\CoreQueryBuilder"]]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":1028,"function":"getSingleCircle","class":"OCA\\Circles\\Db\\CircleRequest","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"]]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":995,"function":"getSingleCircle","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"],true]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":543,"function":"fillSingleCircleId","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"],true]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":550,"function":"getLocalFederatedUser","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":["pader"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Share20/Manager.php","line":1411,"function":"getSharedWith","class":"OCA\\Circles\\ShareByCircleProvider","type":"->","args":["pader",7,null,-1,0]},{"file":"/usr/local/www/public/nextcloud/apps/files_sharing/lib/MountProvider.php","line":69,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->","args":["pader",7,null,-1]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":89,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->","args":[["OC\\User\\User"],["OC\\Files\\Storage\\StorageFactory"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":146,"function":"getMountsFromProvider","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":[["OCA\\Files_Sharing\\MountProvider"],["OC\\User\\User"],["OC\\Files\\Storage\\StorageFactory"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":219,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":[["OC\\User\\User"],["OC\\Files\\Mount\\Manager"],["Closure"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":318,"function":"OC\\Files\\{closure}","class":"OC\\Files\\SetupManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":220,"function":"setupForUserWith","class":"OC\\Files\\SetupManager","type":"->","args":[["OC\\User\\User"],["Closure"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":392,"function":"setupForUser","class":"OC\\Files\\SetupManager","type":"->","args":[["OC\\User\\User"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Mount/Manager.php","line":97,"function":"setupForPath","class":"OC\\Files\\SetupManager","type":"->","args":["/pader/files"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/View.php","line":1372,"function":"find","class":"OC\\Files\\Mount\\Manager","type":"->","args":["/pader/files"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/Root.php","line":203,"function":"getFileInfo","class":"OC\\Files\\View","type":"->","args":["/pader/files",false]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyUserFolder.php","line":47,"function":"get","class":"OC\\Files\\Node\\Root","type":"->","args":["/pader/files"]},{"function":"OC\\Files\\Node\\{closure}","class":"OC\\Files\\Node\\LazyUserFolder","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyFolder.php","line":70,"function":"call_user_func","args":[["Closure"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyFolder.php","line":84,"function":"getRealFolder","class":"OC\\Files\\Node\\LazyFolder","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyFolder.php","line":240,"function":"__call","class":"OC\\Files\\Node\\LazyFolder","type":"->","args":["getMTime",[]]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/Connector/Sabre/Node.php","line":178,"function":"getMTime","class":"OC\\Files\\Node\\LazyFolder","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":749,"function":"getLastModified","class":"OCA\\DAV\\Connector\\Sabre\\Node","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/PropFind.php","line":95,"function":"Sabre\\DAV\\{closure}","class":"Sabre\\DAV\\CorePlugin","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":753,"function":"handle","class":"Sabre\\DAV\\PropFind","type":"->","args":["{DAV:}getlastmodified",["Closure"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"propFind","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[["Sabre\\DAV\\PropFind"],["OCA\\DAV\\Files\\FilesHome"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["propFind",[["Sabre\\DAV\\PropFind"],["OCA\\DAV\\Files\\FilesHome"]]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->","args":[["Sabre\\DAV\\PropFind"],["OCA\\DAV\\Files\\FilesHome"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->","args":["files/pader",["{DAV:}getlastmodified"],0]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->","args":[["Sabre\\Xml\\Writer",[],"/nextcloud/remote.php/dav/",["d","s","oc","nc"],[]],["Generator"],false]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->","args":[["Generator"],false]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[["Sabre\\HTTP\\Request"],["Sabre\\HTTP\\Response"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["method:PROPFIND",[["Sabre\\HTTP\\Request"],["Sabre\\HTTP\\Response"]]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[["Sabre\\HTTP\\Request"],["Sabre\\HTTP\\Response"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/Server.php","line":373,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/remote.php","line":172,"args":["/usr/local/www/public/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/usr/local/www/public/nextcloud/apps/circles/lib/Db/CircleRequestBuilder.php","Line":114,"message":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)","exception":{},"CustomMessage":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)"}}
{"reqId":"H6Hx5DX5hDdxp1PqCtUb","level":3,"time":"2024-04-26T08:04:20+00:00","remoteAddr":"111.39.248.17","user":"pader","app":"webdav","method":"PROPFIND","url":"/nextcloud/remote.php/dav/files/pader/","message":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.4.4git (build 9585) (Nextcloud, osx-22.6.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"28.0.5.1","exception":{"Exception":"Exception","Message":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)","Code":0,"Trace":[{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Db/CircleRequest.php","line":432,"function":"getItemFromRequest","class":"OCA\\Circles\\Db\\CircleRequestBuilder","type":"->","args":[["OCA\\Circles\\Db\\CoreQueryBuilder"]]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":1028,"function":"getSingleCircle","class":"OCA\\Circles\\Db\\CircleRequest","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"]]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":995,"function":"getSingleCircle","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"],true]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/Service/FederatedUserService.php","line":543,"function":"fillSingleCircleId","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":[["OCA\\Circles\\Model\\FederatedUser"],true]},{"file":"/usr/local/www/public/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":550,"function":"getLocalFederatedUser","class":"OCA\\Circles\\Service\\FederatedUserService","type":"->","args":["pader"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Share20/Manager.php","line":1411,"function":"getSharedWith","class":"OCA\\Circles\\ShareByCircleProvider","type":"->","args":["pader",7,null,-1,0]},{"file":"/usr/local/www/public/nextcloud/apps/files_sharing/lib/MountProvider.php","line":69,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->","args":["pader",7,null,-1]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":89,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->","args":[["OC\\User\\User"],["OC\\Files\\Storage\\StorageFactory"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":146,"function":"getMountsFromProvider","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":[["OCA\\Files_Sharing\\MountProvider"],["OC\\User\\User"],["OC\\Files\\Storage\\StorageFactory"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":219,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":[["OC\\User\\User"],["OC\\Files\\Mount\\Manager"],["Closure"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":318,"function":"OC\\Files\\{closure}","class":"OC\\Files\\SetupManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":220,"function":"setupForUserWith","class":"OC\\Files\\SetupManager","type":"->","args":[["OC\\User\\User"],["Closure"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/SetupManager.php","line":392,"function":"setupForUser","class":"OC\\Files\\SetupManager","type":"->","args":[["OC\\User\\User"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Mount/Manager.php","line":97,"function":"setupForPath","class":"OC\\Files\\SetupManager","type":"->","args":["/pader/files"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/View.php","line":1372,"function":"find","class":"OC\\Files\\Mount\\Manager","type":"->","args":["/pader/files"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/Root.php","line":203,"function":"getFileInfo","class":"OC\\Files\\View","type":"->","args":["/pader/files",false]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyUserFolder.php","line":47,"function":"get","class":"OC\\Files\\Node\\Root","type":"->","args":["/pader/files"]},{"function":"OC\\Files\\Node\\{closure}","class":"OC\\Files\\Node\\LazyUserFolder","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyFolder.php","line":70,"function":"call_user_func","args":[["Closure"]]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyFolder.php","line":84,"function":"getRealFolder","class":"OC\\Files\\Node\\LazyFolder","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/lib/private/Files/Node/LazyFolder.php","line":240,"function":"__call","class":"OC\\Files\\Node\\LazyFolder","type":"->","args":["getMTime",[]]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/Connector/Sabre/Node.php","line":178,"function":"getMTime","class":"OC\\Files\\Node\\LazyFolder","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":749,"function":"getLastModified","class":"OCA\\DAV\\Connector\\Sabre\\Node","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/PropFind.php","line":95,"function":"Sabre\\DAV\\{closure}","class":"Sabre\\DAV\\CorePlugin","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":753,"function":"handle","class":"Sabre\\DAV\\PropFind","type":"->","args":["{DAV:}getlastmodified",["Closure"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"propFind","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[["Sabre\\DAV\\PropFind"],["OCA\\DAV\\Files\\FilesHome"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["propFind",[["Sabre\\DAV\\PropFind"],["OCA\\DAV\\Files\\FilesHome"]]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->","args":[["Sabre\\DAV\\PropFind"],["OCA\\DAV\\Files\\FilesHome"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->","args":["files/pader",["{DAV:}getlastmodified"],0]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->","args":[["Sabre\\Xml\\Writer",[],"/nextcloud/remote.php/dav/",["d","s","oc","nc"],[]],["Generator"],false]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->","args":[["Generator"],false]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[["Sabre\\HTTP\\Request"],["Sabre\\HTTP\\Response"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["method:PROPFIND",[["Sabre\\HTTP\\Request"],["Sabre\\HTTP\\Response"]]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[["Sabre\\HTTP\\Request"],["Sabre\\HTTP\\Response"]]},{"file":"/usr/local/www/public/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/apps/dav/lib/Server.php","line":373,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/usr/local/www/public/nextcloud/remote.php","line":172,"args":["/usr/local/www/public/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/usr/local/www/public/nextcloud/apps/circles/lib/Db/CircleRequestBuilder.php","Line":114,"message":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)","exception":{},"CustomMessage":"SELECT `cs`.`unique_id`, `cs`.`name`, `cs`.`display_name`, `cs`.`sanitized_name`, `cs`.`source`, `cs`.`description`, `cs`.`settings`, `cs`.`config`, `cs`.`contact_addressbook`, `cs`.`contact_groupname`, `cs`.`creation` FROM `*PREFIX*circles_circle` `cs` INNER JOIN `*PREFIX*circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id` WHERE (`cs`.`instance` = '') AND ((`cs_mm`.`user_id` = :dcValue1) AND (`cs_mm`.`user_type` = :dcValue2) AND (`cs_mm`.`level` >= :dcValue3)) AND ((`cs`.`config` & 1) > :dcValue4)"}}

Additional info

No response

Apr 26 '24 08:04 xpader

This seems to be a database issue with the circles app

Maybe the database is corrupted, I would recommend to rollback to the backup before the update and then try the update again.

Apr 30 '24 11:04 susnux

I have disable circles app, now it's back to normal, and I feel that nextcloud has become a little bit faster.

May 04 '24 11:05 xpader

Hi @xpader - What version of sqlite3 / what distribution are you running this one?

Does this still happen today if you re-enable Circles/Teams?

Feb 12 '25 15:02 joshtrichards

@joshtrichards It's still happend when I re-enable circles app, and I have already updated nextcloud and php some versions.

My php version: 8.3.12 SQLite Library: 3.46.1 Nextcloud Hub 9 (30.0.6)

Feb 19 '25 02:02 xpader

Looks like I lost circles app tables in sqlite database, in whole nextcloud database, there is no table name include circle string.

Feb 19 '25 02:02 xpader