Mysql upgraded from 5.7 to 8.0 and Sonarqube 7.8 not starting GUI

SonarQube Server / Community Build
1

Hello Team,

We have migrated the Mysql from 5.7 to 8.0 which has already installed and working sonarqube 7.8, after migrated to Mysql 8.0 version GUI not loading and after 1 minutes sonarqube process stopped.

Please help on this below error in web.log

2023.12.25 06:24:05 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2023.12.25 06:24:05 ERROR web[o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'empty,

  text_value as value,
  created_at as createdAt
from
  i' at line 3

The error may exist in org.sonar.db.property.InternalPropertiesMapper

The error may involve org.sonar.db.property.InternalPropertiesMapper.selectAsText-Inline

The error occurred while setting parameters

SQL: select kee as “key”, is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? )

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'empty,

  text_value as value,
  created_at as createdAt
2

SonarQube 7.8 doesn’t work with MySQL file, as described in the default sonar.properties file:

#----- MySQL >=5.6 && <8.0

Source: sonarqube/sonar-application/src/main/assembly/conf/sonar.properties at 870ae4efbf5dcdbe59295eb5827b55a6a74c7b89 · SonarSource/sonarqube · GitHub

Also note: End of Life of MySQL Support

3

Felipe Zorzo, Thanks for the quick reply.