Jira database modification while Jira is running

Øivind Boge

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

Nic Brough -Adaptavist-

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