{"action":"created","issue":{"url":"https://api.github.com/repos/saltstack/salt/issues/33417","repository_url":"https://api.github.com/repos/saltstack/salt","labels_url":"https://api.github.com/repos/saltstack/salt/issues/33417/labels{/name}","comments_url":"https://api.github.com/repos/saltstack/salt/issues/33417/comments","events_url":"https://api.github.com/repos/saltstack/salt/issues/33417/events","html_url":"https://github.com/saltstack/salt/issues/33417","id":156069931,"number":33417,"title":"Feature Request: Add ability to mysql returner to remove past jobs","user":{"login":"Ch3LL","id":6886822,"avatar_url":"https://avatars.githubusercontent.com/u/6886822?v=3","gravatar_id":"","url":"https://api.github.com/users/Ch3LL","html_url":"https://github.com/Ch3LL","followers_url":"https://api.github.com/users/Ch3LL/followers","following_url":"https://api.github.com/users/Ch3LL/following{/other_user}","gists_url":"https://api.github.com/users/Ch3LL/gists{/gist_id}","starred_url":"https://api.github.com/users/Ch3LL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ch3LL/subscriptions","organizations_url":"https://api.github.com/users/Ch3LL/orgs","repos_url":"https://api.github.com/users/Ch3LL/repos","events_url":"https://api.github.com/users/Ch3LL/events{/privacy}","received_events_url":"https://api.github.com/users/Ch3LL/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/saltstack/salt/labels/Carbon","name":"Carbon","color":"fbca04"},{"url":"https://api.github.com/repos/saltstack/salt/labels/Feature","name":"Feature","color":"009800"},{"url":"https://api.github.com/repos/saltstack/salt/labels/P1","name":"P1","color":"2181ee"},{"url":"https://api.github.com/repos/saltstack/salt/labels/Returners","name":"Returners","color":"006b75"},{"url":"https://api.github.com/repos/saltstack/salt/labels/RIoT","name":"RIoT","color":"fef2c0"},{"url":"https://api.github.com/repos/saltstack/salt/labels/TEAM%20RIoT","name":"TEAM RIoT","color":"A9A9A9"},{"url":"https://api.github.com/repos/saltstack/salt/labels/ZD","name":"ZD","color":"e11d21"}],"state":"open","locked":false,"assignee":{"login":"cro","id":83323,"avatar_url":"https://avatars.githubusercontent.com/u/83323?v=3","gravatar_id":"","url":"https://api.github.com/users/cro","html_url":"https://github.com/cro","followers_url":"https://api.github.com/users/cro/followers","following_url":"https://api.github.com/users/cro/following{/other_user}","gists_url":"https://api.github.com/users/cro/gists{/gist_id}","starred_url":"https://api.github.com/users/cro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cro/subscriptions","organizations_url":"https://api.github.com/users/cro/orgs","repos_url":"https://api.github.com/users/cro/repos","events_url":"https://api.github.com/users/cro/events{/privacy}","received_events_url":"https://api.github.com/users/cro/received_events","type":"User","site_admin":false},"assignees":[{"login":"cro","id":83323,"avatar_url":"https://avatars.githubusercontent.com/u/83323?v=3","gravatar_id":"","url":"https://api.github.com/users/cro","html_url":"https://github.com/cro","followers_url":"https://api.github.com/users/cro/followers","following_url":"https://api.github.com/users/cro/following{/other_user}","gists_url":"https://api.github.com/users/cro/gists{/gist_id}","starred_url":"https://api.github.com/users/cro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cro/subscriptions","organizations_url":"https://api.github.com/users/cro/orgs","repos_url":"https://api.github.com/users/cro/repos","events_url":"https://api.github.com/users/cro/events{/privacy}","received_events_url":"https://api.github.com/users/cro/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/saltstack/salt/milestones/89","html_url":"https://github.com/saltstack/salt/milestones/C%205","labels_url":"https://api.github.com/repos/saltstack/salt/milestones/89/labels","id":1897763,"number":89,"title":"C 5","description":"","creator":{"login":"meggiebot","id":12242451,"avatar_url":"https://avatars.githubusercontent.com/u/12242451?v=3","gravatar_id":"","url":"https://api.github.com/users/meggiebot","html_url":"https://github.com/meggiebot","followers_url":"https://api.github.com/users/meggiebot/followers","following_url":"https://api.github.com/users/meggiebot/following{/other_user}","gists_url":"https://api.github.com/users/meggiebot/gists{/gist_id}","starred_url":"https://api.github.com/users/meggiebot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/meggiebot/subscriptions","organizations_url":"https://api.github.com/users/meggiebot/orgs","repos_url":"https://api.github.com/users/meggiebot/repos","events_url":"https://api.github.com/users/meggiebot/events{/privacy}","received_events_url":"https://api.github.com/users/meggiebot/received_events","type":"User","site_admin":false},"open_issues":24,"closed_issues":17,"state":"open","created_at":"2016-07-21T22:34:47Z","updated_at":"2016-08-19T15:41:44Z","due_on":"2016-08-26T06:00:00Z","closed_at":null},"comments":3,"created_at":"2016-05-20T23:41:32Z","updated_at":"2016-08-19T20:14:22Z","closed_at":null,"body":"### Description of Issue/Question\r\n\r\nThis feature request is to add the ability for salt to clean up the jobs stored in a returner, particularly the mysql returner. When using the master_job_cache along side the mysql returner eventually many jobs get stored into the database that it causes issues when querying the jobs. Cleaning up these jobs with salt would be a great feature added.\r\n\r\nIt would be nice to have salt be able to remove jobs. For example:\r\n- only keep jobs for the past n months\r\n- archive the past n months of jobs possibly in another table\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/saltstack/salt/issues/comments/241123150","html_url":"https://github.com/saltstack/salt/issues/33417#issuecomment-241123150","issue_url":"https://api.github.com/repos/saltstack/salt/issues/33417","id":241123150,"user":{"login":"meggiebot","id":12242451,"avatar_url":"https://avatars.githubusercontent.com/u/12242451?v=3","gravatar_id":"","url":"https://api.github.com/users/meggiebot","html_url":"https://github.com/meggiebot","followers_url":"https://api.github.com/users/meggiebot/followers","following_url":"https://api.github.com/users/meggiebot/following{/other_user}","gists_url":"https://api.github.com/users/meggiebot/gists{/gist_id}","starred_url":"https://api.github.com/users/meggiebot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/meggiebot/subscriptions","organizations_url":"https://api.github.com/users/meggiebot/orgs","repos_url":"https://api.github.com/users/meggiebot/repos","events_url":"https://api.github.com/users/meggiebot/events{/privacy}","received_events_url":"https://api.github.com/users/meggiebot/received_events","type":"User","site_admin":false},"created_at":"2016-08-19T20:14:22Z","updated_at":"2016-08-19T20:14:22Z","body":"https://github.com/saltstack/salt/pull/35499"}}
{"actor":{"display_login":"meggiebot"}}