SonarQube server does not load html pages correctly after updating 10.1 -> 10.4.1

  • which versions are you using- SonarQube 10.4.1
  • how is SonarQube deployed: Docker via AWS ECS
  • what are you trying to achieve: I’m wondering what might cause weird sonar server page loading behavior after an upgrade. I just upgraded from 10.1 → 10.4.1 (10.1 worked fine / 10.4.1 does not load pages correctly after the upgrade)
  • what have you tried so far to achieve this: created a new ECS task revision replacing the docker image with sonarqube:10.4.1-developer, and updated the deployment, then after the new task was online clicked the upgrade button at the sonar server setup endpoint. I’ve waited about 25 minutes since the DB upgrade and pages on the sonarqube server still don’t load correctly. See screenshot.
    I have also downloaded and checked the logs on the sonar server and I don’t see any recent errors.

snippet from sonarqube_web.log:

2024.03.22 19:31:16 INFO  web[][o.s.s.p.d.m.DatabaseMigrationImpl] Starting DB Migration and container restart
2024.03.22 19:31:17 INFO  web[][DbMigrations] Executing DB migrations...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102000 'Rename 'component_uuid' in 'user_roles' table to 'entity_uuid''...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102000 'Rename 'component_uuid' in 'user_roles' table to 'entity_uuid'': success | time=57ms
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102001 'Rename 'component_uuid' in 'group_roles' table to 'entity_uuid''...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102001 'Rename 'component_uuid' in 'group_roles' table to 'entity_uuid'': success | time=21ms
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102002 'Drop index 'group_roles_component_uuid' in 'group_roles''...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102002 'Drop index 'group_roles_component_uuid' in 'group_roles'': success | time=32ms
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102003 'Create index 'entity_uuid_user_roles' in 'group_roles' table'...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102003 'Create index 'entity_uuid_user_roles' in 'group_roles' table': success | time=27ms
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102004 'Drop index 'user_roles_component_uuid' in 'user_roles' table'...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102004 'Drop index 'user_roles_component_uuid' in 'user_roles' table': success | time=9ms
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102005 'Create index 'user_roles_entity_uuid' in 'user_roles''...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102005 'Create index 'user_roles_entity_uuid' in 'user_roles'': success | time=16ms
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102006 'Drop index 'ce_activity_component' in 'ce_activity''...
2024.03.22 19:31:17 INFO  web[][DbMigrations] #102006 'Drop index 'ce_activity_component' in 'ce_activity'': success | time=10ms

snippet from sonarqube_app.log

2024.03.22 19:05:52 WARN  app[][startup] ################################################################################
2024.03.22 19:05:52 WARN  app[][startup] The database must be manually upgraded. Please backup the database and browse /setup. For more information: https://docs.sonarsource.com/sonarqube/latest/setup/upgrading
2024.03.22 19:05:52 WARN  app[][startup] ################################################################################
2024.03.22 19:32:56 INFO  app[][o.s.a.SchedulerImpl] Process[web] is up
2024.03.22 19:32:56 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[COMPUTE_ENGINE] from [/opt/sonarqube]: /opt/java/openjdk/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/temp -XX:-OmitStackTraceInFastThrow --add-opens=java.base/java.util=ALL-UNNAMED --add-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.management/sun.management=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED -Dcom.redhat.fips=false -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-10.4.1.88267.jar:/opt/sonarqube/lib/jdbc/postgresql/postgresql-42.6.0.jar org.sonar.ce.app.CeServer /opt/sonarqube/temp/sq-process2395016658587492397properties
2024.03.22 19:33:04 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is up
2024.03.22 19:33:04 INFO  app[][o.s.a.SchedulerImpl] SonarQube is operational

I tried manually restarting the instance by stopping and restarting the task in AWS ECS. This seems to have solved the problem. The pages requested from the sonar server display normally now.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.