{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/14757","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/14757/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/14757/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/14757/events","html_url":"https://github.com/owncloud/core/issues/14757","id":60320177,"number":14757,"title":"Serialization failure, Deadlock found when trying to get lock","user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/blue-ticket","name":"blue-ticket","color":"0033CC"},{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/owncloud/core/labels/db:mariadb","name":"db:mariadb","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/feature:locking","name":"feature:locking","color":"d4c5f9"},{"url":"https://api.github.com/repos/owncloud/core/labels/sev2-high","name":"sev2-high","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/77","html_url":"https://github.com/owncloud/core/milestones/9.0.2-current-maintenance","labels_url":"https://api.github.com/repos/owncloud/core/milestones/77/labels","id":1632540,"number":77,"title":"9.0.2-current-maintenance","description":null,"creator":{"login":"MorrisJobke","id":245432,"avatar_url":"https://avatars.githubusercontent.com/u/245432?v=3","gravatar_id":"","url":"https://api.github.com/users/MorrisJobke","html_url":"https://github.com/MorrisJobke","followers_url":"https://api.github.com/users/MorrisJobke/followers","following_url":"https://api.github.com/users/MorrisJobke/following{/other_user}","gists_url":"https://api.github.com/users/MorrisJobke/gists{/gist_id}","starred_url":"https://api.github.com/users/MorrisJobke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MorrisJobke/subscriptions","organizations_url":"https://api.github.com/users/MorrisJobke/orgs","repos_url":"https://api.github.com/users/MorrisJobke/repos","events_url":"https://api.github.com/users/MorrisJobke/events{/privacy}","received_events_url":"https://api.github.com/users/MorrisJobke/received_events","type":"User","site_admin":false},"open_issues":12,"closed_issues":41,"state":"open","created_at":"2016-03-09T09:57:18Z","updated_at":"2016-04-22T11:04:28Z","due_on":"2016-05-03T04:00:00Z","closed_at":null},"comments":32,"created_at":"2015-03-09T09:54:43Z","updated_at":"2016-04-22T11:13:25Z","closed_at":null,"body":"### Steps to reproduce\r\n1. Prepare a local folder \"lots\" with 1600+ files\r\n2. Setup the sync client and let it upload all the files\r\n3. Rename \"lots\" to \"lots2\", wait for sync\r\n4. Rename \"lots2\" to \"lots3\"\r\n\r\n### Expected result\r\nRenamed properly.\r\n\r\n### Actual result\r\nVery strange internal server error:\r\n```\r\n{\"reqId\":\"913558a89371e56c7248d7c0ac24f820\",\"remoteAddr\":\"127.0.0.1\",\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE `oc_filecache` SET `path` = ?, `path_hash` = ?, `name` = ?, `parent` =? WHERE `fileid` = ?' with params [\\\"files\\\\\\/lots3\\\", \\\"6496454381429272daca5f1453986396\\\", \\\"lots3\\\", \\\"3\\\", 8]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"level\":4,\"time\":\"2015-03-09T09:45:40+00:00\",\"method\":\"MOVE\",\"url\":\"\\/owncloud\\/remote.php\\/webdav\\/lots2\"}\r\n```\r\n\r\nAnd then the sync client reuploads all the files which takes a while...\r\n\r\n### Versions\r\nownCloud 8.0.0 / stable8 found while testing https://github.com/owncloud/core/pull/14752\r\nmariadb-10.0.14-2.3.x86_64\r\nphp5-5.6.6-1.1.x86_64\r\nopenSUSE Factory\r\n\r\nNot sure if this can be reproduced consistently, will try again.\r\n\r\nThat could be another argument for closeCursor.\r\n\r\n@DeepDiver1975 @icewind1991 @MorrisJobke "},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/213383238","html_url":"https://github.com/owncloud/core/issues/14757#issuecomment-213383238","issue_url":"https://api.github.com/repos/owncloud/core/issues/14757","id":213383238,"user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"created_at":"2016-04-22T11:13:25Z","updated_at":"2016-04-22T11:13:25Z","body":"Side note: the web UI's regular \"getstoragestats.php\" call will also trigger a scan while trying to computer the used space. That one also successfully was excluded thanks to the lock."}}