Is it mandatory to shutdown JIRA while doing a simple backend change on customfieldvalue table?

Srinivas Patruni February 4, 2014

Will there be any effect if we update custom field value while the server is up and running?

1 answer

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 4, 2014

There is a good chance that the value will not persist, searches may fail, and in the worst case, you could lose data from other custom field values or other custom fields on the issue. The issue you've amended will behave inconsistently until the index is updated.

Do NOT change data in a Jira database while it is running. Shut it down. Perform the SQL. Restart it and re-index. Make sure you take a full backup before you do this, and prove it can be restored before proceeding.

Srinivas Patruni February 4, 2014

Thank you for your suggestion Nic.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 4, 2014

More of a warning than a suggestion!

Far better to do it with the API somehow (Jelly, REST, CLI, Plugin, etc)

Suggest an answer

Log in or Sign up to answer