{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/17558","labels_url":"https://api.github.com/repos/owncloud/core/issues/17558/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/17558/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/17558/events","html_url":"https://github.com/owncloud/core/issues/17558","id":94285035,"number":17558,"title":"OC 8.1 Heavy Performance Problems with Webinterface and Sync-App","user":{"login":"transistor91","id":10730099,"avatar_url":"https://avatars.githubusercontent.com/u/10730099?v=3","gravatar_id":"","url":"https://api.github.com/users/transistor91","html_url":"https://github.com/transistor91","followers_url":"https://api.github.com/users/transistor91/followers","following_url":"https://api.github.com/users/transistor91/following{/other_user}","gists_url":"https://api.github.com/users/transistor91/gists{/gist_id}","starred_url":"https://api.github.com/users/transistor91/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/transistor91/subscriptions","organizations_url":"https://api.github.com/users/transistor91/orgs","repos_url":"https://api.github.com/users/transistor91/repos","events_url":"https://api.github.com/users/transistor91/events{/privacy}","received_events_url":"https://api.github.com/users/transistor91/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/owncloud/core/labels/performance","name":"performance","color":"fbca04"},{"url":"https://api.github.com/repos/owncloud/core/labels/sharing","name":"sharing","color":"e102d8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":15,"created_at":"2015-07-10T10:59:20Z","updated_at":"2015-07-28T03:59:49Z","closed_at":null,"body":"### Steps to reproduce\r\nNormal usage of owncloud\r\n\r\n### Expected behaviour\r\nSync Client and/or Webinterface should react fast to uploads of files (small files, max. 3MB). \r\n\r\n### Actual behaviour\r\n Sync Client generates some errors and take really long time (not useful anymore), webinterface uploads file but progress bar only goes to 90%, upload is finished after some minutes. \r\nMysql process consumes a lot of CPU time.\r\nSometimes (but not always) client reports connection timeouts or OwnCloud reports wrong filesize (but not reproducable!). \r\n\r\n### Server configuration\r\n**Operating system**:\r\nOpenSuse 13.2\r\n\r\n**Web server:**\r\nApache/2.4.10\r\n\r\n**Database:**\r\nmysql  Ver 14.14 Distrib 5.6.25, for Linux (x86_64) using  EditLine wrapper\r\n\r\n**PHP version:**\r\nPHP 5.6.1 \r\n\r\n**ownCloud version:** (see ownCloud admin page)\r\n8.1\r\n\r\n**Updated from an older ownCloud or fresh install:**\r\nUpdated from older owncloud\r\n\r\n**List of activated apps:**\r\nall official and pre enabled apps + contacts + calendar\r\n\r\n**The content of config/config.php:**\r\n```\r\n<?php\r\n$CONFIG = array (\r\n  'instanceid' => '...',\r\n  'passwordsalt' => '...',\r\n  'datadirectory' => '/srv/www/htdocs/oc_data',\r\n  'dbtype' => 'mysql',\r\n  'version' => '8.1.0.8',\r\n  'dbname' => 'owncloud',\r\n  'dbhost' => 'localhost',\r\n  'dbtableprefix' => 'oc_',\r\n  'dbuser' => 'owncloud',\r\n  'dbpassword' => '...',\r\n  'installed' => true,\r\n  'maxZipInputSize' => 0,\r\n  'allowZipDownload' => true,\r\n  'forcessl' => true,\r\n  'theme' => '',\r\n  'maintenance' => false,\r\n  'overwritewebroot' => '/oc',\r\n  'overwrite.cli.url' => '/oc',\r\n  'preview_libreoffice_path' => '/usr/bin/libreoffice',\r\n  'trusted_domains' => \r\n  array (\r\n    0 => '...',\r\n    1 => '...',\r\n  ),  \r\n  'loglevel' => '1',\r\n  'log_type' => 'syslog',\r\n  'logtimezone' => 'Europe/Berlin',\r\n  'mail_smtpmode' => 'php',\r\n  'secret' => '...',\r\n);\r\n```\r\n\r\n**Are you using external storage, if yes which one:** local/smb/sftp/...\r\nNo\r\n\r\n**Are you using encryption:** yes/no\r\nNo\r\n\r\n**Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/...\r\nNo\r\n\r\n### Client configuration\r\n**Browser:**\r\nFirefox, 38.0.6\r\n\r\n**Operating system:**\r\nOpenSuse\r\n\r\n### Logs\r\n#### Web server error log\r\n```\r\n[Fri Jul 10 12:24:15.611668 2015] [mpm_prefork:notice] [pid 1031] AH00163: Apache/2.4.10 (Linux/SUSE) OpenSSL/1.0.1k-fips configured -- resuming normal operations\r\n[Fri Jul 10 12:24:15.731111 2015] [core:notice] [pid 1031] AH00094: Command line: '/usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D SSL -D SYSTEMD -D FOREGROUND'\r\n[Fri Jul 10 12:49:58.391066 2015] [core:notice] [pid 1031] AH00052: child pid 1707 exit signal Segmentation fault (11)\r\n[Fri Jul 10 12:52:18.546060 2015] [core:notice] [pid 1031] AH00052: child pid 1706 exit signal Segmentation fault (11)\r\n```\r\n\r\n#### ownCloud log (data/owncloud.log)\r\n```\r\n2015-07-10T12:28:08.646500+02:00 my-owncloud ownCloud[1707]: {no app in context} Encryption module \"\" not found, file will be stored unencrypted (Module with id: OC_DEFAULT_MODULE does not exist.)\r\n2015-07-10T12:30:03.335392+02:00 my-owncloud ownCloud[3520]: {PHP} Undefined index: REQUEST_URI at /srv/www/htdocs/oc/apps/contacts/appinfo/app.php#35\r\n2015-07-10T12:30:08.909672+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"IMG_20150608_111443.jpg\" from trash bin because it is older than 30\r\n2015-07-10T12:30:10.033020+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"IMG_20150608_111445.jpg\" from trash bin because it is older than 30\r\n2015-07-10T12:30:10.759300+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"TI.l##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:11.336722+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"TI.l##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:13.523102+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.b##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:15.544532+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.s##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:16.245408+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.b##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:16.930017+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.s##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:17.615748+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.b##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:18.191826+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.s##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:18.934518+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.b##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:19.568976+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.s##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:25.882842+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.b##\" from trash bin because it is older than 30\r\n2015-07-10T12:30:32.004572+02:00 my-owncloud ownCloud[3520]: {files_trashbin} remove \"Baseboard_V2.s##\" from trash bin because it is older than 30\r\n2015-07-10T12:33:10.027169+02:00 my-owncloud ownCloud[1708]: {PHP} Array to string conversion at /srv/www/htdocs/oc/lib/private/template/functions.php#36\r\n2015-07-10T12:36:00.321933+02:00 my-owncloud ownCloud[2575]: {core} No update found at the ownCloud appstore for app 166049\r\n2015-07-10T12:36:00.782670+02:00 my-owncloud ownCloud[2575]: {core} No update found at the ownCloud appstore for app 166051\r\n2015-07-10T12:36:00.903684+02:00 my-owncloud ownCloud[2575]: {core} No update found at the ownCloud appstore for app 166055\r\n2015-07-10T12:36:01.011004+02:00 my-owncloud ownCloud[2575]: {core} No update found at the ownCloud appstore for app 166048\r\n2015-07-10T12:36:18.830524+02:00 my-owncloud ownCloud[1308]: {index} Exception: {\"Exception\":\"Symfony\\\\Component\\\\Routing\\\\Exception\\\\RouteNotFoundException\",\"Message\":\"Unable to generate a URL for the named route \\\"calendar_index\\\" as such route does not exist.\",\"Code\":0,\"Trace\":\"#0 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/route\\/router.php(306): Symfony\\\\Component\\\\Routing\\\\Generator\\\\UrlGenerator->generate('calendar_index', Array, false)\\n#1 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/urlgenerator.php(65): OC\\\\Route\\\\Router->generate('calendar_index', Array)\\n#2 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/helper.php(139): OC\\\\URLGenerator->linkToRoute('calendar_index', Array)\\n#3 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/public\\/util.php(306): OC_Helper::linkToRoute('calendar_index', Array)\\n#4 \\/srv\\/www\\/htdocs\\/oc\\/apps\\/calendar\\/appinfo\\/app.php(30): OCP\\\\Util::linkToRoute('calendar_index')\\n#5 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/app.php(389): require('\\/srv\\/www\\/htdocs...')\\n#6 \\/srv\\/www\\/htdocs\\/oc\\/settings\\/ajax\\/navigationdetect.php(29): OC_App::getAppNavigationEntries('calendar')\\n#7 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/route\\/route.php(154) : runtime-created function(1): require_once('\\/srv\\/www\\/htdocs...')\\n#8 [internal function]: __lambda_func(Array)\\n#9 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/route\\/router.php(274): call_user_func('\\\\x00lambda_1072', Array)\\n#10 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/base.php(867): OC\\\\Route\\\\Router->match('\\/settings\\/ajax\\/...')\\n#11 \\/srv\\/www\\/htdocs\\/oc\\/index.php(40): OC::handleRequest()\\n#12 {main}\",\"File\":\"\\/srv\\/www\\/htdocs\\/oc\\/3rdparty\\/symfony\\/routing\\/Symfony\\/Component\\/Routing\\/Generator\\/UrlGenerator.php\",\"Line\":134}\r\n2015-07-10T12:36:21.675018+02:00 my-owncloud ownCloud[1607]: {index} Exception: {\"Exception\":\"Symfony\\\\Component\\\\Routing\\\\Exception\\\\RouteNotFoundException\",\"Message\":\"Unable to generate a URL for the named route \\\"contacts_index\\\" as such route does not exist.\",\"Code\":0,\"Trace\":\"#0 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/route\\/router.php(306): Symfony\\\\Component\\\\Routing\\\\Generator\\\\UrlGenerator->generate('contacts_index', Array, false)\\n#1 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/urlgenerator.php(65): OC\\\\Route\\\\Router->generate('contacts_index', Array)\\n#2 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/helper.php(139): OC\\\\URLGenerator->linkToRoute('contacts_index', Array)\\n#3 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/public\\/util.php(306): OC_Helper::linkToRoute('contacts_index', Array)\\n#4 \\/srv\\/www\\/htdocs\\/oc\\/apps\\/contacts\\/appinfo\\/app.php(18): OCP\\\\Util::linkToRoute('contacts_index')\\n#5 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/app.php(389): require('\\/srv\\/www\\/htdocs...')\\n#6 \\/srv\\/www\\/htdocs\\/oc\\/settings\\/ajax\\/navigationdetect.php(29): OC_App::getAppNavigationEntries('contacts')\\n#7 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/route\\/route.php(154) : runtime-created function(1): require_once('\\/srv\\/www\\/htdocs...')\\n#8 [internal function]: __lambda_func(Array)\\n#9 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/private\\/route\\/router.php(274): call_user_func('\\\\x00lambda_760', Array)\\n#10 \\/srv\\/www\\/htdocs\\/oc\\/lib\\/base.php(867): OC\\\\Route\\\\Router->match('\\/settings\\/ajax\\/...')\\n#11 \\/srv\\/www\\/htdocs\\/oc\\/index.php(40): OC::handleRequest()\\n#12 {main}\",\"File\":\"\\/srv\\/www\\/htdocs\\/oc\\/3rdparty\\/symfony\\/routing\\/Symfony\\/Component\\/Routing\\/Generator\\/UrlGenerator.php\",\"Line\":134}\r\n2015-07-10T12:38:31.927751+02:00 my-owncloud ownCloud[1305]: {no app in context} Encryption module \"\" not found, file will be stored unencrypted (Module with id: OC_DEFAULT_MODULE does not exist.)\r\n2015-07-10T12:47:27.782717+02:00 my-owncloud ownCloud[1309]: {core} No update found at the ownCloud appstore for app 166049\r\n2015-07-10T12:47:28.300087+02:00 my-owncloud ownCloud[1309]: {core} No update found at the ownCloud appstore for app 166051\r\n2015-07-10T12:47:28.435706+02:00 my-owncloud ownCloud[1309]: {core} No update found at the ownCloud appstore for app 166055\r\n2015-07-10T12:47:28.547347+02:00 my-owncloud ownCloud[1309]: {core} No update found at the ownCloud appstore for app 166048\r\n```\r\n\r\n#### Browser log\r\n```\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/125431733","html_url":"https://github.com/owncloud/core/issues/17558#issuecomment-125431733","issue_url":"https://api.github.com/repos/owncloud/core/issues/17558","id":125431733,"user":{"login":"davidjericho","id":3369078,"avatar_url":"https://avatars.githubusercontent.com/u/3369078?v=3","gravatar_id":"","url":"https://api.github.com/users/davidjericho","html_url":"https://github.com/davidjericho","followers_url":"https://api.github.com/users/davidjericho/followers","following_url":"https://api.github.com/users/davidjericho/following{/other_user}","gists_url":"https://api.github.com/users/davidjericho/gists{/gist_id}","starred_url":"https://api.github.com/users/davidjericho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidjericho/subscriptions","organizations_url":"https://api.github.com/users/davidjericho/orgs","repos_url":"https://api.github.com/users/davidjericho/repos","events_url":"https://api.github.com/users/davidjericho/events{/privacy}","received_events_url":"https://api.github.com/users/davidjericho/received_events","type":"User","site_admin":false},"created_at":"2015-07-28T03:59:49Z","updated_at":"2015-07-28T03:59:49Z","body":"We've upgraded from OC7 to OC8.1 recently, and we experience exactly this problem. With sharing disabled, the service is snappy and extremely quick. With it turned on, I've noticed we're getting deadlocks on accessing the appconfig table, specifically related to files_sharing. \r\n\r\nappconfig is full of records similar to:\r\n\r\n    MariaDB [owncloudstable81]> select * from appconfig where appid='files_sharing' and configkey > 0 limit 2;\r\n    +---------------+-----------+-----------------+\r\n    | appid         | configkey | configvalue     |\r\n    +---------------+-----------+-----------------+\r\n    | files_sharing | 12526     | 1438053344.1823 |\r\n    | files_sharing | 12739     | 1438054256.5294 |\r\n    +---------------+-----------+-----------------+\r\n    2 rows in set (0.00 sec)\r\n\r\nAt this instant our system has 380 rows in there, this number goes up and down over time. \r\n\r\nIf I track timing information on the SQL queries, the update for files_sharing is the problem. Most of the time it has to wait for a lock, and the request ends up being serviced after a second or two (although sometimes as long as 20 seconds). Obviously it it results in terrible performance for lots of files, but it's working quietly enough in the background most users don't notice.\r\n\r\nHowever, occasionally I have the following in the owncloud log, a deadlock and exception on the appconfig table. \r\n\r\n```\r\n{\r\n\t\"reqId\": \"AJ07757OAGolEqGrzM\\/M\",\r\n\t\"remoteAddr\": \"10.222.111.222\",\r\n\t\"app\": \"webdav\",\r\n\t\"message\": \"Exception: {\r\n\t\\\"Message\\\":\\\"An exception occurred while executing 'UPDATE appconfig SET configvalue = ? WHERE appid = ? AND configkey = ?' with params [1438054253.89, \\\\\\\"files_sharing\\\\\\\", \\\\\\\"12739\\\\\\\"]:\\\\n\\\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"#0 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(116): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException))\\\\n#1 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Connection.php(996): Doctrine\\\\\\\\DBAL\\\\\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOMySql\\\\\\\\Driver), Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException), 'UPDATE appconfi...', Array)\\\\n#2 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/connection.php(151): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->executeUpdate('UPDATE appconfi...', Array, Array)\\\\n#3 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Connection.php(669): OC\\\\\\\\DB\\\\\\\\Connection->executeUpdate('UPDATE *PREFIX*...', Array, Array)\\\\n#4 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/lib\\\\\\/private\\\\\\/appconfig.php(210): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->update('*PREFIX*appconf...', Array, Array)\\\\n#5 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/lib\\\\\\/private\\\\\\/allconfig.php(148): OC\\\\\\\\AppConfig->setValue('files_sharing', '12739', 1438054253.89)\\\\n#6 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/apps\\\\\\/files_sharing\\\\\\/lib\\\\\\/propagation\\\\\\/recipientpropagator.php(114): OC\\\\\\\\AllConfig->setAppValue('files_sharing', '12739', 1438054253.89)\\\\n#7 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/apps\\\\\\/files_sharing\\\\\\/lib\\\\\\/propagation\\\\\\/recipientpropagator.php(133): OCA\\\\\\\\Files_Sharing\\\\\\\\Propagation\\\\\\\\RecipientPropagator->markDirty(Array, 1438054253.89)\\\\n#8 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/apps\\\\\\/files_sharing\\\\\\/lib\\\\\\/propagation\\\\\\/recipientpropagator.php(125): OCA\\\\\\\\Files_Sharing\\\\\\\\Propagation\\\\\\\\RecipientPropagator->propagateById(17348995)\\\\n#9 [internal function]: OCA\\\\\\\\Files_Sharing\\\\\\\\Propagation\\\\\\\\RecipientPropagator->OCA\\\\\\\\Files_Sharing\\\\\\\\Propagation\\\\\\\\{closure}('\\\\\\/Shared\\\\\\/Bison_p...', Array)\\\\n#10 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/lib\\\\\\/private\\\\\\/hooks\\\\\\/emittertrait.php(98): call_user_func_array(Object(Closure), Array)\\\\n#11 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/changepropagator.php(80): OC\\\\\\\\Hooks\\\\\\\\BasicEmitter->emit('\\\\\\\\\\\\\\\\OC\\\\\\\\\\\\\\\\Files', 'propagate', Array)\\\\n#12 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/updater.php(92): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\ChangePropagator->propagateChanges(NULL)\\\\n#13 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/lib\\\\\\/private\\\\\\/connector\\\\\\/sabre\\\\\\/file.php(214): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Updater->propagate('\\\\\\/Shared\\\\\\/Bison_p...')\\\\n#14 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(1087): OC\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\File->put(Resource id #28)\\\\n#15 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/CorePlugin.php(501): Sabre\\\\\\\\DAV\\\\\\\\Server->updateFile('Shared\\\\\\/Bison_pr...', Resource id #28, NULL)\\\\n#16 [internal function]: Sabre\\\\\\\\DAV\\\\\\\\CorePlugin->httpPut(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#17 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/sabre\\\\\\/event\\\\\\/lib\\\\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\\\n#18 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(469): Sabre\\\\\\\\Event\\\\\\\\EventEmitter->emit('method:PUT', Array)\\\\n#19 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(254): Sabre\\\\\\\\DAV\\\\\\\\Server->invokeMethod(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#20 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/apps\\\\\\/files\\\\\\/appinfo\\\\\\/remote.php(83): Sabre\\\\\\\\DAV\\\\\\\\Server->exec()\\\\n#21 \\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/remote.php(132): require_once('\\\\\\/cloudstor\\\\\\/www\\\\\\/...')\\\\n#22 {main}\\\",\\\"File\\\":\\\"\\\\\\/cloudstor\\\\\\/www\\\\\\/owncloud-stable8.1\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractMySQLDriver.php\\\",\\\"Line\\\":115}\",\r\n\t\"level\": 4,\r\n\t\"time\": \"July 28, 2015 03:30:54\"\r\n}\r\n```\r\n\r\nTracing the php-fpm processes, they consistently stall and wait on UPDATEing appconfig, and quite routinely will stall when doing a SELECT. \r\n\r\nWith the rate of connections we have, contention on the appconfig table is a bad thing given how frequently OC 8.1 accesses it. \r\n\r\nI've had to work around the issue in the interim by forcing UPDATEs to the appconfig table to another MariaDB cluster member, and doing SELECT against appconfig on other machines, abusing the way MariaDB and Galera do replicated locking.\r\n\r\n"}}