{"action":"closed","issue":{"url":"https://api.github.com/repos/GMOD/Apollo/issues/1067","repository_url":"https://api.github.com/repos/GMOD/Apollo","labels_url":"https://api.github.com/repos/GMOD/Apollo/issues/1067/labels{/name}","comments_url":"https://api.github.com/repos/GMOD/Apollo/issues/1067/comments","events_url":"https://api.github.com/repos/GMOD/Apollo/issues/1067/events","html_url":"https://github.com/GMOD/Apollo/issues/1067","id":157066834,"number":1067,"title":"Weird hibernate RO issue","user":{"login":"erasche","id":458683,"avatar_url":"https://avatars.githubusercontent.com/u/458683?v=3","gravatar_id":"","url":"https://api.github.com/users/erasche","html_url":"https://github.com/erasche","followers_url":"https://api.github.com/users/erasche/followers","following_url":"https://api.github.com/users/erasche/following{/other_user}","gists_url":"https://api.github.com/users/erasche/gists{/gist_id}","starred_url":"https://api.github.com/users/erasche/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erasche/subscriptions","organizations_url":"https://api.github.com/users/erasche/orgs","repos_url":"https://api.github.com/users/erasche/repos","events_url":"https://api.github.com/users/erasche/events{/privacy}","received_events_url":"https://api.github.com/users/erasche/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/GMOD/Apollo/labels/Workingon","name":"Workingon","color":"009800"}],"state":"closed","locked":false,"assignee":{"login":"nathandunn","id":751274,"avatar_url":"https://avatars.githubusercontent.com/u/751274?v=3","gravatar_id":"","url":"https://api.github.com/users/nathandunn","html_url":"https://github.com/nathandunn","followers_url":"https://api.github.com/users/nathandunn/followers","following_url":"https://api.github.com/users/nathandunn/following{/other_user}","gists_url":"https://api.github.com/users/nathandunn/gists{/gist_id}","starred_url":"https://api.github.com/users/nathandunn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nathandunn/subscriptions","organizations_url":"https://api.github.com/users/nathandunn/orgs","repos_url":"https://api.github.com/users/nathandunn/repos","events_url":"https://api.github.com/users/nathandunn/events{/privacy}","received_events_url":"https://api.github.com/users/nathandunn/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/GMOD/Apollo/milestones/23","html_url":"https://github.com/GMOD/Apollo/milestones/2.0.3","labels_url":"https://api.github.com/repos/GMOD/Apollo/milestones/23/labels","id":1299980,"number":23,"title":"2.0.3","description":"Bugfixes and Chado re-implementation.\r\n\r\n- Closed issued: https://github.com/GMOD/Apollo/issues?q=is%3Apr+milestone%3A2.0.3+is%3Aclosed\r\n- Closed pull requests: https://github.com/GMOD/Apollo/pulls?q=is%3Apr+milestone%3A2.0.3+is%3Aclosed","creator":{"login":"nathandunn","id":751274,"avatar_url":"https://avatars.githubusercontent.com/u/751274?v=3","gravatar_id":"","url":"https://api.github.com/users/nathandunn","html_url":"https://github.com/nathandunn","followers_url":"https://api.github.com/users/nathandunn/followers","following_url":"https://api.github.com/users/nathandunn/following{/other_user}","gists_url":"https://api.github.com/users/nathandunn/gists{/gist_id}","starred_url":"https://api.github.com/users/nathandunn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nathandunn/subscriptions","organizations_url":"https://api.github.com/users/nathandunn/orgs","repos_url":"https://api.github.com/users/nathandunn/repos","events_url":"https://api.github.com/users/nathandunn/events{/privacy}","received_events_url":"https://api.github.com/users/nathandunn/received_events","type":"User","site_admin":false},"open_issues":30,"closed_issues":112,"state":"open","created_at":"2015-09-10T19:58:08Z","updated_at":"2016-05-27T18:17:57Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2016-05-26T20:03:25Z","updated_at":"2016-05-27T18:17:57Z","closed_at":"2016-05-27T18:17:56Z","body":"```\r\n$ curl https://cpt.tamu.edu/apollo/user/loadUsers \\\r\n    -H 'Content-Type: application/json' \\\r\n    --data '{\"password\": \"my-password\", \"username\": \"my-username\"}'\r\n\r\n{\"error\":\"Hibernate operation: could not execute statement; uncategorized SQLException \r\nfor SQL [n/a]; SQL state [25006]; error code [0]; ERROR: cannot execute INSERT in a \r\nread-only transaction; nested exception is org.postgresql.util.PSQLException: \r\nERROR: cannot execute INSERT in a read-only transaction\"}\r\n```\r\n\r\nBut with a client token...\r\n\r\n```\r\n$ curl https://cpt.tamu.edu/apollo/user/loadUsers?clientToken=14***************** \\\r\n    -H 'Content-Type: application/json' \\\r\n    --data '{\"password\": \"my-password\", \"username\": \"my-username\"}'\r\n\r\n[{\"organismPermissions\":[{\"id\":21282,\"userId\":4793,\"permissions\":\"[]\",\"organism\":\"DUC4\"}\r\n```\r\n\r\nI've tried selecting idle PG transactions and terminating them, but that does not seem to fix the issue. If anyone has any insights I'd really appreciate it."}}
{"actor":{"display_login":"nathandunn"}}