Upgrade from 7.7 > 7.9.6 LTS Failed -

SonarQube Server / Community Build
1

I tried to update my version from 7.7. to 8.9, so I first update to 7.9.6 LTS but the webapp stopped while I am trying to go on \setup
I’m on linux server with mssql database.

Here are the logs:
Sonar.log

--> Wrapper Started as Daemon
Launching a JVM...
Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
  Copyright 1999-2006 Tanuki Software, Inc.  All Rights Reserved.

2021.12.03 19:18:46 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube-7.9.6/temp
2021.12.03 19:18:46 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2021.12.03 19:18:46 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube-7.9.6/elasticsearch]: /opt/sonarqube-7.9.6/elasticsearch/bin/elasticsearch
2021.12.03 19:18:46 INFO  app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
2021.12.03 19:18:46 INFO  app[][o.e.p.PluginsService] no modules loaded
2021.12.03 19:18:46 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2021.12.03 19:18:53 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
2021.12.03 19:18:54 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonarqube-7.9.6]: /usr/lib/jvm/java-11-openjdk-amd64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube-7.9.6/temp --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*:/opt/sonarqube-7.9.6/lib/jdbc/mssql/mssql-jdbc-6.2.2.jre8.jar org.sonar.server.app.WebServer /opt/sonarqube-7.9.6/temp/sq-process7589762191280834022properties
2021.12.03 19:18:57 WARN  app[][startup] ################################################################################
2021.12.03 19:18:57 WARN  app[][startup] The database must be manually upgraded. Please backup the database and browse /setup. For more information: https://docs.sonarqube.org/latest/setup/upgrading
2021.12.03 19:18:57 WARN  app[][startup] ################################################################################
2021.12.03 19:18:57 INFO  app[][o.s.a.SchedulerImpl] Process[web] is stopped
2021.12.03 19:18:57 WARN  app[][o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
2021.12.03 19:18:57 INFO  app[][o.s.a.SchedulerImpl] Process[es] is stopped
2021.12.03 19:18:57 INFO  app[][o.s.a.SchedulerImpl] SonarQube is stopped
<-- Wrapper Stopped

web.log

2021.12.03 19:18:54 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2021.12.03 19:18:54 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2021.12.03 19:18:55 INFO  web[][o.e.p.PluginsService] no modules loaded
2021.12.03 19:18:55 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2021.12.03 19:18:55 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2021.12.03 19:18:55 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2021.12.03 19:18:56 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2021.12.03 19:18:56 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.9.6.41879 / 38d385dda4435530bb4fdf77e0d28e31c401a976
2021.12.03 19:18:56 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://v5sqlrd.legisway.com;databaseName=sonar
2021.12.03 19:18:56 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube-7.9.6
2021.12.03 19:18:56 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2021.12.03 19:18:57 WARN  web[][o.s.s.p.DatabaseServerCompatibility] The database must be manually upgraded. Please backup the database and browse /setup. For more information: https://docs.sonarqube.org/latest/setup/upgrading
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Git / 1.12.1.2064 / ed18ad2f7cbad8b77048b4b129ddded3d6b70393
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin GitHub Authentication for SonarQube / 1.5.0.870 / 153f7c7af7a264adb0fcbe5fee87bdd140a6a3a1
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin JaCoCo / 1.0.2.475 / b79a4724f3a9af1051266b4f8ca0460977295ead
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin LDAP / 2.2.0.608 / 79dc3fa4393a29667673c70182f3016288b548b7
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SAML 2.0 Authentication for SonarQube / 1.2.0.682 / 44d64e660a3c7f235962a7bcfef78bf8c87db98a
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarCSS / 1.1.1.1010 / 365e21fd0cb9035669fc59f6fec7c8fd28a7303b
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarFlex / 2.5.1.1831 / a0c44437f6abb0feec76edd073f91fec64db2a6c
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarGo / 1.1.1.2000 / 40d55921c7a63b67386a053490d17b6723a46cd5
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarHTML / 3.1.0.1615 / 4181edb5eff5605bec82dc0aa15ecd70eaa5857f
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJS / 5.2.1.7778 / 49f34eaeaad59868d4353d89b1fc5c02bbe51976
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJava / 5.13.1.18282 / 568f8ed2349f48e250a9329895b9a870100dfbeb
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarKotlin / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarScala / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarTS / 1.9.0.3766 / 4a4080b78001a78d758d1d0fa0190fb9496b6f57
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarXML / 2.0.1.2020 / c5b84004face582d56f110e24c29bf9c6a679e69
2021.12.03 19:18:57 INFO  web[][o.s.s.p.ServerPluginRepository] Deploy plugin Svn / 1.9.0.1295 / 942e075773975354e32691a60bfd968065703e04
2021.12.03 19:18:57 INFO  web[][o.s.s.p.d.m.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive
2021.12.03 19:18:57 INFO  web[][o.s.s.p.Platform] Database needs to be migrated. Please refer to https://docs.sonarqube.org/latest/setup/upgrading
2021.12.03 19:18:57 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceFilter@65deb90 [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/properties*, ...]}]
2021.12.03 19:18:57 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2021.12.03 19:18:57 INFO  web[][o.s.p.ProcessEntryPoint] Hard stopping process

es.log

