Where does issue keys live in JIRA

Hi,

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

84 views 0 5
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