I am Trying to setup SQ (Developer edition) with postgreSQL as the database. However, I am not getting any luck getting it to start. Keeps failing. I have attached the log files, any help would be much appreciated!!!
2019.11.04 09:20:29 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
Did you consider the hints here => https://docs.sonarqube.org/latest/requirements/requirements/ for
Linux (don’t run as root … etc.) ?
Also for diagnostics you should increase the loglevel to DEBUG to get more details via
$SONARQUBE_HOME/conf/sonar.properties => set sonar.log.level.es=DEBUG or even for all
logs with sonar.log.level=DEBUG
Is this the pure release version, or are there addtional plugins in $SONARQUBE_HOME/extensions ?
Did you change any of the default jvm parameters in …/conf/sonar.properties ?
Try:
stop SQ
delete $SONARQUBE_HOME/data/es6 Folder
change config to use the builtin H2 database
start SQ
to make sure it’s not db related
OK, so no additional plugins.
I can’t find anything suspicious in your sonar.properties, but i would increase the heapspace for
ES process, Xms has to be equal to Xmx. e.g. :
# JVM options of Elasticsearch process
sonar.search.javaOpts=-Xmx2G -Xms2G -XX:+HeapDumpOnOutOfMemoryError
To test with the builtin H2 db, simply deactivate your db properties:
sonar.jdbc.username, sonar.jdbc.password, sonar.jdbc.url
I noticed this error, failed to connect to a node? would that mean I have a port issue?
This is after deleting the es6 and setting it back to the H2 database…same errors as before
Does the user that runs Sonarqube has sufficient rights for $SONARQUBE_HOME/data folder ?
Maybe it’s a port issue or some process is lurking in the background.
you may try
# Elasticsearch port. Default is 9001. Use 0 to get a free port.
# As a security precaution, should be blocked by a firewall and not exposed to the Internet.
sonar.search.port=0
2019.11.04 09:20:29 ERROR web[o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Fail to connect to database
…
Caused by: org.sonar.api.utils.MessageException: Unsupported postgresql version: 9.2. Minimal supported version is 9.3.
(I looked in the web log after my text search of the other two logs failed to find the string “ERROR”.)
… I’d want to see the logs on that. If it truly failed to connect to the H2 database, then I’d suspect some overly vigilant process on the box blocking access to the necessary ports.
after rechecking my logs (SQ Enterprise 7.9.1 / 8.0, running on windows server 2016), it seems this
ES connection refused … errors are quite ‘normal’. Found a bunch ot those entries in ES logs, but everything works just fine.
@devine to get back on track we’ll need to check the logs of your test with builtin H2 database.
btw, with all those (similar) postings, it seems a lot of users have problems with Sonarqube setup,
especially on Linux systems - even when the documentation gets constantly better.
What about providing a wizard driven installer for windows/linux … , doing all that nasty stuff ?
It could also check whether prerequisites are fulfilled and ask for basic properties (SQ server base url,
mail server settings …) ?
To add on to this, when ever a PR is committed…And i go to review the PR on bitbucket, it does not show the decoration, yet on SQ, it has the report visible with a link to view the PR on bitbucket…any ideas as to why ??