Error when run StartSonar.bat "Failed to create table schema_migrations"

Hi community members,

I have downloaded SonarQube 8.9.8 LTS (Community Edition).
After running startSonar.bat I encountered the following error in web.log:

ERROR web[ ][o.s.s.p.PlatformImpl] Web server startup failed java.lang.IllegalStateException: Failed to create table schema_migrations

.

.

.

Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE SCHEMA_MIGRATIONS (VERSION VARCHAR (255[ ]) NOT NULL) "; expected “long”; SQL statement: CREATE TABLE schema_migrations (version VARCHAR (255) NOT NULL) [42001-199]*

Hi,

Welcome to the community!

The H2 DB is embedded for evaluation purposes only and should not be used as a production database. There is no migration path for H2. That’s why there’s a warning at the bottom of every single page in the UI.

 
Ann

Hi Ann,
Many thanks for your response. When I run the startSonar.bat, I encounter the following messages:


Therefore, I read the log files and found only a database migration error.
Do you know why the Sonar service will be stopped?

Hi,

You’ll find the answer in your server logs (specifically web.log). And it will be that there’s no migration path for H2.

 
Ann