...

Several community members have written scripts that automate at least some of those tasks in the past.

Validate ticket has matching commit

To validate that every ticket has a corresponding commit and vice versa, you could use this script.

Validate ticket has matching commit

If a ticket doesn't have a matching commit, you might take the following investigation steps:

...

Validate all changes have a matching ticket

If a commit mentions a JIRA ticket which isn't marked as fixed or where there is no matching JIRA ticket, you might consider the following steps:

Check if there is any matching JIRA ticket. If so, why isn't it closed?

If there is no matching JIRA ticket

...

, take a look at the commit and the PR and see if you can find more information from there.

Validate tickets are marked as fixed

Sometimes tickets get marked with a fixVersion, but then get reopened or don't get marked as fixed. This can lead to false information if someone looks at release notes. The below JIRA query should find those tickets:

project = GEODE AND fixVersion = <current release> AND resolution != Fixed

...

Creating a Release Candidate

...