{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/25376","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/25376/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/25376/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/25376/events","html_url":"https://github.com/owncloud/core/issues/25376","id":164043136,"number":25376,"title":"Integrity constraint errors in oc_file_locks due to insufficient length of key column","user":{"login":"inty","id":10284,"avatar_url":"https://avatars.githubusercontent.com/u/10284?v=3","gravatar_id":"","url":"https://api.github.com/users/inty","html_url":"https://github.com/inty","followers_url":"https://api.github.com/users/inty/followers","following_url":"https://api.github.com/users/inty/following{/other_user}","gists_url":"https://api.github.com/users/inty/gists{/gist_id}","starred_url":"https://api.github.com/users/inty/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/inty/subscriptions","organizations_url":"https://api.github.com/users/inty/orgs","repos_url":"https://api.github.com/users/inty/repos","events_url":"https://api.github.com/users/inty/events{/privacy}","received_events_url":"https://api.github.com/users/inty/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/2%20-%20Developing","name":"2 - Developing","color":"ededed"},{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"},{"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/sev1-critical","name":"sev1-critical","color":"fc2929"}],"state":"closed","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},"assignees":[{"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},{"login":"guruz","id":959327,"avatar_url":"https://avatars.githubusercontent.com/u/959327?v=3","gravatar_id":"","url":"https://api.github.com/users/guruz","html_url":"https://github.com/guruz","followers_url":"https://api.github.com/users/guruz/followers","following_url":"https://api.github.com/users/guruz/following{/other_user}","gists_url":"https://api.github.com/users/guruz/gists{/gist_id}","starred_url":"https://api.github.com/users/guruz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/guruz/subscriptions","organizations_url":"https://api.github.com/users/guruz/orgs","repos_url":"https://api.github.com/users/guruz/repos","events_url":"https://api.github.com/users/guruz/events{/privacy}","received_events_url":"https://api.github.com/users/guruz/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/86","html_url":"https://github.com/owncloud/core/milestones/8.2.7","labels_url":"https://api.github.com/repos/owncloud/core/milestones/86/labels","id":1770790,"number":86,"title":"8.2.7","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":17,"closed_issues":8,"state":"open","created_at":"2016-05-17T08:28:23Z","updated_at":"2016-07-13T12:39:02Z","due_on":"2016-08-23T04:00:00Z","closed_at":null},"comments":12,"created_at":"2016-07-06T10:13:54Z","updated_at":"2016-07-13T12:39:02Z","closed_at":"2016-07-13T12:39:02Z","body":"### Steps to reproduce\r\n\r\nI can't seem to reproduce this myself. Either because it only happens with previously created shares or it's related to the Windows client, I don't know. But the issue is pretty clear, we get this error for certain folders from the Windows client and the web interface.\r\n\r\n```\r\nIntegrity constraint violation: 1062 Duplicate entry 'scanner::shared::[OMITTED]' for key 'lock_key_index'\r\n```\r\n\r\nThe problem here seems to be that for these folders it doesn't use a md5 for the key for some reason and the key column of oc_file_locks is only 64 chars so anything longer than that (minus the prefix obviously) will generate constraint errors.\r\n\r\nI fixed this for now by changing the key column to varchar(255), seems to be working.\r\n\r\nFirst I thought this might have been a bug with strlen and our usage of \"åäö\" in paths but that doesn't seem to be it. I can't reproduce it when I create a new share anyhow.\r\n\r\n### Expected behaviour\r\n\r\nLocking should not produce these errors for certain paths over certain length.\r\n\r\n### Actual behaviour\r\n\r\nSyncing fails.\r\n\r\n### Server configuration\r\n**Operating system**:\r\nDebian Wheezy\r\n**Web server:**\r\nApache 2.2\r\n**Database:**\r\nMySQL 5.5\r\n**PHP version:**\r\n5.4\r\n**ownCloud version:** (see ownCloud admin page)\r\n8.2.6\r\n**Updated from an older ownCloud or fresh install:**\r\nUpdated from older\r\n**Where did you install ownCloud from:**\r\nYour Open Build Service\r\n**List of activated apps:**\r\n\r\n```\r\nIf you have access to your command line run e.g.:\r\nsudo -u www-data php occ app:list\r\nfrom within your ownCloud installation folder\r\n```\r\n\r\n**The content of config/config.php:**\r\n\r\n```\r\n{\r\n    \"system\": {\r\n        \"instanceid\": \"oc836321d4d1\",\r\n        \"passwordsalt\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"trusted_domains\": [\r\n            \"owncloud.chas.se\"\r\n        ],\r\n        \"datadirectory\": \"\\/var\\/www\\/owncloud\\/data\",\r\n        \"overwrite.cli.url\": \"https:\\/\\/owncloud.xxx.se\",\r\n        \"dbtype\": \"mysql\",\r\n        \"version\": \"8.2.6.2\",\r\n        \"dbname\": \"owncloud\",\r\n        \"dbhost\": \"localhost\",\r\n        \"dbtableprefix\": \"oc_\",\r\n        \"dbuser\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"dbpassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"installed\": true,\r\n        \"mail_smtpmode\": \"smtp\",\r\n        \"ldapIgnoreNamingRules\": false,\r\n        \"forcessl\": true,\r\n        \"mail_smtpsecure\": \"ssl\",\r\n        \"mail_smtpauthtype\": \"PLAIN\",\r\n        \"mail_smtpauth\": 1,\r\n        \"mail_smtphost\": \"mail.chas.se\",\r\n        \"mail_smtpport\": \"465\",\r\n        \"mail_smtpname\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_smtppassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_domain\": \"chas.se\",\r\n        \"mail_from_address\": \"owncloud\",\r\n        \"theme\": \"\",\r\n        \"maintenance\": false,\r\n        \"secret\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"memcache.local\": \"\\\\OC\\\\Memcache\\\\Memcached\",\r\n        \"memcached_servers\": [\r\n            [\r\n                \"localhost\",\r\n                11211\r\n            ]\r\n        ],\r\n        \"loglevel\": 2,\r\n        \"trashbin_retention_obligation\": \"auto\"\r\n    }\r\n}\r\n```\r\n\r\n**Are you using external storage, if yes which one:** local/smb/sftp/...\r\nNFS\r\n**Are you using encryption:** yes/no\r\nYes"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/232342398","html_url":"https://github.com/owncloud/core/issues/25376#issuecomment-232342398","issue_url":"https://api.github.com/repos/owncloud/core/issues/25376","id":232342398,"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-07-13T12:39:00Z","updated_at":"2016-07-13T12:39:00Z","body":"PR was merged, closing\r\n\r\n@guruz can you port the unit test to master/stable9* ?"}}
{"actor":{"display_login":"PVince81"}}