Which Component/files execute SQL commands while installing SonarQube 7.7

SonarQube
1

I am doing a fresh installation of SonarQube 7.7 with MySQ 8.0 on RHEL 7.6 server.
After installation when i try to start the SonarQube using command - /opt/sonar/bin/linux-x86-64/sonar.sh start, i am getting error

2019.07.04 15:55:46 INFO web[o.s.s.p.d.m.AutoDbMigration] Automatically perform DB migration on fresh install
2019.07.04 15:55:46 INFO web[DbMigrations] Executing DB migrations…
2019.07.04 15:55:46 INFO web[DbMigrations] #1 ‘Create initial schema’…
2019.07.04 15:55:47 ERROR web[DbMigrations] #1 ‘Create initial schema’: failure | time=962ms
2019.07.04 15:55:47 ERROR web[DbMigrations] Executed DB migrations: failure | time=964ms
2019.07.04 15:55:47 ERROR web[o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Fail to execute CREATE TABLE groups (id INTEGER NOT NULL AUTO_INCREMENT,name VARCHAR (500) NULL,description VARCHAR (200) NULL,created_at DATETIME NULL,updated_at DATETIME NULL, CONSTRAINT pk_groups PRIMARY KEY (id)) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
at org.sonar.server.platform.db.migration.step.DdlChange$Context.execute(DdlChange.java:97)

I need to know which file/component execute these SQL coomands

2

The Web Server JVM process is executing these commands.

Also, for what it’s worth, SonarQube v7.8 is available and is the last version compatible with MySQL.

If you’re doing a fresh install, you may want to start up a PostgreSQL database server (or Oracle / Microsoft SQL Server, but PostgreSQL is the free option) and install the v7.9 LTS and avoid having to do a migration later!

3

Thanks for reply. i will try v7.9 LTS