Lines of Code is not showing correctly, after restoring Production DB dump in to new SonarQube-6.7.5 LTS in test server

Hi,

I have installed SonarQube-6.7.5 LTS in one of the test server.

Taken DB dump from production with “pg_dump” and loaded in test instance DB and it was successfully loaded with out any errors.

But, I could see all projects list is visible under https://sonarqube-qa.xxx.in/admin/background_tasks, but i don’t see any project at https://sonarqube-qa.xxx.in/projects and i see message like

Once you analyze some projects, they will show up here.

And also i don’t see lines of code does not reflecting at https://sonarqube-qa.xxx.in/admin/system?expand=System. It should show lines code similar to production instance.

Could you please clarify, if it is expected or something could be wrong ?

Hi,

It sounds like your ElasticSearch indices are messed up. Stop the server, delete $SONARQUBE_HOME/data/es5, and restart. The incides will be rebuilt automatically.

 
Ann

Thanks a million, that worked :smile: