What do you get from a 10+ year old open source framework, thousands and thousands of users within a wide range of roles, and tremendous complexity? A JIRA project with over 3,000 unresolved tickets, ranging from the brand-new to a stale 8+ years. Welcome to Hibernate ORM.
Is the large number indicative of low software quality? Definitely not. And therein lies the problem. A vast majority of the tickets are no longer issues, no longer relevant, or duplicates. But due to the sheer quantity, it became nearly impossible to weed through them.
I became the self-appointed "JIRA czar", in an attempt to clean it up. The following details the steps I've taken, so far, in case they're useful to other teams in similar situations. Unfortunately, while some steps are automatable, the majority require a lot of tedious, manual work. But in the end, it's worth it.
* denotes the addition of common query parameters: unresolved, unassigned, and reported by someone outside of the core team.
Through the above steps, I've been able to close out nearly 1,000 tickets. And that does not mean I've become trigger happy and closed issues that really are still problems. But frankly, I'd rather be overly aggressive and rely on the community to push back if something is erroneously closed. Being too conservative will not help.
To help prevent this situation from happening again, I've implemented some regular steps and rules:
If anyone has other tips, please post them!