Database update without stopping Jira services

Vijay Sv

Can we update customfield table "Stringvalue" column for one of the single list custom field which has LOV's without bring Jira services down.

If yes, please let me know the impact on Application

 

Note : I have done this in our test environment and i didnt notice any impact on the app, however i would like know suggestions/recommendations from experts here.

scenario:

i have a custom field called Dept. which has lov's 

engg

ops

tech

admin

which inturn will have stringvalues associated with these lov's and stores in Jira DB under customfield value table column "String value".

 

now i have to replace below 3 options

tech

ops

admin

with option "SA".

can i query for these 3 options indivually based on string values(option id) and update with "SA" in DB and re-index projects that are associated with this custom field?

 

Nic Brough -Adaptavist-

No, absolutely not.

JIRA caches all sorts of things, and you should never, never, never alter a JIRA database when it is running.  In general, you should not mess with the database even when it's not running, because it's not as simple as most  people think.

What you should do here is correct the values using a bulk edit.  If you insist on doing it with database changes (don't), then take JIRA down, take a full database backup, make the changes, restart it and run a *full* re-index (project indexing won't be enough for your changes)