Installation IONOS Shared Hosting - Der Server konnte die Anfrage nicht fertig stellen

Leonid1 · December 3, 2021, 12:07pm

Hallo von einem Nextcloud-Anfänger.
Ich habe Nextcloud (22.2.0) auf einem Shared Hosting Paket von IONOS installiert. Die Installation lief gut.

Allerdings erhalte ich nun folgende Fehlermeldung beim Versuch mich einzuloggen:

Interner Serverfehler
Der Server konnte die Anfrage nicht fertig stellen.
Sollte dies erneut auftreten, senden Sie bitte die nachfolgenden technischen Einzelheiten an Ihren Server-Administrator.
Weitere Details können im Server-Protokoll gefunden werden.
Technische Details
Entfernte Adresse: 87.123.190.247
Yan@McLgZ4BcRVLegcTVVQAAAAk

Der IONOS-Support konnte mir nicht weiterhelfen, da für IONOS Nextcloud eine Fremdsoftware ist.
In ähnlichen Beiträgen wurde immer nach der nextcloud.log-Datei gefragt. Deshalb habe ich sie auf https://filehorst.de/d/eJzEjjvy hochgeladen.
Könnt Ihr mir bei dem Problem helfen? Werden noch weitere Infos benötigt?
Falls mein Vorhaben scheitern sollte: wie deinstalliere ich Nextcloud?
Danke für die Unterstützung.

SysKeeper · December 3, 2021, 7:48pm

Hey Leonid1,

auf Anhieb ist folgendes im Log zu sehen:
SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size

Ich würde bei folgenden Links ansetzen:

github.com/nextcloud/circles

Out of sort buffer memory error (`sort_buffer_size`)

opened 10:26AM - 15 Aug 21 UTC

closed 12:54PM - 19 Apr 22 UTC

ikke-t

