java.lang.IllegalStateException: Unable to start database on SonarQube Server / 8.2.0.32929

SonarQube
1

Hello Team,

We are using SonarQube Server / 8.2.0.32929 on Windows since more than a year.
Now we are unable to start the sonarqube with the below error:

2021.11.12 11:39:33 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 8.2.0.32929 / ffde725e701a0acdc2bfac653743c4d91063cd45
2021.11.12 11:39:33 ERROR web[][o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Unable to start database
	at org.sonar.server.platform.db.EmbeddedDatabase.startServer(EmbeddedDatabase.java:87)
	at org.sonar.server.platform.db.EmbeddedDatabase.start(EmbeddedDatabase.java:62)
	at org.sonar.server.platform.db.EmbeddedDatabaseFactory.start(EmbeddedDatabaseFactory.java:49)
	at org.sonar.core.platform.StartableCloseableSafeLifecyleStrategy.start(StartableCloseableSafeLifecyleStrategy.java:40)
	at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)


Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: File corrupted while reading record: null. Possible solution: use the recovery tool [90030-199]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:617)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
	at org.h2.message.DbException.get(DbException.java:194)
	at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:205)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:173)
	at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:95)
	at org.h2.engine.Database.getPageStore(Database.java:2739)
	at org.h2.engine.Database.open(Database.java:769)
	at org.h2.engine.Database.openDatabase(Database.java:319)
	at org.h2.engine.Database.<init>(Database.java:313)
	at org.h2.engine.Engine.openSession(Engine.java:69)

Tried to use the recovery tool also, still no luck
C:\SonarQube\sonarqube-8.2.0.32929\data>java -cp ..\lib\jdbc\h2\h2-1.4.199.jar org.h2.tools.Recover
Exception in thread "main" java.lang.IllegalStateException: File corrupted in chunk 92691, expected page length 4..768, got 1882862387 [1.4.199/6]
        at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:883)
        at org.h2.mvstore.MVStore.readBufferForPage(MVStore.java:1055)
        at org.h2.mvstore.MVStore.readPage(MVStore.java:2186)
        at org.h2.mvstore.MVMap.readPage(MVMap.java:554)
        at org.h2.mvstore.Page$NonLeaf.getChildPage(Page.java:1086)
        at org.h2.mvstore.Cursor.hasNext(Cursor.java:53)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:793)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:401)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:3343)
        at org.h2.mvstore.MVStoreTool.info(MVStoreTool.java:347)
        at org.h2.tools.Recover.process(Recover.java:344)
        at org.h2.tools.Recover.runTool(Recover.java:195)
        at org.h2.tools.Recover.main(Recover.java:158)

C:\SonarQube\sonarqube-8.2.0.32929\data>

Please help us to recover the data and start the sonarqube.

Thanks,
Champa

2

Can some one please help me on this.

3

Hi,

Welcome to the community!

First, your version is past EOL. You should upgrade to either the latest version or the current LTS at your earliest convenience.

Second, it appears that you’ve been using the embedded H2 database in production for the last year. Unfortunately for you, we don’t support H2 as a production database. It’s only there to make initial evaluation easy. Didn’t you wonder about the banner across the bottom of every page?

I’m afraid you’re just going to have to start over with a supported database. PostgreSQL is free. And while your’e starting over, you might as well upgrade to a current version; 9.2 was released yesterday.

 
Ann