Hi Team,
We have more than 400 project already created in SonarQube but from 15th Oct there is no project showing in SonarQube dashboard.
I also check the logs (access.logs & sonar.logs) but not found anything related.
Could you please confirm how i can restore all the project again.
Did you also check the es.log to see if there are problems related to elasticsearch ?
Otherwise you can try with reindexing
see Troubleshooting
Hi Gilbert
Thanks for your quick response.
I have checked there is no issue with es.logs.
I have DB backup can i restore all the project using DB backup.
ok, then try with reindexing the elasticsearch indices as menttioned above.
Hi
I have done the reindexing after that sonarqube is not able to up.
getting below error in web.log
2024.10.17 16:18:20 INFO web[o.s.s.e.IndexerStartupTask] Indexing of type [issues/issue] …
2024.10.17 16:18:20 ERROR web[o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
java.lang.IllegalStateException: Fail to prepare SQL request to select all issues
at org.sonar.server.issue.index.IssueIteratorForSingleChunk.(IssueIteratorForSingleChunk.java:120)
at org.sonar.server.issue.index.IssueIteratorFactory.createForProject(IssueIteratorFactory.java:39)
at org.sonar.server.issue.index.IssueIteratorFactory.createForAll(IssueIteratorFactory.java:35)
at org.sonar.server.issue.index.IssueIndexer.indexOnStartup(IssueIndexer.java:94)
at org.sonar.server.es.IndexerStartupTask.indexUninitializedTypes(IndexerStartupTask.java:68)
at org.sonar.server.es.IndexerStartupTask$$Lambda$953/288188659.accept(Unknown Source)
at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
at org.sonar.server.es.IndexerStartupTask.execute(IndexerStartupTask.java:55)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1$$Lambda$952/655564440.accept(Unknown Source)
at java.util.Optional.ifPresent(Optional.java:159)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:84)
at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:45)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:80)
at org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:196)
at org.sonar.server.platform.Platform.access$400(Platform.java:46)
at org.sonar.server.platform.Platform$1.lambda$doRun$1(Platform.java:121)
at org.sonar.server.platform.Platform$1$$Lambda$876/317840738.run(Unknown Source)
at org.sonar.server.platform.Platform$AutoStarterRunnable.runIfNotAborted(Platform.java:371)
at org.sonar.server.platform.Platform$1.doRun(Platform.java:121)
at org.sonar.server.platform.Platform$AutoStarterRunnable.run(Platform.java:355)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: Fail to prepare SQL request to select all issues
at org.sonar.server.issue.index.IssueIteratorForSingleChunk.createIterator(IssueIteratorForSingleChunk.java:130)
at org.sonar.server.issue.index.IssueIteratorForSingleChunk.(IssueIteratorForSingleChunk.java:117)
… 21 common frames omitted
Caused by: java.sql.SQLException: Tablespace is missing for table sonarfem.issues.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2490)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.sonar.db.ResultSetIterator.(ResultSetIterator.java:51)
at org.sonar.server.issue.index.IssueIteratorForSingleChunk$IssueIteratorInternal.(IssueIteratorForSingleChunk.java:184)
at org.sonar.server.issue.index.IssueIteratorForSingleChunk.createIterator(IssueIteratorForSingleChunk.java:127)
… 22 common frames omitted
2024.10.17 16:18:20 INFO web[o.s.p.StopWatcher] Stopping process
Means there’s a problem with your database.
You could import the database backup and see if it fixes the problem.
Did you update your Sonarqube version on October 15 ?
What’s your Sonarqube version ?
What database you’re using ?
Hi Gilbert,
Currently we are using SonarQube 6.7.3 and Mysql 5.7.
We already upgrade with SonarQube 9.9 and postgress.
But due to team blockage we have to continue using SonarQube 6.7.3 and Mysql 5.7 for next 2 months.
Also Please confirm we have deleted project from sonar API is there any way to recover the whole project again. We have DB backup.
I see two problems
Sonarqube 6.7.3 > Sonarqube 9.9 LTA is a BIG gap
The upgrade path is always your version > next LTA(S) > next LTA(S) … > LATEST (optional)
In your case 6.7.3 > 6.9 (IIRC) > 7.9.6 > 8.9.10 > 9.9.7
Did you use the correct update path !?
The historical downloads page has all versions but no 6.9.x
I once used the wayback machine for a similar case, see
As Sonarqube doesn’t support MySQL anymore, how did you convert from MySQL to PostgreSQL ?
Maybe the conversion (export from MySQL and import into PostgreSQL) is the cause for the database problems.
I’m not sure if you can use the Sonarqube db copy tool or if it only supports the copy between databases Sonarqube runs on.
I Have setup an another instance with 9.9 LTS and for the new instance no need to copy DB.
Now our main issue is that suddenly from our old server 6.7.3 all the projects are removed automatically and i want to recover that project. Please me on this.
Using the DB backup getting error like :- tablespace is missing from table
Ok, so you did not update from 6.7.3 < 9.9.LTA but started from scratch with 9.9 LTA on a new instance with PostgreSQL.
Unfortunately, I can’t help you any further with your db problem
after using the db backup in your Sonarqube 6.7.3 instance
