{"action":"created","issue":{"url":"https://api.github.com/repos/nextcloud/server/issues/6187","repository_url":"https://api.github.com/repos/nextcloud/server","labels_url":"https://api.github.com/repos/nextcloud/server/issues/6187/labels{/name}","comments_url":"https://api.github.com/repos/nextcloud/server/issues/6187/comments","events_url":"https://api.github.com/repos/nextcloud/server/issues/6187/events","html_url":"https://github.com/nextcloud/server/issues/6187","id":251437002,"number":6187,"title":"Deadlock found when trying to get lock; try restarting transaction in LDAP app","user":{"login":"snowball77","id":6409197,"avatar_url":"https://avatars1.githubusercontent.com/u/6409197?v=4","gravatar_id":"","url":"https://api.github.com/users/snowball77","html_url":"https://github.com/snowball77","followers_url":"https://api.github.com/users/snowball77/followers","following_url":"https://api.github.com/users/snowball77/following{/other_user}","gists_url":"https://api.github.com/users/snowball77/gists{/gist_id}","starred_url":"https://api.github.com/users/snowball77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snowball77/subscriptions","organizations_url":"https://api.github.com/users/snowball77/orgs","repos_url":"https://api.github.com/users/snowball77/repos","events_url":"https://api.github.com/users/snowball77/events{/privacy}","received_events_url":"https://api.github.com/users/snowball77/received_events","type":"User","site_admin":false},"labels":[{"id":389032633,"url":"https://api.github.com/repos/nextcloud/server/labels/feature:%20ldap","name":"feature: ldap","color":"c2e0c6","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2017-08-19T16:56:15Z","updated_at":"2017-11-02T15:24:34Z","closed_at":null,"author_association":"NONE","body":"### Steps to reproduce\r\n1. Install nextcloud, LDAP and a DAV app like calendar\r\n2. Run a huge amount of DAV operations like in a calendar synchronization\r\n3.\r\n\r\n### Expected behaviour\r\nTell us what should happen\r\nServer should work fine. Best would be to not run into the issue at all, hotfix would be to do what the error says and retry the transaction (maybe while issueing a warning).\r\n\r\n### Actual behaviour\r\nTell us what happens instead\r\nYou get an \"internal server error\"\r\nServer log explains the cause is a database locking issue \"An exception occurred while executing 'UPDATE `oc_preferences` SET `configvalue` = ? WHERE (`userid` = ?) AND (`appid` = ?) AND (`configkey` = ?)' with params [...]. Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\"\r\n\r\n### General server configuration\r\n\r\n**Operating system:** Linux nextcloud-225186920-qsznp 3.10.0-514.21.1.el7.x86_64 #1 SMP Thu May 25 17:04:51 UTC 2017 x86_64\r\n\r\n**Web server:** Apache/2.4.10 (Debian) (apache2handler)\r\n\r\n**Database:** mysql 10.1.25\r\n\r\n**PHP version:** 7.1.8\r\n<details>\r\n        <summary>PHP-modules loaded</summary>\r\n\r\n```\r\n - Core\r\n - date\r\n - libxml\r\n - openssl\r\n - pcre\r\n - sqlite3\r\n - zlib\r\n - ctype\r\n - curl\r\n - dom\r\n - fileinfo\r\n - filter\r\n - ftp\r\n - hash\r\n - iconv\r\n - json\r\n - mbstring\r\n - SPL\r\n - PDO\r\n - session\r\n - posix\r\n - Reflection\r\n - standard\r\n - SimpleXML\r\n - pdo_sqlite\r\n - Phar\r\n - tokenizer\r\n - xml\r\n - xmlreader\r\n - xmlwriter\r\n - mysqlnd\r\n - apache2handler\r\n - apcu\r\n - exif\r\n - gd\r\n - intl\r\n - ldap\r\n - mcrypt\r\n - memcached\r\n - mysqli\r\n - pcntl\r\n - pdo_mysql\r\n - pdo_pgsql\r\n - pgsql\r\n - redis\r\n - zip\r\n - Zend OPcache\r\n```\r\n</details>\r\n\r\n### Nextcloud configuration\r\n\r\n**Nextcloud version:** 12.0.2 - 12.0.2.0\r\n\r\n**Updated from an older Nextcloud/ownCloud or fresh install: Updated from 12.0\r\n\r\n\r\n**Where did you install Nextcloud from: Offical docker image\r\n\r\n\r\n**Are you using external storage, if yes which one: no\r\n\r\n**Are you using encryption:** no\r\n\r\n**Are you using an external user-backend, if yes which one: LDAP, using OpenLDAP - this is the root cause.\r\n\r\n<details>\r\n        <summary>Signing status</summary>\r\n\r\n```\r\n[]\r\n```\r\n</details>\r\n\r\n<details>\r\n        <summary>Enabled apps</summary>\r\n\r\n```\r\n - activity: 2.5.2\r\n - bruteforcesettings: 1.0.2\r\n - calendar: 1.5.3\r\n - comments: 1.2.0\r\n - contacts: 1.5.3\r\n - dav: 1.3.0\r\n - federatedfilesharing: 1.2.0\r\n - federation: 1.2.0\r\n - files: 1.7.2\r\n - files_pdfviewer: 1.1.1\r\n - files_sharing: 1.4.0\r\n - files_texteditor: 2.4.1\r\n - files_trashbin: 1.2.0\r\n - files_versions: 1.5.0\r\n - files_videoplayer: 1.1.0\r\n - firstrunwizard: 2.1\r\n - gallery: 17.0.0\r\n - issuetemplate: 0.2.2\r\n - logreader: 2.0.0\r\n - lookup_server_connector: 1.0.0\r\n - nextcloud_announcements: 1.1\r\n - notifications: 2.0.0\r\n - oauth2: 1.0.5\r\n - password_policy: 1.2.2\r\n - provisioning_api: 1.2.0\r\n - serverinfo: 1.2.0\r\n - sharebymail: 1.2.0\r\n - survey_client: 1.0.0\r\n - systemtags: 1.2.0\r\n - theming: 1.3.0\r\n - twofactor_backupcodes: 1.1.1\r\n - updatenotification: 1.2.0\r\n - user_ldap: 1.2.1\r\n - workflowengine: 1.2.0\r\n```\r\n</details>\r\n\r\n<details>\r\n        <summary>Disabled apps</summary>\r\n\r\n```\r\n - admin_audit\r\n - encryption\r\n - files_external\r\n - user_external\r\n```\r\n</details>\r\n\r\n<details>\r\n        <summary>Content of config/config.php</summary>\r\n\r\n```\r\n{\r\n    \"apps_paths\": [\r\n        {\r\n            \"path\": \"\\/var\\/www\\/html\\/apps\",\r\n            \"url\": \"\\/apps\",\r\n            \"writable\": false\r\n        },\r\n        {\r\n            \"path\": \"\\/var\\/www\\/html\\/custom_apps\",\r\n            \"url\": \"\\/custom_apps\",\r\n            \"writable\": true\r\n        }\r\n    ],\r\n    \"instanceid\": \"oco6psmk02yu\",\r\n    \"passwordsalt\": \"***REMOVED SENSITIVE VALUE***\",\r\n    \"secret\": \"***REMOVED SENSITIVE VALUE***\",\r\n    \"trusted_domains\": [\r\n        \"storage.rss.iste.uni-stuttgart.de\",\r\n        \"nextcloud.default.svc.cluster.local\"\r\n    ],\r\n    \"datadirectory\": \"\\/var\\/www\\/html\\/data\",\r\n    \"overwrite.cli.url\": \"https:\\/\\/storage.rss.iste.uni-stuttgart.de\",\r\n    \"dbtype\": \"mysql\",\r\n    \"version\": \"12.0.2.0\",\r\n    \"dbname\": \"nextcloud\",\r\n    \"dbhost\": \"pxc-cluster.default.svc.cluster.local\",\r\n    \"dbport\": \"\",\r\n    \"dbtableprefix\": \"oc_\",\r\n    \"dbuser\": \"***REMOVED SENSITIVE VALUE***\",\r\n    \"dbpassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n    \"installed\": true,\r\n    \"ldapIgnoreNamingRules\": false,\r\n    \"ldapProviderFactory\": \"\\\\OCA\\\\User_LDAP\\\\LDAPProviderFactory\",\r\n    \"mail_smtpmode\": \"smtp\",\r\n    \"mail_smtpauthtype\": \"LOGIN\",\r\n    \"mail_domain\": \"rss.iste.uni-stuttgart.de\",\r\n    \"mail_smtphost\": \"mailgw.informatik.uni-stuttgart.de\",\r\n    \"mail_smtpport\": \"465\",\r\n    \"mail_smtpdebug\": true,\r\n    \"mail_smtpsecure\": \"ssl\",\r\n    \"mail_smtpauth\": 1,\r\n    \"mail_smtpname\": \"***REMOVED SENSITIVE VALUE***\",\r\n    \"mail_smtppassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n    \"memcache.local\": \"\\\\OC\\\\Memcache\\\\APCu\",\r\n    \"filelocking.enabled\": true,\r\n    \"memcache.locking\": \"\\\\OC\\\\Memcache\\\\Redis\",\r\n    \"redis\": {\r\n        \"host\": \"redis.default.svc.cluster.local\",\r\n        \"port\": 6379,\r\n        \"timeout\": 0,\r\n        \"password\": \"***REMOVED SENSITIVE VALUE***\"\r\n    },\r\n    \"mail_from_address\": \"nextcloud-noreply\",\r\n    \"theme\": \"\",\r\n    \"loglevel\": 2,\r\n    \"maintenance\": false,\r\n    \"updater.secret\": \"***REMOVED SENSITIVE VALUE***\"\r\n}\r\n```\r\n</details>\r\n\r\n<details>\r\n        <summary>LDAP config</summary>\r\n\r\n```\r\nWith access to your command line run e.g.:\r\nsudo -u www-data php occ ldap:show-config\r\nfrom within your Nextcloud installation folder\r\n\r\nWithout access to your command line download the data/owncloud.db to your local\r\ncomputer or access your SQL server remotely and run the select query:\r\nSELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';\r\n\r\nEventually replace sensitive data as the name/IP-address of your LDAP server or groups.\r\n```\r\n</details>\r\n\r\n### Client configuration\r\n\r\n**Browser:** Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:54.0) Gecko/20100101 Firefox/54.0\r\n\r\n**Operating system: latest MacOS\r\n\r\n### Logs\r\n\r\n<details>\r\n        <summary>Web server error log</summary>\r\n\r\n```\r\nInsert your webserver log here\r\n```\r\n</details>\r\n\r\n<details>\r\n        <summary>Nextcloud log (data/nextcloud.log)</summary>\r\n\r\n{\"reqId\":\"o0nv7P3dGBdRoHu5kexs\",\"level\":3,\"time\":\"2017-08-19T15:51:18+00:00\",\"remoteAddr\":\"10.244.4.134\",\"user\":\"--\",\"app\":\"no app in context\",\"method\":\"PROPFIND\",\"url\":\"\\/remote.php\\/dav\\/principals\\/users\\/ae7066da-f4fb-1036-8cad-9b286aacc383\\/\",\"message\":\"Exception: {\\\"Exception\\\":\\\"Doctrine\\\\\\\\DBAL\\\\\\\\Exception\\\\\\\\DriverException\\\",\\\"Message\\\":\\\"An exception occurred while executing 'UPDATE `oc_preferences` SET `configvalue` = ? WHERE (`userid` = ?) AND (`appid` = ?) AND (`configkey` = ?)' with params [1503157877, \\\\\\\"ae7066da-f4fb-1036-8cad-9b286aacc383\\\\\\\", \\\\\\\"user_ldap\\\\\\\", \\\\\\\"lastFeatureRefresh\\\\\\\"]:\\\\n\\\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"#0 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(128): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException))\\\\n#1 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Connection.php(1015): Doctrine\\\\\\\\DBAL\\\\\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOMySql\\\\\\\\Driver), Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException), 'UPDATE `oc_pref...', Array)\\\\n#2 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/DB\\\\\\/Connection.php(213): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->executeUpdate('UPDATE `oc_pref...', Array, Array)\\\\n#3 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Query\\\\\\/QueryBuilder.php(208): OC\\\\\\\\DB\\\\\\\\Connection->executeUpdate('UPDATE `oc_pref...', Array, Array)\\\\n#4 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/DB\\\\\\/QueryBuilder\\\\\\/QueryBuilder.php(213): Doctrine\\\\\\\\DBAL\\\\\\\\Query\\\\\\\\QueryBuilder->execute()\\\\n#5 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/AllConfig.php(232): OC\\\\\\\\DB\\\\\\\\QueryBuilder\\\\\\\\QueryBuilder->execute()\\\\n#6 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/User\\\\\\/User.php(372): OC\\\\\\\\AllConfig->setUserValue('ae7066da-f4fb-1...', 'user_ldap', 'lastFeatureRefr...', 1503157877)\\\\n#7 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/User\\\\\\/User.php(178): OCA\\\\\\\\User_LDAP\\\\\\\\User\\\\\\\\User->markRefreshTime()\\\\n#8 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/Access.php(835): OCA\\\\\\\\User_LDAP\\\\\\\\User\\\\\\\\User->processAttributes(Array)\\\\n#9 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/Access.php(807): OCA\\\\\\\\User_LDAP\\\\\\\\Access->batchApplyUserAttributes(Array)\\\\n#10 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/Access.php(780): OCA\\\\\\\\User_LDAP\\\\\\\\Access->fetchListOfUsers('(&(&(|(objectcl...', Array)\\\\n#11 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/User_LDAP.php(136): OCA\\\\\\\\User_LDAP\\\\\\\\Access->fetchUsersByLoginName('snowball', Array)\\\\n#12 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/User_LDAP.php(153): OCA\\\\\\\\User_LDAP\\\\\\\\User_LDAP->getLDAPUserByLoginName('snowball')\\\\n#13 [internal function]: OCA\\\\\\\\User_LDAP\\\\\\\\User_LDAP->checkPassword(*** sensitive parameters replaced ***)\\\\n#14 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/User_Proxy.php(98): call_user_func_array(Array, Array)\\\\n#15 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/Proxy.php(148): OCA\\\\\\\\User_LDAP\\\\\\\\User_Proxy->callOnLastSeenOn('snowball', 'checkPassword', Array, false)\\\\n#16 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/user_ldap\\\\\\/lib\\\\\\/User_Proxy.php(186): OCA\\\\\\\\User_LDAP\\\\\\\\Proxy->handleRequest('snowball', 'checkPassword', Array)\\\\n#17 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/User\\\\\\/Manager.php(215): OCA\\\\\\\\User_LDAP\\\\\\\\User_Proxy->checkPassword(*** sensitive parameters replaced ***)\\\\n#18 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/User\\\\\\/Manager.php(192): OC\\\\\\\\User\\\\\\\\Manager->checkPasswordNoLogging('snowball', 'SHAUsiCEaDyneRt')\\\\n#19 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/User\\\\\\/Session.php(541): OC\\\\\\\\User\\\\\\\\Manager->checkPassword(*** sensitive parameters replaced ***)\\\\n#20 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/User\\\\\\/Session.php(326): OC\\\\\\\\User\\\\\\\\Session->loginWithPassword(*** sensitive parameters replaced ***)\\\\n#21 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/User\\\\\\/Session.php(400): OC\\\\\\\\User\\\\\\\\Session->login(*** sensitive parameters replaced ***)\\\\n#22 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/lib\\\\\\/Connector\\\\\\/Sabre\\\\\\/Auth.php(129): OC\\\\\\\\User\\\\\\\\Session->logClientIn(*** sensitive parameters replaced ***)\\\\n#23 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Auth\\\\\\/Backend\\\\\\/AbstractBasic.php(105): OCA\\\\\\\\DAV\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\Auth->validateUserPass(*** sensitive parameters replaced ***)\\\\n#24 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/lib\\\\\\/Connector\\\\\\/Sabre\\\\\\/Auth.php(252): Sabre\\\\\\\\DAV\\\\\\\\Auth\\\\\\\\Backend\\\\\\\\AbstractBasic->check(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#25 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/lib\\\\\\/Connector\\\\\\/Sabre\\\\\\/Auth.php(154): OCA\\\\\\\\DAV\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\Auth->auth(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#26 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Auth\\\\\\/Plugin.php(201): OCA\\\\\\\\DAV\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\Auth->check(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#27 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Auth\\\\\\/Plugin.php(150): Sabre\\\\\\\\DAV\\\\\\\\Auth\\\\\\\\Plugin->check(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#28 [internal function]: Sabre\\\\\\\\DAV\\\\\\\\Auth\\\\\\\\Plugin->beforeMethod(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#29 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/event\\\\\\/lib\\\\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\\\n#30 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(466): Sabre\\\\\\\\Event\\\\\\\\EventEmitter->emit('beforeMethod', Array)\\\\n#31 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(254): Sabre\\\\\\\\DAV\\\\\\\\Server->invokeMethod(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#32 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/lib\\\\\\/Server.php(253): Sabre\\\\\\\\DAV\\\\\\\\Server->exec()\\\\n#33 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/appinfo\\\\\\/v2\\\\\\/remote.php(33): OCA\\\\\\\\DAV\\\\\\\\Server->exec()\\\\n#34 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/remote.php(162): require_once('\\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/a...')\\\\n#35 {main}\\\",\\\"File\\\":\\\"\\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractMySQLDriver.php\\\",\\\"Line\\\":116}\",\"userAgent\":\"Mac OS X\\/10.12.6 (16G29) AddressBook\\/1756.20\",\"version\":\"12.0.2.0\"}\r\n{\"reqId\":\"o0nv7P3dGBdRoHu5kexs\",\"level\":4,\"time\":\"2017-08-19T15:51:18+00:00\",\"remoteAddr\":\"10.244.4.134\",\"user\":\"--\",\"app\":\"webdav\",\"method\":\"PROPFIND\",\"url\":\"\\/remote.php\\/dav\\/principals\\/users\\/ae7066da-f4fb-1036-8cad-9b286aacc383\\/\",\"message\":\"Exception: {\\\"Exception\\\":\\\"Sabre\\\\\\\\DAV\\\\\\\\Exception\\\\\\\\ServiceUnavailable\\\",\\\"Message\\\":\\\"Doctrine\\\\\\\\DBAL\\\\\\\\Exception\\\\\\\\DriverException: An exception occurred while executing 'UPDATE `oc_preferences` SET `configvalue` = ? WHERE (`userid` = ?) AND (`appid` = ?) AND (`configkey` = ?)' with params [1503157877, \\\\\\\"ae7066da-f4fb-1036-8cad-9b286aacc383\\\\\\\", \\\\\\\"user_ldap\\\\\\\", \\\\\\\"lastFeatureRefresh\\\\\\\"]:\\\\n\\\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"#0 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Auth\\\\\\/Plugin.php(201): OCA\\\\\\\\DAV\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\Auth->check(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#1 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Auth\\\\\\/Plugin.php(150): Sabre\\\\\\\\DAV\\\\\\\\Auth\\\\\\\\Plugin->check(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#2 [internal function]: Sabre\\\\\\\\DAV\\\\\\\\Auth\\\\\\\\Plugin->beforeMethod(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#3 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/event\\\\\\/lib\\\\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\\\n#4 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(466): Sabre\\\\\\\\Event\\\\\\\\EventEmitter->emit('beforeMethod', Array)\\\\n#5 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(254): Sabre\\\\\\\\DAV\\\\\\\\Server->invokeMethod(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#6 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/lib\\\\\\/Server.php(253): Sabre\\\\\\\\DAV\\\\\\\\Server->exec()\\\\n#7 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/appinfo\\\\\\/v2\\\\\\/remote.php(33): OCA\\\\\\\\DAV\\\\\\\\Server->exec()\\\\n#8 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/remote.php(162): require_once('\\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/a...')\\\\n#9 {main}\\\",\\\"File\\\":\\\"\\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/dav\\\\\\/lib\\\\\\/Connector\\\\\\/Sabre\\\\\\/Auth.php\\\",\\\"Line\\\":162}\",\"userAgent\":\"Mac OS X\\/10.12.6 (16G29) AddressBook\\/1756.20\",\"version\":\"12.0.2.0\"}\r\n\r\n</details>\r\n\r\n<details>\r\n        <summary>Browser log</summary>\r\n\r\n```\r\nInsert your browser log here, this could for example include:\r\n\r\na) The javascript console log\r\nb) The network log\r\nc) ...\r\n```\r\n</details>\r\n"},"comment":{"url":"https://api.github.com/repos/nextcloud/server/issues/comments/341457428","html_url":"https://github.com/nextcloud/server/issues/6187#issuecomment-341457428","issue_url":"https://api.github.com/repos/nextcloud/server/issues/6187","id":341457428,"user":{"login":"snowball77","id":6409197,"avatar_url":"https://avatars1.githubusercontent.com/u/6409197?v=4","gravatar_id":"","url":"https://api.github.com/users/snowball77","html_url":"https://github.com/snowball77","followers_url":"https://api.github.com/users/snowball77/followers","following_url":"https://api.github.com/users/snowball77/following{/other_user}","gists_url":"https://api.github.com/users/snowball77/gists{/gist_id}","starred_url":"https://api.github.com/users/snowball77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snowball77/subscriptions","organizations_url":"https://api.github.com/users/snowball77/orgs","repos_url":"https://api.github.com/users/snowball77/repos","events_url":"https://api.github.com/users/snowball77/events{/privacy}","received_events_url":"https://api.github.com/users/snowball77/received_events","type":"User","site_admin":false},"created_at":"2017-11-02T15:24:34Z","updated_at":"2017-11-02T15:24:34Z","author_association":"NONE","body":"I just cross-checked the issue:  On the database I executed\r\nSELECT @@GLOBAL.tx_isolation, @@tx_isolation\r\nand got\r\nREAD-COMMITTED\tREAD-COMMITTED\t\r\nThat should be right, shouldn't it?\r\n\r\nBut still I get\r\nDoctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'UPDATE `oc_preferences` SET `configvalue` = ? WHERE (`userid` = ?) AND (`appid` = ?) AND (`configkey` = ?)' with params [..., ...., \"user_ldap\", \"lastFeatureRefresh\"]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\r\n"}}
{"actor":{"display_login":"snowball77"}}