Sonarqube Errors and Database

Error 1

2020.07.21 15:08:24 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:9001}, bound_a
ddresses {127.0.0.1:9001}
2020.07.21 15:08:24 INFO  es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2020.07.21 15:08:24 ERROR es[][o.e.b.Bootstrap] node validation exception
[1] bootstrap checks failed
[1]: max file descriptors [4096] for elasticsearch process is too low, increase to at least [655
35]
2020.07.21 15:08:24 INFO  es[][o.e.n.Node] stopping ...
2020.07.21 15:08:24 INFO  es[][o.e.n.Node] stopped
2020.07.21 15:08:24 INFO  es[][o.e.n.Node] closing ...
2020.07.21 15:08:24 INFO  es[][o.e.n.Node] closed
Code language: PHP (php)

Solution 1

1. https://www.devopsschool.com/blog/elastic-search-error-max-virtual-memory-areas-vm-max_map_count-65530-is-too-low-increase-to-at-least-262144/
2. https://www.devopsschool.com/blog/elastic-search-error-max-file-descriptors-4096-for-elasticsearch-process-is-too-low-increase-to-at-least-65535/

Error 2

[centos@ip-172-31-13-50 logs]$ more web.log | grep -i error
2020.07.21 15:47:00 ERROR web[][o.s.s.p.PlatformImpl] Web server startup failed
Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
[centos@ip-172-31-13-50 logs]$

Solution 2:

#sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube?currentSchema=my_schema
TO
sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube

Where "sonarqube" is a name of the DB.Code language: PHP (php)

SonarQube Tutorial & OWASP SonarQube Tutorial Securing Code (SAST) Crash Course:- https://bit.ly/3x5ZOmA

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.