How can I delete orphaned sprints?

Hi JIRA Support:

I've run into an issue where orphaned sprints from deleted boards still show up in my project. Is there a way to delete orphaned sprints after I've deleted the boards? The issue I'm having is the same as what is posted under the first response (copied support text) from this thread:

Thanks in advance.

2 answers


I'm not sure if it helps, but I have an alternate that I tried. Assuming your situation was like mine, then this may help. This is also for anyone else who stumbles upon this.

This ticket outlines a solution in the comments - I followed the advice here and it worked

  1. Create a Filter that gets all issues across all projects
  2. Create a Board based on the filter from step 1
  3. Create a random Issue, and associate it with the Sprint that you want to delete
  4. The orphaned / unavailable Sprint now shows up in the Board from step 2
  5. Delete the Sprint (if it is in planning) or Close the Sprint (if it is already active)

    This worked well for me and took about ten minutes; I had 20 orphan sprints to clean-up. 

you sir are a hero, thank you!!!

Brilliant - thanks for posting this...

0 votes
Justin Burke Atlassian Team Jan 30, 2015

You can delete the sprint in the database.  

  1. Take a backup of your system.
  2. Shut down JIRA.
  3. Find the ID of the sprint in question:  SELECT * FROM AO_60DB71_SPRINT
  4. Delete the offending sprint:  DELETE FROM AO_60DB71_SPRINT where ID = <ID>
  5. Restart JIRA
  6. Reindex.

The above queries are written in MySQL syntax.  You may need to tweak the syntax if you are running another database platform.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 29, 2019 in Jira Software

Transforming Jira Software projects for general project management purposes

...It's true that there are projects in Jira; but they are merely a way to cut off issues, to tell them apart from other sections of work and to apply rules that are specific to that team (the schemes)....

146 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you