{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/client/issues/3491","labels_url":"https://api.github.com/repos/owncloud/client/issues/3491/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/client/issues/3491/comments","events_url":"https://api.github.com/repos/owncloud/client/issues/3491/events","html_url":"https://github.com/owncloud/client/issues/3491","id":96806584,"number":3491,"title":"Sync fails randomly","user":{"login":"nodomain","id":104389,"avatar_url":"https://avatars.githubusercontent.com/u/104389?v=3","gravatar_id":"","url":"https://api.github.com/users/nodomain","html_url":"https://github.com/nodomain","followers_url":"https://api.github.com/users/nodomain/followers","following_url":"https://api.github.com/users/nodomain/following{/other_user}","gists_url":"https://api.github.com/users/nodomain/gists{/gist_id}","starred_url":"https://api.github.com/users/nodomain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nodomain/subscriptions","organizations_url":"https://api.github.com/users/nodomain/orgs","repos_url":"https://api.github.com/users/nodomain/repos","events_url":"https://api.github.com/users/nodomain/events{/privacy}","received_events_url":"https://api.github.com/users/nodomain/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/client/labels/Needs%20info","name":"Needs info","color":"207de5"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-07-23T12:53:22Z","updated_at":"2015-07-24T11:54:55Z","closed_at":null,"body":"Hi,\r\n\r\nwhen syncing some files cannot be synced.\r\n\r\nFollowing error occurs. How can this happen and how can this be fixed? Perhaps a hash collision?\r\n\r\n```javascript\r\n{\"reqId\":\"RvI6RotnifUtpAZJOOAY\",\"remoteAddr\":\"2.242.145.108\",\"app\":\"webdav\",\"message\":\"Exception: {\\\"Message\\\":\\\"An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`encrypted`,`parent`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params [\\\\\\\"3\\\\\\\", \\\\\\\"4\\\\\\\", 1437655813, 407525, \\\\\\\"71a454fc2175f8b739a81223e8c42c0b\\\\\\\", 1437655813, 27, 1, \\\\\\\"15364\\\\\\\", \\\\\\\"65d66885085cc10d771bc8537a418fbb\\\\\\\", \\\\\\\"files\\\\\\\\\\\\\\/xxxxx\\\\\\\\\\\\\\/xxxz.pdf\\\\\\\", \\\\\\\" xxxz.pdf\\\\\\\", \\\\\\\"4\\\\\\\", \\\\\\\"4\\\\\\\", \\\\\\\"65d66885085cc10d771bc8537a418fbb\\\\\\\"]:\\\\n\\\\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-65d66885085cc10d771bc8537a418fbb' for key 'fs_storage_path_hash'\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"#0 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(116): 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(996): Doctrine\\\\\\\\DBAL\\\\\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOMySql\\\\\\\\Driver), Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException), 'INSERT INTO `oc...', Array)\\\\n#2 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/connection.php(151): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\\\n#3 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/adapter.php(93): OC\\\\\\\\DB\\\\\\\\Connection->executeUpdate('INSERT INTO `*P...', Array)\\\\n#4 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/connection.php(190): OC\\\\\\\\DB\\\\\\\\Adapter->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\\\n#5 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/cache.php(322): OC\\\\\\\\DB\\\\\\\\Connection->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\\\n#6 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/scanner.php(225): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Cache->put('files\\\\\\/XXXXXXr F...', Array)\\\\n#7 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/scanner.php(188): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Scanner->addToCache('files\\\\\\/XXXXXXr F...', Array, -1)\\\\n#8 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/connector\\\\\\/sabre\\\\\\/file.php(208): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Scanner->scanFile('files\\\\\\/XXXXXXr F...')\\\\n#9 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/lib\\\\\\/private\\\\\\/connector\\\\\\/sabre\\\\\\/directory.php(113): OC\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\File->put(Resource id #33)\\\\n#10 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(1053): OC\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\Directory->createFile('6. XXXXXX...', Resource id #33)\\\\n#11 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/CorePlugin.php(513): Sabre\\\\\\\\DAV\\\\\\\\Server->createFile('XXXXXX...', Resource id #33, NULL)\\\\n#12 [internal function]: Sabre\\\\\\\\DAV\\\\\\\\CorePlugin->httpPut(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#13 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/event\\\\\\/lib\\\\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\\\n#14 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(469): Sabre\\\\\\\\Event\\\\\\\\EventEmitter->emit('method:PUT', Array)\\\\n#15 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(254): Sabre\\\\\\\\DAV\\\\\\\\Server->invokeMethod(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n#16 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/apps\\\\\\/files\\\\\\/appinfo\\\\\\/remote.php(83): Sabre\\\\\\\\DAV\\\\\\\\Server->exec()\\\\n#17 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/remote.php(132): require_once('\\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/a...')\\\\n#18 {main}\\\",\\\"File\\\":\\\"\\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractMySQLDriver.php\\\",\\\"Line\\\":66}\",\"level\":4,\"time\":\"2015-07-23T14:50:13+02:00\"}\r\n```\r\n\r\nNewest client and server, Windows 7.\r\nPHP Version 5.6.9-0+deb8u1, Debian 8.1, Apache 2.4.10."},"comment":{"url":"https://api.github.com/repos/owncloud/client/issues/comments/124498689","html_url":"https://github.com/owncloud/client/issues/3491#issuecomment-124498689","issue_url":"https://api.github.com/repos/owncloud/client/issues/3491","id":124498689,"user":{"login":"nodomain","id":104389,"avatar_url":"https://avatars.githubusercontent.com/u/104389?v=3","gravatar_id":"","url":"https://api.github.com/users/nodomain","html_url":"https://github.com/nodomain","followers_url":"https://api.github.com/users/nodomain/followers","following_url":"https://api.github.com/users/nodomain/following{/other_user}","gists_url":"https://api.github.com/users/nodomain/gists{/gist_id}","starred_url":"https://api.github.com/users/nodomain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nodomain/subscriptions","organizations_url":"https://api.github.com/users/nodomain/orgs","repos_url":"https://api.github.com/users/nodomain/repos","events_url":"https://api.github.com/users/nodomain/events{/privacy}","received_events_url":"https://api.github.com/users/nodomain/received_events","type":"User","site_admin":false},"created_at":"2015-07-24T11:54:55Z","updated_at":"2015-07-24T11:54:55Z","body":"As far as I remember, no. I am going to verify that though. \n\n> Am 24.07.2015 um 10:49 schrieb Markus Goetz <notifications@github.com>:\n> \n> And you don't see any \"Connection Closed\" or \"Connection Timeout\" error in the client?\n> \n> —\n> Reply to this email directly or view it on GitHub.\n> \n"}}