payload: {"action":"created","issue":{"url":"https://api.github.com/repos/dockstore/dockstore/issues/3020","repository_url":"https://api.github.com/repos/dockstore/dockstore","labels_url":"https://api.github.com/repos/dockstore/dockstore/issues/3020/labels{/name}","comments_url":"https://api.github.com/repos/dockstore/dockstore/issues/3020/comments","events_url":"https://api.github.com/repos/dockstore/dockstore/issues/3020/events","html_url":"https://github.com/dockstore/dockstore/issues/3020","id":522504586,"node_id":"MDU6SXNzdWU1MjI1MDQ1ODY=","number":3020,"title":"Instructions for loading data in compose_setup no longer work","user":{"login":"coverbeck","id":1049340,"node_id":"MDQ6VXNlcjEwNDkzNDA=","avatar_url":"https://avatars3.githubusercontent.com/u/1049340?v=4","gravatar_id":"","url":"https://api.github.com/users/coverbeck","html_url":"https://github.com/coverbeck","followers_url":"https://api.github.com/users/coverbeck/followers","following_url":"https://api.github.com/users/coverbeck/following{/other_user}","gists_url":"https://api.github.com/users/coverbeck/gists{/gist_id}","starred_url":"https://api.github.com/users/coverbeck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coverbeck/subscriptions","organizations_url":"https://api.github.com/users/coverbeck/orgs","repos_url":"https://api.github.com/users/coverbeck/repos","events_url":"https://api.github.com/users/coverbeck/events{/privacy}","received_events_url":"https://api.github.com/users/coverbeck/received_events","type":"User","site_admin":false},"labels":[{"id":195581986,"node_id":"MDU6TGFiZWwxOTU1ODE5ODY=","url":"https://api.github.com/repos/dockstore/dockstore/labels/bug","name":"bug","color":"fc2929","default":true,"description":null},{"id":913795034,"node_id":"MDU6TGFiZWw5MTM3OTUwMzQ=","url":"https://api.github.com/repos/dockstore/dockstore/labels/operations","name":"operations","color":"0052cc","default":false,"description":"Changes to our configuration or AWS setup"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/dockstore/dockstore/milestones/28","html_url":"https://github.com/dockstore/dockstore/milestone/28","labels_url":"https://api.github.com/repos/dockstore/dockstore/milestones/28/labels","id":4205211,"node_id":"MDk6TWlsZXN0b25lNDIwNTIxMQ==","number":28,"title":"1.8.0","description":"Near future work","creator":{"login":"denis-yuen","id":1730679,"node_id":"MDQ6VXNlcjE3MzA2Nzk=","avatar_url":"https://avatars0.githubusercontent.com/u/1730679?v=4","gravatar_id":"","url":"https://api.github.com/users/denis-yuen","html_url":"https://github.com/denis-yuen","followers_url":"https://api.github.com/users/denis-yuen/followers","following_url":"https://api.github.com/users/denis-yuen/following{/other_user}","gists_url":"https://api.github.com/users/denis-yuen/gists{/gist_id}","starred_url":"https://api.github.com/users/denis-yuen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denis-yuen/subscriptions","organizations_url":"https://api.github.com/users/denis-yuen/orgs","repos_url":"https://api.github.com/users/denis-yuen/repos","events_url":"https://api.github.com/users/denis-yuen/events{/privacy}","received_events_url":"https://api.github.com/users/denis-yuen/received_events","type":"User","site_admin":false},"open_issues":68,"closed_issues":31,"state":"open","created_at":"2019-04-05T18:24:21Z","updated_at":"2019-12-03T22:11:01Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2019-11-13T22:15:45Z","updated_at":"2019-12-04T22:27:57Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"## Bug Report\n\nThe [Loading up a database section](https://github.com/dockstore/compose_setup#loading-up-a-database) no longer works for 1.8. This section\n\n```\nsu - postgres\npsql -f  /tmp/fix.sql \n```\nleads to the data being created with the user `postgres` being the owner of all tables. However the webservice is [now configured](https://github.com/dockstore/dockstore/blob/develop/dockstore-webservice/src/main/resources/migrations.1.7.0.relinquish.xml) for the user `dockstore` to be the owner, and so when the webservice launches it does not have permission to access the tables.\n\nYou'd think changing the psql command to something like `psql -f /tmp/fix.sql -U dockstore -d ...` would fix it, but when I tried it on staging, I got errors. I was trying to get staging back up, so I did not save them (should have), but I'm guessing the dockstore user doesn't have permission to execute all the commands in our psql file.\n\nIOW, the solution needs to be figured out.\n\n┆Issue is synchronized with this [Jira Story](https://ucsc-cgl.atlassian.net/browse/DOCK-1080)\n┆Issue Type: Story\n┆Fix Versions: Dockstore 1.8\n┆Issue Number: DOCK-1080\n"},"comment":{"url":"https://api.github.com/repos/dockstore/dockstore/issues/comments/561868513","html_url":"https://github.com/dockstore/dockstore/issues/3020#issuecomment-561868513","issue_url":"https://api.github.com/repos/dockstore/dockstore/issues/3020","id":561868513,"node_id":"MDEyOklzc3VlQ29tbWVudDU2MTg2ODUxMw==","user":{"login":"coverbeck","id":1049340,"node_id":"MDQ6VXNlcjEwNDkzNDA=","avatar_url":"https://avatars3.githubusercontent.com/u/1049340?v=4","gravatar_id":"","url":"https://api.github.com/users/coverbeck","html_url":"https://github.com/coverbeck","followers_url":"https://api.github.com/users/coverbeck/followers","following_url":"https://api.github.com/users/coverbeck/following{/other_user}","gists_url":"https://api.github.com/users/coverbeck/gists{/gist_id}","starred_url":"https://api.github.com/users/coverbeck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coverbeck/subscriptions","organizations_url":"https://api.github.com/users/coverbeck/orgs","repos_url":"https://api.github.com/users/coverbeck/repos","events_url":"https://api.github.com/users/coverbeck/events{/privacy}","received_events_url":"https://api.github.com/users/coverbeck/received_events","type":"User","site_admin":false},"created_at":"2019-12-04T22:27:57Z","updated_at":"2019-12-04T22:27:57Z","author_association":"CONTRIBUTOR","body":"Ah right... I think I didn't fully understand the problem when I created the issue, having run into it when deploying 1.7 to staging after 1.8 had already been deployed there, and so the title ~~is~~ was misleading (will update it right after this comment)"}}
other: {"actor":{"display_login":"coverbeck"}}