Duplicate kee values detected in projects table

SonarSource / mysql-migrator

Command line tool to migrate MySQL database of SonarQube 6.7-7.8 to non-MySQL

39 stars 11 forks source link

Duplicate kee values detected in projects table #57

Closed marceloavilaoliveira closed 4 years ago

marceloavilaoliveira commented 4 years ago

Hi,

I am trying to migrate our 6.7 SonarQube server from MySQL to PostgreSQL, in preparation to update to 7.9. I am running the DB converter tool (mysql-migrator) but it fails with the following error:

"Duplicate kee values detected in projects table. Please clean the table first. Aborting migration."

I was able to find 26 duplicated projects in the "projects" table. Can I just delete them in the database?

Thanks,

marceloavilaoliveira commented 4 years ago

I deleted the 26 duplicated projects from the MySQL database, re-executed the DB converter tool (mysql-migrator) and everything worked just fine this time.