How to start PLSQL analysis initiated by Jenkins

Hi!

Currenlty I am evaluating sonarqube-8.2 developer edition (Docker), because we are curious about the abilities of the PLSQL plugin. I got a developer edition licence from the support and applied the licence after successfull sonarqube installation.

I would like to initiate the analysis from Jenkins with this command from Jenkins pipeline: mvn sonar:sonar -Dsonar.login=xyz -Dsonar.password=xyz -Dsonar.host.url=http://localhost:9000 -Dsonar.sources=."

The analysis is executed successfully but there is no lines of code in sonarqube.

  1. Should I manually enable the PLSQL plugin, because in SonarQube/marketplace/installed plugins not shows it.

  2. In project/Quality Profiles/Actiate more rules menu there is no plsql related rule. Why?

  3. The plsql code is in our git repository, should I use any other configuration parameter for the successfull analysis?

thanks

Hello,

The first problem that you be resolved is why you don’t see in the Marketplace > Installed the “SonarPL/SQL” analyzer. It is provided out of the box with SQ Developer Edition, so there is no reason to have to install something. Even without the license set you should see that:

Is that the case?

Alex

Hi!
This is that I see.

licence is installed as you can see:

Do you see that when you go on the Rules page?

No, it displays: “0 shown”

Hello,

I believe it would be great to describe the steps you followed to have your SQ DE (Docker) running. Maybe you downloaded the wrong image, I don’t know.

Also you should know that providing official docker images for Editions is new to us (we just did it from the v8.2) so maybe we did a mistake somewhere or you are facing a corner case. The more context you give us, easier it is to help.

If having a docker version of SonarQube is not a big requirement for today and your main focus for the moment is to evaluate PLSQL scanning, I would like to suggest to step back and run the standalone version:

Regards

Hello! I have a docker-compose file contained this. SonarQube started successfully then I typed the given licence key. That’s all I did.

sonarqube-postgres-dev:
  image: postgres:11.6
  container_name: sonarqube-postgres-dev
  hostname: sonarqube-postgres-dev
  volumes:
   - /opt/tcd/workspace/sonarqube-postgres-dev:/var/lib/postgresql/data
  networks:
   - ci-network
  environment:
   - POSTGRES_DB=sonarqubedb
   - POSTGRES_USER=myuser
   - POSTGRES_PASSWORD=mypassword



 sonarqube:
  image: sonarqube:8-developer
  container_name: sonarqube
  hostname: sonarqube
  networks:
   - ci-network
  environment:
   - sonar.jdbc.username=myuser
   - sonar.jdbc.password=mypassword
   - sonar.jdbc.url=jdbc:postgresql://sonarqube-postgres-dev/sonarqubedb
  volumes:
   - /opt/tcd/workspace/sonarqube-dev:/opt/sonarqube
  depends_on:
   - sonarqube-postgres-dev

Hello! It appears you’ve attempted to define a single volume for all of /opt/sonarqube, rather than following our instructions showing separate volumes for data, extensions, and logs.

I have a local docker-compose setup working, and within my relevant sections look like this:

sq-8-ee:
image: sonarqube:8-enterprise
ports:
- 9082:9000
depends_on:
- db
environment:
SONAR_JDBC_USERNAME: XXXXX
SONAR_JDBC_PASSWORD: XXXXX
SONAR_JDBC_URL: jdbc:postgresql://db:5432/sonar8
volumes:
- sq8_extensions:/opt/sonarqube/extensions
- sq8_logs:/opt/sonarqube/logs
- sq8_data:/opt/sonarqube/data

And then the volumes:

volumes:
sq8_extensions:
external: true
sq8_data:
external: true
sq8_logs:
external: true

Can you redefine the volumes in your docker-compose file and try again? You should then see a positive number of rules for all languages as mentioned by @Alexandre_Gigleux above, and this is a good check to validate prior to even trying analysis. Of course, then once you validate you have rules you can then try your analysis again.

1 Like

Hi! Same result with tehese parameter, so it not works

 volumes:
   - /opt/tcd/workspace/sonarqube-dev/temp:/opt/sonarqube/temp
   - /opt/tcd/workspace/sonarqube-dev/data:/opt/sonarqube/data
   - /opt/tcd/workspace/sonarqube-dev/logs:/opt/sonarqube/logs
   - /opt/tcd/workspace/sonarqube-dev/extensions:/opt/sonarqube/extensions

Before thinking about using a docker-compose setup, did you try this simple command?

docker run -d --name sonarqube -p 9000:9000 sonarqube:8.2-developer

I’ll reach out via private message so you can share your logs.

Hi! I reinstall sonarqube-developer edition again with the same licence. The problem is the same. These are the logs:

