{"action":"opened","issue":{"url":"https://api.github.com/repos/zalando-stups/planb-revocation/issues/131","repository_url":"https://api.github.com/repos/zalando-stups/planb-revocation","labels_url":"https://api.github.com/repos/zalando-stups/planb-revocation/issues/131/labels{/name}","comments_url":"https://api.github.com/repos/zalando-stups/planb-revocation/issues/131/comments","events_url":"https://api.github.com/repos/zalando-stups/planb-revocation/issues/131/events","html_url":"https://github.com/zalando-stups/planb-revocation/issues/131","id":315793733,"number":131,"title":"Auto-Cleanup DB","user":{"login":"jbspeakr","id":2291138,"avatar_url":"https://avatars1.githubusercontent.com/u/2291138?v=4","gravatar_id":"","url":"https://api.github.com/users/jbspeakr","html_url":"https://github.com/jbspeakr","followers_url":"https://api.github.com/users/jbspeakr/followers","following_url":"https://api.github.com/users/jbspeakr/following{/other_user}","gists_url":"https://api.github.com/users/jbspeakr/gists{/gist_id}","starred_url":"https://api.github.com/users/jbspeakr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jbspeakr/subscriptions","organizations_url":"https://api.github.com/users/jbspeakr/orgs","repos_url":"https://api.github.com/users/jbspeakr/repos","events_url":"https://api.github.com/users/jbspeakr/events{/privacy}","received_events_url":"https://api.github.com/users/jbspeakr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-19T09:18:17Z","updated_at":"2018-04-19T09:18:17Z","closed_at":null,"author_association":"OWNER","body":"## Current Behaviour\r\nRevocation stores data following a more or less sophisticated [\"bucket algorithm\"](https://github.com/zalando-stups/planb-revocation/blob/master/src/main/java/org/zalando/planb/revocation/persistence/CassandraRevocationStore.java#L230). However, data is never removed from DB which eventually not just results in a filling up DB but also in increased resource usage on all levels. \r\n\r\n## Expected Behaviour\r\nThere is no outdated data stored. This could get achieved by using e.g. TTLs on DB-level or some cleanup worker. This could also help getting rid of that \"bucket algorithm\" and its arbitrary [maxTimeDelta](https://github.com/zalando-stups/planb-revocation/blob/2df4f676eb37b67549df80234acf73f316b58df7/src/main/java/org/zalando/planb/revocation/config/properties/CassandraProperties.java#L59)."}}
{"actor":{"display_login":"jbspeakr"}}