Issue 3494: Code Review Error while displaying Projects list and and list of all Open, Merged and Abandoned reviews
Status:  New
Owner: ----
Reported by anantha....@gmail.com, Jul 24, 2015
*****************************************************************
*****                                                       *****
***** !!!! THIS BUG TRACKER IS FOR GERRIT CODE REVIEW !!!!  *****
*****                                                       *****
***** DO NOT SUBMIT BUGS FOR CHROME, ANDROID, CYANOGENMOD,  *****
***** INTERNAL ISSUES WITH YOUR COMPANY'S GERRIT SETUP, ETC.*****
*****                                                       *****
*****   THOSE ISSUES BELONG IN DIFFERENT ISSUE TRACKERS     *****
*****                                                       *****
*****************************************************************

Affected Version: 2.10 and 2.11.2

What steps will reproduce the problem?
1. I had setup Gerrit 2.9.1 on MySQL 5.5, Java 7, Tomcat 7.0.23. To upgrade to 2.11.2, we planned to upgrade it stage wise. At first to 2.10 and then Offline reindexing and then to 2.11.2 and then let Gerrit do online reindexing after its launch. Both these upgraded versions are hosted on Tomcat 8.0.23.

2. During the offline reindexing on 2.10, we got many errors as follows:

Caused by: java.lang.OutOfMemoryError: Java heap space
Exception in thread "pool-19-thread-4" java.lang.OutOfMemoryError: GC overhead limit exceeded
[2015-07-25 06:05:32,794] ERROR com.google.gerrit.sshd.BaseCommand : Internal server error (user <username> account 262) during git-upload-pack '/<ProjetName>.git'
com.google.common.util.concurrent.ExecutionError: java.lang.OutOfMemoryError: GC overhead limit exceeded

But still, the reindexing got completed and Gerrit was launched.

Gerrit_index.config was updated with "index "11""

3. After Gerrit launch, I am unable to browse Projects List. Unable to browse All Open/Merged/Abandoned reviews from the Dashboard. I get "Code Review Error - 500 Internal Server Error". Where as the search query lists the relevant reviews. 

What is the expected output? What do you see instead?
Browsing the All Open/Merged/Abandoned reviews and Projects should list them on dashboard. Instead, I get "Code Review Error - 500 Internal Server Error".

Please provide any additional information below.
The upgrade to 2.11.2 from this state has the same problem. 
I am sure, the DB has the data, could you please help me tweak the required tables so that dashboard displays it.

Jul 28, 2015
Project Member #1 bassem.rabil
The dashboards are served from the secondary index, and thus I think your issue is coming from the reindexing process. I would try to rerun the reindex program [1] with --recheck-mergeable switch and see if this would display properly changes in your dashboards. We are running here with Tomcat7 and haven't tried with Tomcat 8, thus I would suggest to keep tomcat 7 and change only the Gerrit version to avoid confusion.

[1] https://gerrit-review.googlesource.com/Documentation/pgm-reindex.html