Where does issue keys live in JIRA


When I created a project, I realised afterwards that the issue key was misspelt (OPENUGRADE). Without realising that in our version of JIRA we could update the issue key through the UI, I went ahead and updated the database. I updated the "project" table (OPENUGRADE to OPENUPGRADE = missing P is added) but this then broke my project view and issue view, even though the issue key is shows the correctly spelt name (OPENUPGRADE-1). I then realised that this was the wrong approach so I have reverted the change in the db to update the "project" table to put back the misspelt pkey (OPENUPGRADE to OPENUGRADE = removed P) and even though I can now access my project configuration information through the Projects menu (I wasn't able to after making the initial change), the tickets still show the correctly spelt pkey (OPENUPGRADE-1). JIRA tells me that the issue does not exist but when I update the URL in the browser from OPENUPGRADE-1 to OPENUGRADE-1, I am able to access the issue.

What am I missing here?

We are using version 6.2.6 of JIRA.

Thanks in advance!!

1 answer

1 accepted

0 vote

Arg. Never touch a Jira database when it's running. Generally, 99% of people who try it even when it's not running shouldn't have because they don't understand it well enough.

Try the following, and then consider restoring from the backup you should have taken before running the SQL.

1. Stop Jira

2. Check that the database really is still correct, the shutdown has not re-written bad data into your project table.

3. Restat Jira

4. Re-index it in full (the option to lock it and reindex from scratch)

Thanks Nic. Yep, it was silly of me. It sounds as if there is some caching going on here, even though the tables look the way they should?

Also, how does a full re-index differ from the background one?

Thirdly, I see that you can reindex just a project - should I give this a go instead of a full reindex? However, it doesn't state what state it will leave JIRA in, e.g. running or unavailable like a full reindex: https://confluence.atlassian.com/display/JIRA/Search+Indexing

Yes, there's a lot of caching, that's why you need to stop and start it.

A background re-index does not delete everything and start again, unlike the full one. A project index is similar to the background one - it might fix it all, but you really should be doing a complete one.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

232 views 1 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