{"action":"created","issue":{"url":"https://api.github.com/repos/xtuple/xtuple-admin-utility/issues/35","labels_url":"https://api.github.com/repos/xtuple/xtuple-admin-utility/issues/35/labels{/name}","comments_url":"https://api.github.com/repos/xtuple/xtuple-admin-utility/issues/35/comments","events_url":"https://api.github.com/repos/xtuple/xtuple-admin-utility/issues/35/events","html_url":"https://github.com/xtuple/xtuple-admin-utility/issues/35","id":93883088,"number":35,"title":"Carve Pilot from database not working","user":{"login":"bixwilson","id":2564915,"avatar_url":"https://avatars.githubusercontent.com/u/2564915?v=3","gravatar_id":"","url":"https://api.github.com/users/bixwilson","html_url":"https://github.com/bixwilson","followers_url":"https://api.github.com/users/bixwilson/followers","following_url":"https://api.github.com/users/bixwilson/following{/other_user}","gists_url":"https://api.github.com/users/bixwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/bixwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bixwilson/subscriptions","organizations_url":"https://api.github.com/users/bixwilson/orgs","repos_url":"https://api.github.com/users/bixwilson/repos","events_url":"https://api.github.com/users/bixwilson/events{/privacy}","received_events_url":"https://api.github.com/users/bixwilson/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-08T20:28:14Z","updated_at":"2015-07-15T16:42:55Z","closed_at":null,"body":"I attempted to use this command on my test system and got an unhelpful failure message: \r\n\r\n>MessageBox >> Something has gone wrong. Check output and correct any issues.\r\n\r\nNot sure what output to check. The log file showed the same message as above with no additional info."},"comment":{"url":"https://api.github.com/repos/xtuple/xtuple-admin-utility/issues/comments/121674053","html_url":"https://github.com/xtuple/xtuple-admin-utility/issues/35#issuecomment-121674053","issue_url":"https://api.github.com/repos/xtuple/xtuple-admin-utility/issues/35","id":121674053,"user":{"login":"elipup","id":3178379,"avatar_url":"https://avatars.githubusercontent.com/u/3178379?v=3","gravatar_id":"","url":"https://api.github.com/users/elipup","html_url":"https://github.com/elipup","followers_url":"https://api.github.com/users/elipup/followers","following_url":"https://api.github.com/users/elipup/following{/other_user}","gists_url":"https://api.github.com/users/elipup/gists{/gist_id}","starred_url":"https://api.github.com/users/elipup/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elipup/subscriptions","organizations_url":"https://api.github.com/users/elipup/orgs","repos_url":"https://api.github.com/users/elipup/repos","events_url":"https://api.github.com/users/elipup/events{/privacy}","received_events_url":"https://api.github.com/users/elipup/received_events","type":"User","site_admin":false},"created_at":"2015-07-15T16:42:55Z","updated_at":"2015-07-15T16:42:55Z","body":"The actual error is coming from the postgres command:\r\n```bash\r\nsudo su - postgres -c \"psql postgres -q -h $PGHOST -p $PGPORT -c \\\"CREATE DATABASE \\\"$PILOT\\\" TEMPLATE \\\"$SOURCE\\\" OWNER admin;\\\"\"\r\n```\r\nWhen I tested carving a pilot, I got this in my terminal (but not in the log):\r\n> ERROR:  source database \"demo481\" is being accessed by other users\r\n> DETAIL:  There are 2 other sessions using the database.\r\n\r\nThen I ran this query to see who's connected:\r\n```sql\r\nSELECT datname, usename, state, query FROM pg_stat_activity;\r\n```\r\n\r\n> demo481  | admin    | idle   | LISTEN nodext\r\n> demo481  | admin    | idle   | select xt.get($${\"nameSpace\":\"SYS\",\"type\":\"SessionStore\",\"username\":\"node\",\"encryptionKey\":\"kbOXTzQ_QMbxb2i+&kV1h^xj$O9m6SqzV98b08B4fypjJhO3L3l4dUbfZ1L+!sZ-\"}$$) as request\r\n> postgres | postgres | active | SELECT datname, usename, state, query FROM pg_stat_activity;\r\n\r\nI did install the mobile client during a previous testing run and it looks like the server is holding on to some connections.  How to we want to handle this situation?"}}