Cannot running SonarQube Server (problems in web.log)

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    SonaQube: 9.4.0
    SonarScanner: 4.6.2
    Java: 11

  • what are you trying to achieve
    Running SonarQube

  • what have you tried so far to achieve this
    Looking at web.log

It worked well until yesterday, but it doesn’t work suddenly this morning.
There is no changed setting.

I think there are some problems in web.log, not es.log.
I cannot understand why this problems suddenly occur.

2022.06.03 15:12:31 INFO  es[][o.e.n.Node] version[7.17.1], pid[21708], build[unknown/unknown/e5acb99f822233d62d6444ce45a4543dc1c8059a/2022-02-23T22:20:54.153567231Z], OS[Windows 10/10.0/amd64], JVM[Oracle Corporation/Java HotSpot(TM) 64-Bit Server VM/11.0.15/11.0.15+8-LTS-149]
2022.06.03 15:12:31 INFO  es[][o.e.n.Node] JVM home [C:\Program Files\Java\jdk-11.0.15]
2022.06.03 15:12:31 INFO  es[][o.e.n.Node] JVM arguments [-XX:+UseG1GC, -Djava.io.tmpdir=C:\Users\soonh.hong\Desktop\sonarqube-9.4.0.54424\temp, -XX:ErrorFile=../logs/es_hs_err_pid%p.log, -Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -Djna.tmpdir=C:\Users\soonh.hong\Desktop\sonarqube-9.4.0.54424\temp, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dio.netty.allocator.numDirectArenas=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Dlog4j2.formatMsgNoLookups=true, -Djava.locale.providers=COMPAT, -Dcom.redhat.fips=false, -Xmx512m, -Xms512m, -XX:MaxDirectMemorySize=256m, -XX:+HeapDumpOnOutOfMemoryError, -Delasticsearch, -Des.path.home=C:\Users\soonh.hong\Desktop\sonarqube-9.4.0.54424\elasticsearch, -Des.path.conf=C:\Users\soonh.hong\Desktop\sonarqube-9.4.0.54424\temp\conf\es]
2022.06.03 15:12:31 INFO  es[][o.e.p.PluginsService] loaded module [analysis-common]
2022.06.03 15:12:31 INFO  es[][o.e.p.PluginsService] loaded module [lang-painless]
2022.06.03 15:12:31 INFO  es[][o.e.p.PluginsService] loaded module [parent-join]
2022.06.03 15:12:31 INFO  es[][o.e.p.PluginsService] loaded module [reindex]
2022.06.03 15:12:31 INFO  es[][o.e.p.PluginsService] loaded module [transport-netty4]
2022.06.03 15:12:31 INFO  es[][o.e.p.PluginsService] no plugins loaded
2022.06.03 15:12:32 INFO  es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[(C:)]], net usable_space [171.5gb], net total_space [238.1gb], types [NTFS]
2022.06.03 15:12:32 INFO  es[][o.e.e.NodeEnvironment] heap size [512mb], compressed ordinary object pointers [true]
2022.06.03 15:12:33 INFO  es[][o.e.n.Node] node name [sonarqube], node ID [sdzyC4_2RCK7Czos26mBcQ], cluster name [sonarqube], roles [data_frozen, master, remote_cluster_client, data, data_content, data_hot, data_warm, data_cold, ingest]
2022.06.03 15:12:38 INFO  es[][o.e.t.NettyAllocator] creating NettyAllocator with the following configs: [name=unpooled, suggested_max_allocation_size=256kb, factors={es.unsafe.use_unpooled_allocator=null, g1gc_enabled=true, g1gc_region_size=1mb, heap_size=512mb}]
2022.06.03 15:12:38 INFO  es[][o.e.i.r.RecoverySettings] using rate limit [40mb] with [default=40mb, read=0b, write=0b, max=0b]
2022.06.03 15:12:38 INFO  es[][o.e.d.DiscoveryModule] using discovery type [zen] and seed hosts providers [settings]
2022.06.03 15:12:38 INFO  es[][o.e.g.DanglingIndicesState] gateway.auto_import_dangling_indices is disabled, dangling indices will not be automatically detected or imported and must be managed manually
2022.06.03 15:12:38 INFO  es[][o.e.n.Node] initialized
2022.06.03 15:12:38 INFO  es[][o.e.n.Node] starting ...
2022.06.03 15:12:39 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:60804}, bound_addresses {127.0.0.1:60804}
2022.06.03 15:12:40 INFO  es[][o.e.c.c.Coordinator] cluster UUID [X7jQzpqsRb2Km7ZuRYafVA]
2022.06.03 15:12:40 INFO  es[][o.e.c.s.MasterService] elected-as-master ([1] nodes joined)[{sonarqube}{sdzyC4_2RCK7Czos26mBcQ}{Iv10TRD0QYKuVakMwzqczw}{127.0.0.1}{127.0.0.1:60804}{cdfhimrsw} elect leader, _BECOME_MASTER_TASK_, _FINISH_ELECTION_], term: 43, version: 460, delta: master node changed {previous [], current [{sonarqube}{sdzyC4_2RCK7Czos26mBcQ}{Iv10TRD0QYKuVakMwzqczw}{127.0.0.1}{127.0.0.1:60804}{cdfhimrsw}]}
2022.06.03 15:12:40 INFO  es[][o.e.c.s.ClusterApplierService] master node changed {previous [], current [{sonarqube}{sdzyC4_2RCK7Czos26mBcQ}{Iv10TRD0QYKuVakMwzqczw}{127.0.0.1}{127.0.0.1:60804}{cdfhimrsw}]}, term: 43, version: 460, reason: Publication{term=43, version=460}
2022.06.03 15:12:40 INFO  es[][o.e.h.AbstractHttpServerTransport] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2022.06.03 15:12:40 INFO  es[][o.e.n.Node] started
2022.06.03 15:12:40 INFO  es[][o.e.g.GatewayService] recovered [7] indices into cluster_state
2022.06.03 15:12:46 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [RED] to [GREEN] (reason: [shards started [[metadatas][0]]]).

