{"action":"created","issue":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/165","repository_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql","labels_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/165/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/165/comments","events_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/165/events","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/165","id":174044601,"number":165,"title":"fix(db): don't return zombie devices from accountDevices","user":{"login":"philbooth","id":64367,"avatar_url":"https://avatars.githubusercontent.com/u/64367?v=3","gravatar_id":"","url":"https://api.github.com/users/philbooth","html_url":"https://github.com/philbooth","followers_url":"https://api.github.com/users/philbooth/followers","following_url":"https://api.github.com/users/philbooth/following{/other_user}","gists_url":"https://api.github.com/users/philbooth/gists{/gist_id}","starred_url":"https://api.github.com/users/philbooth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/philbooth/subscriptions","organizations_url":"https://api.github.com/users/philbooth/orgs","repos_url":"https://api.github.com/users/philbooth/repos","events_url":"https://api.github.com/users/philbooth/events{/privacy}","received_events_url":"https://api.github.com/users/philbooth/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/labels/waffle:active","name":"waffle:active","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"vbudhram","id":1295288,"avatar_url":"https://avatars.githubusercontent.com/u/1295288?v=3","gravatar_id":"","url":"https://api.github.com/users/vbudhram","html_url":"https://github.com/vbudhram","followers_url":"https://api.github.com/users/vbudhram/followers","following_url":"https://api.github.com/users/vbudhram/following{/other_user}","gists_url":"https://api.github.com/users/vbudhram/gists{/gist_id}","starred_url":"https://api.github.com/users/vbudhram/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vbudhram/subscriptions","organizations_url":"https://api.github.com/users/vbudhram/orgs","repos_url":"https://api.github.com/users/vbudhram/repos","events_url":"https://api.github.com/users/vbudhram/events{/privacy}","received_events_url":"https://api.github.com/users/vbudhram/received_events","type":"User","site_admin":false},"assignees":[{"login":"vbudhram","id":1295288,"avatar_url":"https://avatars.githubusercontent.com/u/1295288?v=3","gravatar_id":"","url":"https://api.github.com/users/vbudhram","html_url":"https://github.com/vbudhram","followers_url":"https://api.github.com/users/vbudhram/followers","following_url":"https://api.github.com/users/vbudhram/following{/other_user}","gists_url":"https://api.github.com/users/vbudhram/gists{/gist_id}","starred_url":"https://api.github.com/users/vbudhram/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vbudhram/subscriptions","organizations_url":"https://api.github.com/users/vbudhram/orgs","repos_url":"https://api.github.com/users/vbudhram/repos","events_url":"https://api.github.com/users/vbudhram/events{/privacy}","received_events_url":"https://api.github.com/users/vbudhram/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2016-08-30T15:05:11Z","updated_at":"2016-08-31T13:31:06Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/pulls/165","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/165","diff_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/165.diff","patch_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/165.patch"},"body":"Fixes #162.\r\n\r\nPossibly this is wrong because I've ploughed the `INNER JOIN` furrow raised in https://github.com/mozilla/fxa-auth-db-mysql/issues/162#issuecomment-243435229, without waiting for feedback. I figured I may as well offer something concrete to discuss.\r\n\r\n(and sorry about #164, ignore everything I said there!)"},"comment":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/comments/243764365","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/165#issuecomment-243764365","issue_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/165","id":243764365,"user":{"login":"vbudhram","id":1295288,"avatar_url":"https://avatars.githubusercontent.com/u/1295288?v=3","gravatar_id":"","url":"https://api.github.com/users/vbudhram","html_url":"https://github.com/vbudhram","followers_url":"https://api.github.com/users/vbudhram/followers","following_url":"https://api.github.com/users/vbudhram/following{/other_user}","gists_url":"https://api.github.com/users/vbudhram/gists{/gist_id}","starred_url":"https://api.github.com/users/vbudhram/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vbudhram/subscriptions","organizations_url":"https://api.github.com/users/vbudhram/orgs","repos_url":"https://api.github.com/users/vbudhram/repos","events_url":"https://api.github.com/users/vbudhram/events{/privacy}","received_events_url":"https://api.github.com/users/vbudhram/received_events","type":"User","site_admin":false},"created_at":"2016-08-31T13:31:06Z","updated_at":"2016-08-31T13:31:06Z","body":"@philbooth Not in the scope of this PR, but maybe something to think about, was how we were going to delete zombie sessions? Since they are not returned from `accountDevices` anymore, the only way I could see that happening is through a script?\r\n\r\nBesides nits, LGTM 👍 , merge at will"}}
{"actor":{"display_login":"vbudhram"}}