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]*
ganncamp
(G Ann Campbell)
April 13, 2022, 2:39pm
2
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?
ganncamp
(G Ann Campbell)
April 18, 2022, 11:47am
4
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