Error when trying to add new option to "Select List (single choice)" custom field

[Rafael da Silva Rodrigues]

My customer is using JIRA Server 8.14 and I'm getting an error when trying to add new option to "Select List (single choice)" custom field. 

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldOption][customfieldconfig,11205][sequence,0][customfield,10903][parentoptionid,null][disabled,N][id,10618][value,Comercial] (SQL Exception while executing the following:INSERT INTO public.customfieldoption (ID, CUSTOMFIELD, CUSTOMFIELDCONFIG, PARENTOPTIONID, SEQUENCE, customvalue, optiontype, disabled) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_customfieldoption"
      Detail: Key (id)=(10618) already exists.))
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:299) [classes/:?]
	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:172) [classes/:?]
	at com.atlassian.jira.issue.customfields.manager.DefaultOptionsManager.createOptionInDb(DefaultOptionsManager.java:124) [classes/:?]
	at com.atlassian.jira.issue.customfields.manager.DefaultOptionsManager.createOption(DefaultOptionsManager.java:103) [classes/:?]
	at com.atlassian.jira.issue.customfields.manager.CachedOptionsManager.createOption(CachedOptionsManager.java:135) [classes/:?]
	at com.atlassian.jira.issue.customfields.option.OptionsImpl.addOption(OptionsImpl.java:95) [classes/:?]
	at com.atlassian.jira.web.action.admin.customfields.EditCustomFieldOptions.doAdd(EditCustomFieldOptions.java:171) [classes/:?]

On this link you can see the full log and a video of the error.

https://www.dropbox.com/sh/qass5oiscp86q4i/AABhH1SK-Xqh4do8mvggqYrVa?dl=0

[Mirek · Accepted solution]

Hi @Rafael da Silva Rodrigues 

You might want to check this page

https://codeclou.io/blog/2020/03/repair-broken-customfield-primary-key-sequence-in-jira-database-after-sql-inserts/

Maybe this would help with your problem also

[Rafael da Silva Rodrigues]

Thank you very much @Mirek , it must be this issue! I'll try to fix it following the guideline!

[Mirek]

Your welcome. Hope that you would be able to fix it :)

[Rafael da Silva Rodrigues]

It's worked for me @Mirek ! Thanks again!