Issue 2828: Gerrit 2.9 is missing the tracking_ids table
Status:  WontFix
Owner: ----
Closed:  Aug 2014
Reported by zindagir...@gmail.com, Aug 13, 2014
************************************************************
***** NOTE: THIS BUG TRACKER IS FOR GERRIT CODE REVIEW *****
***** DO NOT SUBMIT BUGS FOR CHROME, ANDROID, INTERNAL *****
***** ISSUES WITH YOUR COMPANY'S GERRIT SETUP, ETC.    *****
***** THOSE ISSUE BELONG IN DIFFERENT ISSUE TRACKERS!  *****
************************************************************

Affected Version: 2.9

What steps will reproduce the problem?
1. Upgrade gerrit from 2.8 to 2.9 by initiating the site
2. Run reindexing ->  java -jar gerrit.war reindex --recheck-mergeable -d site_path
3. start the server
4. login to mysql database

What is the expected output? What do you see instead?

There is no tracking_ids table.

Please provide any additional information below.

Aug 13, 2014
#1 dborowitz@google.com
This was intentionally removed. The underlying database format is not guaranteed to be stable, but the REST API (including searching by bug ID) is.

What are you trying to do with this table? Can it not be done with the REST API?
Status: WontFix
Aug 14, 2014
#2 zindagir...@gmail.com
I have not tried REST API, hopefully it should be done via that. 
I can still search the newly generated issues, but I am concerned about the issues which had been generated before the upgrade as I cannot search them (coz the table has been removed from the DB)

I would like to know where is it storing the information for tracking_system & tracking key if not in database?
Aug 14, 2014
#3 dborowitz@google.com
Are you not able to search for old issues?

The issues are stored as fields on the change documents that Lucene indexes. We do not provide a way to list all distinct issue IDs extracted from all changes, but it's there somewhere.