# The Projects page is empty after a database restore

**URL:** <https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728>\
**Category:** SonarQube Server / Community Build\
**Tags:** postgres, sonarqube\
**Created:** [April 11, 2019, 4:21pm UTC](https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728 "2019-04-11T16:21:01Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![adrianblakey](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@adrianblakey](https://community.sonarsource.com/u/adrianblakey)\
**Post date:** [April 11, 2019, 4:21pm UTC](https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728/1 "2019-04-11T16:21:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ganncamp](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/ganncamp/32/1261_2.png) [@ganncamp](https://community.sonarsource.com/u/ganncamp)\
**Post date:** [April 12, 2019, 5:11pm UTC](https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728/2 "2019-04-12T17:11:25Z")

</div>

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.

&nbsp;  
Ann

---

<div class="post-metadata">

**Author:** ![adrianblakey](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@adrianblakey](https://community.sonarsource.com/u/adrianblakey)\
**Post date:** [April 12, 2019, 5:12pm UTC](https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728/3 "2019-04-12T17:12:40Z")

</div>

I’l give it a shot - TY

---

<div class="post-metadata">

**Author:** ![adrianblakey](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@adrianblakey](https://community.sonarsource.com/u/adrianblakey)\
**Post date:** [April 15, 2019, 11:35pm UTC](https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728/4 "2019-04-15T23:35:45Z")

</div>

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 …

---

<div class="post-metadata">

**Author:** ![ganncamp](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/ganncamp/32/1261_2.png) [@ganncamp](https://community.sonarsource.com/u/ganncamp)\
**Post date:** [April 16, 2019, 1:03pm UTC](https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728/5 "2019-04-16T13:03:46Z")

</div>

Hi,

Check `sonar.properties` to see if ES has been [configured for another directory](https://docs.sonarqube.org/latest/setup/install-server/#header-2).

&nbsp;  
Ann

---

<div class="post-metadata">

**Author:** ![adrianblakey](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@adrianblakey](https://community.sonarsource.com/u/adrianblakey)\
**Post date:** [April 23, 2019, 10:27pm UTC](https://community.sonarsource.com/t/the-projects-page-is-empty-after-a-database-restore/8728/6 "2019-04-23T22:27:29Z")

</div>

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