es.log

2022.06.03 15:12:47 INFO  web[][o.s.p.ProcessEntryPoint] Starting Web Server
2022.06.03 15:12:48 INFO  web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2022.06.03 15:12:49 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 9.4.0.54424 / 5c36a2e19337da136080a276102eaaefce073c68
2022.06.03 15:12:52 WARN  web[][o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@69663380-org.sonar.server.platform.db.EmbeddedDatabaseFactory': Initialization of bean failed; nested exception is java.lang.IllegalStateException: Unable to start database
2022.06.03 15:12:52 ERROR web[][o.s.s.p.PlatformImpl] Web server startup failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@69663380-org.sonar.server.platform.db.EmbeddedDatabaseFactory': Initialization of bean failed; nested exception is java.lang.IllegalStateException: Unable to start database
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
	at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:187)
	at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)
	at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:163)
	at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:196)
	at org.sonar.server.platform.PlatformImpl.startLevel1Container(PlatformImpl.java:162)
	at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:76)
	at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4763)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5232)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: Unable to start database
	at org.sonar.server.platform.db.EmbeddedDatabase.startServer(EmbeddedDatabase.java:88)
	at org.sonar.server.platform.db.EmbeddedDatabase.start(EmbeddedDatabase.java:63)
	at org.sonar.server.platform.db.EmbeddedDatabaseFactory.start(EmbeddedDatabaseFactory.java:49)
	at org.sonar.core.platform.StartableBeanPostProcessor.postProcessBeforeInitialization(StartableBeanPostProcessor.java:33)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
	... 24 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: File corrupted while reading record: null. Possible solution: use the recovery tool [90030-210]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:697)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:496)
	at org.h2.message.DbException.get(DbException.java:216)
	at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:159)
	at org.h2.mvstore.db.Store.<init>(Store.java:140)
	at org.h2.engine.Database.<init>(Database.java:324)
	at org.h2.engine.Engine.openSession(Engine.java:92)
	at org.h2.engine.Engine.openSession(Engine.java:222)
	at org.h2.engine.Engine.createSession(Engine.java:201)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
	at org.h2.Driver.connect(Driver.java:59)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
	at org.sonar.server.platform.db.EmbeddedDatabase.createDatabase(EmbeddedDatabase.java:115)
	at org.sonar.server.platform.db.EmbeddedDatabase.startServer(EmbeddedDatabase.java:79)
	... 30 common frames omitted
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.210/6]
	at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
	at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1031)
	at org.h2.mvstore.MVStore.<init>(MVStore.java:455)
	at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4056)
	at org.h2.mvstore.db.Store.<init>(Store.java:129)
	... 41 common frames omitted
2022.06.03 15:12:52 WARN  web[][o.a.c.u.SessionIdGeneratorBase] Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [261] milliseconds.
2022.06.03 15:12:52 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9003
2022.06.03 15:12:52 INFO  web[][o.s.p.ProcessEntryPoint] Hard stopping process

web.log

Hey there.

It looks like your embedded database (intended only for testing purposes) has been corrupted.

You should delete the data/sonar.mv.db file from your SonarQube installation and start again (and when you get serious about SonarQube, use a supported database)