{"action":"created","issue":{"url":"https://api.github.com/repos/nextcloud/server/issues/366","repository_url":"https://api.github.com/repos/nextcloud/server","labels_url":"https://api.github.com/repos/nextcloud/server/issues/366/labels{/name}","comments_url":"https://api.github.com/repos/nextcloud/server/issues/366/comments","events_url":"https://api.github.com/repos/nextcloud/server/issues/366/events","html_url":"https://github.com/nextcloud/server/issues/366","id":164852839,"number":366,"title":"PostgreSQL: violation of constraints","user":{"login":"pmattern","id":9860801,"avatar_url":"https://avatars.githubusercontent.com/u/9860801?v=3","gravatar_id":"","url":"https://api.github.com/users/pmattern","html_url":"https://github.com/pmattern","followers_url":"https://api.github.com/users/pmattern/followers","following_url":"https://api.github.com/users/pmattern/following{/other_user}","gists_url":"https://api.github.com/users/pmattern/gists{/gist_id}","starred_url":"https://api.github.com/users/pmattern/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pmattern/subscriptions","organizations_url":"https://api.github.com/users/pmattern/orgs","repos_url":"https://api.github.com/users/pmattern/repos","events_url":"https://api.github.com/users/pmattern/events{/privacy}","received_events_url":"https://api.github.com/users/pmattern/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-11T14:36:34Z","updated_at":"2016-07-12T15:25:45Z","closed_at":null,"body":"Using PostgreSQL some database constraints are by default violated.\r\n\r\nFrom the second time users log in onwards there are messages\r\n```\r\nERROR:  duplicate key value violates unique constraint \"oc_preferences_pkey\"\r\nDETAIL:  Key (userid, appid, configkey)=(nextcloud_admin, login, lastLogin) already exists.\r\nSTATEMENT:  INSERT INTO \"oc_preferences\" (\"userid\", \"appid\", \"configkey\", \"configvalue\") VALUES($1, $2, $3, $4)\r\n```\r\nand\r\n```\r\nERROR:  duplicate key value violates unique constraint \"oc_preferences_pkey\"\r\nDETAIL:  Key (userid, appid, configkey)=(nextcloud_admin, core, timezone) already exists.\r\nSTATEMENT:  INSERT INTO \"oc_preferences\" (\"userid\", \"appid\", \"configkey\", \"configvalue\") VALUES($1, $2, $3, $4)\r\n```\r\n\r\nThe first time a user is browsing the sample \"Photos\" in section \"All files\" there's\r\n```\r\nERROR:  duplicate key value violates unique constraint \"mimetype_id_index\"\r\nDETAIL:  Key (mimetype)=(image/png) already exists.\r\nSTATEMENT:  INSERT INTO \"oc_mimetypes\" (\"mimetype\") VALUES($1)\r\n```\r\n\r\nSeen running 9.0.52 on Arch Linux (PostgreSQL 9.5.3, PHP 7.0.8, Apache 2.4.23 using the PHP module)."},"comment":{"url":"https://api.github.com/repos/nextcloud/server/issues/comments/232083635","html_url":"https://github.com/nextcloud/server/issues/366#issuecomment-232083635","issue_url":"https://api.github.com/repos/nextcloud/server/issues/366","id":232083635,"user":{"login":"nickvergessen","id":213943,"avatar_url":"https://avatars.githubusercontent.com/u/213943?v=3","gravatar_id":"","url":"https://api.github.com/users/nickvergessen","html_url":"https://github.com/nickvergessen","followers_url":"https://api.github.com/users/nickvergessen/followers","following_url":"https://api.github.com/users/nickvergessen/following{/other_user}","gists_url":"https://api.github.com/users/nickvergessen/gists{/gist_id}","starred_url":"https://api.github.com/users/nickvergessen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nickvergessen/subscriptions","organizations_url":"https://api.github.com/users/nickvergessen/orgs","repos_url":"https://api.github.com/users/nickvergessen/repos","events_url":"https://api.github.com/users/nickvergessen/events{/privacy}","received_events_url":"https://api.github.com/users/nickvergessen/received_events","type":"User","site_admin":false},"created_at":"2016-07-12T15:25:45Z","updated_at":"2016-07-12T15:25:45Z","body":"What's the transaction isolation level you are using?"}}
{"actor":{"display_login":"nickvergessen"}}