Out of sort buffer memory error (sort_buffer_size) #789
Description
How to use GitHub
- Please use the 👍 reaction 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
- 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 - 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:
Signing status
Login as admin user into your Nextcloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here.
List of activated apps:
App list
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
Nextcloud configuration:
Config report
{
"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"
}
}
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)
Nextcloud log
{
"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" : "/"
}