{"action":"opened","issue":{"url":"https://api.github.com/repos/poanetwork/blockscout/issues/1308","repository_url":"https://api.github.com/repos/poanetwork/blockscout","labels_url":"https://api.github.com/repos/poanetwork/blockscout/issues/1308/labels{/name}","comments_url":"https://api.github.com/repos/poanetwork/blockscout/issues/1308/comments","events_url":"https://api.github.com/repos/poanetwork/blockscout/issues/1308/events","html_url":"https://github.com/poanetwork/blockscout/issues/1308","id":396031929,"node_id":"MDU6SXNzdWUzOTYwMzE5Mjk=","number":1308,"title":"Block rewards aren't deleted when block loses consensus","user":{"login":"KronicDeth","id":298259,"node_id":"MDQ6VXNlcjI5ODI1OQ==","avatar_url":"https://avatars3.githubusercontent.com/u/298259?v=4","gravatar_id":"","url":"https://api.github.com/users/KronicDeth","html_url":"https://github.com/KronicDeth","followers_url":"https://api.github.com/users/KronicDeth/followers","following_url":"https://api.github.com/users/KronicDeth/following{/other_user}","gists_url":"https://api.github.com/users/KronicDeth/gists{/gist_id}","starred_url":"https://api.github.com/users/KronicDeth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KronicDeth/subscriptions","organizations_url":"https://api.github.com/users/KronicDeth/orgs","repos_url":"https://api.github.com/users/KronicDeth/repos","events_url":"https://api.github.com/users/KronicDeth/events{/privacy}","received_events_url":"https://api.github.com/users/KronicDeth/received_events","type":"User","site_admin":false},"labels":[{"id":803248120,"node_id":"MDU6TGFiZWw4MDMyNDgxMjA=","url":"https://api.github.com/repos/poanetwork/blockscout/labels/bug%20:bug:","name":"bug :bug:","color":"ee0701","default":false}],"state":"open","locked":false,"assignee":{"login":"KronicDeth","id":298259,"node_id":"MDQ6VXNlcjI5ODI1OQ==","avatar_url":"https://avatars3.githubusercontent.com/u/298259?v=4","gravatar_id":"","url":"https://api.github.com/users/KronicDeth","html_url":"https://github.com/KronicDeth","followers_url":"https://api.github.com/users/KronicDeth/followers","following_url":"https://api.github.com/users/KronicDeth/following{/other_user}","gists_url":"https://api.github.com/users/KronicDeth/gists{/gist_id}","starred_url":"https://api.github.com/users/KronicDeth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KronicDeth/subscriptions","organizations_url":"https://api.github.com/users/KronicDeth/orgs","repos_url":"https://api.github.com/users/KronicDeth/repos","events_url":"https://api.github.com/users/KronicDeth/events{/privacy}","received_events_url":"https://api.github.com/users/KronicDeth/received_events","type":"User","site_admin":false},"assignees":[{"login":"KronicDeth","id":298259,"node_id":"MDQ6VXNlcjI5ODI1OQ==","avatar_url":"https://avatars3.githubusercontent.com/u/298259?v=4","gravatar_id":"","url":"https://api.github.com/users/KronicDeth","html_url":"https://github.com/KronicDeth","followers_url":"https://api.github.com/users/KronicDeth/followers","following_url":"https://api.github.com/users/KronicDeth/following{/other_user}","gists_url":"https://api.github.com/users/KronicDeth/gists{/gist_id}","starred_url":"https://api.github.com/users/KronicDeth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KronicDeth/subscriptions","organizations_url":"https://api.github.com/users/KronicDeth/orgs","repos_url":"https://api.github.com/users/KronicDeth/repos","events_url":"https://api.github.com/users/KronicDeth/events{/privacy}","received_events_url":"https://api.github.com/users/KronicDeth/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2019-01-04T19:01:39Z","updated_at":"2019-01-04T19:01:39Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"The `block_rewards` table has a foreign key to `blocks.hash`, but the actual `fetch_beneficiaries` call and the underlying `trace_block` JSONRPC call use block numbers, so when a reorg occurs, the `block_rewards` for the `hash` for the `number` becomes invalid and so should be deleted until new block rewards are added."}}
{"actor":{"display_login":"KronicDeth"}}