### How to use GitHub * Please use the 👍 [reaction](https://blog.github.com/2…016-03-10-add-reactions-to-pull-requests-issues-and-comments/) to show that you are affected by the same issue. * Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue. * Subscribe to receive notifications on status change and new comments. ### Steps to reproduce 1. start nextcloud ```/usr/bin/podman run --name nextcloud \ --rm -p 8090:80/tcp -v "/var/lib/containers/exported_volumes/nextcloud_www:/var/www/html:Z" -v "/mnt/nextcloud_data/data:/var/www/html/data" --hostname="nextcloud.me" --memory=1024M --label "io.containers.autoupdate=image" \ --conmon-pidfile %T/%n-pid --cidfile %T/%n-cid \ docker.io/nextcloud:latest``` 2. try logging in ### Expected behaviour I should be able to login, as I've been for years with the very same instance. ### Actual behaviour Even if increasing the sort memory at backend: ``` innodb_sort_buffer_size=512M sort_buffer_size=512M ``` it didn't help. But as I got hinted to disable circles app, which immediately fixed the login error. So with circles being enbled I get error page after login, and this super long log, basically saying sql has run out of sort buffer. See logs part below. ### Server configuration **Operating system:** nextcloud:latest from dockerhub **Web server:** HAproxy in front of docker image which has apache built in. **Database:** external mariadb **PHP version:** **Nextcloud version:** (see Nextcloud admin page) container: 22.1.0.1 **Updated from an older Nextcloud/ownCloud or fresh install:** Update, I've been running this instance for years successfully. **Where did you install Nextcloud from:** dockerhub **Signing status:** <details> <summary>Signing status</summary> ``` Login as admin user into your Nextcloud and access http://example.com/index.php/settings/integrity/failed paste the results here. ``` </details> **List of activated apps:** <details> <summary>App list</summary> ``` Enabled: - accessibility: 1.7.0 - activity: 2.15.0 - admin_audit: 1.11.0 - calendar: 2.3.1 - circles: 22.1.0 - cloud_federation_api: 1.4.0 - comments: 1.11.0 - contactsinteraction: 1.2.0 - dashboard: 7.1.0 - dav: 1.18.0 - deck: 1.5.0 - drawio: 1.0.1 - federatedfilesharing: 1.11.0 - federation: 1.11.0 - files: 1.16.0 - files_markdown: 2.3.4 - files_pdfviewer: 2.3.0 - files_markdown: 2.3.4 - files_pdfviewer: 2.3.0 - files_rightclick: 1.1.0 - files_sharing: 1.13.2 - files_trashbin: 1.11.0 - files_versions: 1.14.0 - files_videoplayer: 1.11.0 - firstrunwizard: 2.11.0 - forms: 2.3.0 - keeweb: 0.6.6 - logreader: 2.7.0 - lookup_server_connector: 1.9.0 - mindmaps: 0.1.0 - nextcloud_announcements: 1.11.0 - notes: 4.1.1 - notifications: 2.10.1 - oauth2: 1.9.0 - password_policy: 1.12.0 - photos: 1.4.0 - privacy: 1.6.0 - provisioning_api: 1.11.0 - recommendations: 1.1.0 - serverinfo: 1.12.0 - settings: 1.3.0 - sharebymail: 1.11.0 - spreed: 12.0.1 - support: 1.5.0 - survey_client: 1.10.0 - systemtags: 1.11.0 - talk_matterbridge: 1.22.4 - text: 3.3.0 - theming: 1.12.0 - twofactor_backupcodes: 1.10.1 - updatenotification: 1.11.0 - user_status: 1.1.1 - viewer: 1.6.0 - weather_status: 1.1.0 - workflowengine: 2.3.0 Disabled: - bruteforcesettings - encryption - files_external - socialsharing_email - twofactor_totp - user_ldap ``` </details> **Nextcloud configuration:** <details> <summary>Config report</summary> ``` { "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "22.1.0.1", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "theme": "", "maintenance": false, "trusted_domains": [ "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***" ], "mail_smtpmode": "smtp", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "secret": "***REMOVED SENSITIVE VALUE***", "forcessl": false, "loglevel": 3, "trashbin_retention_obligation": "auto", "htaccess.RewriteBase": "\/", "appstore.experimental.enabled": true, "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***", "overwriteprotocol": "https", "memcache.local": "\\OC\\Memcache\\APCu", "apps_paths": [ { "path": "\/var\/www\/html\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/www\/html\/custom_apps", "url": "\/custom_apps", "writable": true } ], "mail_smtpauthtype": "PLAIN", "app_install_overwrite": [ "mindmaps", "keeweb", "drawio" ], "mysql.utf8mb4": true, "default_phone_region": "FI" }, "apps": { "accessibility": { "enabled": "yes", "installed_version": "1.7.0", "types": "" }, "activity": { "enabled": "yes", "installed_version": "2.15.0", "notify_email_calendar": "0", "notify_email_calendar_event": "0", "notify_email_calendar_todo": "0", "notify_email_comments": "0", "notify_email_deck": "0", "notify_email_deck_card_description": "0", "notify_email_deck_comment": "0", "notify_email_favorite": "0", "notify_email_file_changed": "0", "notify_email_file_favorite_changed": "0", "notify_email_forms_newshare": "0", "notify_email_forms_newsubmission": "0", "notify_email_public_links": "0", "notify_email_remote_share": "0", "notify_email_shared": "0", "notify_email_spreed": "0", "notify_email_systemtags": "0", "notify_notification_calendar": "0", "notify_notification_calendar_event": "0", "notify_notification_calendar_todo": "0", "notify_notification_comments": "1", "notify_notification_deck": "1", "notify_notification_deck_card_description": "0", "notify_notification_deck_comment": "1", "notify_notification_favorite": "0", "notify_notification_file_changed": "0", "notify_notification_file_favorite_changed": "1", "notify_notification_forms_newshare": "1", "notify_notification_forms_newsubmission": "1", "notify_notification_group_settings": "1", "notify_notification_personal_settings": "0", "notify_notification_public_links": "0", "notify_notification_remote_share": "0", "notify_notification_security": "1", "notify_notification_shared": "0", "notify_notification_spreed": "1", "notify_notification_systemtags": "0", "notify_notification_twofactor_totp": "1", "notify_setting_batchtime": "3600", "notify_setting_self": "0", "notify_setting_selfemail": "0", "types": "filesystem" }, "admin_audit": { "enabled": "yes", "installed_version": "1.11.0", "types": "logging" }, "admin_dependencies_chk": { "enabled": "no", "installed_version": "0.02", "types": "" }, "admin_migrate": { "enabled": "no", "installed_version": "0.1" }, "backgroundjob": { "lastjob": "16849" }, "bookmarks": { "enabled": "no", "installed_version": "0.9.1", "ocsid": "168710", "types": "" }, "bruteForce": { "whitelist_1": "***REMOVED SENSITIVE VALUE***" }, "bruteforcesettings": { "enabled": "no", "installed_version": "2.2.0", "types": "" }, "calendar": { "enabled": "yes", "installed_version": "2.3.1", "types": "" }, "circles": { "enabled": "no", "installed_version": "22.1.0", "loopback_tmp_scheme": "https", "types": "filesystem,dav" }, "cloud_federation_api": { "enabled": "yes", "installed_version": "1.4.0", "types": "filesystem" }, "comments": { "enabled": "yes", "installed_version": "1.11.0", "types": "logging" }, "contacts": { "enabled": "no", "installed_version": "1.5.2", "ocsid": "168708", "types": "" }, "contactsinteraction": { "enabled": "yes", "installed_version": "1.2.0", "types": "dav" }, "core": { "backgroundjobs_mode": "cron", "backgroundjobs_step": "queued_tasks", "backgroundjobs_task": "", "enterpriseLogoChecked": "yes", "global_cache_gc_lastrun": "1431086641", "installed.bundles": "[\"CoreBundle\"]", "installedat": "1375705366.3101", "lastcron": "1618003468", "lastupdateResult": "[]", "lastupdatedat": "0", "moveavatarsdone": "yes", "oc.integritycheck.checker": "[]", "previewsCleanedUp": "1", "public_caldav": "calendar\/share.php", "public_calendar": "calendar\/share.php", "public_documents": "documents\/public.php", "public_files": "files_sharing\/public.php", "public_gallery": "gallery\/public.php", "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php", "remote_ampache": "media\/remote.php", "remote_caldav": "dav\/appinfo\/v1\/caldav.php", "remote_calendar": "dav\/appinfo\/v1\/caldav.php", "remote_carddav": "dav\/appinfo\/v1\/carddav.php", "remote_contacts": "dav\/appinfo\/v1\/carddav.php", "remote_contactthumbnail": "contacts\/thumbnail.php", "remote_core.css": "\/core\/minimizer.php", "remote_core.js": "\/core\/minimizer.php", "remote_dav": "dav\/appinfo\/v2\/remote.php", "remote_files": "dav\/appinfo\/v1\/webdav.php", "remote_filesync": "files\/appinfo\/filesync.php", "remote_webdav": "dav\/appinfo\/v1\/webdav.php", "repairlegacystoragesdone": "yes", "scss.variables": "1a7e8904c881eeb465063c0453e51cdb", "shareapi_allow_mail_notification": "yes", "shareapi_default_expire_date": "yes", "shareapi_only_share_with_group_members": "yes", "shareapi_share_policy": "groups_only", "theming.variables": "d362e03ad5e4950a4bfdb02459dc00f3", "updater.secret.created": "1609829705", "vendor": "nextcloud" }, "dashboard": { "enabled": "yes", "installed_version": "7.1.0", "types": "" }, "dav": { "buildCalendarReminderIndex": "yes", "buildCalendarSearchIndex": "yes", "chunks_migrated": "1", "enabled": "yes", "installed_version": "1.18.0", "regeneratedBirthdayCalendarsForYearFix": "yes", "types": "filesystem" }, "deck": { "enabled": "yes", "installed_version": "1.5.0", "types": "dav" }, "documents": { "enabled": "no", "installed_version": "0.12.0", "ocsid": "168711", "types": "", "unstable": "false" }, "drawio": { "enabled": "yes", "installed_version": "1.0.1", "types": "filesystem" }, "external": { "enabled": "no", "installed_version": "1.2", "ocsid": "166046", "types": "" }, "federatedfilesharing": { "enabled": "yes", "installed_version": "1.11.0", "types": "" }, "federation": { "enabled": "yes", "installed_version": "1.11.0", "types": "authentication" }, "files": { "backgroundwatcher_previous_file": "5291", "backgroundwatcher_previous_folder": "13677", "cronjob_scan_files": "500", "default_quota": "10 GB", "enabled": "yes", "installed_version": "1.16.0", "types": "filesystem" }, "files_imageviewer": { "enabled": "no", "installed_version": "1.0" }, "files_markdown": { "enabled": "yes", "installed_version": "2.3.4", "types": "" }, "files_odfviewer": { "enabled": "no", "installed_version": "0.1" }, "files_pdfviewer": { "enabled": "yes", "installed_version": "2.3.0", "types": "" }, "files_rightclick": { "enabled": "yes", "installed_version": "1.1.0", "types": "" }, "files_sharing": { "enabled": "yes", "installed_version": "1.13.2", "types": "filesystem" }, "files_texteditor": { "enabled": "no", "installed_version": "2.8.0", "types": "" }, "files_trashbin": { "enabled": "yes", "installed_version": "1.11.0", "types": "filesystem,dav" }, "files_versions": { "enabled": "yes", "installed_version": "1.14.0", "types": "filesystem,dav" }, "files_videoplayer": { "enabled": "yes", "installed_version": "1.11.0", "types": "" }, "files_videoviewer": { "enabled": "no", "installed_version": "0.1.3", "ocsid": "166054", "types": "" }, "firstrunwizard": { "enabled": "yes", "installed_version": "2.11.0", "types": "logging" }, "forms": { "enabled": "yes", "installed_version": "2.3.0", "types": "" }, "gallery": { "enabled": "no", "installed_version": "18.4.0", "types": "" }, "galleryplus": { "enabled": "no", "installed_version": "15.0.0", "ocsid": "169116", "types": "" }, "keeweb": { "enabled": "yes", "installed_version": "0.6.6", "types": "" }, "logreader": { "enabled": "yes", "installed_version": "2.7.0", "types": "" }, "lookup_server_connector": { "enabled": "yes", "installed_version": "1.9.0", "types": "authentication" }, "media": { "enabled": "no", "installed_version": "0.4.3" }, "mindmaps": { "enabled": "yes", "installed_version": "0.1.0", "types": "" }, "nextcloud_announcements": { "enabled": "yes", "installed_version": "1.11.0", "pub_date": "Thu, 24 Oct 2019 00:00:00 +0200", "types": "logging" }, "notes": { "enabled": "yes", "installed_version": "4.1.1", "types": "" }, "notifications": { "enabled": "yes", "installed_version": "2.10.1", "types": "logging" }, "oauth2": { "enabled": "yes", "installed_version": "1.9.0", "types": "authentication" }, "onlyoffice": { "enabled": "no", "installed_version": "1.1.4", "ocsid": "174798", "skey": "1496127086728", "types": "filesystem" }, "ownnote": { "enabled": "no", "folder": "ownNote", "installed_version": "1.08", "ocsid": "168512", "types": "" }, "password_policy": { "enabled": "yes", "installed_version": "1.12.0", "minLength": "13", "types": "authentication" }, "photos": { "enabled": "yes", "installed_version": "1.4.0", "types": "" }, "privacy": { "enabled": "yes", "installed_version": "1.6.0", "types": "" }, "provisioning_api": { "enabled": "yes", "installed_version": "1.11.0", "types": "prevent_group_restriction" }, "recommendations": { "enabled": "yes", "installed_version": "1.1.0", "types": "" }, "search_lucene": { "enabled": "no", "installed_version": "0.6.0", "ocsid": "168709", "types": "filesystem" }, "serverinfo": { "enabled": "yes", "installed_version": "1.12.0", "types": "" }, "settings": { "enabled": "yes", "installed_version": "1.3.0", "types": "" }, "sharebymail": { "enabled": "yes", "installed_version": "1.11.0", "types": "filesystem" }, "socialsharing_email": { "enabled": "no", "installed_version": "2.1.0", "types": "" }, "spreed": { "enable_matterbridge": "1", "enabled": "yes", "has_reference_id": "yes", "installed_version": "12.0.1", "matterbridge_binary": "\/var\/www\/html\/custom_apps\/talk_matterbridge\/bin\/matterbridge-1.22.3-linux-64bit", "project_access_invalidated": "1", "stun_servers": "***REMOVED SENSITIVE VALUE***", "types": "dav,prevent_group_restriction" }, "support": { "SwitchUpdaterServerHasRun": "yes", "enabled": "yes", "installed_version": "1.5.0", "types": "session" }, "survey_client": { "enabled": "yes", "installed_version": "1.10.0", "last_report": "{\"id\":\"51ff95d5e68a2\",\"items\":[[\"server\",\"version\",\"18.0.3.0\"],[\"server\",\"code\",\"other\"],[\"server\" ,\"enable_avatars\",\"yes\"],[\"server\",\"enable_previews\",\"yes\"],[\"server\",\"memcache.local\",\"\\\\OC\\\\Memcache\\\\APCu\"],[\"server\",\ "memcache.distributed\",\"none\"],[\"server\",\"asset-pipeline.enabled\",\"no\"],[\"server\",\"filelocking.enabled\",\"yes\"],[\"server\",\"memcac he.locking\",\"none\"],[\"server\",\"debug\",\"no\"],[\"server\",\"cron\",\"cron\"],[\"php\",\"version\",\"7.3.16\"],[\"php\",\"memory_limit\",536 870912],[\"php\",\"max_execution_time\",0],[\"php\",\"upload_max_filesize\",2097152],[\"database\",\"type\",\"mysql\"],[\"database\",\"version\",\ "10.3.13\"],[\"database\",\"size\",27394048],[\"apps\",\"accessibility\",\"1.4.0\"],[\"apps\",\"activity\",\"2.11.0\"],[\"apps\",\"admin_audit\",\ "1.8.0\"],[\"apps\",\"admin_dependencies_chk\",\"disabled\"],[\"apps\",\"admin_migrate\",\"disabled\"],[\"apps\",\"bookmarks\",\"disabled\"],[\"ap ps\",\"bruteforcesettings\",\"1.6.0\"],[\"apps\",\"calendar\",\"disabled\"],[\"apps\",\"cloud_federation_api\",\"1.1.0\"],[\"apps\",\"comments\",\ "1.8.0\"],[\"apps\",\"contacts\",\"disabled\"],[\"apps\",\"dav\",\"1.14.0\"],[\"apps\",\"deck\",\"0.8.2\"],[\"apps\",\"documents\",\"disabled\"],[ \"apps\",\"drawio\",\"0.9.5\"],[\"apps\",\"external\",\"disabled\"],[\"apps\",\"federatedfilesharing\",\"1.8.0\"],[\"apps\",\"federation\",\"1.8.0 \"],[\"apps\",\"files\",\"1.13.1\"],[\"apps\",\"files_imageviewer\",\"disabled\"],[\"apps\",\"files_markdown\",\"2.2.0\"],[\"apps\",\"files_odfvie wer\",\"disabled\"],[\"apps\",\"files_pdfviewer\",\"1.7.0\"],[\"apps\",\"files_rightclick\",\"0.15.2\"],[\"apps\",\"files_sharing\",\"1.10.1\"],[\ "apps\",\"files_texteditor\",\"disabled\"],[\"apps\",\"files_trashbin\",\"1.8.0\"],[\"apps\",\"files_versions\",\"1.11.0\"],[\"apps\",\"files_vide oplayer\",\"1.7.0\"],[\"apps\",\"files_videoviewer\",\"disabled\"],[\"apps\",\"firstrunwizard\",\"2.7.0\"],[\"apps\",\"gallery\",\"disabled\"],[\" apps\",\"galleryplus\",\"disabled\"],[\"apps\",\"keeweb\",\"0.6.2\"],[\"apps\",\"logreader\",\"2.3.0\"],[\"apps\",\"lookup_server_connector\",\"1. 6.0\"],[\"apps\",\"media\",\"disabled\"],[\"apps\",\"mindmaps\",\"0.1.0\"],[\"apps\",\"nextcloud_announcements\",\"1.7.0\"],[\"apps\",\"notes\",\" 3.2.0\"],[\"apps\",\"notifications\",\"2.6.0\"],[\"apps\",\"oauth2\",\"1.6.0\"],[\"apps\",\"onlyoffice\",\"disabled\"],[\"apps\",\"ownnote\",\"dis abled\"],[\"apps\",\"password_policy\",\"1.8.0\"],[\"apps\",\"photos\",\"1.0.0\"],[\"apps\",\"privacy\",\"1.2.0\"],[\"apps\",\"provisioning_api\", \"1.8.0\"],[\"apps\",\"recommendations\",\"0.6.0\"],[\"apps\",\"search_lucene\",\"disabled\"],[\"apps\",\"serverinfo\",\"1.8.0\"],[\"apps\",\"sett ings\",\"1.0.0\"],[\"apps\",\"sharebymail\",\"1.8.0\"],[\"apps\",\"socialsharing_email\",\"disabled\"],[\"apps\",\"support\",\"1.1.0\"],[\"apps\", \"survey_client\",\"1.6.0\"],[\"apps\",\"systemtags\",\"1.8.0\"],[\"apps\",\"templateeditor\",\"disabled\"],[\"apps\",\"text\",\"2.0.0\"],[\"apps\ ",\"theming\",\"1.9.0\"],[\"apps\",\"twofactor_backupcodes\",\"1.7.0\"],[\"apps\",\"twofactor_rcdevsopenotp\",\"1.0.3\"],[\"apps\",\"twofactor_tot p\",\"4.1.3\"],[\"apps\",\"updatenotification\",\"1.8.0\"],[\"apps\",\"updater\",\"disabled\"],[\"apps\",\"user_migrate\",\"disabled\"],[\"apps\", \"viewer\",\"1.2.0\"],[\"apps\",\"workflowengine\",\"2.0.0\"],[\"stats\",\"num_files\",52258],[\"stats\",\"num_users\",5],[\"stats\",\"num_storage s\",22],[\"stats\",\"num_storages_local\",7],[\"stats\",\"num_storages_home\",5],[\"stats\",\"num_storages_other\",10],[\"stats\",\"num_comments\" ,0],[\"stats\",\"num_comment_markers\",0],[\"stats\",\"num_systemtags\",0],[\"stats\",\"num_systemtags_mappings\",0],[\"files_sharing\",\"num_shar es\",7],[\"files_sharing\",\"num_shares_user\",6],[\"files_sharing\",\"num_shares_groups\",0],[\"files_sharing\",\"num_shares_link\",0],[\"files_s haring\",\"num_shares_link_no_password\",0],[\"files_sharing\",\"num_fed_shares_sent\",0],[\"files_sharing\",\"num_fed_shares_received\",0],[\"fil es_sharing\",\"permissions_4_1\",\"1\"],[\"files_sharing\",\"permissions_0_17\",\"2\"],[\"files_sharing\",\"permissions_0_19\",\"3\"],[\"files_sha ring\",\"permissions_0_31\",\"1\"],[\"encryption\",\"enabled\",\"no\"],[\"encryption\",\"default_module\",\"no\"]]}", "last_sent": "1587401109", "types": "" }, "systemtags": { "enabled": "yes", "installed_version": "1.11.0", "types": "logging" }, "talk_matterbridge": { "enabled": "yes", [44/1900] "installed_version": "1.22.4", "types": "prevent_group_restriction" }, "templateeditor": { "enabled": "no", "installed_version": "0.2", "types": "" }, "text": { "enabled": "yes", "installed_version": "3.3.0", "types": "dav" }, "theming": { "cachebuster": "7", "color": "#35BA2B", "enabled": "yes", "installed_version": "1.12.0", "name": "Oma Pilivi", "slogan": "***REMOVED SENSITIVE VALUE***", "types": "logging", "url": "***REMOVED SENSITIVE VALUE***" }, "twofactor_backupcodes": { "enabled": "yes", "installed_version": "1.10.1", "types": "" }, "twofactor_rcdevsopenotp": { "installed_version": "1.0.3", "types": "prelogin,authentication" }, "twofactor_totp": { "enabled": "yes", "installed_version": "6.1.0", "types": "" }, "updatenotification": { "bruteforcesettings": "2.0.1", "calendar": "2.2.0", "core": "21.0.1.1", "deck": "1.3.2", "drawio": "1.0.0", "enabled": "yes", "files_markdown": "2.3.3", "files_pdfviewer": "1.2.1", "files_rightclick": "0.15.1", "forms": "2.2.4", "installed_version": "1.11.0", "keeweb": "0.6.5", "notes": "4.0.4", "onlyoffice": "1.1.4", "spreed": "11.1.1", "twofactor_totp": "5.0.0", "types": "", "update_check_errors": "0" }, "updater": { "enabled": "no", "installed_version": "0.6", "types": "" }, "user_migrate": { "enabled": "no", "installed_version": "0.1" }, "user_status": { "enabled": "yes", "installed_version": "1.1.1", "types": "" }, "viewer": { "enabled": "yes", "installed_version": "1.6.0", "types": "" }, "weather_status": { "enabled": "yes", "installed_version": "1.1.0", "types": "" }, "workflowengine": { "enabled": "yes", "installed_version": "2.3.0", "types": "filesystem" } } ``` </details> **Are you using external storage, if yes which one:** nfs **Are you using encryption:** no **Are you using an external user-backend, if yes which one:** no ### Client configuration **Browser:** FF **Operating system:** RHEL 8 ### Logs #### Nextcloud log (data/nextcloud.log) <details> <summary>Nextcloud log</summary> ``` { "app" : "index", "user" : "foobar", "exception" : { "Line" : 114, "Message" : "An exception occurred while executing a query: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size", "File" : "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php", "Code" : 1038, "Trace" : [ { "args" : [ { "__class__" : "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, { "__class__" : "Doctrine\\DBAL\\Query" } ], "type" : "->", "function" : "convert", "line" : 1728, "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "class" : "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter" }, { "class" : "Doctrine\\DBAL\\Connection", "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "function" : "handleDriverException", "line" : 1667, "args" : [ { "__class__" : "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, { "__class__" : "Doctrine\\DBAL\\Query" } ], "type" : "->" }, { "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "class" : "Doctrine\\DBAL\\Connection", "args" : [ { "__class__" : "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, "SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = ?) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` `share_filecache` ON `share`.`file_source` = `share_filecache`.`fileid` LEFT JOIN `oc_circles_member` `share_circle_owner` ON (`share_circle_owner`.`circle_id` = `share_circle`.`unique_id`) AND (`share_circle_owner`.`level` = ?) LEFT JOIN `oc_circles_circle` `share_memberships_config` ON `share_memberships`.`circle_id` = `share_memberships_config`.`unique_id` LEFT JOIN `oc_circles_member` `share_initiator` ON (`share_memberships`.`inheritance_first` = `share_initiator`.`single_id`) AND (`share_memberships`.`circle_id` = `share_initiator`.`circle_id`) LEFT JOIN `oc_share` `share_share` ON (`share_share`.`parent` = `share`.`id`) AND (`share_share`.`share_with` = `share_memberships`.`single_id`) LEFT JOIN `oc_circles_member` `share_initiator_inheritedby` ON (`share_memberships`.`single_id` = `share_initiator_inheritedby`.`single_id`) AND (`share_memberships`.`inheritance_last` = `share_initiator_inheritedby`.`circle_id`) LEFT JOIN `oc_circles_circle` `share_initiator_basedon` ON `share_initiator_basedon`.`unique_id` = `share_initiator`.`single_id` LEFT JOIN `oc_storages` `share_filecache_storages` ON `share_filecache`.`storage` = `share_filecache_storages`.`numeric_id` WHERE (`share`.`share_type` = ?) AND (`share_memberships`.`level` >= ?) AND (`share`.`parent` IS NULL) GROUP BY `share`.`mail_send`, `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share_circle`.`unique_id`, `share_circle`.`name`, `share_circle`.`display_name`, `share_circle`.`sanitized_name`, `share_circle`.`source`, `share_circle`.`description`, `share_circle`.`settings`, `share_circle`.`config`, `share_circle`.`contact_addressbook`, `share_circle`.`contact_groupname`, `share_circle`.`creation`, `share_circle_owner`.`circle_id`, `share_circle_owner`.`member_id`, `share_circle_owner`.`single_id`, `share_circle_owner`.`user_id`, `share_circle_owner`.`instance`, `share_circle_owner`.`user_type`, `share_circle_owner`.`level`, `share_circle_owner`.`status`, `share_circle_owner`.`note`, `share_circle_owner`.`contact_id`, `share_circle_owner`.`cached_name`, `share_circle_owner`.`cached_update`, `share_circle_owner`.`contact_meta`, `share_circle_owner`.`joined`, `share_initiator`.`circle_id`, `share_initiator`.`member_id`, `share_initiator`.`single_id`, `share_initiator`.`user_id`, `share_initiator`.`instance`, `share_initiator`.`user_type`, `share_initiator`.`level`, `share_initiator`.`status`, `share_initiator`.`note`, `share_initiator`.`contact_id`, `share_initiator`.`cached_name`, `share_initiator`.`cached_update`, `share_initiator`.`contact_meta`, `share_initiator`.`joined`, `share_initiator_inheritedby`.`circle_id`, `share_initiator_inheritedby`.`member_id`, `share_initiator_inheritedby`.`single_id`, `share_initiator_inheritedby`.`user_id`, `share_initiator_inheritedby`.`instance`, `share_initiator_inheritedby`.`user_type`, `share_initiator_inheritedby`.`level`, `share_initiator_inheritedby`.`status`, `share_initiator_inheritedby`.`note`, `share_initiator_inheritedby`.`contact_id`, `share_initiator_inheritedby`.`cached_name`, `share_initiator_inheritedby`.`cached_update`, `share_initiator_inheritedby`.`contact_meta`, `share_initiator_inheritedby`.`joined`, `share_memberships`.`single_id`, `share_memberships`.`circle_id`, `share_memberships`.`level`, `share_memberships`.`inheritance_first`, `share_memberships`.`inheritance_last`, `share_memberships`.`inheritance_path`, `share_memberships`.`inheritance_depth`, `share_initiator_basedon`.`unique_id`, `share_initiator_basedon`.`name`, `share_initiator_basedon`.`display_name`, `share_initiator_basedon`.`sanitized_name`, `share_initiator_basedon`.`source`, `share_initiator_basedon`.`description`, `share_initiator_basedon`.`settings`, `share_initiator_basedon`.`config`, `share_initiator_basedon`.`contact_addressbook`, `share_initiator_basedon`.`contact_groupname`, `share_initiator_basedon`.`creation`, `share_filecache`.`fileid`, `share_filecache`.`path`, `share_filecache`.`permissions`, `share_filecache`.`storage`, `share_filecache`.`path_hash`, `share_filecache`.`parent`, `share_filecache`.`name`, `share_filecache`.`mimetype`, `share_filecache`.`mimepart`, `share_filecache`.`size`, `share_filecache`.`mtime`, `share_filecache`.`storage_mtime`, `share_filecache`.`encrypted`, `share_filecache`.`unencrypted_size`, `share_filecache`.`etag`, `share_filecache`.`checksum`, `share_filecache_storages`.`id`, `share_share`.`id`, `share_share`.`file_target`, `share_share`.`permissions`", [ "J6OUVcDP2QYrcnP85kfyBBfvLx59JmO", 9, 7, 1 ], [ 2, 1, 1, 2 ] ], "type" : "->", "line" : 1040, "function" : "convertExceptionDuringQuery" }, { "class" : "Doctrine\\DBAL\\Connection", "file" : "/var/www/html/lib/private/DB/Connection.php", "function" : "executeQuery", "line" : 231, "args" : [ "SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = ?) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` `share_filecache` ON `share`.`file_source` = `share_filecache`.`fileid` LEFT JOIN `oc_circles_member` `share_circle_owner` ON (`share_circle_owner`.`circle_id` = `share_circle`.`unique_id`) AND (`share_circle_owner`.`level` = ?) LEFT JOIN `oc_circles_circle` `share_memberships_config` ON `share_memberships`.`circle_id` = `share_memberships_config`.`unique_id` LEFT JOIN `oc_circles_member` `share_initiator` ON (`share_memberships`.`inheritance_first` = `share_initiator`.`single_id`) AND (`share_memberships`.`circle_id` = `share_initiator`.`circle_id`) LEFT JOIN `oc_share` `share_share` ON (`share_share`.`parent` = `share`.`id`) AND (`share_share`.`share_with` = `share_memberships`.`single_id`) LEFT JOIN `oc_circles_member` `share_initiator_inheritedby` ON (`share_memberships`.`single_id` = `share_initiator_inheritedby`.`single_id`) AND (`share_memberships`.`inheritance_last` = `share_initiator_inheritedby`.`circle_id`) LEFT JOIN `oc_circles_circle` `share_initiator_basedon` ON `share_initiator_basedon`.`unique_id` = `share_initiator`.`single_id` LEFT JOIN `oc_storages` `share_filecache_storages` ON `share_filecache`.`storage` = `share_filecache_storages`.`numeric_id` WHERE (`share`.`share_type` = ?) AND (`share_memberships`.`level` >= ?) AND (`share`.`parent` IS NULL) GROUP BY `share`.`mail_send`, `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share_circle`.`unique_id`, `share_circle`.`name`, `share_circle`.`display_name`, `share_circle`.`sanitized_name`, `share_circle`.`source`, `share_circle`.`description`, `share_circle`.`settings`, `share_circle`.`config`, `share_circle`.`contact_addressbook`, `share_circle`.`contact_groupname`, `share_circle`.`creation`, `share_circle_owner`.`circle_id`, `share_circle_owner`.`member_id`, `share_circle_owner`.`single_id`, `share_circle_owner`.`user_id`, `share_circle_owner`.`instance`, `share_circle_owner`.`user_type`, `share_circle_owner`.`level`, `share_circle_owner`.`status`, `share_circle_owner`.`note`, `share_circle_owner`.`contact_id`, `share_circle_owner`.`cached_name`, `share_circle_owner`.`cached_update`, `share_circle_owner`.`contact_meta`, `share_circle_owner`.`joined`, `share_initiator`.`circle_id`, `share_initiator`.`member_id`, `share_initiator`.`single_id`, `share_initiator`.`user_id`, `share_initiator`.`instance`, `share_initiator`.`user_type`, `share_initiator`.`level`, `share_initiator`.`status`, `share_initiator`.`note`, `share_initiator`.`contact_id`, `share_initiator`.`cached_name`, `share_initiator`.`cached_update`, `share_initiator`.`contact_meta`, `share_initiator`.`joined`, `share_initiator_inheritedby`.`circle_id`, `share_initiator_inheritedby`.`member_id`, `share_initiator_inheritedby`.`single_id`, `share_initiator_inheritedby`.`user_id`, `share_initiator_inheritedby`.`instance`, `share_initiator_inheritedby`.`user_type`, `share_initiator_inheritedby`.`level`, `share_initiator_inheritedby`.`status`, `share_initiator_inheritedby`.`note`, `share_initiator_inheritedby`.`contact_id`, `share_initiator_inheritedby`.`cached_name`, `share_initiator_inheritedby`.`cached_update`, `share_initiator_inheritedby`.`contact_meta`, `share_initiator_inheritedby`.`joined`, `share_memberships`.`single_id`, `share_memberships`.`circle_id`, `share_memberships`.`level`, `share_memberships`.`inheritance_first`, `share_memberships`.`inheritance_last`, `share_memberships`.`inheritance_path`, `share_memberships`.`inheritance_depth`, `share_initiator_basedon`.`unique_id`, `share_initiator_basedon`.`name`, `share_initiator_basedon`.`display_name`, `share_initiator_basedon`.`sanitized_name`, `share_initiator_basedon`.`source`, `share_initiator_basedon`.`description`, `share_initiator_basedon`.`settings`, `share_initiator_basedon`.`config`, `share_initiator_basedon`.`contact_addressbook`, `share_initiator_basedon`.`contact_groupname`, `share_initiator_basedon`.`creation`, `share_filecache`.`fileid`, `share_filecache`.`path`, `share_filecache`.`permissions`, `share_filecache`.`storage`, `share_filecache`.`path_hash`, `share_filecache`.`parent`, `share_filecache`.`name`, `share_filecache`.`mimetype`, `share_filecache`.`mimepart`, `share_filecache`.`size`, `share_filecache`.`mtime`, `share_filecache`.`storage_mtime`, `share_filecache`.`encrypted`, `share_filecache`.`unencrypted_size`, `share_filecache`.`etag`, `share_filecache`.`checksum`, `share_filecache_storages`.`id`, `share_share`.`id`, `share_share`.`file_target`, `share_share`.`permissions`", [ "J6OUVcDP2QYrcnP85kfyBBfvLx59JmO", 9, 7, 1 ], [ 2, 1, 1, 2 ], null ], "type" : "->" }, { "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "class" : "OC\\DB\\Connection", "type" : "->", "args" : [ "SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = :dcValue3) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` `share_filecache` ON `share`.`file_source` = `share_filecache`.`fileid` LEFT JOIN `oc_circles_member` `share_circle_owner` ON (`share_circle_owner`.`circle_id` = `share_circle`.`unique_id`) AND (`share_circle_owner`.`level` = :dcValue2) LEFT JOIN `oc_circles_circle` `share_memberships_config` ON `share_memberships`.`circle_id` = `share_memberships_config`.`unique_id` LEFT JOIN `oc_circles_member` `share_initiator` ON (`share_memberships`.`inheritance_first` = `share_initiator`.`single_id`) AND (`share_memberships`.`circle_id` = `share_initiator`.`circle_id`) LEFT JOIN `oc_share` `share_share` ON (`share_share`.`parent` = `share`.`id`) AND (`share_share`.`share_with` = `share_memberships`.`single_id`) LEFT JOIN `oc_circles_member` `share_initiator_inheritedby` ON (`share_memberships`.`single_id` = `share_initiator_inheritedby`.`single_id`) AND (`share_memberships`.`inheritance_last` = `share_initiator_inheritedby`.`circle_id`) LEFT JOIN `oc_circles_circle` `share_initiator_basedon` ON `share_initiator_basedon`.`unique_id` = `share_initiator`.`single_id` LEFT JOIN `oc_storages` `share_filecache_storages` ON `share_filecache`.`storage` = `share_filecache_storages`.`numeric_id` WHERE (`share`.`share_type` = :dcValue1) AND (`share_memberships`.`level` >= :dcValue4) AND (`share`.`parent` IS NULL) GROUP BY `share`.`mail_send`, `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share_circle`.`unique_id`, `share_circle`.`name`, `share_circle`.`display_name`, `share_circle`.`sanitized_name`, `share_circle`.`source`, `share_circle`.`description`, `share_circle`.`settings`, `share_circle`.`config`, `share_circle`.`contact_addressbook`, `share_circle`.`contact_groupname`, `share_circle`.`creation`, `share_circle_owner`.`circle_id`, `share_circle_owner`.`member_id`, `share_circle_owner`.`single_id`, `share_circle_owner`.`user_id`, `share_circle_owner`.`instance`, `share_circle_owner`.`user_type`, `share_circle_owner`.`level`, `share_circle_owner`.`status`, `share_circle_owner`.`note`, `share_circle_owner`.`contact_id`, `share_circle_owner`.`cached_name`, `share_circle_owner`.`cached_update`, `share_circle_owner`.`contact_meta`, `share_circle_owner`.`joined`, `share_initiator`.`circle_id`, `share_initiator`.`member_id`, `share_initiator`.`single_id`, `share_initiator`.`user_id`, `share_initiator`.`instance`, `share_initiator`.`user_type`, `share_initiator`.`level`, `share_initiator`.`status`, `share_initiator`.`note`, `share_initiator`.`contact_id`, `share_initiator`.`cached_name`, `share_initiator`.`cached_update`, `share_initiator`.`contact_meta`, `share_initiator`.`joined`, `share_initiator_inheritedby`.`circle_id`, `share_initiator_inheritedby`.`member_id`, `share_initiator_inheritedby`.`single_id`, `share_initiator_inheritedby`.`user_id`, `share_initiator_inheritedby`.`instance`, `share_initiator_inheritedby`.`user_type`, `share_initiator_inheritedby`.`level`, `share_initiator_inheritedby`.`status`, `share_initiator_inheritedby`.`note`, `share_initiator_inheritedby`.`contact_id`, `share_initiator_inheritedby`.`cached_name`, `share_initiator_inheritedby`.`cached_update`, `share_initiator_inheritedby`.`contact_meta`, `share_initiator_inheritedby`.`joined`, `share_memberships`.`single_id`, `share_memberships`.`circle_id`, `share_memberships`.`level`, `share_memberships`.`inheritance_first`, `share_memberships`.`inheritance_last`, `share_memberships`.`inheritance_path`, `share_memberships`.`inheritance_depth`, `share_initiator_basedon`.`unique_id`, `share_initiator_basedon`.`name`, `share_initiator_basedon`.`display_name`, `share_initiator_basedon`.`sanitized_name`, `share_initiator_basedon`.`source`, `share_initiator_basedon`.`description`, `share_initiator_basedon`.`settings`, `share_initiator_basedon`.`config`, `share_initiator_basedon`.`contact_addressbook`, `share_initiator_basedon`.`contact_groupname`, `share_initiator_basedon`.`creation`, `share_filecache`.`fileid`, `share_filecache`.`path`, `share_filecache`.`permissions`, `share_filecache`.`storage`, `share_filecache`.`path_hash`, `share_filecache`.`parent`, `share_filecache`.`name`, `share_filecache`.`mimetype`, `share_filecache`.`mimepart`, `share_filecache`.`size`, `share_filecache`.`mtime`, `share_filecache`.`storage_mtime`, `share_filecache`.`encrypted`, `share_filecache`.`unencrypted_size`, `share_filecache`.`etag`, `share_filecache`.`checksum`, `share_filecache_storages`.`id`, `share_share`.`id`, `share_share`.`file_target`, `share_share`.`permissions`", { "dcValue4" : 1, "dcValue1" : 7, "dcValue2" : 9, "dcValue3" : "J6OUVcDP2QYrcnP85kfyBBfvLx59JmO" }, { "dcValue3" : 2, "dcValue2" : 1, "dcValue1" : 1, "dcValue4" : 2 } ], "function" : "executeQuery", "line" : 210 }, { "file" : "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "class" : "Doctrine\\DBAL\\Query\\QueryBuilder", "args" : [], "type" : "->", "function" : "execute", "line" : 287 }, { "file" : "/var/www/html/apps/circles/vendor/artificial-owl/my-small-php-tools/lib/Db/Nextcloud/nc22/NC22ExtendedQueryBuilder.php", "class" : "OC\\DB\\QueryBuilder\\QueryBuilder", "type" : "->", "args" : [], "function" : "execute", "line" : 1340 }, { "file" : "/var/www/html/apps/circles/vendor/artificial-owl/my-small-php-tools/lib/Db/Nextcloud/nc22/NC22ExtendedQueryBuilder.php", "class" : "ArtificialOwl\\MySmallPhpTools\\Db\\Nextcloud\\nc22\\NC22ExtendedQueryBuilder", "type" : "->", "args" : [ [ { "__class__" : "OCA\\Circles\\Db\\CoreQueryBuilder" }, "parseSimpleSelectSql" ], "OCA\\Circles\\Model\\ShareWrapper", [] ], "function" : "getRows", "line" : 1276 }, { "function" : "asItems", "line" : 123, "args" : [ "OCA\\Circles\\Model\\ShareWrapper" ], "type" : "->", "class" : "ArtificialOwl\\MySmallPhpTools\\Db\\Nextcloud\\nc22\\NC22ExtendedQueryBuilder", "file" : "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php" }, { "file" : "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php", "class" : "OCA\\Circles\\Db\\ShareWrapperRequestBuilder", "type" : "->", "args" : [ { "__class__" : "OCA\\Circles\\Db\\CoreQueryBuilder" } ], "function" : "getItemsFromRequest", "line" : 339 }, { "class" : "OCA\\Circles\\Db\\ShareWrapperRequest", "file" : "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php", "function" : "getSharedWith", "line" : 180, "args" : [ { "__class__" : "OCA\\Circles\\Model\\FederatedUser" }, 0, { "__class__" : "OCA\\Circles\\Model\\Probes\\CircleProbe" } ], "type" : "->" }, { "line" : 557, "function" : "getSharedWith", "args" : [ { "__class__" : "OCA\\Circles\\Model\\FederatedUser" }, 0, { "__class__" : "OCA\\Circles\\Model\\Probes\\CircleProbe" } ], "type" : "->", "class" : "OCA\\Circles\\Service\\ShareWrapperService", "file" : "/var/www/html/apps/circles/lib/ShareByCircleProvider.php" }, { "line" : 1360, "function" : "getSharedWith", "type" : "->", "args" : [ "foobar", 7, null, -1, 0 ], "class" : "OCA\\Circles\\ShareByCircleProvider", "file" : "/var/www/html/lib/private/Share20/Manager.php" }, { "line" : 79, "function" : "getSharedWith", "args" : [ "foobar", 7, null, -1 ], "type" : "->", "class" : "OC\\Share20\\Manager", "file" : "/var/www/html/apps/files_sharing/lib/MountProvider.php" }, { "args" : [ { "__class__" : "OC\\User\\User" }, { "__class__" : "OC\\Files\\Storage\\StorageFactory" } ], "type" : "->", "line" : 118, "function" : "getMountsForUser", "file" : "/var/www/html/lib/private/Files/Config/MountProviderCollection.php", "class" : "OCA\\Files_Sharing\\MountProvider" }, { "line" : 429, "function" : "addMountForUser", "args" : [ { "__class__" : "OC\\User\\User" }, { "__class__" : "OC\\Files\\Mount\\Manager" } ], "type" : "->", "class" : "OC\\Files\\Config\\MountProviderCollection", "file" : "/var/www/html/lib/private/Files/Filesystem.php" }, { "class" : "OC\\Files\\Filesystem", "file" : "/var/www/html/lib/private/Files/Filesystem.php", "function" : "initMountPoints", "line" : 354, "type" : "::", "args" : [ "foobar" ] }, { "type" : "::", "args" : [ "foobar", "/foobar/files" ], "line" : 325, "function" : "init", "file" : "/var/www/html/lib/private/legacy/OC_Util.php", "class" : "OC\\Files\\Filesystem" }, { "args" : [], "type" : "::", "function" : "setupFS", "line" : 1023, "file" : "/var/www/html/lib/base.php", "class" : "OC_Util" }, { "line" : 36, "function" : "handleRequest", "args" : [], "type" : "::", "class" : "OC", "file" : "/var/www/html/index.php" } ], "Exception" : "Doctrine\\DBAL\\Exception\\DriverException", "Previous" : { "Previous" : { "Code" : "HY001", "Line" : 82, "Message" : "SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size", "Trace" : [ { "args" : [ null ], "type" : "->", "line" : 82, "function" : "execute", "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "class" : "PDOStatement" }, { "type" : "->", "args" : [], "function" : "execute", "line" : 1030, "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "class" : "Doctrine\\DBAL\\Driver\\PDO\\Statement" }, { "class" : "Doctrine\\DBAL\\Connection", "file" : "/var/www/html/lib/private/DB/Connection.php", "function" : "executeQuery", "line" : 231, "args" : [ "SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = ?) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` `share_filecache` ON `share`.`file_source` = `share_filecache`.`fileid` LEFT JOIN `oc_circles_member` `share_circle_owner` ON (`share_circle_owner`.`circle_id` = `share_circle`.`unique_id`) AND (`share_circle_owner`.`level` = ?) LEFT JOIN `oc_circles_circle` `share_memberships_config` ON `share_memberships`.`circle_id` = `share_memberships_config`.`unique_id` LEFT JOIN `oc_circles_member` `share_initiator` ON (`share_memberships`.`inheritance_first` = `share_initiator`.`single_id`) AND (`share_memberships`.`circle_id` = `share_initiator`.`circle_id`) LEFT JOIN `oc_share` `share_share` ON (`share_share`.`parent` = `share`.`id`) AND (`share_share`.`share_with` = `share_memberships`.`single_id`) LEFT JOIN `oc_circles_member` `share_initiator_inheritedby` ON (`share_memberships`.`single_id` = `share_initiator_inheritedby`.`single_id`) AND (`share_memberships`.`inheritance_last` = `share_initiator_inheritedby`.`circle_id`) LEFT JOIN `oc_circles_circle` `share_initiator_basedon` ON `share_initiator_basedon`.`unique_id` = `share_initiator`.`single_id` LEFT JOIN `oc_storages` `share_filecache_storages` ON `share_filecache`.`storage` = `share_filecache_storages`.`numeric_id` WHERE (`share`.`share_type` = ?) AND (`share_memberships`.`level` >= ?) AND (`share`.`parent` IS NULL) GROUP BY `share`.`mail_send`, `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share_circle`.`unique_id`, `share_circle`.`name`, `share_circle`.`display_name`, `share_circle`.`sanitized_name`, `share_circle`.`source`, `share_circle`.`description`, `share_circle`.`settings`, `share_circle`.`config`, `share_circle`.`contact_addressbook`, `share_circle`.`contact_groupname`, `share_circle`.`creation`, `share_circle_owner`.`circle_id`, `share_circle_owner`.`member_id`, `share_circle_owner`.`single_id`, `share_circle_owner`.`user_id`, `share_circle_owner`.`instance`, `share_circle_owner`.`user_type`, `share_circle_owner`.`level`, `share_circle_owner`.`status`, `share_circle_owner`.`note`, `share_circle_owner`.`contact_id`, `share_circle_owner`.`cached_name`, `share_circle_owner`.`cached_update`, `share_circle_owner`.`contact_meta`, `share_circle_owner`.`joined`, `share_initiator`.`circle_id`, `share_initiator`.`member_id`, `share_initiator`.`single_id`, `share_initiator`.`user_id`, `share_initiator`.`instance`, `share_initiator`.`user_type`, `share_initiator`.`level`, `share_initiator`.`status`, `share_initiator`.`note`, `share_initiator`.`contact_id`, `share_initiator`.`cached_name`, `share_initiator`.`cached_update`, `share_initiator`.`contact_meta`, `share_initiator`.`joined`, `share_initiator_inheritedby`.`circle_id`, `share_initiator_inheritedby`.`member_id`, `share_initiator_inheritedby`.`single_id`, `share_initiator_inheritedby`.`user_id`, `share_initiator_inheritedby`.`instance`, `share_initiator_inheritedby`.`user_type`, `share_initiator_inheritedby`.`level`, `share_initiator_inheritedby`.`status`, `share_initiator_inheritedby`.`note`, `share_initiator_inheritedby`.`contact_id`, `share_initiator_inheritedby`.`cached_name`, `share_initiator_inheritedby`.`cached_update`, `share_initiator_inheritedby`.`contact_meta`, `share_initiator_inheritedby`.`joined`, `share_memberships`.`single_id`, `share_memberships`.`circle_id`, `share_memberships`.`level`, `share_memberships`.`inheritance_first`, `share_memberships`.`inheritance_last`, `share_memberships`.`inheritance_path`, `share_memberships`.`inheritance_depth`, `share_initiator_basedon`.`unique_id`, `share_initiator_basedon`.`name`, `share_initiator_basedon`.`display_name`, `share_initiator_basedon`.`sanitized_name`, `share_initiator_basedon`.`source`, `share_initiator_basedon`.`description`, `share_initiator_basedon`.`settings`, `share_initiator_basedon`.`config`, `share_initiator_basedon`.`contact_addressbook`, `share_initiator_basedon`.`contact_groupname`, `share_initiator_basedon`.`creation`, `share_filecache`.`fileid`, `share_filecache`.`path`, `share_filecache`.`permissions`, `share_filecache`.`storage`, `share_filecache`.`path_hash`, `share_filecache`.`parent`, `share_filecache`.`name`, `share_filecache`.`mimetype`, `share_filecache`.`mimepart`, `share_filecache`.`size`, `share_filecache`.`mtime`, `share_filecache`.`storage_mtime`, `share_filecache`.`encrypted`, `share_filecache`.`unencrypted_size`, `share_filecache`.`etag`, `share_filecache`.`checksum`, `share_filecache_storages`.`id`, `share_share`.`id`, `share_share`.`file_target`, `share_share`.`permissions`", [ "J6OUVcDP2QYrcnP85kfyBBfvLx59JmO", 9, 7, 1 ], [ 2, 1, 1, 2 ], null ], "type" : "->" }, { "class" : "OC\\DB\\Connection", "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "function" : "executeQuery", "line" : 210, "type" : "->", "args" : [ "SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = :dcValue3) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` `share_filecache` ON `share`.`file_source` = `share_filecache`.`fileid` LEFT JOIN `oc_circles_member` `share_circle_owner` ON (`share_circle_owner`.`circle_id` = `share_circle`.`unique_id`) AND (`share_circle_owner`.`level` = :dcValue2) LEFT JOIN `oc_circles_circle` `share_memberships_config` ON `share_memberships`.`circle_id` = `share_memberships_config`.`unique_id` LEFT JOIN `oc_circles_member` `share_initiator` ON (`share_memberships`.`inheritance_first` = `share_initiator`.`single_id`) AND (`share_memberships`.`circle_id` = `share_initiator`.`circle_id`) LEFT JOIN `oc_share` `share_share` ON (`share_share`.`parent` = `share`.`id`) AND (`share_share`.`share_with` = `share_memberships`.`single_id`) LEFT JOIN `oc_circles_member` `share_initiator_inheritedby` ON (`share_memberships`.`single_id` = `share_initiator_inheritedby`.`single_id`) AND (`share_memberships`.`inheritance_last` = `share_initiator_inheritedby`.`circle_id`) LEFT JOIN `oc_circles_circle` `share_initiator_basedon` ON `share_initiator_basedon`.`unique_id` = `share_initiator`.`single_id` LEFT JOIN `oc_storages` `share_filecache_storages` ON `share_filecache`.`storage` = `share_filecache_storages`.`numeric_id` WHERE (`share`.`share_type` = :dcValue1) AND (`share_memberships`.`level` >= :dcValue4) AND (`share`.`parent` IS NULL) GROUP BY `share`.`mail_send`, `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share_circle`.`unique_id`, `share_circle`.`name`, `share_circle`.`display_name`, `share_circle`.`sanitized_name`, `share_circle`.`source`, `share_circle`.`description`, `share_circle`.`settings`, `share_circle`.`config`, `share_circle`.`contact_addressbook`, `share_circle`.`contact_groupname`, `share_circle`.`creation`, `share_circle_owner`.`circle_id`, `share_circle_owner`.`member_id`, `share_circle_owner`.`single_id`, `share_circle_owner`.`user_id`, `share_circle_owner`.`instance`, `share_circle_owner`.`user_type`, `share_circle_owner`.`level`, `share_circle_owner`.`status`, `share_circle_owner`.`note`, `share_circle_owner`.`contact_id`, `share_circle_owner`.`cached_name`, `share_circle_owner`.`cached_update`, `share_circle_owner`.`contact_meta`, `share_circle_owner`.`joined`, `share_initiator`.`circle_id`, `share_initiator`.`member_id`, `share_initiator`.`single_id`, `share_initiator`.`user_id`, `share_initiator`.`instance`, `share_initiator`.`user_type`, `share_initiator`.`level`, `share_initiator`.`status`, `share_initiator`.`note`, `share_initiator`.`contact_id`, `share_initiator`.`cached_name`, `share_initiator`.`cached_update`, `share_initiator`.`contact_meta`, `share_initiator`.`joined`, `share_initiator_inheritedby`.`circle_id`, `share_initiator_inheritedby`.`member_id`, `share_initiator_inheritedby`.`single_id`, `share_initiator_inheritedby`.`user_id`, `share_initiator_inheritedby`.`instance`, `share_initiator_inheritedby`.`user_type`, `share_initiator_inheritedby`.`level`, `share_initiator_inheritedby`.`status`, `share_initiator_inheritedby`.`note`, `share_initiator_inheritedby`.`contact_id`, `share_initiator_inheritedby`.`cached_name`, `share_initiator_inheritedby`.`cached_update`, `share_initiator_inheritedby`.`contact_meta`, `share_initiator_inheritedby`.`joined`, `share_memberships`.`single_id`, `share_memberships`.`circle_id`, `share_memberships`.`level`, `share_memberships`.`inheritance_first`, `share_memberships`.`inheritance_last`, `share_memberships`.`inheritance_path`, `share_memberships`.`inheritance_depth`, `share_initiator_basedon`.`unique_id`, `share_initiator_basedon`.`name`, `share_initiator_basedon`.`display_name`, `share_initiator_basedon`.`sanitized_name`, `share_initiator_basedon`.`source`, `share_initiator_basedon`.`description`, `share_initiator_basedon`.`settings`, `share_initiator_basedon`.`config`, `share_initiator_basedon`.`contact_addressbook`, `share_initiator_basedon`.`contact_groupname`, `share_initiator_basedon`.`creation`, `share_filecache`.`fileid`, `share_filecache`.`path`, `share_filecache`.`permissions`, `share_filecache`.`storage`, `share_filecache`.`path_hash`, `share_filecache`.`parent`, `share_filecache`.`name`, `share_filecache`.`mimetype`, `share_filecache`.`mimepart`, `share_filecache`.`size`, `share_filecache`.`mtime`, `share_filecache`.`storage_mtime`, `share_filecache`.`encrypted`, `share_filecache`.`unencrypted_size`, `share_filecache`.`etag`, `share_filecache`.`checksum`, `share_filecache_storages`.`id`, `share_share`.`id`, `share_share`.`file_target`, `share_share`.`permissions`", { "dcValue4" : 1, "dcValue1" : 7, "dcValue2" : 9, "dcValue3" : "J6OUVcDP2QYrcnP85kfyBBfvLx59JmO" }, { "dcValue3" : 2, "dcValue2" : 1, "dcValue4" : 2, "dcValue1" : 1 } ] }, { "type" : "->", "args" : [], "line" : 287, "function" : "execute", "file" : "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "class" : "Doctrine\\DBAL\\Query\\QueryBuilder" }, { "function" : "execute", "line" : 1340, "type" : "->", "args" : [], "class" : "OC\\DB\\QueryBuilder\\QueryBuilder", "file" : "/var/www/html/apps/circles/vendor/artificial-owl/my-small-php-tools/lib/Db/Nextcloud/nc22/NC22ExtendedQueryBuilder.php" }, { "type" : "->", "args" : [ [ { "__class__" : "OCA\\Circles\\Db\\CoreQueryBuilder" }, "parseSimpleSelectSql" ], "OCA\\Circles\\Model\\ShareWrapper", [] ], "function" : "getRows", "line" : 1276, "file" : "/var/www/html/apps/circles/vendor/artificial-owl/my-small-php-tools/lib/Db/Nextcloud/nc22/NC22ExtendedQueryBuilder.php", "class" : "ArtificialOwl\\MySmallPhpTools\\Db\\Nextcloud\\nc22\\NC22ExtendedQueryBuilder" }, { "file" : "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php", "class" : "ArtificialOwl\\MySmallPhpTools\\Db\\Nextcloud\\nc22\\NC22ExtendedQueryBuilder", "type" : "->", "args" : [ "OCA\\Circles\\Model\\ShareWrapper" ], "line" : 123, "function" : "asItems" }, { "file" : "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php", "class" : "OCA\\Circles\\Db\\ShareWrapperRequestBuilder", "args" : [ { "__class__" : "OCA\\Circles\\Db\\CoreQueryBuilder" } ], "type" : "->", "function" : "getItemsFromRequest", "line" : 339 }, { "args" : [ { "__class__" : "OCA\\Circles\\Model\\FederatedUser" }, 0, { "__class__" : "OCA\\Circles\\Model\\Probes\\CircleProbe" } ], "type" : "->", "function" : "getSharedWith", "line" : 180, "file" : "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php", "class" : "OCA\\Circles\\Db\\ShareWrapperRequest" }, { "class" : "OCA\\Circles\\Service\\ShareWrapperService", "file" : "/var/www/html/apps/circles/lib/ShareByCircleProvider.php", "function" : "getSharedWith", "line" : 557, "args" : [ { "__class__" : "OCA\\Circles\\Model\\FederatedUser" }, 0, { "__class__" : "OCA\\Circles\\Model\\Probes\\CircleProbe" } ], "type" : "->" }, { "type" : "->", "args" : [ "foobar", 7, null, -1, 0 ], "line" : 1360, "function" : "getSharedWith", "file" : "/var/www/html/lib/private/Share20/Manager.php", "class" : "OCA\\Circles\\ShareByCircleProvider" }, { "class" : "OC\\Share20\\Manager", "file" : "/var/www/html/apps/files_sharing/lib/MountProvider.php", "line" : 79, "function" : "getSharedWith", "type" : "->", "args" : [ "foobar", 7, null, -1 ] }, { "line" : 118, "function" : "getMountsForUser", "args" : [ { "__class__" : "OC\\User\\User" }, { "__class__" : "OC\\Files\\Storage\\StorageFactory" } ], "type" : "->", "class" : "OCA\\Files_Sharing\\MountProvider", "file" : "/var/www/html/lib/private/Files/Config/MountProviderCollection.php" }, { "file" : "/var/www/html/lib/private/Files/Filesystem.php", "class" : "OC\\Files\\Config\\MountProviderCollection", "args" : [ { "__class__" : "OC\\User\\User" }, { "__class__" : "OC\\Files\\Mount\\Manager" } ], "type" : "->", "line" : 429, "function" : "addMountForUser" }, { "function" : "initMountPoints", "line" : 354, "args" : [ "foobar" ], "type" : "::", "class" : "OC\\Files\\Filesystem", "file" : "/var/www/html/lib/private/Files/Filesystem.php" }, { "args" : [ "foobar", "/foobar/files" ], "type" : "::", "function" : "init", "line" : 325, "file" : "/var/www/html/lib/private/legacy/OC_Util.php", "class" : "OC\\Files\\Filesystem" }, { "class" : "OC_Util", "file" : "/var/www/html/lib/base.php", "line" : 1023, "function" : "setupFS", "args" : [], "type" : "::" }, { "type" : "::", "args" : [], "line" : 36, "function" : "handleRequest", "file" : "/var/www/html/index.php", "class" : "OC" } ], "File" : "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "Exception" : "PDOException" }, "File" : "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php", "Exception" : "Doctrine\\DBAL\\Driver\\PDO\\Exception", "Trace" : [ { "function" : "new", "line" : 84, "type" : "::", "args" : [ { "__class__" : "PDOException", "errorInfo" : [ "HY001", 1038, "Out of sort memory, consider increasing server sort buffer size" ] } ], "class" : "Doctrine\\DBAL\\Driver\\PDO\\Exception", "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php" }, { "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "class" : "Doctrine\\DBAL\\Driver\\PDO\\Statement", "type" : "->", "args" : [], "line" : 1030, "function" : "execute" }, { "class" : "Doctrine\\DBAL\\Connection", "file" : "/var/www/html/lib/private/DB/Connection.php", "line" : 231, "function" : "executeQuery", "args" : [ "SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = ?) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` `share_filecache` ON `share`.`file_source` = `share_filecache`.`fileid` LEFT JOIN `oc_circles_member` `share_circle_owner` ON (`share_circle_owner`.`circle_id` = `share_circle`.`unique_id`) AND (`share_circle_owner`.`level` = ?) LEFT JOIN `oc_circles_circle` `share_memberships_config` ON `share_memberships`.`circle_id` = `share_memberships_config`.`unique_id` LEFT JOIN `oc_circles_member` `share_initiator` ON (`share_memberships`.`inheritance_first` = `share_initiator`.`single_id`) AND (`share_memberships`.`circle_id` = `share_initiator`.`circle_id`) LEFT JOIN `oc_share` `share_share` ON (`share_share`.`parent` = `share`.`id`) AND (`share_share`.`share_with` = `share_memberships`.`single_id`) LEFT JOIN `oc_circles_member` `share_initiator_inheritedby` ON (`share_memberships`.`single_id` = `share_initiator_inheritedby`.`single_id`) AND (`share_memberships`.`inheritance_last` = `share_initiator_inheritedby`.`circle_id`) LEFT JOIN `oc_circles_circle` `share_initiator_basedon` ON `share_initiator_basedon`.`unique_id` = `share_initiator`.`single_id` LEFT JOIN `oc_storages` `share_filecache_storages` ON `share_filecache`.`storage` = `share_filecache_storages`.`numeric_id` WHERE (`share`.`share_type` = ?) AND (`share_memberships`.`level` >= ?) AND (`share`.`parent` IS NULL) GROUP BY `share`.`mail_send`, `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share_circle`.`unique_id`, `share_circle`.`name`, `share_circle`.`display_name`, `share_circle`.`sanitized_name`, `share_circle`.`source`, `share_circle`.`description`, `share_circle`.`settings`, `share_circle`.`config`, `share_circle`.`contact_addressbook`, `share_circle`.`contact_groupname`, `share_circle`.`creation`, `share_circle_owner`.`circle_id`, `share_circle_owner`.`member_id`, `share_circle_owner`.`single_id`, `share_circle_owner`.`user_id`, `share_circle_owner`.`instance`, `share_circle_owner`.`user_type`, `share_circle_owner`.`level`, `share_circle_owner`.`status`, `share_circle_owner`.`note`, `share_circle_owner`.`contact_id`, `share_circle_owner`.`cached_name`, `share_circle_owner`.`cached_update`, `share_circle_owner`.`contact_meta`, `share_circle_owner`.`joined`, `share_initiator`.`circle_id`, `share_initiator`.`member_id`, `share_initiator`.`single_id`, `share_initiator`.`user_id`, `share_initiator`.`instance`, `share_initiator`.`user_type`, `share_initiator`.`level`, `share_initiator`.`status`, `share_initiator`.`note`, `share_initiator`.`contact_id`, `share_initiator`.`cached_name`, `share_initiator`.`cached_update`, `share_initiator`.`contact_meta`, `share_initiator`.`joined`, `share_initiator_inheritedby`.`circle_id`, `share_initiator_inheritedby`.`member_id`, `share_initiator_inheritedby`.`single_id`, `share_initiator_inheritedby`.`user_id`, `share_initiator_inheritedby`.`instance`, `share_initiator_inheritedby`.`user_type`, `share_initiator_inheritedby`.`level`, `share_initiator_inheritedby`.`status`, `share_initiator_inheritedby`.`note`, `share_initiator_inheritedby`.`contact_id`, `share_initiator_inheritedby`.`cached_name`, `share_initiator_inheritedby`.`cached_update`, `share_initiator_inheritedby`.`contact_meta`, `share_initiator_inheritedby`.`joined`, `share_memberships`.`single_id`, `share_memberships`.`circle_id`, `share_memberships`.`level`, `share_memberships`.`inheritance_first`, `share_memberships`.`inheritance_last`, `share_memberships`.`inheritance_path`, `share_memberships`.`inheritance_depth`, `share_initiator_basedon`.`unique_id`, `share_initiator_basedon`.`name`, `share_initiator_basedon`.`display_name`, `share_initiator_basedon`.`sanitized_name`, `share_initiator_basedon`.`source`, `share_initiator_basedon`.`description`, `share_initiator_basedon`.`settings`, `share_initiator_basedon`.`config`, `share_initiator_basedon`.`contact_addressbook`, `share_initiator_basedon`.`contact_groupname`, `share_initiator_basedon`.`creation`, `share_filecache`.`fileid`, `share_filecache`.`path`, `share_filecache`.`permissions`, `share_filecache`.`storage`, `share_filecache`.`path_hash`, `share_filecache`.`parent`, `share_filecache`.`name`, `share_filecache`.`mimetype`, `share_filecache`.`mimepart`, `share_filecache`.`size`, `share_filecache`.`mtime`, `share_filecache`.`storage_mtime`, `share_filecache`.`encrypted`, `share_filecache`.`unencrypted_size`, `share_filecache`.`etag`, `share_filecache`.`checksum`, `share_filecache_storages`.`id`, `share_share`.`id`, `share_share`.`file_target`, `share_share`.`permissions`", [ "J6OUVcDP2QYrcnP85kfyBBfvLx59JmO", 9, 7, 1 ], [ 2, 1, 1, 2 ], null ], "type" : "->" }, { "type" : "->", "args" : [ "SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = :dcValue3) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` `share_filecache` ON `share`.`file_source` = `share_filecache`.`fileid` LEFT JOIN `oc_circles_member` `share_circle_owner` ON (`share_circle_owner`.`circle_id` = `share_circle`.`unique_id`) AND (`share_circle_owner`.`level` = :dcValue2) LEFT JOIN `oc_circles_circle` `share_memberships_config` ON `share_memberships`.`circle_id` = `share_memberships_config`.`unique_id` LEFT JOIN `oc_circles_member` `share_initiator` ON (`share_memberships`.`inheritance_first` = `share_initiator`.`single_id`) AND (`share_memberships`.`circle_id` = `share_initiator`.`circle_id`) LEFT JOIN `oc_share` `share_share` ON (`share_share`.`parent` = `share`.`id`) AND (`share_share`.`share_with` = `share_memberships`.`single_id`) LEFT JOIN `oc_circles_member` `share_initiator_inheritedby` ON (`share_memberships`.`single_id` = `share_initiator_inheritedby`.`single_id`) AND (`share_memberships`.`inheritance_last` = `share_initiator_inheritedby`.`circle_id`) LEFT JOIN `oc_circles_circle` `share_initiator_basedon` ON `share_initiator_basedon`.`unique_id` = `share_initiator`.`single_id` LEFT JOIN `oc_storages` `share_filecache_storages` ON `share_filecache`.`storage` = `share_filecache_storages`.`numeric_id` WHERE (`share`.`share_type` = :dcValue1) AND (`share_memberships`.`level` >= :dcValue4) AND (`share`.`parent` IS NULL) GROUP BY `share`.`mail_send`, `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share_circle`.`unique_id`, `share_circle`.`name`, `share_circle`.`display_name`, `share_circle`.`sanitized_name`, `share_circle`.`source`, `share_circle`.`description`, `share_circle`.`settings`, `share_circle`.`config`, `share_circle`.`contact_addressbook`, `share_circle`.`contact_groupname`, `share_circle`.`creation`, `share_circle_owner`.`circle_id`, `share_circle_owner`.`member_id`, `share_circle_owner`.`single_id`, `share_circle_owner`.`user_id`, `share_circle_owner`.`instance`, `share_circle_owner`.`user_type`, `share_circle_owner`.`level`, `share_circle_owner`.`status`, `share_circle_owner`.`note`, `share_circle_owner`.`contact_id`, `share_circle_owner`.`cached_name`, `share_circle_owner`.`cached_update`, `share_circle_owner`.`contact_meta`, `share_circle_owner`.`joined`, `share_initiator`.`circle_id`, `share_initiator`.`member_id`, `share_initiator`.`single_id`, `share_initiator`.`user_id`, `share_initiator`.`instance`, `share_initiator`.`user_type`, `share_initiator`.`level`, `share_initiator`.`status`, `share_initiator`.`note`, `share_initiator`.`contact_id`, `share_initiator`.`cached_name`, `share_initiator`.`cached_update`, `share_initiator`.`contact_meta`, `share_initiator`.`joined`, `share_initiator_inheritedby`.`circle_id`, `share_initiator_inheritedby`.`member_id`, `share_initiator_inheritedby`.`single_id`, `share_initiator_inheritedby`.`user_id`, `share_initiator_inheritedby`.`instance`, `share_initiator_inheritedby`.`user_type`, `share_initiator_inheritedby`.`level`, `share_initiator_inheritedby`.`status`, `share_initiator_inheritedby`.`note`, `share_initiator_inheritedby`.`contact_id`, `share_initiator_inheritedby`.`cached_name`, `share_initiator_inheritedby`.`cached_update`, `share_initiator_inheritedby`.`contact_meta`, `share_initiator_inheritedby`.`joined`, `share_memberships`.`single_id`, `share_memberships`.`circle_id`, `share_memberships`.`level`, `share_memberships`.`inheritance_first`, `share_memberships`.`inheritance_last`, `share_memberships`.`inheritance_path`, `share_memberships`.`inheritance_depth`, `share_initiator_basedon`.`unique_id`, `share_initiator_basedon`.`name`, `share_initiator_basedon`.`display_name`, `share_initiator_basedon`.`sanitized_name`, `share_initiator_basedon`.`source`, `share_initiator_basedon`.`description`, `share_initiator_basedon`.`settings`, `share_initiator_basedon`.`config`, `share_initiator_basedon`.`contact_addressbook`, `share_initiator_basedon`.`contact_groupname`, `share_initiator_basedon`.`creation`, `share_filecache`.`fileid`, `share_filecache`.`path`, `share_filecache`.`permissions`, `share_filecache`.`storage`, `share_filecache`.`path_hash`, `share_filecache`.`parent`, `share_filecache`.`name`, `share_filecache`.`mimetype`, `share_filecache`.`mimepart`, `share_filecache`.`size`, `share_filecache`.`mtime`, `share_filecache`.`storage_mtime`, `share_filecache`.`encrypted`, `share_filecache`.`unencrypted_size`, `share_filecache`.`etag`, `share_filecache`.`checksum`, `share_filecache_storages`.`id`, `share_share`.`id`, `share_share`.`file_target`, `share_share`.`permissions`", { "dcValue2" : 9, "dcValue1" : 7, "dcValue4" : 1, "dcValue3" : "J6OUVcDP2QYrcnP85kfyBBfvLx59JmO" }, { "dcValue2" : 1, "dcValue4" : 2, "dcValue1" : 1, "dcValue3" : 2 } ], "function" : "executeQuery", "line" : 210, "file" : "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "class" : "OC\\DB\\Connection" }, { "class" : "Doctrine\\DBAL\\Query\\QueryBuilder", "file" : "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line" : 287, "function" : "execute", "type" : "->", "args" : [] }, { "file" : "/var/www/html/apps/circles/vendor/artificial-owl/my-small-php-tools/lib/Db/Nextcloud/nc22/NC22ExtendedQueryBuilder.php", "class" : "OC\\DB\\QueryBuilder\\QueryBuilder", "args" : [], "type" : "->", "function" : "execute", "line" : 1340 }, { "file" : "/var/www/html/apps/circles/vendor/artificial-owl/my-small-php-tools/lib/Db/Nextcloud/nc22/NC22ExtendedQueryBuilder.php", "class" : "ArtificialOwl\\MySmallPhpTools\\Db\\Nextcloud\\nc22\\NC22ExtendedQueryBuilder", "args" : [ [ { "__class__" : "OCA\\Circles\\Db\\CoreQueryBuilder" }, "parseSimpleSelectSql" ], "OCA\\Circles\\Model\\ShareWrapper", [] ], "type" : "->", "function" : "getRows", "line" : 1276 }, { "args" : [ "OCA\\Circles\\Model\\ShareWrapper" ], "type" : "->", "function" : "asItems", "line" : 123, "file" : "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php", "class" : "ArtificialOwl\\MySmallPhpTools\\Db\\Nextcloud\\nc22\\NC22ExtendedQueryBuilder" }, { "args" : [ { "__class__" : "OCA\\Circles\\Db\\CoreQueryBuilder" } ], "type" : "->", "function" : "getItemsFromRequest", "line" : 339, "file" : "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php", "class" : "OCA\\Circles\\Db\\ShareWrapperRequestBuilder" }, { "function" : "getSharedWith", "line" : 180, "type" : "->", "args" : [ { "__class__" : "OCA\\Circles\\Model\\FederatedUser" }, 0, { "__class__" : "OCA\\Circles\\Model\\Probes\\CircleProbe" } ], "class" : "OCA\\Circles\\Db\\ShareWrapperRequest", "file" : "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php" }, { "args" : [ { "__class__" : "OCA\\Circles\\Model\\FederatedUser" }, 0, { "__class__" : "OCA\\Circles\\Model\\Probes\\CircleProbe" } ], "type" : "->", "line" : 557, "function" : "getSharedWith", "file" : "/var/www/html/apps/circles/lib/ShareByCircleProvider.php", "class" : "OCA\\Circles\\Service\\ShareWrapperService" }, { "function" : "getSharedWith", "line" : 1360, "args" : [ "foobar", 7, null, -1, 0 ], "type" : "->", "class" : "OCA\\Circles\\ShareByCircleProvider", "file" : "/var/www/html/lib/private/Share20/Manager.php" }, { "type" : "->", "args" : [ "foobar", 7, null, -1 ], "function" : "getSharedWith", "line" : 79, "file" : "/var/www/html/apps/files_sharing/lib/MountProvider.php", "class" : "OC\\Share20\\Manager" }, { "class" : "OCA\\Files_Sharing\\MountProvider", "file" : "/var/www/html/lib/private/Files/Config/MountProviderCollection.php", "line" : 118, "function" : "getMountsForUser", "args" : [ { "__class__" : "OC\\User\\User" }, { "__class__" : "OC\\Files\\Storage\\StorageFactory" } ], "type" : "->" }, { "line" : 429, "function" : "addMountForUser", "args" : [ { "__class__" : "OC\\User\\User" }, { "__class__" : "OC\\Files\\Mount\\Manager" } ], "type" : "->", "class" : "OC\\Files\\Config\\MountProviderCollection", "file" : "/var/www/html/lib/private/Files/Filesystem.php" }, { "line" : 354, "function" : "initMountPoints", "args" : [ "foobar" ], "type" : "::", "class" : "OC\\Files\\Filesystem", "file" : "/var/www/html/lib/private/Files/Filesystem.php" }, { "line" : 325, "function" : "init", "args" : [ "foobar", "/foobar/files" ], "type" : "::", "class" : "OC\\Files\\Filesystem", "file" : "/var/www/html/lib/private/legacy/OC_Util.php" }, { "file" : "/var/www/html/lib/base.php", "class" : "OC_Util", "args" : [], "type" : "::", "function" : "setupFS", "line" : 1023 }, { "line" : 36, "function" : "handleRequest", "type" : "::", "args" : [], "class" : "OC", "file" : "/var/www/html/index.php" } ], "Message" : "SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size", "Code" : 1038, "Line" : 26 }, "CustomMessage" : "--" }, "method" : "GET", "userAgent" : "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0", "message" : "An exception occurred while executing a query: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size", "level" : 3, "version" : "22.1.0.1", "reqId" : "CSJBQC6iBpafKeieM9xU", "remoteAddr" : "10.0.2.100", "time" : "2021-08-15T07:15:21+00:00", "url" : "/" } ``` </details> #### Browser log </details>

Leonid1 · December 4, 2021, 2:01pm

Moin SysKeeper,
damit bin ich weitergekommen. Über FTP habe ich den Ordner /nextcloud/apps/circles umbenannt.
Danach konnte ich mich einloggen.
Vielen Dank für die Hilfe