ce.log:

        2020.03.27 06:00:07 INFO  ce[][o.s.p.ProcessEntryPoint] Starting ce
        2020.03.27 06:00:07 INFO  ce[][o.s.ce.app.CeServer] Compute Engine starting up...
        2020.03.27 06:00:08 INFO  ce[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: developer-edition, developer-scanner, developer-server, license
        2020.03.27 06:00:09 INFO  ce[][o.e.p.PluginsService] no modules loaded
        2020.03.27 06:00:09 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
        2020.03.27 06:00:09 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
        2020.03.27 06:00:09 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
        2020.03.27 06:00:13 INFO  ce[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
        2020.03.27 06:00:13 INFO  ce[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://sonarqube-postgres-dev/sonarqubedb
        2020.03.27 06:00:16 INFO  ce[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
        2020.03.27 06:00:16 INFO  ce[][o.s.c.c.CePluginRepository] Load plugins
        2020.03.27 06:00:18 INFO  ce[][o.s.c.c.ComputeEngineContainerImpl] Running Developer edition
        2020.03.27 06:00:18 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is operational
        2020.03.27 06:00:53 INFO  ce[][o.s.p.ProcessEntryPoint] Gracefully stopping process
        2020.03.27 06:00:53 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is stopping...
        2020.03.27 06:00:53 INFO  ce[][o.s.c.t.CeProcessingSchedulerImpl] Gracefully stopping workers...
        2020.03.27 06:00:54 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is stopped
        2020.03.27 06:01:49 INFO  ce[][o.s.p.ProcessEntryPoint] Starting ce
        2020.03.27 06:01:49 INFO  ce[][o.s.ce.app.CeServer] Compute Engine starting up...
        2020.03.27 06:01:50 INFO  ce[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: developer-edition, developer-scanner, developer-server, license
        2020.03.27 06:01:51 INFO  ce[][o.e.p.PluginsService] no modules loaded
        2020.03.27 06:01:51 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
        2020.03.27 06:01:51 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
        2020.03.27 06:01:51 INFO  ce[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
        2020.03.27 06:01:54 INFO  ce[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
        2020.03.27 06:01:54 INFO  ce[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://sonarqube-postgres-dev/sonarqubedb
        2020.03.27 06:01:57 INFO  ce[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
        2020.03.27 06:01:57 INFO  ce[][o.s.c.c.CePluginRepository] Load plugins
        2020.03.27 06:01:59 INFO  ce[][o.s.c.c.ComputeEngineContainerImpl] Running Developer edition
        2020.03.27 06:01:59 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is operational

es.log:

    2020.03.27 05:59:22 INFO  es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/opt/sonarqube/data (/dev/sda2)]], net usable_space [312.3gb], net total_space [392.6gb], types [ext4]
    2020.03.27 05:59:22 INFO  es[][o.e.e.NodeEnvironment] heap size [494.9mb], compressed ordinary object pointers [true]
    2020.03.27 05:59:22 INFO  es[][o.e.n.Node] node name [sonarqube], node ID [rQiSeaRdTESDaAuHvLffpA]
    2020.03.27 05:59:22 INFO  es[][o.e.n.Node] version[6.8.4], pid[26], build[default/tar/bca0c8d/2019-10-16T06:19:49.319352Z], OS[Linux/3.10.0-1062.4.3.el7.x86_64/amd64], JVM[Oracle Corporation/OpenJDK 64-Bit Server VM/11.0.6/11.0.6+10]
    2020.03.27 05:59:22 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/temp, -XX:ErrorFile=../logs/es_hs_err_pid%p.log, -Des.enforce.bootstrap.checks=true, -Xmx512m, -Xms512m, -XX:+HeapDumpOnOutOfMemoryError, -Des.path.home=/opt/sonarqube/elasticsearch, -Des.path.conf=/opt/sonarqube/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [analysis-common]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [lang-painless]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [mapper-extras]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [parent-join]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [percolator]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [reindex]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [repository-url]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] loaded module [transport-netty4]
    2020.03.27 05:59:22 INFO  es[][o.e.p.PluginsService] no plugins loaded
    2020.03.27 05:59:26 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.
    2020.03.27 05:59:28 INFO  es[][o.e.d.DiscoveryModule] using discovery type [zen] and host providers [settings]
    2020.03.27 05:59:29 INFO  es[][o.e.n.Node] initialized
    2020.03.27 05:59:29 INFO  es[][o.e.n.Node] starting ...
    2020.03.27 05:59:29 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
    2020.03.27 05:59:29 INFO  es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
    2020.03.27 05:59:32 INFO  es[][o.e.c.s.MasterService] zen-disco-elected-as-master ([0] nodes joined), reason: new_master {sonarqube}{rQiSeaRdTESDaAuHvLffpA}{gzIaXS48TiW9NJskGQSLZQ}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}
    2020.03.27 05:59:32 INFO  es[][o.e.c.s.ClusterApplierService] new_master {sonarqube}{rQiSeaRdTESDaAuHvLffpA}{gzIaXS48TiW9NJskGQSLZQ}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}, reason: apply cluster state (from master [master {sonarqube}{rQiSeaRdTESDaAuHvLffpA}{gzIaXS48TiW9NJskGQSLZQ}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube} committed version [1] source [zen-disco-elected-as-master ([0] nodes joined)]])
    2020.03.27 05:59:32 INFO  es[][o.e.n.Node] started
    2020.03.27 05:59:32 INFO  es[][o.e.g.GatewayService] recovered [0] indices into cluster_state
    2020.03.27 05:59:52 INFO  es[][o.e.c.m.MetaDataCreateIndexService] [metadatas] creating index, cause [api], templates [], shards [1]/[0], mappings []
    2020.03.27 05:59:52 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[metadatas][0]] ...]).
    2020.03.27 05:59:53 INFO  es[][o.e.c.m.MetaDataMappingService] [metadatas/aHa9iK8uQvGQK19RaFPy_w] create_mapping [metadata]
    2020.03.27 05:59:54 INFO  es[][o.e.c.m.MetaDataCreateIndexService] [components] creating index, cause [api], templates [], shards [5]/[0], mappings []
    2020.03.27 05:59:54 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[components][4]] ...]).
    2020.03.27 05:59:55 INFO  es[][o.e.c.m.MetaDataMappingService] [components/iIRZvas4RN6U157DqfV9Lg] create_mapping [auth]
    2020.03.27 05:59:55 INFO  es[][o.e.c.m.MetaDataCreateIndexService] [projectmeasures] creating index, cause [api], templates [], shards [5]/[0], mappings []
    2020.03.27 05:59:56 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[projectmeasures][4]] ...]).
    2020.03.27 05:59:56 INFO  es[][o.e.c.m.MetaDataMappingService] [projectmeasures/gvHTcO-YSnqrBUc4BJ6gpA] create_mapping [auth]
    2020.03.27 05:59:56 INFO  es[][o.e.c.m.MetaDataCreateIndexService] [rules] creating index, cause [api], templates [], shards [2]/[0], mappings []
    2020.03.27 05:59:57 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[rules][0]] ...]).
    2020.03.27 05:59:57 INFO  es[][o.e.c.m.MetaDataMappingService] [rules/XPmzbbDrTi-f7nrRNEDZjQ] create_mapping [rule]
    2020.03.27 05:59:57 INFO  es[][o.e.c.m.MetaDataCreateIndexService] [issues] creating index, cause [api], templates [], shards [5]/[0], mappings []
    2020.03.27 05:59:57 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[issues][4]] ...]).
    2020.03.27 05:59:58 INFO  es[][o.e.c.m.MetaDataMappingService] [issues/NPGID_zTTFaRgy2C2LNR3Q] create_mapping [auth]
    2020.03.27 05:59:58 INFO  es[][o.e.c.m.MetaDataCreateIndexService] [users] creating index, cause [api], templates [], shards [1]/[0], mappings []
    2020.03.27 05:59:58 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[users][0]] ...]).
    2020.03.27 05:59:58 INFO  es[][o.e.c.m.MetaDataMappingService] [users/nhJkPcWeRuuOm9j8EmWoEA] create_mapping [user]
    2020.03.27 05:59:58 INFO  es[][o.e.c.m.MetaDataCreateIndexService] [views] creating index, cause [api], templates [], shards [5]/[0], mappings []
    2020.03.27 05:59:59 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[views][4]] ...]).
    2020.03.27 05:59:59 INFO  es[][o.e.c.m.MetaDataMappingService] [views/nBj1cmIFT3eYaB1LoSpvLA] create_mapping [view]
    2020.03.27 06:00:01 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [30s] to [-1]
    2020.03.27 06:00:01 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [30s] to [-1]
    2020.03.27 06:00:02 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [-1] to [30s]
    2020.03.27 06:00:02 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [-1] to [30s]
    2020.03.27 06:00:03 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [30s] to [-1]
    2020.03.27 06:00:03 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [30s] to [-1]

