Jira database modification while Jira is running

Hi.

We have an issue in our Jira instance which has been closed but the resolution has not been set, and our workflow does not allow us to reopen that issue.

So is there any possible issues which could occur while updating the resolution directly in the database WHILE Jira is running?

I have tested this several times in a test environment, and the resolution is successfully updated (but not the search index). And when I performed a reindex, the searching was also updated with the new resolution.

Thanks

Øivind Boge

2 answers

1 accepted

This widget could not be displayed.

>So is there any possible issues which could occur while updating the resolution directly in the database WHILE Jira is running?

You could destroy a chunk of the project. I've only seen it happen a couple of times, but direct modification of the issue table while Jira is running can lead to a LOT of serious damage (although I'd expect resolution to be moderately safe, I've seen catastrophic loss caused by updating other fields I'd have said were moderately safe as well)

Stop your Jira before using SQL to amend stuff!

This widget could not be displayed.

I would advice against making manual changes in your DB for such a reason. Instead, create a transition in the relevant workflow, from the current status of the issue, TO the current status of the issue. As a postfunction in that transition, set the resolution field value to whichever value you want it to have. Now, navigate to the issue, perform the transition you have just added, and your resolution will have changed. Regarding the editing of closed issues in general, please have a look at this product documentation.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

41 views 0 1
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