{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/25070","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/25070/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/25070/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/25070/events","html_url":"https://github.com/owncloud/core/issues/25070","id":159788918,"number":25070,"title":"Constraint violation insert into filecache / upload many small files","user":{"login":"chrsch","id":198256,"avatar_url":"https://avatars.githubusercontent.com/u/198256?v=3","gravatar_id":"","url":"https://api.github.com/users/chrsch","html_url":"https://github.com/chrsch","followers_url":"https://api.github.com/users/chrsch/followers","following_url":"https://api.github.com/users/chrsch/following{/other_user}","gists_url":"https://api.github.com/users/chrsch/gists{/gist_id}","starred_url":"https://api.github.com/users/chrsch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrsch/subscriptions","organizations_url":"https://api.github.com/users/chrsch/orgs","repos_url":"https://api.github.com/users/chrsch/repos","events_url":"https://api.github.com/users/chrsch/events{/privacy}","received_events_url":"https://api.github.com/users/chrsch/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/comp:filesystem","name":"comp:filesystem","color":"d4c5f9"},{"url":"https://api.github.com/repos/owncloud/core/labels/needs%20info","name":"needs info","color":"0b02e1"},{"url":"https://api.github.com/repos/owncloud/core/labels/sev2-high","name":"sev2-high","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"DeepDiver1975","id":1005065,"avatar_url":"https://avatars.githubusercontent.com/u/1005065?v=3","gravatar_id":"","url":"https://api.github.com/users/DeepDiver1975","html_url":"https://github.com/DeepDiver1975","followers_url":"https://api.github.com/users/DeepDiver1975/followers","following_url":"https://api.github.com/users/DeepDiver1975/following{/other_user}","gists_url":"https://api.github.com/users/DeepDiver1975/gists{/gist_id}","starred_url":"https://api.github.com/users/DeepDiver1975/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DeepDiver1975/subscriptions","organizations_url":"https://api.github.com/users/DeepDiver1975/orgs","repos_url":"https://api.github.com/users/DeepDiver1975/repos","events_url":"https://api.github.com/users/DeepDiver1975/events{/privacy}","received_events_url":"https://api.github.com/users/DeepDiver1975/received_events","type":"User","site_admin":false},"assignees":[{"login":"DeepDiver1975","id":1005065,"avatar_url":"https://avatars.githubusercontent.com/u/1005065?v=3","gravatar_id":"","url":"https://api.github.com/users/DeepDiver1975","html_url":"https://github.com/DeepDiver1975","followers_url":"https://api.github.com/users/DeepDiver1975/followers","following_url":"https://api.github.com/users/DeepDiver1975/following{/other_user}","gists_url":"https://api.github.com/users/DeepDiver1975/gists{/gist_id}","starred_url":"https://api.github.com/users/DeepDiver1975/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DeepDiver1975/subscriptions","organizations_url":"https://api.github.com/users/DeepDiver1975/orgs","repos_url":"https://api.github.com/users/DeepDiver1975/repos","events_url":"https://api.github.com/users/DeepDiver1975/events{/privacy}","received_events_url":"https://api.github.com/users/DeepDiver1975/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/89","html_url":"https://github.com/owncloud/core/milestones/9.0.5","labels_url":"https://api.github.com/repos/owncloud/core/milestones/89/labels","id":1857606,"number":89,"title":"9.0.5","description":null,"creator":{"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},"open_issues":64,"closed_issues":11,"state":"open","created_at":"2016-06-30T14:57:54Z","updated_at":"2016-07-28T13:52:08Z","due_on":"2016-08-23T04:00:00Z","closed_at":null},"comments":11,"created_at":"2016-06-11T19:07:31Z","updated_at":"2016-07-29T03:03:24Z","closed_at":null,"body":"Hi all,\r\n\r\nI've been struggling with this issue for days now. This is not exactly a new topic but I have worked through all suggestions and tickets I was able to find on github and elsewhere without success.\r\n\r\nTickets probably relates:\r\nhttps://github.com/owncloud/core/issues/18502 // Suggestion is to use filesystem_check_changes => 0; in config.php --> No difference for me whether 1 or 2\r\nhttps://github.com/owncloud/core/issues/13934 // Suggestion is to ensure MariaDB transaction isolation is READ-COMITTED. Was REPEATABLE-READ for me, but switching to READ-COMITTED didn't make a difference for me at all.\r\nhttps://github.com/owncloud/core/issues/19068 // Solution here was turn on file locking via redis --> Didn't solve the problem for me, I already have file locking via redis. Turning file lockin on/off didn't make a difference. Also tried locking without redis.\r\nhttps://github.com/owncloud/core/issues/14701 // Just related with a good summary by @DeepDiver1975 what may be going on.\r\n\r\n### Steps to reproduce\r\n1. Get some folder with many small file, e. g. node js project. E. .g clone https://github.com/linnovate/mean\r\n2. Setup a sync folder to sync the cloned repository to ownCloud\r\n3. Wait some time for the insert into filecache error to pop up, will happen within 1-2 minutes with a server configuration providing good performance\r\n\r\n### Expected behaviour\r\nThe upload must finish without errors.\r\n\r\n### Actual behaviour\r\nThere are \"Insert into filecache.. constraint violation duplicate entry\" errors from time to time on random files.\r\n\r\n### Server configuration\r\n**Operating system**: \r\nUbuntu 14.04 LTS\r\n\r\n**Web server:** \r\nApache 2.4.7 with modules:\r\n core_module (static)\r\n so_module (static)\r\n watchdog_module (static)\r\n http_module (static)\r\n log_config_module (static)\r\n logio_module (static)\r\n version_module (static)\r\n unixd_module (static)\r\n access_compat_module (shared)\r\n alias_module (shared)\r\n auth_basic_module (shared)\r\n authn_core_module (shared)\r\n authn_file_module (shared)\r\n authz_core_module (shared)\r\n authz_host_module (shared)\r\n authz_user_module (shared)\r\n autoindex_module (shared)\r\n deflate_module (shared)\r\n dir_module (shared)\r\n env_module (shared)\r\n filter_module (shared)\r\n headers_module (shared)\r\n mime_module (shared)\r\n mpm_prefork_module (shared)\r\n negotiation_module (shared)\r\n php5_module (shared)\r\n proxy_module (shared)\r\n proxy_http_module (shared)\r\n rewrite_module (shared)\r\n setenvif_module (shared)\r\n socache_shmcb_module (shared)\r\n ssl_module (shared)\r\n status_module (shared)\r\n\r\n**Database:** \r\nMaria DB Galera Cluster Maser-Master Active-Backup\r\nMaria DB: Ver 15.1 Distrib 5.5.49-MariaDB\r\nwsrep_provider_version, 25.3.15(r3578)\r\n\r\n**PHP version:**\r\n5.6.22 with modules \r\n[PHP Modules]\r\nbcmath\r\nbz2\r\ncalendar\r\nCore\r\nctype\r\ncurl\r\ndate\r\ndba\r\ndom\r\nereg\r\nexif\r\nfileinfo\r\nfilter\r\nftp\r\ngd\r\ngettext\r\nhash\r\niconv\r\njson\r\nlibxml\r\nmbstring\r\nmcrypt\r\nmhash\r\nmysql\r\nmysqli\r\nopenssl\r\npcntl\r\npcre\r\nPDO\r\npdo_mysql\r\nPhar\r\nposix\r\nreadline\r\nredis\r\nReflection\r\nsession\r\nshmop\r\nSimpleXML\r\nsoap\r\nsockets\r\nSPL\r\nstandard\r\nsysvmsg\r\nsysvsem\r\nsysvshm\r\ntokenizer\r\nwddx\r\nxml\r\nxmlreader\r\nxmlwriter\r\nZend OPcache\r\nzip\r\nzlib\r\n[Zend Modules]\r\nZend OPcache\r\n\r\n**ownCloud version:**\r\n9.0.2\r\n\r\n**Updated from an older ownCloud or fresh install:**\r\nUpdate from 8.2.5\r\n\r\n**Where did you install ownCloud from:**\r\nManual\r\n\r\n**Signing status (ownCloud 9.0 and above):**\r\nNo errors have been found.\r\n\r\n**List of activated apps:**\r\nEnabled:\r\n  - activity: 2.2.1\r\n  - bookmarks: 0.7\r\n  - calendar: 1.2.2\r\n  - comments: 0.2\r\n  - contacts: 1.3.1.0\r\n  - dav: 0.1.6\r\n  - encryption: 1.2.0\r\n  - federatedfilesharing: 0.1.0\r\n  - federation: 0.0.4\r\n  - files: 1.4.4\r\n  - files_pdfviewer: 0.8.1\r\n  - files_sharing: 0.9.1\r\n  - files_texteditor: 2.1\r\n  - files_trashbin: 0.8.0\r\n  - files_versions: 1.2.0\r\n  - files_videoplayer: 0.9.8\r\n  - galleryplus: 15.0.0\r\n  - imprint: 0.2.5\r\n  - mail: 0.5.1\r\n  - news: 8.8.0\r\n  - notifications: 0.2.3\r\n  - passwords: 18.0\r\n  - provisioning_api: 0.4.1\r\n  - systemtags: 0.2\r\n  - templateeditor: 0.1\r\n  - updatenotification: 0.1.0\r\nDisabled:\r\n  - documents\r\n  - external\r\n  - files_clipboard\r\n  - files_external\r\n  - firstrunwizard\r\n  - gallery\r\n  - user_external\r\n  - user_ldap\r\n  - user_otp\r\n  - user_rcdevsopenotp\r\n\r\n**The content of config/config.php:**\r\n{\r\n    \"system\": {\r\n        \"instanceid\": \"xxxxxxxxxx\",\r\n        \"passwordsalt\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"secret\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"trusted_domains\": [\r\n            \"xxxxxxxxxx\"\r\n        ],\r\n        \"datadirectory\": \"\\/var\\/xxxxxxxxx\",\r\n        \"overwrite.cli.url\": \"https:\\/\\/xxxxxxxxxx\",\r\n        \"dbtype\": \"mysql\",\r\n        \"version\": \"9.0.2.2\",\r\n        \"dbname\": \"xxxxxxxxx\",\r\n        \"dbhost\": \"xxxxxxxxx\",\r\n        \"dbtableprefix\": \"\",\r\n        \"dbuser\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"dbpassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"logtimezone\": \"UTC\",\r\n        \"installed\": true,\r\n        \"mail_domain\": \"xxxxxxxxx\",\r\n        \"mail_smtpmode\": \"smtp\",\r\n        \"mail_smtphost\": \"xxxxxxxxxx\",\r\n        \"mail_smtpport\": \"25\",\r\n        \"mail_smtpsecure\": \"tls\",\r\n        \"mail_smtpauth\": 1,\r\n        \"mail_smtpauthtype\": \"LOGIN\",\r\n        \"mail_smtpname\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_smtppassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_from_address\": \"no-reply\",\r\n        \"forcessl\": true,\r\n        \"default_language\": \"de\",\r\n        \"asset-pipeline.enabled\": false,\r\n        \"activity_expire_days\": 360,\r\n        \"theme\": \"xxxxxxxxxx\",\r\n        \"custom_csp_policy\": \"default-src 'self'; script-src 'self' 'unsafe-inline' 'unsafe-eval'; style-src 'self' 'unsafe-inline'; frame-src *; img-src *; font-src 'self' data:; media-src *\",\r\n        \"memcache.local\": \"\\\\OC\\\\Memcache\\\\Redis\",\r\n        \"filelocking.enabled\": true,\r\n        \"memcache.distributed\": \"\\\\OC\\\\Memcache\\\\Redis\",\r\n        \"memcache.locking\": \"\\\\OC\\\\Memcache\\\\Redis\",\r\n        \"redis\": {\r\n            \"host\": \"xxxxxxxxxx\",\r\n            \"port\": 6389,\r\n            \"timeout\": 0,\r\n            \"dbindex\": 0,\r\n            \"password\": \"xxxxxxxxx\"\r\n        },\r\n        \"maintenance\": false,\r\n        \"loglevel\": \"0\",\r\n        \"singleuser\": false,\r\n        \"filesystem_check_changes\": 0\r\n    }\r\n}\r\n\r\n**Are you using external storage, if yes which one:**\r\nno\r\n\r\n**Are you using encryption:**\r\nyes\r\n\r\n**Are you using an external user-backend, if yes which one:**\r\nno\r\n\r\n### Client configuration\r\n**Browser:**\r\nChrome 51\r\n\r\n**Operating system:**\r\nWindows 10\r\n\r\n### Logs\r\n#### Web server error log\r\nNo errrors in apache2 log\r\n\r\n#### ownCloud log (data/owncloud.log)\r\nno errors in owncloud.log on loglevel 0...\r\n\r\n#### ownCloud Client log\r\n[owncloud.log.zip](https://github.com/owncloud/core/files/317158/owncloud.log.zip)\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/236083196","html_url":"https://github.com/owncloud/core/issues/25070#issuecomment-236083196","issue_url":"https://api.github.com/repos/owncloud/core/issues/25070","id":236083196,"user":{"login":"joeyjy","id":2981719,"avatar_url":"https://avatars.githubusercontent.com/u/2981719?v=3","gravatar_id":"","url":"https://api.github.com/users/joeyjy","html_url":"https://github.com/joeyjy","followers_url":"https://api.github.com/users/joeyjy/followers","following_url":"https://api.github.com/users/joeyjy/following{/other_user}","gists_url":"https://api.github.com/users/joeyjy/gists{/gist_id}","starred_url":"https://api.github.com/users/joeyjy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joeyjy/subscriptions","organizations_url":"https://api.github.com/users/joeyjy/orgs","repos_url":"https://api.github.com/users/joeyjy/repos","events_url":"https://api.github.com/users/joeyjy/events{/privacy}","received_events_url":"https://api.github.com/users/joeyjy/received_events","type":"User","site_admin":false},"created_at":"2016-07-29T03:03:23Z","updated_at":"2016-07-29T03:03:23Z","body":"@PVince81 If I use 'INSERT IGNORE' or 'ON DUPLICATE KEY UPDATE', does it matter? if it will damage the system?"}}
{"actor":{"display_login":"joeyjy"}}