We are using SonarQube 10.6 Community edition version and does not have any external database attached to it. We are using only H2 Embedded DB offered by Sonar and suddenly from yesterday our SonarQube application struggles to load and ending with 502 error. We want to know what is the default size of embedded db and how far it can handle the larger applications.
Is there any options to increase/extend it?
Any other ways there to cleanup the data’s in embedded DB to make SonarQube operational and up?
Please assist here. Expecting your quick response over this matter!
at org.h2.message.DbException.getJdbcSQLException(DbException.java:566)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at org.h2.message.DbException.get(DbException.java:212)
at org.h2.engine.Database.throwLastBackgroundException(Database.java:1817)
at org.h2.engine.SessionLocal.beforeCommitOrRollback(SessionLocal.java:764)
at org.h2.engine.SessionLocal.commit(SessionLocal.java:679)
at org.h2.command.Command.commitIfNonTransactional(Command.java:315)
at org.h2.command.Command.executeUpdate(Command.java:247)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:413)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:191)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: org.h2.message.DbException: General error: “org.h2.mvstore.MVStoreException: java.lang.OutOfMemoryError: Capacity: 35831808 [2.2.224/3]” [50000-224]
at org.h2.message.DbException.get(DbException.java:212)
at org.h2.message.DbException.convert(DbException.java:407)
at org.h2.mvstore.db.Store.lambda$new$0(Store.java:122)
at org.h2.mvstore.MVStore.handleException(MVStore.java:1546)
at org.h2.mvstore.MVStore.panic(MVStore.java:371)
at org.h2.mvstore.FileStore.serializeAndStore(FileStore.java:1441)
at org.h2.mvstore.FileStore.lambda$storeIt$2(FileStore.java:1376)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
… 1 more
Suddenly today onwards our sonarqube url was down and we did restart the sonar services as well. it was not working.
We are using sonarqube 10.6 version and having java jdk 17.0.12. even we tried to install jdk 17.0.13 as well but not working. We have IIS reverse proxy setup for the URL and hosted this sonarqube on windows VM
Kindly help us. Service is running inside the VM but the localhost url as well as DNS url is not loading.
Adding log files as well from server.es.log (57.4 KB) es.log (57.4 KB)
Sonarqube 10.6 version was loading very slowly first and was giving authentication error even after the correct entry of username and password. Later it stopped loading and started giving 500 internal error. We restarted the services and app pool to make it work but that also did not work as now we are getting 502 error.
Jdk 17.0.13 is the java version which we are currently using and earlier we were using jdk 17.0.12 but anyhow both were stable.
Localhost 9443 itself is not loading for us. We have reverse proxy settings for our sonar url and we have attached the logs.
We are at a very crucial stage right now as sonarqube is like production for us.
I’ve combined your 3 separate threads related to the same issue. In the future, it is much preferred that you have 1 thread.
There is a big sign on every page of a SonarQube instance using the embedded H2 database that it should only be used for testing, and not for production purposes.
We are not looking for moving out the data from embedded H2 DB. We wanted to know if any upgrade option available to expand H2 DB but from your recent post we assume that it is not possible.
Alternatively any other options is there to make the SonarQube Operational now? Do we need to use any external MSSQL DB to our SonarQube application?
Also you are saying to install a production instance. Means you asking us to go for Developer/Enterprise edition? We are currently having community edition.
This is an open community with people volunteering their free time to provide assistance. We’re eager to contribute to the community, but you are not guaranteed a fast response.
