My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 3483: Gerrit is not reading reviewdb database
1 person starred this issue and may be notified of changes. Back to list
Status:  Invalid
Owner:  ----
Closed:  Jul 20


Sign in to add a comment
 
Reported by arunjobe...@gmail.com, Jul 16, 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: Gerrit 2.10

What steps will reproduce the problem?
1. Take dump of reviewdb database from Gerrit A server. Gerrit 2.10 version, and mysql 14.14 Distrib 5.6.23 for Linux
2. Load the dump of reviewdb database in Gerrit B server. Gerrit 2.10 version, and mysql 14.14 Distrib 5.6.25 for Linux 
3. Restart mysql and Restart Gerrit.

What is the expected output? What do you see instead?
Gerrit B server should display all the data which is in Gerrit A also.


Please provide any additional information below.

I am trying to set up back up server of Gerrit. Both the versions are 2.10, both are using mysql.
I have taken reviewdb dump from Server A and loaded in Server B.

when I hit the page http://serverBipaddress:8080 I do not see data which is in http://serverAipaddress:8080

But, when I log in my mysql and check reviewdb. It is loaded properly and I could able to see all the tables.

How to fix this ?
Many thanks for your replies.

Jul 17, 2015
Project Member #1 bassem.rabil
The information displayed mainly in Gerrit dashboards is coming from secondary index which is by default stored at: $REVIEW_SITE/index. You need to copy this directory from A Server to B server to display the same information in Gerrit dashboards and screens.
Jul 17, 2015
#2 arunjobe...@gmail.com
Hey Baseem.Rabil. Many many thanks to you !. This fixed my issue. You are amazing. I was scratching my head since 2 days to fix this.
Once again many thanks. 
Jul 20, 2015
Project Member #3 edwin.ke...@gmail.com
(No comment was entered for this change.)
Status: Invalid
Jul 28, 2015
#4 arunjobe...@gmail.com
Hi Baseem.Rabil, I am facing this below issue even after doing the sync of index directory.
 
I have taken dump of reviewdb in mysql of Gerrit A server and 
loaded the reviewdb dump file in mysql of Gerrit B server.

Both dumping and loading seems to be successful.  

But, when I check my tables, data inside the tables seem to be different even after taking the dump and loading it. 

Server A has 56 rows in the table account_group_names.
And, 
Server B should also contain 56 rows in the table account_group_names.

But it is still showing the old data which is 40 rows.

what could be the issue. Please help
Sign in to add a comment

Powered by Google Project Hosting