Make sure to tell us:
- What version are you upgrading from?
sonarqube 9.2.4 → 9.9(LTS)
- System information (Operating system, Java version, Database provider/version)
OS: centos 7.9
Java: jdk 17
DB: postgres 12
- What’s the issue you’re facing?
failed on migration step #6407
Fail to execute CREATE UNIQUE INDEX uniq_rule_desc_sections_kee ON rule_desc_sections (rule_uuid, kee)
ERROR: could not create unique index “uniq_rule_desc_sections_kee” key(rule_uuid, kee)=(6645, how_to_fix) is duplicated.
The same error occurs when you enter the postgresql console and type the command.
so, I entered the following command
sonaruqbe=# select rule_uuid, kee from rule_desc_sections GROUP BY rule_uuid, kee HAVING COUNT(*) > 1;