Getting error while upgrading version from 9.1 to 9.9.1

Make sure to tell us:

  • What version are you upgrading from?
  • 9.1.1 to 9.9.1
  • System information (Operating system, Java version, Database provider/version)
    Amazon linux 2, Java-17, Postgres 13
  • What’s the issue you’re facing?
Issue - 2023.05.11 09:55:15 ERROR web[][o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
### Error querying database.  Cause: java.lang.NullPointerException: projectUuid can't be null
### The error may exist in org.sonar.db.component.ComponentMapper
### The error may involve org.sonar.db.component.ComponentMapper.scrollForIndexing
### The error occurred while handling results
### SQL: select             p.uuid as uuid,     p.uuid_path as uuidPath,     p.branch_uuid as branchUuid,     p.module_uuid as moduleUuid,     p.module_uuid_path as moduleUuidPat
h,     p.main_branch_project_uuid as mainBranchProjectUuid,     p.kee as kee, as name,     p.long_name as longName,     p.description as description,     p.qualifier a
s qualifier,     p.scope as scope,     p.language as language,     p.root_uuid as rootUuid,     p.path as path,     p.enabled as enabled,     p.copy_component_uuid as copyCompone
ntUuid,     p.private as isPrivate,     p.created_at as createdAt         from components p     where       p.enabled=true       and p.copy_component_uuid is null       and p.mai
n_branch_project_uuid is null       and p.scope = 'PRJ'       and p.qualifier in ('TRK','VW','SVW','APP')
### Cause: java.lang.NullPointerException: projectUuid can't be null
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(]

Hey there.

Can you confirm if you’re experiencing this issue when you try to upgrade (during the database migration), or it’s something that happens after the migration has completed and SonarQube tries to start up?