During import of data into JIRA get Duplicate entry '10000' for key 'PRIMARY'

When I import the exported data from another JIRA system I get this error.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '10000' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

I ran the integrity check on the original system and it did seem to find and fix errors around this duplicate entry '10000' problem.  I re exported the backup, and tried re importing it but get the same error.  The integrity check comes back clean on the original server now.

Original server is 

  • v7.3.0#73011-sha1:3c73d0e

New server is most current version downloaded 11/13/17.

 

2 answers

0 vote
Lenard Lee Atlassian Team Nov 15, 2017

Hello Clint,

You could be hitting into the problem described here in this KB. Could you confirm by running the diagnosis, and then performing the suggested resolution.

As a precaution, I would recommend backing up your database prior to performing any update query on the database.

Regards,
Lenard

That article gave me some insight, but I was not able to get the queries right.

 

I went into the database Feature table and there was one entry with 10000, so I changed the ID to 99999 in the DB, then re-exported, and then I was able to get the import process to work on the new server. The instance seems to be working well so far.

Did you adjust the sequence table as well?

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

12,749 views 15 13
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you