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

Accepted Answer
0 votes

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
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

440 views 7 5
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