sonar.log:

    2020.03.27 05:59:17 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
    2020.03.27 05:59:17 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
    2020.03.27 05:59:17 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube/elasticsearch]: /opt/sonarqube/elasticsearch/bin/elasticsearch
    2020.03.27 05:59:17 INFO  app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
    2020.03.27 05:59:18 INFO  app[][o.e.p.PluginsService] no modules loaded
    2020.03.27 05:59:18 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
    2020.03.27 05:59:32 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
    2020.03.27 05:59:32 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonarqube]: /usr/local/openjdk-11/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/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/lib/jdbc/postgresql/postgresql-42.2.8.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process6543753861317923293properties
    2020.03.27 06:00:05 INFO  app[][o.s.a.SchedulerImpl] Process[web] is up
    2020.03.27 06:00:05 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='ce', ipcIndex=3, logFilenamePrefix=ce]] from [/opt/sonarqube]: /usr/local/openjdk-11/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/temp --add-opens=java.base/java.util=ALL-UNNAMED -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*:/opt/sonarqube/lib/jdbc/postgresql/postgresql-42.2.8.jar org.sonar.ce.app.CeServer /opt/sonarqube/temp/sq-process15638970174856845811properties
    2020.03.27 06:00:18 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is up
    2020.03.27 06:00:18 INFO  app[][o.s.a.SchedulerImpl] SonarQube is up
    2020.03.27 06:00:52 INFO  app[][o.s.a.SchedulerImpl] Stopping SonarQube
    2020.03.27 06:00:54 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is stopped
    2020.03.27 06:00:54 INFO  app[][o.s.a.SchedulerImpl] Process[web] is stopped
    2020.03.27 06:00:54 WARN  app[][o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
    2020.03.27 06:00:54 INFO  app[][o.s.a.SchedulerImpl] Process[es] is stopped
    2020.03.27 06:00:54 INFO  app[][o.s.a.SchedulerImpl] SonarQube is stopped
    2020.03.27 06:01:06 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
    2020.03.27 06:01:06 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
    2020.03.27 06:01:06 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube/elasticsearch]: /opt/sonarqube/elasticsearch/bin/elasticsearch
    2020.03.27 06:01:06 INFO  app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
    2020.03.27 06:01:07 INFO  app[][o.e.p.PluginsService] no modules loaded
    2020.03.27 06:01:07 INFO  app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
    2020.03.27 06:01:26 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
    2020.03.27 06:01:26 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonarqube]: /usr/local/openjdk-11/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/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/lib/jdbc/postgresql/postgresql-42.2.8.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process15778332887191632022properties
    2020.03.27 06:01:47 INFO  app[][o.s.a.SchedulerImpl] Process[web] is up
    2020.03.27 06:01:47 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[[key='ce', ipcIndex=3, logFilenamePrefix=ce]] from [/opt/sonarqube]: /usr/local/openjdk-11/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/temp --add-opens=java.base/java.util=ALL-UNNAMED -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*:/opt/sonarqube/lib/jdbc/postgresql/postgresql-42.2.8.jar org.sonar.ce.app.CeServer /opt/sonarqube/temp/sq-process1847095786488481965properties
    2020.03.27 06:01:59 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is up
    2020.03.27 06:01:59 INFO  app[][o.s.a.SchedulerImpl] SonarQube is up

