Duplicated entry – unique constraint violated in JIRA making you frustrated?

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped a customer with duplicated entry – unique constraint violated in JIRA

How to resolve: Duplicated entry – unique constraint violated in JIRA

We usually come across the unique constraint violated error in JIRA due to an interrupted or incomplete update attempt. It usually results in a mismatch in the id counts.

There are two ways to resolve this specific issue. According to our Support Techs, we have to choose a method depending on the output value of the following commands where entityname indicates the problematic entity and tablename is its corresponding table:

SELECT * FROM sequence_value_item WHERE seq_name = 'entityname';
SELECT max(id) FROM tablename;

If we wind up with a larger value for the second query than the first one, we will proceed with Solution 1, else we have to refer to Solution 2.

Solution 1: Unique constraint violated in JIRA

1. First, we have to shut down the JIRA application.
2. Next, we will run this query in the database:

   UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM <TableName>) WHERE seq_name = '<EntityName>';
3. After that, we will restart the JIRA application.

Solution 2: Unique constraint violated in JIRA

If we get a higher sequence value than the table’s maximum ID value, our Support Team recommends restarting JIRA.

This will push JIRA to generate the next ID number internally, as an alternative to referring to the database. Furthermore, if the in-memory value does not match with what is present in the database, the database insertions are likely to fail.

By restarting JIRA we are prompting JIRA to re-read the database, thereby having the correct IDs to generate.

[In search of a solution for another query? We are just a click away.]

Conclusion

To conclude, the skilled Support Engineers at Bobcares demonstrated how to go deal with unique constraint violated errors in JIRA.