{"action":"created","issue":{"url":"https://api.github.com/repos/nextcloud/server/issues/12729","repository_url":"https://api.github.com/repos/nextcloud/server","labels_url":"https://api.github.com/repos/nextcloud/server/issues/12729/labels{/name}","comments_url":"https://api.github.com/repos/nextcloud/server/issues/12729/comments","events_url":"https://api.github.com/repos/nextcloud/server/issues/12729/events","html_url":"https://github.com/nextcloud/server/issues/12729","id":385780293,"node_id":"MDU6SXNzdWUzODU3ODAyOTM=","number":12729,"title":"14.0.4: PostgreSQL Duplicate key value violates unique constraint lock_key_index","user":{"login":"torrentkino","id":2344992,"node_id":"MDQ6VXNlcjIzNDQ5OTI=","avatar_url":"https://avatars0.githubusercontent.com/u/2344992?v=4","gravatar_id":"","url":"https://api.github.com/users/torrentkino","html_url":"https://github.com/torrentkino","followers_url":"https://api.github.com/users/torrentkino/followers","following_url":"https://api.github.com/users/torrentkino/following{/other_user}","gists_url":"https://api.github.com/users/torrentkino/gists{/gist_id}","starred_url":"https://api.github.com/users/torrentkino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/torrentkino/subscriptions","organizations_url":"https://api.github.com/users/torrentkino/orgs","repos_url":"https://api.github.com/users/torrentkino/repos","events_url":"https://api.github.com/users/torrentkino/events{/privacy}","received_events_url":"https://api.github.com/users/torrentkino/received_events","type":"User","site_admin":false},"labels":[{"id":386379231,"node_id":"MDU6TGFiZWwzODYzNzkyMzE=","url":"https://api.github.com/repos/nextcloud/server/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-29T15:07:57Z","updated_at":"2018-11-29T15:21:35Z","closed_at":null,"author_association":"NONE","body":"### Steps to reproduce\r\n1. Use Nextcloud-14.0.4 + php-fpm + nginx + PostgreSQL\r\n2. Only one single user needed\r\n\r\n### Expected behaviour\r\nNo error messages.\r\n\r\n### Actual behaviour\r\nToo many error messages:\r\n\r\n$ sudo egrep '2018-11-29.*duplicate key value violates unique constraint \"lock_key_index\"' \\\r\n  /var/log/postgresql/postgresql-11-main.log | wc -l\r\n15484\r\n\r\nThose error messages look like this:\r\nnextcloud@nextcloud ERROR:  duplicate key value violates unique constraint \"lock_key_index\"\r\nnextcloud@nextcloud DETAIL:  Key (key)=(files/5f46d7639d8049fc652b79286a38d339) already exists.\r\nnextcloud@nextcloud STATEMENT:  INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3)\r\n\r\n\r\n### Server configuration\r\n\r\n**Operating system**: Debian/Buster\r\n\r\n**Web server:** nginx-1.14.1-1\r\n\r\n**Database:** PostgreSQL-11\r\n\r\n**PHP version:** 7.3\r\n\r\n**Nextcloud version:** 14.0.4\r\n\r\n**Updated from an older Nextcloud/ownCloud or fresh install:** Updates vom 13.x\r\n\r\n**Where did you install Nextcloud from:** Official package. No docker.\r\n\r\n**List of activated apps:**\r\n\r\nEnabled:\r\n  - accessibility: 1.0.1\r\n  - activity: 2.7.0\r\n  - audioplayer: 2.4.1\r\n  - bookmarks: 0.14.2\r\n  - bruteforcesettings: 1.2.0\r\n  - calendar: 1.6.4\r\n  - cloud_federation_api: 0.0.1\r\n  - comments: 1.4.0\r\n  - contacts: 2.1.7\r\n  - dav: 1.6.0\r\n  - deck: 0.5.0\r\n  - federatedfilesharing: 1.4.0\r\n  - federation: 1.4.0\r\n  - files: 1.9.0\r\n  - files_pdfviewer: 1.3.2\r\n  - files_sharing: 1.6.2\r\n  - files_texteditor: 2.6.0\r\n  - files_trashbin: 1.4.1\r\n  - files_versions: 1.7.1\r\n  - files_videoplayer: 1.3.0\r\n  - firstrunwizard: 2.3.0\r\n  - gallery: 18.1.0\r\n  - logreader: 2.0.0\r\n  - lookup_server_connector: 1.2.0\r\n  - news: 13.0.3\r\n  - nextcloud_announcements: 1.3.0\r\n  - notes: 2.5.0\r\n  - notifications: 2.2.1\r\n  - oauth2: 1.2.1\r\n  - password_policy: 1.4.0\r\n  - previewgenerator: 2.0.0\r\n  - provisioning_api: 1.4.0\r\n  - serverinfo: 1.4.0\r\n  - sharebymail: 1.4.0\r\n  - support: 1.0.0\r\n  - survey_client: 1.2.0\r\n  - systemtags: 1.4.0\r\n  - theming: 1.5.0\r\n  - twofactor_backupcodes: 1.3.1\r\n  - updatenotification: 1.4.1\r\n  - workflowengine: 1.4.0\r\nDisabled:\r\n  - admin_audit\r\n  - encryption\r\n  - files_external\r\n  - user_external\r\n  - user_ldap\r\n\r\n**Nextcloud configuration:**\r\n\r\n{\r\n    \"system\": {\r\n        \"instanceid\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"passwordsalt\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"secret\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"trusted_domains\": [\r\n            \"foo.torrentkino.de\"\r\n        ],\r\n        \"datadirectory\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"overwrite.cli.url\": \"https:\\/\\/foo.torrentkino.de\",\r\n        \"memcache.local\": \"\\\\OC\\\\Memcache\\\\APCu\",\r\n        \"dbtype\": \"pgsql\",\r\n        \"version\": \"14.0.4.2\",\r\n        \"dbname\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"dbhost\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"dbport\": \"\",\r\n        \"dbtableprefix\": \"oc_\",\r\n        \"dbuser\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"dbpassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"installed\": true,\r\n        \"maintenance\": false,\r\n        \"theme\": \"\",\r\n        \"loglevel\": 2,\r\n        \"mail_smtpmode\": \"smtp\",\r\n        \"mail_smtpauthtype\": \"LOGIN\",\r\n        \"mail_smtpsecure\": \"tls\",\r\n        \"mail_from_address\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_domain\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_smtpauth\": 1,\r\n        \"mail_smtphost\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_smtpport\": \"587\",\r\n        \"mail_smtpname\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_smtppassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"updater.release.channel\": \"stable\"\r\n    }\r\n}\r\n\r\n**Are you using external storage, if yes which one:** No\r\n\r\n**Are you using encryption:** No\r\n\r\n**Are you using an external user-backend, if yes which one:** No"},"comment":{"url":"https://api.github.com/repos/nextcloud/server/issues/comments/442872424","html_url":"https://github.com/nextcloud/server/issues/12729#issuecomment-442872424","issue_url":"https://api.github.com/repos/nextcloud/server/issues/12729","id":442872424,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0Mjg3MjQyNA==","user":{"login":"nextcloud-bot","id":20296731,"node_id":"MDQ6VXNlcjIwMjk2NzMx","avatar_url":"https://avatars2.githubusercontent.com/u/20296731?v=4","gravatar_id":"","url":"https://api.github.com/users/nextcloud-bot","html_url":"https://github.com/nextcloud-bot","followers_url":"https://api.github.com/users/nextcloud-bot/followers","following_url":"https://api.github.com/users/nextcloud-bot/following{/other_user}","gists_url":"https://api.github.com/users/nextcloud-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/nextcloud-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nextcloud-bot/subscriptions","organizations_url":"https://api.github.com/users/nextcloud-bot/orgs","repos_url":"https://api.github.com/users/nextcloud-bot/repos","events_url":"https://api.github.com/users/nextcloud-bot/events{/privacy}","received_events_url":"https://api.github.com/users/nextcloud-bot/received_events","type":"User","site_admin":false},"created_at":"2018-11-29T15:21:35Z","updated_at":"2018-11-29T15:21:35Z","author_association":"MEMBER","body":"[GitMate.io](https://gitmate.io) thinks possibly related issues are https://github.com/nextcloud/server/pull/12586 (14.0.4), https://github.com/nextcloud/server/issues/366 (PostgreSQL: violation of constraints), https://github.com/nextcloud/server/issues/6343 (PostgreSQL : duplicate key value violates unique constraint error message), https://github.com/nextcloud/server/issues/12204 (Resolve ERROR: duplicate key value violates unique constraint \"oc_credentials_pkey\"), and https://github.com/nextcloud/server/issues/11779 (SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry * for key 'lock_key_index')."}}
{"actor":{"display_login":"nextcloud-bot"}}