Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Insight DB reset key index

Gleb Kartashov
Contributor
July 2, 2020

Hi. I'm getting SQL error when creating Insight - related entities in Jira.

Error reads "Duplicate unique key AO_8542F1_IFJ_OBJ_TYPE_pkey"

Occurring scenarios:

  • Creating Insight Object/s CF
  • Creating Insight Referenced Object/s CF
  • Creating Insight Object Type

When creating Insight object type "Create" button result in this error, but when clicked a couple more times Object type was successfully created (found non-duplicate key).

How do I set index (counter) value as last free index?

Jira DB was restored from DB backup

DB version is Postgresql 11.8

Insight version is 8.3.2

JSD version is 4.7.1

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events