{"action":"closed","issue":{"url":"https://api.github.com/repos/HearthSim/HSReplay.net/issues/885","repository_url":"https://api.github.com/repos/HearthSim/HSReplay.net","labels_url":"https://api.github.com/repos/HearthSim/HSReplay.net/issues/885/labels{/name}","comments_url":"https://api.github.com/repos/HearthSim/HSReplay.net/issues/885/comments","events_url":"https://api.github.com/repos/HearthSim/HSReplay.net/issues/885/events","html_url":"https://github.com/HearthSim/HSReplay.net/issues/885","id":336415759,"node_id":"MDU6SXNzdWUzMzY0MTU3NTk=","number":885,"title":"Productionized implementation of Redshift Archiving tool","user":{"login":"joolean","id":799596,"node_id":"MDQ6VXNlcjc5OTU5Ng==","avatar_url":"https://avatars1.githubusercontent.com/u/799596?v=4","gravatar_id":"","url":"https://api.github.com/users/joolean","html_url":"https://github.com/joolean","followers_url":"https://api.github.com/users/joolean/followers","following_url":"https://api.github.com/users/joolean/following{/other_user}","gists_url":"https://api.github.com/users/joolean/gists{/gist_id}","starred_url":"https://api.github.com/users/joolean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joolean/subscriptions","organizations_url":"https://api.github.com/users/joolean/orgs","repos_url":"https://api.github.com/users/joolean/repos","events_url":"https://api.github.com/users/joolean/events{/privacy}","received_events_url":"https://api.github.com/users/joolean/received_events","type":"User","site_admin":false},"labels":[{"id":948208101,"node_id":"MDU6TGFiZWw5NDgyMDgxMDE=","url":"https://api.github.com/repos/HearthSim/HSReplay.net/labels/story","name":"story","color":"000000","default":false}],"state":"closed","locked":false,"assignee":{"login":"joolean","id":799596,"node_id":"MDQ6VXNlcjc5OTU5Ng==","avatar_url":"https://avatars1.githubusercontent.com/u/799596?v=4","gravatar_id":"","url":"https://api.github.com/users/joolean","html_url":"https://github.com/joolean","followers_url":"https://api.github.com/users/joolean/followers","following_url":"https://api.github.com/users/joolean/following{/other_user}","gists_url":"https://api.github.com/users/joolean/gists{/gist_id}","starred_url":"https://api.github.com/users/joolean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joolean/subscriptions","organizations_url":"https://api.github.com/users/joolean/orgs","repos_url":"https://api.github.com/users/joolean/repos","events_url":"https://api.github.com/users/joolean/events{/privacy}","received_events_url":"https://api.github.com/users/joolean/received_events","type":"User","site_admin":false},"assignees":[{"login":"joolean","id":799596,"node_id":"MDQ6VXNlcjc5OTU5Ng==","avatar_url":"https://avatars1.githubusercontent.com/u/799596?v=4","gravatar_id":"","url":"https://api.github.com/users/joolean","html_url":"https://github.com/joolean","followers_url":"https://api.github.com/users/joolean/followers","following_url":"https://api.github.com/users/joolean/following{/other_user}","gists_url":"https://api.github.com/users/joolean/gists{/gist_id}","starred_url":"https://api.github.com/users/joolean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joolean/subscriptions","organizations_url":"https://api.github.com/users/joolean/orgs","repos_url":"https://api.github.com/users/joolean/repos","events_url":"https://api.github.com/users/joolean/events{/privacy}","received_events_url":"https://api.github.com/users/joolean/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/HearthSim/HSReplay.net/milestones/8","html_url":"https://github.com/HearthSim/HSReplay.net/milestone/8","labels_url":"https://api.github.com/repos/HearthSim/HSReplay.net/milestones/8/labels","id":3479573,"node_id":"MDk6TWlsZXN0b25lMzQ3OTU3Mw==","number":8,"title":"Sprint Four Mana Seven Seven","description":"","creator":{"login":"beheh","id":929769,"node_id":"MDQ6VXNlcjkyOTc2OQ==","avatar_url":"https://avatars2.githubusercontent.com/u/929769?v=4","gravatar_id":"","url":"https://api.github.com/users/beheh","html_url":"https://github.com/beheh","followers_url":"https://api.github.com/users/beheh/followers","following_url":"https://api.github.com/users/beheh/following{/other_user}","gists_url":"https://api.github.com/users/beheh/gists{/gist_id}","starred_url":"https://api.github.com/users/beheh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beheh/subscriptions","organizations_url":"https://api.github.com/users/beheh/orgs","repos_url":"https://api.github.com/users/beheh/repos","events_url":"https://api.github.com/users/beheh/events{/privacy}","received_events_url":"https://api.github.com/users/beheh/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":4,"state":"open","created_at":"2018-07-06T21:25:55Z","updated_at":"2018-08-15T21:00:26Z","due_on":"2018-08-16T07:00:00Z","closed_at":null},"comments":0,"created_at":"2018-06-27T22:56:08Z","updated_at":"2018-08-15T21:00:26Z","closed_at":"2018-08-15T21:00:26Z","author_association":"CONTRIBUTOR","body":"As an operational stakeholder in HSReplay.net, I need a fully-automated solution for performing periodic maintenance on our Redshift data warehouse, so that I can turn my attention to higher-value technical work.\r\n\r\nThe technical design / spec for the archive tool is available here: https://hearthsim.atlassian.net/wiki/spaces/IN/pages/11304974/DRAFT+Design+HSReplay.net+Redshift+archive+tool\r\n\r\nThis story is complete when:\r\n- [x] We have a version of the archive tool as described in the design document that executes destructive commands / queries against S3 and Redshift unless the `--dry-run` flag was specified\r\n- [x] Unit and integration tests have been written as appropriate to cover the changes to support writing / deleting\r\n- [x] The tool has been deployed to build.hearthsim.net, along with a configuration file giving a retention policy for all archivable tables (and a list of all compactible tables) and a scheduled Jenkins job has been created that executes it once per day\r\n- [x] The tool has actually run in production at least once end-to-end without failures and the Redshift cluster is in compliance with the archiving policy.\r\n- [x] The metrics, alerts, and dashboard described in the design document have been created in Grafana and Telegraph\r\n"}}
{"actor":{"display_login":"joolean"}}