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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,959 views 19 22
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