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

1 vote

>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!

1 vote

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
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...

187 views 1 17
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