Purge old RT tickets

Moritz suggested that we purge old RT tickets from time to time to avoid sitting on lots of personal data, email addresses, and so on. I would imagine that this is easy to do with a cron on the same server and poking at the DB a bit. Thoughts?

added component::user experience/tor support owner::lunar priority::medium resolution::fixed status::closed type::task labels

RT seems to come with a command line utility/lib called RTx-Shredder to purge tickets from the database. The example does not show how to apply a time limitation ("old" tickets), and from the documentation it is not clear whether there is an option to do so. One would have to run it to see which plugins it lists and what they offer.

Seems like a horrible idea to rewrite/destroy part of the debugging/change log history.

Trac:
Resolution: N/A to wontfix
Status: new to closed

reopening since weasel said he didn't realize this was about rt

Trac:
Resolution: wontfix to N/A
Status: closed to reopened

We'll need to provide stats on help desk utilization for various contracts. Before we purge, we should figure out what the stats are, and get them.

What kind of stats do you want?

Please provide guidance on what to delete.

Would something like rt-shredder --plugin "Tickets=query,(Status = 'resolve' OR Status = 'rejected') AND LastUpdated < '90 days ago'" be what you want?

Trac:
Status: reopened to needs_information

We shouldn't purge tickets until we have finalized the work and summary data for the projects. This also purges past history of work performed and provides a trail of who does what.

Further, we lose the history of communications and discussions about tickets.

I was not aware of this ticket and restarted the discussion on the tor-internal mailing list. Hopefully we will agree on the right way to do it.

Trac:
Status: needs_information to assigned
Component: Tor Sysadmin Team to Tor Support
Owner: N/A to lunar

Trac:
Status: assigned to needs_information

This is now implemented. Tickets will be removed from the database after 100 days of inactivity.

Trac:
Status: needs_information to closed
Resolution: N/A to fixed

closed