2021.12.03 19:18:48 INFO  es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/ (/dev/mapper/srv--rd--sonar2--vg-root)]], net usable_space [40.9gb], net total_space [46.7gb], types [ext4]
2021.12.03 19:18:48 INFO  es[][o.e.e.NodeEnvironment] heap size [494.9mb], compressed ordinary object pointers [true]
2021.12.03 19:18:48 INFO  es[][o.e.n.Node] node name [sonarqube], node ID [QKqr9IpaQGmMjioHgNVi2g]
2021.12.03 19:18:48 INFO  es[][o.e.n.Node] version[6.8.0], pid[28630], build[default/tar/65b6179/2019-05-15T20:06:13.172855Z], OS[Linux/4.9.0-7-amd64/amd64], JVM[Debian/OpenJDK 64-Bit Server VM/11.0.6/11.0.6+10-post-Debian-1bpo91]
2021.12.03 19:18:48 INFO  es[][o.e.n.Node] JVM arguments [-XX:+UseConcMarkSweepGC, -XX:CMSInitiatingOccupancyFraction=75, -XX:+UseCMSInitiatingOccupancyOnly, -Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Djava.io.tmpdir=/opt/sonarqube-7.9.6/temp, -XX:ErrorFile=../logs/es_hs_err_pid%p.log, -Des.enforce.bootstrap.checks=true, -Xms512m, -Xmx512m, -XX:+HeapDumpOnOutOfMemoryError, -Des.path.home=/opt/sonarqube-7.9.6/elasticsearch, -Des.path.conf=/opt/sonarqube-7.9.6/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [analysis-common]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [lang-painless]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [mapper-extras]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [parent-join]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [percolator]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [reindex]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [repository-url]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] loaded module [transport-netty4]
2021.12.03 19:18:48 INFO  es[][o.e.p.PluginsService] no plugins loaded
2021.12.03 19:18:49 WARN  es[][o.e.d.c.s.Settings] [http.enabled] setting was deprecated in Elasticsearch and will be removed in a future release! See the breaking changes documentation for the next major version.
2021.12.03 19:18:50 INFO  es[][o.e.d.DiscoveryModule] using discovery type [zen] and host providers [settings]
2021.12.03 19:18:50 INFO  es[][o.e.n.Node] initialized
2021.12.03 19:18:50 INFO  es[][o.e.n.Node] starting ...
2021.12.03 19:18:50 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2021.12.03 19:18:50 INFO  es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2021.12.03 19:18:53 INFO  es[][o.e.c.s.MasterService] zen-disco-elected-as-master ([0] nodes joined), reason: new_master {sonarqube}{QKqr9IpaQGmMjioHgNVi2g}{I9RYkENWRLeq_93V1X7LzQ}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}
2021.12.03 19:18:53 INFO  es[][o.e.c.s.ClusterApplierService] new_master {sonarqube}{QKqr9IpaQGmMjioHgNVi2g}{I9RYkENWRLeq_93V1X7LzQ}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}, reason: apply cluster state (from master [master {sonarqube}{QKqr9IpaQGmMjioHgNVi2g}{I9RYkENWRLeq_93V1X7LzQ}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube} committed version [1] source [zen-disco-elected-as-master ([0] nodes joined)]])
2021.12.03 19:18:53 INFO  es[][o.e.n.Node] started
2021.12.03 19:18:53 INFO  es[][o.e.g.GatewayService] recovered [0] indices into cluster_state
2021.12.03 19:18:57 INFO  es[][o.e.n.Node] stopping ...
2021.12.03 19:18:57 INFO  es[][o.e.n.Node] stopped
2021.12.03 19:18:57 INFO  es[][o.e.n.Node] closing ...
2021.12.03 19:18:57 INFO  es[][o.e.n.Node] closed
2

Hi,

Welcome to the community!

The answer is there in web.log:

 
HTH,
Ann

3

Hi @ganncamp ,

We are on Microsoft SQL Server.
I’m upgrading from the ZipFile.
But when we start the server. we are stuck on step 5. Start your new SonarQube Server
We can’t upgrade by going to /setup cause the server stopped while starting.
The following step : 6. Browse to http://yourSonarQubeServerURL/setup and follow the setup instruction cannot be achieved. :frowning:
In the instructions on the upgrade page, there is no further information or advice for MSSQL.
Did I miss something?

Thanks and Regards,

Benoît

4

Hi Benoit,

(Sorry about the missing accent; AmE keyboard :flushed: )

You’re right. I overlooked that.

So first, there’s another log in that directory. Anything interesting in it?

 
Ann

5

Hi @ganncamp ,
There is only an access.log file. which is empty.

Regards,
Benoît

6

Hi Benoit,

There’s no ce.log?

 
Ann

7

Hi,
No, only sonar.log, es.log, web.log and access.log.
Regards,
Benoît

8

Hi Benoit,

This is odd. Can you double-check the ownership of $SONARQUBE-HOME and its subdirectories? Is it possible that SonarQube isn’t able to write that log file?

 
Ann

9

Hi Ann,

Yesterday, I double check each directory and found nothing.
Today, I have download a fresh version of the sonar 7.9.6 and retry from the beginning and it is working.
I don’t know what was missing but this time the update can go further.
I wil continue to update to next LTS version ( 8.9.3).

Thanks for your advice.

Benoît

10

Everything was fine for update to 8.9.3.
I’m now in last LTS version. :blush:

Thanks @ganncamp for the quick reply.

1 Like
11

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