How to re-assign deleted CMG ID # to a new issue logged later


I have recently deleted an issue(which was a dummy issue, issue ID for it was CMG-9) under a project in JIRA( and after that, i created a new issue but JIRA assigns the ID as CMG-10 and don't use CMG-9. it looks like counter used to create the issue doesn't go back when issue is deleted. am i correct? If not, can you please let me know how to use the deleted issue ID to a new issue logged.


1 answer

0 votes

You are correct, JIRA will not reuse dead issue IDs

It's actually a bit of a pain when systems do - I've been in a situation a couple of times where a document or comment has said "see issue x-123" and when you visit it, you find out it's nothing to do with the problem because the number has been recycled for something totally different, and you're wasting time looking at it.  It's much better to have "no, sorry, this has been deleted", at least you know where you stand.

Having said that, you can safely hack the database (stop Jira, get a backup, run an SQL update, restart JIRA) to wind it back.  But you can only do it if no more issues have been added to the project, or they have been deleted.  In your case, if you want to roll back to CMG-9, then you need to delete CMG-10 and above before rolling the clock back.

Hi Nic,

Thank you for the response. Is this behviour true for project name and key value assigned to it. I mean, Can i delete a project called "CMG" and re-create the same project again? or Do i need to do hack the data base to allow me to create the project with deleted project name?


Now there's something I don't know. In older versions of JIRA, yes, deleting a project and then reusing its key worked fine. But I don't think more recent versions of JIRA let you do this. BUT, I have not tried it, so I am not sure.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,770 views 11 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot