{"action":"created","issue":{"url":"https://api.github.com/repos/informatics-isi-edu/ermrest/issues/110","repository_url":"https://api.github.com/repos/informatics-isi-edu/ermrest","labels_url":"https://api.github.com/repos/informatics-isi-edu/ermrest/issues/110/labels{/name}","comments_url":"https://api.github.com/repos/informatics-isi-edu/ermrest/issues/110/comments","events_url":"https://api.github.com/repos/informatics-isi-edu/ermrest/issues/110/events","html_url":"https://github.com/informatics-isi-edu/ermrest/issues/110","id":182331882,"number":110,"title":"Postgres errors returned to user in certain error contexts","user":{"login":"jrchudy","id":2932600,"avatar_url":"https://avatars.githubusercontent.com/u/2932600?v=3","gravatar_id":"","url":"https://api.github.com/users/jrchudy","html_url":"https://github.com/jrchudy","followers_url":"https://api.github.com/users/jrchudy/followers","following_url":"https://api.github.com/users/jrchudy/following{/other_user}","gists_url":"https://api.github.com/users/jrchudy/gists{/gist_id}","starred_url":"https://api.github.com/users/jrchudy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrchudy/subscriptions","organizations_url":"https://api.github.com/users/jrchudy/orgs","repos_url":"https://api.github.com/users/jrchudy/repos","events_url":"https://api.github.com/users/jrchudy/events{/privacy}","received_events_url":"https://api.github.com/users/jrchudy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"karlcz","id":1075148,"avatar_url":"https://avatars.githubusercontent.com/u/1075148?v=3","gravatar_id":"","url":"https://api.github.com/users/karlcz","html_url":"https://github.com/karlcz","followers_url":"https://api.github.com/users/karlcz/followers","following_url":"https://api.github.com/users/karlcz/following{/other_user}","gists_url":"https://api.github.com/users/karlcz/gists{/gist_id}","starred_url":"https://api.github.com/users/karlcz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlcz/subscriptions","organizations_url":"https://api.github.com/users/karlcz/orgs","repos_url":"https://api.github.com/users/karlcz/repos","events_url":"https://api.github.com/users/karlcz/events{/privacy}","received_events_url":"https://api.github.com/users/karlcz/received_events","type":"User","site_admin":false},"assignees":[{"login":"karlcz","id":1075148,"avatar_url":"https://avatars.githubusercontent.com/u/1075148?v=3","gravatar_id":"","url":"https://api.github.com/users/karlcz","html_url":"https://github.com/karlcz","followers_url":"https://api.github.com/users/karlcz/followers","following_url":"https://api.github.com/users/karlcz/following{/other_user}","gists_url":"https://api.github.com/users/karlcz/gists{/gist_id}","starred_url":"https://api.github.com/users/karlcz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlcz/subscriptions","organizations_url":"https://api.github.com/users/karlcz/orgs","repos_url":"https://api.github.com/users/karlcz/repos","events_url":"https://api.github.com/users/karlcz/events{/privacy}","received_events_url":"https://api.github.com/users/karlcz/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2016-10-11T17:59:47Z","updated_at":"2016-10-13T22:07:43Z","closed_at":null,"body":"I am being presented with Postgres errors when certain 409 errors occur. The most recent error is the following:\r\n```\r\n{ [Error: 409 Conflict\r\nThe request conflicts with the state of the server. could not serialize access due to concurrent update\r\n\r\n]\r\n  code: 409,\r\n  status: undefined,\r\n  message: '409 Conflict\\nThe request conflicts with the state of the server. could not serialize access due to concurrent update\\n\\n' }\r\n```\r\n\r\nEdit: removed an error that was a client mistake (deleted a table before trying to use it)."},"comment":{"url":"https://api.github.com/repos/informatics-isi-edu/ermrest/issues/comments/253653076","html_url":"https://github.com/informatics-isi-edu/ermrest/issues/110#issuecomment-253653076","issue_url":"https://api.github.com/repos/informatics-isi-edu/ermrest/issues/110","id":253653076,"user":{"login":"karlcz","id":1075148,"avatar_url":"https://avatars.githubusercontent.com/u/1075148?v=3","gravatar_id":"","url":"https://api.github.com/users/karlcz","html_url":"https://github.com/karlcz","followers_url":"https://api.github.com/users/karlcz/followers","following_url":"https://api.github.com/users/karlcz/following{/other_user}","gists_url":"https://api.github.com/users/karlcz/gists{/gist_id}","starred_url":"https://api.github.com/users/karlcz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlcz/subscriptions","organizations_url":"https://api.github.com/users/karlcz/orgs","repos_url":"https://api.github.com/users/karlcz/repos","events_url":"https://api.github.com/users/karlcz/events{/privacy}","received_events_url":"https://api.github.com/users/karlcz/received_events","type":"User","site_admin":false},"created_at":"2016-10-13T22:07:43Z","updated_at":"2016-10-13T22:07:43Z","body":"Looking at the dev server logs I saw two classes of postgres errors that can happen under concurrent access.  I just pushed changes to map these to a 503 Service Unavailable HTTP error so the client can retry the request.\r\n\r\nI'm not sure if you'll encounter these errors again since the underlying trigger was your new test suite executing things concurrently when you thought they were serialized..."}}
{"actor":{"display_login":"karlcz"}}