Unable to strart SonarQube 7.7

SonarQube
1

Hello ,

I am not able to start SonarQube v7.7. getting the below error -

--> 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.

2020.12.21 17:25:38 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/brownfield_tools/sonarqube-7.7/sonarqube-7.7/temp
2020.12.21 17:25:38 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2020.12.21 17:25:38 INFO  app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/opt/brownfield_tools/sonarqube-7.7/sonarqube-7.7/elasticsearch]: /opt/brownfield_tools/sonarqube-7.7/sonarqube-7.7/elasticsearch/bin/elasticsearch
2020.12.21 17:25:38 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.
2020.12.21 17:25:39 INFO  app[][o.e.p.PluginsService] no modules loaded
2020.12.21 17:25:39 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.12.21 17:25:41 WARN  app[][o.s.a.p.AbstractProcessMonitor] Process exited with exit value [es]: 1
2020.12.21 17:25:41 INFO  app[][o.s.a.SchedulerImpl] Process [es] is stopped
2020.12.21 17:25:41 INFO  app[][o.s.a.SchedulerImpl] SonarQube is stopped
2020.12.21 17:25:41 INFO  app[][o.e.c.t.TransportClientNodesService] failed to get node info for {#transport#-1}{Z_gnlYmjSjumyAArYcAEbQ}{127.0.0.1}{127.0.0.1:9001}, disconnecting...
java.lang.IllegalStateException: Future got interrupted
        at org.elasticsearch.common.util.concurrent.FutureUtils.get(FutureUtils.java:60)
        at org.elasticsearch.action.support.AdapterActionFuture.actionGet(AdapterActionFuture.java:34)
        at org.elasticsearch.transport.ConnectionManager.internalOpenConnection(ConnectionManager.java:226)
        at org.elasticsearch.transport.ConnectionManager.openConnection(ConnectionManager.java:85)
        at org.elasticsearch.transport.TransportService.openConnection(TransportService.java:367)
        at org.elasticsearch.client.transport.TransportClientNodesService$SimpleNodeSampler.doSample(TransportClientNodesService.java:410)
        at org.elasticsearch.client.transport.TransportClientNodesService$NodeSampler.sample(TransportClientNodesService.java:361)
        at org.elasticsearch.client.transport.TransportClientNodesService.addTransportAddresses(TransportClientNodesService.java:202)
        at org.elasticsearch.client.transport.TransportClient.addTransportAddress(TransportClient.java:342)
        at org.sonar.application.es.EsConnectorImpl$MinimalTransportClient.<init>(EsConnectorImpl.java:108)
        at org.sonar.application.es.EsConnectorImpl.buildTransportClient(EsConnectorImpl.java:89)
        at org.sonar.application.es.EsConnectorImpl.getTransportClient(EsConnectorImpl.java:74)
        at org.sonar.application.es.EsConnectorImpl.getClusterHealthStatus(EsConnectorImpl.java:61)
        at org.sonar.application.process.EsProcessMonitor.checkStatus(EsProcessMonitor.java:90)
        at org.sonar.application.process.EsProcessMonitor.checkOperational(EsProcessMonitor.java:75)
        at org.sonar.application.process.EsProcessMonitor.isOperational(EsProcessMonitor.java:60)
        at org.sonar.application.process.SQProcess.refreshState(SQProcess.java:161)
        at org.sonar.application.process.SQProcess$EventWatcher.run(SQProcess.java:220)
Caused by: java.lang.InterruptedException: null
        at java.base/java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(AbstractQueuedSynchronizer.java:1343)
        at org.elasticsearch.common.util.concurrent.BaseFuture$Sync.get(BaseFuture.java:251)
        at org.elasticsearch.common.util.concurrent.BaseFuture.get(BaseFuture.java:94)
        at org.elasticsearch.common.util.concurrent.FutureUtils.get(FutureUtils.java:57)
        ... 17 common frames omitted
<-- Wrapper Stopped
--> 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.

2020.12.23 16:56:24 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/brownfield_tools/sonarqube-7.7/sonarqube-7.7/temp
2020.12.23 16:56:24 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2020.12.23 16:56:24 INFO  app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/opt/brownfield_tools/sonarqube-7.7/sonarqube-7.7/elasticsearch]: /opt/brownfield_tools/sonarqube-7.7/sonarqube-7.7/elasticsearch/bin/elasticsearch
2020.12.23 16:56:24 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.
2020.12.23 16:56:25 INFO  app[][o.e.p.PluginsService] no modules loaded
2020.12.23 16:56:25 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.12.23 16:56:28 WARN  app[][o.s.a.p.AbstractProcessMonitor] Process exited with exit value [es]: 1
2020.12.23 16:56:28 INFO  app[][o.e.c.t.TransportClientNodesService] failed to get node info for {#transport#-1}{idogTdnNQTO9xkbVKi656Q}{127.0.0.1}{127.0.0.1:9001}, disconnecting...
java.lang.IllegalStateException: Future got interrupted
        at org.elasticsearch.common.util.concurrent.FutureUtils.get(FutureUtils.java:60)
        at org.elasticsearch.action.support.AdapterActionFuture.actionGet(AdapterActionFuture.java:34)
        at org.elasticsearch.transport.ConnectionManager.internalOpenConnection(ConnectionManager.java:226)
        at org.elasticsearch.transport.ConnectionManager.openConnection(ConnectionManager.java:85)
        at org.elasticsearch.transport.TransportService.openConnection(TransportService.java:367)
        at org.elasticsearch.client.transport.TransportClientNodesService$SimpleNodeSampler.doSample(TransportClientNodesService.java:410)
        at org.elasticsearch.client.transport.TransportClientNodesService$NodeSampler.sample(TransportClientNodesService.java:361)
        at org.elasticsearch.client.transport.TransportClientNodesService.addTransportAddresses(TransportClientNodesService.java:202)
        at org.elasticsearch.client.transport.TransportClient.addTransportAddress(TransportClient.java:342)
        at org.sonar.application.es.EsConnectorImpl$MinimalTransportClient.<init>(EsConnectorImpl.java:108)
        at org.sonar.application.es.EsConnectorImpl.buildTransportClient(EsConnectorImpl.java:89)
        at org.sonar.application.es.EsConnectorImpl.getTransportClient(EsConnectorImpl.java:74)
        at org.sonar.application.es.EsConnectorImpl.getClusterHealthStatus(EsConnectorImpl.java:61)
        at org.sonar.application.process.EsProcessMonitor.checkStatus(EsProcessMonitor.java:90)
        at org.sonar.application.process.EsProcessMonitor.checkOperational(EsProcessMonitor.java:75)
        at org.sonar.application.process.EsProcessMonitor.isOperational(EsProcessMonitor.java:60)
        at org.sonar.application.process.SQProcess.refreshState(SQProcess.java:161)
        at org.sonar.application.process.SQProcess$EventWatcher.run(SQProcess.java:220)```
2

Hi, SonarQube 7.7 is not supported anymore. You should upgrade to the latest LTS (7.9.5) or to the latest release (8.6).

4

Thanks Pierre. Currently we have sonarque v7.7 running on MySQL server. If we are looking for any upgrade like v7.9 or 8.6 , need to migrate our data from MySQL to SQL . Could you please suggest me any tools that can we use to migrate our data from MySQL to SQL server.

5

Sure, I suggest you use the SonarSource tool mysql-migrator.

Let us know if you have any issue with this tool.

6

Thanks Pierre. I will back to you with the results.

7

Hello Pierre,

Hope you are doing well. While using the mysql-Migrator command I am getting the below error –

[esbuser@vhlgnsqas001 bin]$ ./mysql-migrator -source /opt/sonarqube-7.7/sonarqube-7.7/conf/sonar.properties -target /opt/brownfield_tools/sonarqube-7.7/sonarqube-7.7/conf/sonar.properties

Jan 19, 2021 6:49:59 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI

WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path

This driver is not configured for integrated authentication. ClientConnectionId:eb5d3989-fe07-4939-89bf-b9bc42f6706e

8

It looks like you have an issue with the authentication on your target database. Double-check your configuration, or try to use your own version of the jdbc MsSQL driver (the embedded version is 6.2.2.jre8).

Are you using a Windows host to run mysql-migrator? If yes, there are resource online that suggests to add the jdbc connector to the JDK directly

9

I am using Linux one. Now I am getting below error while running migration –

Could not determine SonarQube version of the target database. Could not select version from schema_migrations. Invalid object name ‘schema_migrations’.

10

Did you perform step 2 of mysql-migrator readme?

11

Yes Pierre. I performed all those steps.

12

Could you please show us what your target database schema looks like?

13

Hello Pierre,

Here are the details-

The code that was generated is over 9K lines. Here is the code that was generated and the migration results for schema_migrations

CREATE TABLE

dbo.schema_migrations

(

/*

  • SSMA warning messages:

  • M2SS0183: The following SQL clause was ignored during conversion: COLLATE utf8_bin.

*/

version nvarchar(255) NOT NULL

)

WITH (DATA_COMPRESSION = NONE)