Upgrade from 7.9.6 LTS to 8.9.0 LTS failed

SonarQube
,
4

Hi @App-Infra-LHT ,

You seem to be experiencing the same issue as this user here: SonarQube Update 8.4 failed PERM_TEMPLATES_GROUPS

The approach to resolution would be similar, with an extra step:

  • run the database migration until it fails at step 3492
  • Manually delete the 'ID' is not null constraint
  • Manually delete the index in the ID column
  • Manually delete the existing perm_templates_groups_id_trg trigger
  • Execute this insert query insert into schema_migrations (version) values ('3492')
  • Resume the migration (restart SonarQube)

The migration should continue with the next steps.

2 Likes