{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/18502","labels_url":"https://api.github.com/repos/owncloud/core/issues/18502/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/18502/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/18502/events","html_url":"https://github.com/owncloud/core/issues/18502","id":102662009,"number":18502,"title":"8.1.1 + Encryption: Exception: {\\\"Message\\\":\\\"An exception occurred while executing 'INSERT INTO `oc_filecache`","user":{"login":"Bobuscho","id":4531989,"avatar_url":"https://avatars.githubusercontent.com/u/4531989?v=3","gravatar_id":"","url":"https://api.github.com/users/Bobuscho","html_url":"https://github.com/Bobuscho","followers_url":"https://api.github.com/users/Bobuscho/followers","following_url":"https://api.github.com/users/Bobuscho/following{/other_user}","gists_url":"https://api.github.com/users/Bobuscho/gists{/gist_id}","starred_url":"https://api.github.com/users/Bobuscho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bobuscho/subscriptions","organizations_url":"https://api.github.com/users/Bobuscho/orgs","repos_url":"https://api.github.com/users/Bobuscho/repos","events_url":"https://api.github.com/users/Bobuscho/events{/privacy}","received_events_url":"https://api.github.com/users/Bobuscho/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/app:encryption","name":"app:encryption","color":"02d7e1"},{"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/feature:locking","name":"feature:locking","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":20,"created_at":"2015-08-23T21:19:33Z","updated_at":"2015-09-18T20:38:09Z","closed_at":null,"body":"### Steps to reproduce\r\n1. Start Owncloud - Client with 1Password - Folder or Pictures folder\r\n2. Wait\r\n3. See the log message stated in the title appear while the connection interrupts, sync is not possible.\r\n\r\n### Expected behaviour\r\nComplete sync of the folders stated above\r\n\r\n### Actual behaviour\r\nClient reports: \"Connection closed/interrupted\" (Vorgang abgebrochen)\r\n\r\n### Server configuration\r\n**Operating system**:\r\nRaspbian Wheezy\r\n\r\n**Web server:**\r\nNginx 1.9.4\r\n\r\n**Database:**\r\nMySQL\r\n\r\n**PHP version:**\r\n5.4.41\r\n\r\n**ownCloud version:** (see ownCloud admin page)\r\n8.1.1\r\n**Updated from an older ownCloud or fresh install:**\r\nfresh install\r\n\r\n**List of activated apps:**\r\nEnabled:\r\n - activity: 2.0.1\r\n - files: 1.1.10\r\n - files_locking:\r\n - files_pdfviewer: 0.7\r\n - files_sharing: 0.6.2\r\n - files_texteditor: 0.4\r\n - files_trashbin: 0.6.3\r\n - files_versions: 1.0.6\r\n - files_videoviewer: 0.1.3\r\n - firstrunwizard: 1.1\r\n - gallery: 0.6.0\r\n - provisioning_api: 0.2\r\n - templateeditor: 0.1\r\n - updater: 0.6\r\n\r\n**The content of config/config.php:**\r\n\r\n```\r\n<?php\r\n$CONFIG = array (\r\n*** salt and instance id removed ***\r\n\r\n  'trusted_domains' =>\r\n  array (\r\n    0 => 'example.de',\r\n  ),\r\n  'datadirectory' => '/srv/www/oc-data',\r\n  'overwrite.cli.url' => 'https://example.de/owncloud',\r\n  'dbtype' => 'mysql',\r\n  'version' => '8.1.1.3',\r\n  'dbname' => 'oc_db',\r\n  'dbhost' => 'localhost',\r\n  'dbtableprefix' => ***\r\n  'dbuser' => ***\r\n  'dbpassword' => ***\r\n  'logtimezone' => 'Europe/Berlin',\r\n  'installed' => true,\r\n  'mail_from_address' => 'webmaster',\r\n  'mail_smtpmode' => 'php',\r\n  'mail_domain' => 'example.de',\r\n  'memcache.local' => '\\\\OC\\\\Memcache\\\\APC',\r\n  'loglevel' => 3,\r\n);\r\n```\r\n\r\n**Are you using external storage, if yes which one:** local/smb/sftp/...\r\nGoogle Drive\r\n\r\n**Are you using encryption:** yes/no\r\nYes\r\n\r\n### Client configuration\r\nOwncloud Sync Client\r\n\r\n**Operating system:**\r\nWindows 10\r\n\r\n### Log\r\n\r\n#### ownCloud log (data/owncloud.log)\r\n\r\n```\r\n{\"reqId\":\"Vizi30N8NXSa\\/jo2hYzT\",\"remoteAddr\":\"IP ADDRESS\",\"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\\\\\\\", \\\\\\\"8\\\\\\\", 1440107331, 906, \\\\\\\"64108a6d100693f566cb6a4382a516ab\\\\\\\", 1440107331, 27, 1, \\\\\\\"67\\\\\\\", \\\\\\\"8f43ac16cdb5d9ba8da70e8b1a7df19a\\\\\\\", \\\\\\\"files\\\\\\\\\\\\\\/1Password\\\\\\\\\\\\\\/1Password.agilekeychain\\\\\\\\\\\\\\/data\\\\\\\\\\\\\\/default\\\\\\\\\\\\\\/3F6CEFFE0B634D2094A1247B4234C079.1password\\\\\\\", \\\\\\\"3F6CEFFE0B634D2094A1247B4234C079.1password\\\\\\\", \\\\\\\"1\\\\\\\", \\\\\\\"1\\\\\\\", \\\\\\\"8f43ac16cdb5d9ba8da70e8b1a7df19a\\\\\\\"]:\\\\n\\\\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-8f43ac16cdb5d9ba8da70e8b1a7df19a' for key 'fs_storage_path_hash'\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"\r\n#0 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(116): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException))\\\\n\r\n#1 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/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\r\n#2 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/connection.php(151): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\\\n\r\n#3 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/adapter.php(93): OC\\\\\\\\DB\\\\\\\\Connection->executeUpdate('INSERT INTO `*P...', Array)\\\\n\r\n#4 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/connection.php(190): OC\\\\\\\\DB\\\\\\\\Adapter->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\\\n\r\n#5 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/cache.php(322): OC\\\\\\\\DB\\\\\\\\Connection->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\\\n\r\n#6 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/scanner.php(225): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Cache->put('files\\\\\\/1Password...', Array)\\\\n\r\n#7 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/scanner.php(188): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Scanner->addToCache('files\\\\\\/1Password...', Array, -1)\\\\n\r\n#8 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/connector\\\\\\/sabre\\\\\\/file.php(208): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Scanner->scanFile('files\\\\\\/1Password...')\\\\n\r\n#9 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/connector\\\\\\/sabre\\\\\\/directory.php(113): OC\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\File->put(Resource id #26)\\\\n\r\n#10 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(1053): OC\\\\\\\\Connector\\\\\\\\Sabre\\\\\\\\Directory->createFile('3F6CEFFE0B634D2...', Resource id #26)\\\\n\r\n#11 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/CorePlugin.php(513): Sabre\\\\\\\\DAV\\\\\\\\Server->createFile('1Password\\\\\\/1Pass...', Resource id #26, NULL)\\\\n\r\n#12 [internal function]: Sabre\\\\\\\\DAV\\\\\\\\CorePlugin->httpPut(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n\r\n#13 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/sabre\\\\\\/event\\\\\\/lib\\\\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\\\n\r\n#14 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(469): Sabre\\\\\\\\Event\\\\\\\\EventEmitter->emit('method:PUT', Array)\\\\n\r\n#15 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/sabre\\\\\\/dav\\\\\\/lib\\\\\\/DAV\\\\\\/Server.php(254): Sabre\\\\\\\\DAV\\\\\\\\Server->invokeMethod(Object(Sabre\\\\\\\\HTTP\\\\\\\\Request), Object(Sabre\\\\\\\\HTTP\\\\\\\\Response))\\\\n\r\n#16 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/apps\\\\\\/files\\\\\\/appinfo\\\\\\/remote.php(83): Sabre\\\\\\\\DAV\\\\\\\\Server->exec()\\\\n\r\n#17 \\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/remote.php(132): require_once('\\\\\\/var\\\\\\/www\\\\\\/virtua...')\\\\n\r\n#18 {main}\\\",\\\"File\\\":\\\"\\\\\\/var\\\\\\/www\\\\\\/virtual\\\\\\/mfin\\\\\\/html\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractMySQLDriver.php\\\",\\\"Line\\\":66}\",\"level\":4,\"time\":\"2015-08-20T21:48:51+00:00\"}\r\n```\r\n\r\n\r\nWebserver log (nginx.log) shows nothing but \"an upstream response is buffered to a temporary file\"...i don't know how to solve the problem...i own the server, permissions are set correctly, it seems to be an issue with the encryption module because on an unencrypted install, the error does not appear. \r\n\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/141562244","html_url":"https://github.com/owncloud/core/issues/18502#issuecomment-141562244","issue_url":"https://api.github.com/repos/owncloud/core/issues/18502","id":141562244,"user":{"login":"cdamken","id":7264495,"avatar_url":"https://avatars.githubusercontent.com/u/7264495?v=3","gravatar_id":"","url":"https://api.github.com/users/cdamken","html_url":"https://github.com/cdamken","followers_url":"https://api.github.com/users/cdamken/followers","following_url":"https://api.github.com/users/cdamken/following{/other_user}","gists_url":"https://api.github.com/users/cdamken/gists{/gist_id}","starred_url":"https://api.github.com/users/cdamken/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdamken/subscriptions","organizations_url":"https://api.github.com/users/cdamken/orgs","repos_url":"https://api.github.com/users/cdamken/repos","events_url":"https://api.github.com/users/cdamken/events{/privacy}","received_events_url":"https://api.github.com/users/cdamken/received_events","type":"User","site_admin":false},"created_at":"2015-09-18T20:38:09Z","updated_at":"2015-09-18T20:38:09Z","body":"@schiesbn @PVince81 Your recomendation ``filesystem_check_changes => 0;``` in the config.php sounds really good because with encryption is not needed to check all the time the data folder.\r\n\r\nAfter a few hours where not so many error, but this one seems weird:\r\n\r\n![screenshot-new](https://cloud.githubusercontent.com/assets/7264495/9970443/80bcf7ee-5e55-11e5-8002-ade67209794d.jpg)\r\n\r\n@guruz @danimo Any clue?  I'm trying to get the log file when the error happens again."}}