I attached the web.log files , maybe it will need you

2020.03.27 05:59:34 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2020.03.27 05:59:36 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.03.27 05:59:37 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: developer-edition, developer-scanner, developer-server, license
2020.03.27 05:59:37 INFO  web[][o.e.p.PluginsService] no modules loaded
2020.03.27 05:59:37 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.03.27 05:59:37 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.03.27 05:59:37 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.03.27 05:59:40 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.03.27 05:59:40 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 8.2.0.32929 / ffde725e701a0acdc2bfac653743c4d91063cd45
2020.03.27 05:59:40 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://sonarqube-postgres-dev/sonarqubedb
2020.03.27 05:59:44 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
2020.03.27 05:59:44 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.03.27 05:59:44 INFO  web[][o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2020.03.27 05:59:44 INFO  web[][o.s.s.p.d.m.c.PostgresCharsetHandler] Verify that database charset supports UTF8
2020.03.27 05:59:44 INFO  web[][o.s.s.p.d.m.AutoDbMigration] Automatically perform DB migration on fresh install
2020.03.27 05:59:44 INFO  web[][DbMigrations] Executing DB migrations...
2020.03.27 05:59:44 INFO  web[][DbMigrations] #1 'Create initial schema'...
2020.03.27 05:59:46 INFO  web[][DbMigrations] #1 'Create initial schema': success | time=2148ms
2020.03.27 05:59:46 INFO  web[][DbMigrations] #2 'Populate initial schema'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #2 'Populate initial schema': success | time=125ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3000 'Set Organizations#guarded column nullable'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3000 'Set Organizations#guarded column nullable': success | time=4ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3001 'Create ProjectQualityGates table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3001 'Create ProjectQualityGates table': success | time=19ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3002 'Make index on DEPRECATED_RULE_KEYS.RULE_ID non unique'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3002 'Make index on DEPRECATED_RULE_KEYS.RULE_ID non unique': success | time=13ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3003 'Populate ProjectQualityGate table from Properties table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3003 'Populate ProjectQualityGate table from Properties table': success | time=15ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3004 'Rename ANALYSIS_PROPERTIES.SNAPSHOT_UUID to ANALYSIS_UUID'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3004 'Rename ANALYSIS_PROPERTIES.SNAPSHOT_UUID to ANALYSIS_UUID': success | time=28ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3005 'Remove default quality gate property from Properties table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3005 'Remove default quality gate property from Properties table': success | time=5ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3006 'Create NEW_CODE_PERIOD table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3006 'Create NEW_CODE_PERIOD table': success | time=27ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3007 'Populate NEW_CODE_PERIOD table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3007 'Populate NEW_CODE_PERIOD table': success | time=14ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3008 'Remove leak period properties'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3008 'Remove leak period properties': success | time=4ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3009 'Remove GitHub login generation strategy property'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3009 'Remove GitHub login generation strategy property': success | time=4ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3100 'Create ALM_SETTINGS table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3100 'Create ALM_SETTINGS table': success | time=22ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3101 'Create PROJECT_ALM_SETTINGS table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3101 'Create PROJECT_ALM_SETTINGS table': success | time=24ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3102 'Migrate property 'sonar.alm.github.app.privateKey.secured' to 'sonar.alm.github.app.privateKeyContent.secured''...
2020.03.27 05:59:47 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3102 'Migrate property 'sonar.alm.github.app.privateKey.secured' to 'sonar.alm.github.app.privateKeyContent.secured'': success | time=16ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3103 'Migrate GitHub ALM settings from PROPERTIES to ALM_SETTINGS tables'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3103 'Migrate GitHub ALM settings from PROPERTIES to ALM_SETTINGS tables': success | time=6ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3104 'Migrate Bitbucket ALM settings from PROPERTIES to ALM_SETTINGS tables'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3104 'Migrate Bitbucket ALM settings from PROPERTIES to ALM_SETTINGS tables': success | time=12ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3105 'Migrate Azure ALM settings from PROPERTIES to ALM_SETTINGS tables'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3105 'Migrate Azure ALM settings from PROPERTIES to ALM_SETTINGS tables': success | time=5ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3106 'Delete 'sonar.pullrequest.provider' property'...
2020.03.27 05:59:47 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3106 'Delete 'sonar.pullrequest.provider' property': success | time=10ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3107 'Migrate default branches to keep global setting'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3107 'Migrate default branches to keep global setting': success | time=26ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3108 'Add EXCLUDE_FROM_PURGE column'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3108 'Add EXCLUDE_FROM_PURGE column': success | time=10ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3109 'Populate EXCLUDE_FROM_PURGE column'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3109 'Populate EXCLUDE_FROM_PURGE column': success | time=6ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3110 'Remove 'sonar.branch.longLivedBranches.regex''...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3110 'Remove 'sonar.branch.longLivedBranches.regex'': success | time=10ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3111 'Rename 'sonar.dbcleaner.daysBeforeDeletingInactiveShortLivingBranches' setting'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3111 'Rename 'sonar.dbcleaner.daysBeforeDeletingInactiveShortLivingBranches' setting': success | time=5ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3112 'Migrate short and long living branches types to common BRANCH type'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3112 'Migrate short and long living branches types to common BRANCH type': success | time=10ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3113 'Migrate short and long living branches types to common BRANCH type in ce tasks table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3113 'Migrate short and long living branches types to common BRANCH type in ce tasks table': success | time=6ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3200 'Drop 'In Review' Security Hotspots status '...
2020.03.27 05:59:47 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3200 'Drop 'In Review' Security Hotspots status ': success | time=19ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3201 'Migrate Manual Vulnerabilities to Security Hotspots '...
2020.03.27 05:59:47 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3201 'Migrate Manual Vulnerabilities to Security Hotspots ': success | time=8ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3202 'Remove 'newsbox.dismiss.hotspots' user property'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3202 'Remove 'newsbox.dismiss.hotspots' user property': success | time=5ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3203 'Ensure Security Hotspots have status TO_REVIEW'...
2020.03.27 05:59:47 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3203 'Ensure Security Hotspots have status TO_REVIEW': success | time=5ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3204 'Rename table 'PROJECTS' to 'COMPONENTS''...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3204 'Rename table 'PROJECTS' to 'COMPONENTS'': success | time=11ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3205 'Add PROJECTS table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3205 'Add PROJECTS table': success | time=32ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3206 'Populate PROJECTS table'...
2020.03.27 05:59:47 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 projects processed (0 items/sec)
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3206 'Populate PROJECTS table': success | time=13ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3207 'Drop 'TAGS' column from COMPONENTS table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3207 'Drop 'TAGS' column from COMPONENTS table': success | time=6ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3208 'Remove old Security Review Rating measures'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3208 'Remove old Security Review Rating measures': success | time=10ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3209 'Create ALM_PATS table'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3209 'Create ALM_PATS table': success | time=36ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3210 'Add index on ALM_slug'...
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3210 'Add index on ALM_slug': success | time=74ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3211 'Delete conditions using 'security_hotspots' and 'new_security_hotspots' metrics'...
2020.03.27 05:59:47 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2020.03.27 05:59:47 INFO  web[][DbMigrations] #3211 'Delete conditions using 'security_hotspots' and 'new_security_hotspots' metrics': success | time=54ms
2020.03.27 05:59:47 INFO  web[][DbMigrations] Executed DB migrations: success | time=2888ms
2020.03.27 05:59:47 INFO  web[][o.s.s.p.Platform] Database has been automatically updated
2020.03.27 05:59:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@438242f9 [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/components/update_key, ...]}]
2020.03.27 05:59:47 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.03.27 05:59:50 INFO  web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2020.03.27 05:59:51 INFO  web[][o.s.s.e.IndexCreator] Create index [metadatas]
2020.03.27 05:59:52 INFO  web[][o.s.s.e.IndexCreator] Create type metadatas/metadata
2020.03.27 05:59:53 INFO  web[][o.s.s.e.IndexCreator] Create index [components]
2020.03.27 05:59:55 INFO  web[][o.s.s.e.IndexCreator] Create type components/auth
2020.03.27 05:59:55 INFO  web[][o.s.s.e.IndexCreator] Create index [projectmeasures]
2020.03.27 05:59:56 INFO  web[][o.s.s.e.IndexCreator] Create type projectmeasures/auth
2020.03.27 05:59:56 INFO  web[][o.s.s.e.IndexCreator] Create index [rules]
2020.03.27 05:59:57 INFO  web[][o.s.s.e.IndexCreator] Create type rules/rule
2020.03.27 05:59:57 INFO  web[][o.s.s.e.IndexCreator] Create index [issues]
2020.03.27 05:59:58 INFO  web[][o.s.s.e.IndexCreator] Create type issues/auth
2020.03.27 05:59:58 INFO  web[][o.s.s.e.IndexCreator] Create index [users]
2020.03.27 05:59:58 INFO  web[][o.s.s.e.IndexCreator] Create type users/user
2020.03.27 05:59:58 INFO  web[][o.s.s.e.IndexCreator] Create index [views]
2020.03.27 05:59:59 INFO  web[][o.s.s.e.IndexCreator] Create type views/view
2020.03.27 05:59:59 INFO  web[][o.s.s.s.LogServerId] Server ID: 54415953-AXEakzgKbVKAfPB0nSe3
2020.03.27 05:59:59 WARN  web[][o.s.s.a.LogOAuthWarning] For security reasons, OAuth authentication should use HTTPS. You should set the property 'Administration > Configuration > Server base URL' to a HTTPS URL.
2020.03.27 05:59:59 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2020.03.27 05:59:59 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/permissions/search_templates
2020.03.27 06:00:00 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/list_bitbucketserver_projects
2020.03.27 06:00:00 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/search_bitbucketserver_repos
2020.03.27 06:00:00 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/check_pat
2020.03.27 06:00:00 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/support/info
2020.03.27 06:00:00 INFO  web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2020.03.27 06:00:00 INFO  web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2020.03.27 06:00:00 INFO  web[][com.sonarsource.D.H] Loaded virtual plugin License for SonarLint
2020.03.27 06:00:00 INFO  web[][o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2020.03.27 06:00:00 INFO  web[][o.s.s.s.RegisterPlugins] Register plugins
2020.03.27 06:00:00 INFO  web[][o.s.s.s.RegisterMetrics] Register metrics
2020.03.27 06:00:00 INFO  web[][o.s.s.q.RegisterQualityGates] Built-in quality gate's conditions of [Sonar way] has been updated
2020.03.27 06:00:00 INFO  web[][o.s.s.r.RegisterRules] Register rules
2020.03.27 06:00:01 INFO  web[][o.s.s.q.BuiltInQProfileRepositoryImpl] Load quality profiles
2020.03.27 06:00:01 INFO  web[][o.s.s.s.RegisterPermissionTemplates] Register permission templates
2020.03.27 06:00:01 INFO  web[][o.s.s.s.RenameDeprecatedPropertyKeys] Rename deprecated property keys
2020.03.27 06:00:01 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@2a81581c [pattern=UrlPattern{inclusions=[/api/issues/delete_comment.*, ...], exclusions=[/api/authentication/login.*, ...]}]
2020.03.27 06:00:01 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceReroutingFilter@4f6466ed [pattern=UrlPattern{inclusions=[/api/components/bulk_update_key, ...], exclusions=[]}]
2020.03.27 06:00:01 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.InitFilter@6020fa26 [pattern=UrlPattern{inclusions=[/sessions/init/*], exclusions=[]}]
2020.03.27 06:00:01 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.OAuth2CallbackFilter@1b20a561 [pattern=UrlPattern{inclusions=[/oauth2/callback/*], exclusions=[]}]
2020.03.27 06:00:01 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LoginAction@3fc518f8 [pattern=UrlPattern{inclusions=[/api/authentication/login], exclusions=[]}]
2020.03.27 06:00:01 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LogoutAction@29747d3f [pattern=UrlPattern{inclusions=[/api/authentication/logout], exclusions=[]}]
2020.03.27 06:00:01 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.ValidateAction@7f33f473 [pattern=UrlPattern{inclusions=[/api/authentication/validate], exclusions=[]}]
2020.03.27 06:00:01 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [users/user] ...
2020.03.27 06:00:02 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [users/user] done | time=1303ms
2020.03.27 06:00:02 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [components/auth/component] ...
2020.03.27 06:00:03 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [components/auth/component] done | time=474ms
2020.03.27 06:00:03 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [views/view] ...
2020.03.27 06:00:03 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [views/view] done | time=386ms
2020.03.27 06:00:03 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [issues/auth/issue] ...
2020.03.27 06:00:03 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [issues/auth/issue] done | time=308ms
2020.03.27 06:00:03 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of types [components/auth],[projectmeasures/auth],[issues/auth] ...
2020.03.27 06:00:04 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of types [components/auth],[projectmeasures/auth],[issues/auth] done | time=336ms
2020.03.27 06:00:04 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [projectmeasures/auth/projectmeasure] ...
2020.03.27 06:00:04 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [projectmeasures/auth/projectmeasure] done | time=354ms
2020.03.27 06:00:04 INFO  web[][o.s.s.q.ProjectsInWarningDaemon] Counting number of projects in warning is enabled.
2020.03.27 06:00:04 INFO  web[][o.s.s.p.p.PlatformLevelStartup] Running Developer Edition
2020.03.27 06:00:04 INFO  web[][o.s.s.p.Platform] WebServer is operational
2020.03.27 06:00:05 INFO  web[][o.s.s.q.ProjectsInWarningDaemon] Counting number of projects in warning will be disabled as there are no more projects in warning.
2020.03.27 06:00:54 INFO  web[][o.s.p.ProcessEntryPoint] Gracefully stopping process
2020.03.27 06:00:54 INFO  web[][o.s.s.n.NotificationDaemon] Notification service stopped
2020.03.27 06:00:54 INFO  web[][o.s.s.app.WebServer] WebServer stopped
2020.03.27 06:01:27 INFO  web[][o.s.p.ProcessEntryPoint] Starting web
2020.03.27 06:01:28 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.03.27 06:01:29 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: developer-edition, developer-scanner, developer-server, license
2020.03.27 06:01:30 INFO  web[][o.e.p.PluginsService] no modules loaded
2020.03.27 06:01:30 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.03.27 06:01:30 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.03.27 06:01:30 INFO  web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.03.27 06:01:34 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.03.27 06:01:34 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 8.2.0.32929 / ffde725e701a0acdc2bfac653743c4d91063cd45
2020.03.27 06:01:34 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://sonarqube-postgres-dev/sonarqubedb
2020.03.27 06:01:38 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
2020.03.27 06:01:38 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.03.27 06:01:38 INFO  web[][o.s.s.p.d.m.c.PostgresCharsetHandler] Verify that database charset supports UTF8
2020.03.27 06:01:39 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@2b30dbd4 [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/components/update_key, ...]}]
2020.03.27 06:01:39 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.03.27 06:01:42 INFO  web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2020.03.27 06:01:45 INFO  web[][o.s.s.s.LogServerId] Server ID: 54415953-AXEakzgKbVKAfPB0nSe3
2020.03.27 06:01:45 WARN  web[][o.s.s.a.LogOAuthWarning] For security reasons, OAuth authentication should use HTTPS. You should set the property 'Administration > Configuration > Server base URL' to a HTTPS URL.
2020.03.27 06:01:45 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2020.03.27 06:01:45 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/permissions/search_templates
2020.03.27 06:01:45 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/list_bitbucketserver_projects
2020.03.27 06:01:45 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/search_bitbucketserver_repos
2020.03.27 06:01:45 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/check_pat
2020.03.27 06:01:45 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/support/info
2020.03.27 06:01:45 INFO  web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2020.03.27 06:01:45 INFO  web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2020.03.27 06:01:45 INFO  web[][com.sonarsource.D.H] Loaded virtual plugin License for SonarLint
2020.03.27 06:01:45 INFO  web[][o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2020.03.27 06:01:45 INFO  web[][o.s.s.s.RegisterPlugins] Register plugins
2020.03.27 06:01:45 INFO  web[][o.s.s.s.RegisterMetrics] Register metrics
2020.03.27 06:01:46 INFO  web[][o.s.s.r.RegisterRules] Register rules
2020.03.27 06:01:46 INFO  web[][o.s.s.q.BuiltInQProfileRepositoryImpl] Load quality profiles
2020.03.27 06:01:46 INFO  web[][o.s.s.s.RegisterPermissionTemplates] Register permission templates
2020.03.27 06:01:47 INFO  web[][o.s.s.s.RenameDeprecatedPropertyKeys] Rename deprecated property keys
2020.03.27 06:01:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@25288e [pattern=UrlPattern{inclusions=[/api/issues/delete_comment.*, ...], exclusions=[/api/authentication/login.*, ...]}]
2020.03.27 06:01:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceReroutingFilter@2a08c27f [pattern=UrlPattern{inclusions=[/api/components/bulk_update_key, ...], exclusions=[]}]
2020.03.27 06:01:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.InitFilter@53945f3b [pattern=UrlPattern{inclusions=[/sessions/init/*], exclusions=[]}]
2020.03.27 06:01:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.OAuth2CallbackFilter@609c4969 [pattern=UrlPattern{inclusions=[/oauth2/callback/*], exclusions=[]}]
2020.03.27 06:01:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LoginAction@1533ba05 [pattern=UrlPattern{inclusions=[/api/authentication/login], exclusions=[]}]
2020.03.27 06:01:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LogoutAction@40972143 [pattern=UrlPattern{inclusions=[/api/authentication/logout], exclusions=[]}]
2020.03.27 06:01:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.ValidateAction@56aca19e [pattern=UrlPattern{inclusions=[/api/authentication/validate], exclusions=[]}]
2020.03.27 06:01:47 INFO  web[][o.s.s.q.ProjectsInWarningDaemon] Counting number of projects in warning is not started as there are no projects in this situation.
2020.03.27 06:01:47 INFO  web[][o.s.s.p.p.PlatformLevelStartup] Running Developer Edition
2020.03.27 06:01:47 INFO  web[][o.s.s.p.Platform] WebServer is operational

Hi @bbalazs,

One thing that appears missing in your logs is evidence that any language analyzers are loaded within SonarQube. You say you reinstalled the Developer Edition – are you still utilizing Docker? Can you specify exactly what you installed and how you are starting the server?

Yes. I reinstalled with docker. I started with docker compose: docker-compose up -d --build

 sonarqube-postgres-dev:
  image: postgres:11.6
  container_name: sonarqube-postgres-dev
  hostname: sonarqube-postgres-dev
  restart: always
  environment:
   TZ : "Europe/Budapest"
  volumes:
   - /opt/tcd/workspace/sonarqube-postgres-dev:/var/lib/postgresql/data
   - /etc/localtime:/etc/localtime:ro
  networks:
   - ci-network
  environment:
   - POSTGRES_DB=sonarqubedb
   - POSTGRES_USER=myuser
   - POSTGRES_PASSWORD=mypassword



 sonarqube:
  image: sonarqube:8.2-developer
  container_name: sonarqube
  hostname: sonarqube
  user: 1000:1000
  restart: always
  networks:
   - ci-network
  environment:
   - sonar.jdbc.username=myuser
   - sonar.jdbc.password=mypassword
   - sonar.jdbc.url=jdbc:postgresql://sonarqube-postgres-dev/sonarqubedb
  volumes:
   - /opt/tcd/workspace/sonarqube-dev/temp:/opt/sonarqube/temp
   - /opt/tcd/workspace/sonarqube-dev/data:/opt/sonarqube/data
   - /opt/tcd/workspace/sonarqube-dev/logs:/opt/sonarqube/logs
   - /opt/tcd/workspace/sonarqube-dev/extensions:/opt/sonarqube/extensions
   - /etc/localtime:/etc/localtime:ro
  depends_on:
   - sonarqube-postgres-dev

networks:
 ci-network:

@bbalazs can you take a look within /opt/tcd/workspace/sonarqube-dev/extensions? Within it, you should see a folder plugins which contains many jar files, among them something like sonar-plsql-plugin-3.4.1.2576.jar.

Hi! There is an extension/plugins folder, but it contains only the manually installed plugins (sonar-findbugs, …) not the sonar-plsql. Yesterday I installed sonar-developer on windows and it works, but we would like to use sonarqube via docker under linux

Hi! I downloaded sonarqube-developer edition (https://www.sonarqube.org/downloads/​) and I copied the plugins from extensions/plugins to the sonarqube-developer docker container volume extensions/plugins. And it works…

Hi,
The problem is you are using bind mounts instead of using volumes. In docker-compose this:

sonarqube:
  ...
  volumes:
    - /opt/tcd/workspace/sonarqube-dev/temp:/opt/sonarqube/temp
    - /opt/tcd/workspace/sonarqube-dev/data:/opt/sonarqube/data
    - /opt/tcd/workspace/sonarqube-dev/logs:/opt/sonarqube/logs
    - /opt/tcd/workspace/sonarqube-dev/extensions:/opt/sonarqube/extensions

uses bind mounts and is different from this:

sonarqube:
    ...
    volumes:
      - sonarqube_data:/opt/sonarqube/data
      - sonarqube_extensions:/opt/sonarqube/extensions
      - sonarqube_logs:/opt/sonarqube/logs
      - sonarqube_temp:/opt/sonarqube/temp

volumes:
  sonarqube_data:
  sonarqube_extensions:
  sonarqube_logs:
  sonarqube_temp:

that uses Docker named volumes.

If you use Docker volumes (which we recommend) everything will be prepared automatically for you on container startup and you don’t have to worry about permissions. If you want to use bind mounts you have to prepare the directory on the host in advance and make sure the permissions are set correctly.