Accidentally restored 2 mo. old database, can't remove issues

Hello,

We were attempting to restore a database on our company server.  The server included a website and JIRA Agile, among other things.  While we only intended to restore the websites database backup, unfortunately, the JIRA database was "restored" as well, resulting in data that is over a month old.  We have no other copies of this data which are newer.  Here's the problem:  When viewing the Kanban for our primary project, the deleted issues are still there, but if you try to view them, move them or delete them, a red error dialog pops up saying, "This issue does not exist".  It appears that either the Kanban itself or JIRA kept its own index or record separate from the database, but it is incomplete.  I know this is really a terrible SNAFU, but can anyone give us any advice on how to get rid of these ghost issues?  Are we going to have to simply shut down the whole thing and rebuild it by hand?  Thanks for your help!

1 answer

1 accepted

Accepted Answer
0 votes

You have not explained what you have done to "restore" this data, but my best guess is that you reloaded a database and then tried to use it as the back-end of a more recent JIRA.

If that's right, then try running a complete re-index of JIRA.  Run the full "lock JIRA, it will be unusable while I run" option.  That should recreate the indices (including search) from scratch and hence fix all your ghosts.

Hello,

Thank you for your quick reply.  What you said, "...that you reloaded a database and then tried to use it as the back-end of a more recent JIRA.", is what I was trying to say in my original question.  Alas, this task has fallen to me, even though I am by no means qualified or experienced with the administration of JIRA.  I'm pretty sure that you summed it up nicely.

I will attempt to implement your solution and I will return with the results.

Again, thank you.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

132 views 6 8
View post

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