The Projects page is empty after a database restore

sonarqube
postgres

(Adrian Blakey) #1

Is there some way to restore the contents of the Projects page?

I am running in docker containers.

SQ 7.1, community docker alpine - sonarqube:7.1-alpine
Postgres 11 docker - postgres:11.0-alpine

I had to restore the database using pg_restore.
Everything is back up and running but there is no data in the Projects page, even though as admin the projects are available in Administration->Projects->Management


(G Ann Campbell) #2

Hi,

It sounds like you have a corrupt Elasticsearch index. Try

  • stop server
  • delete $SONARQUBE_HOME/data/es5
  • restart server

This will force ES to rebuild the indices.

 
Ann


(Adrian Blakey) #3

I’l give it a shot - TY


(Adrian Blakey) #4

Ann:

There isn’t a directory called $SONARQUBE_HOME/data/es5

The only thing in $SONARQUBE_HOME/data is a README file that says it’s where the embedded database will save files.

I also ran a find . | grep es5 - no results either …

Any other ideas?

There is an $SONARQUBE_HOME/elasticsearch with LICENSE.txt NOTICE.txt README.textile VERSION.txt bin config lib modules plugins
in it - but none of those look like indexes …


(G Ann Campbell) #5

Hi,

Check sonar.properties to see if ES has been configured for another directory.

 
Ann


(Adrian Blakey) #6

You were right. I was attaching to the docker image incorrectly. I deleted the directory and restarted to recover “Projects.” TY.