Issue 1580: Upgrade 2.4.2 to 2.5-rc0 warning SUBMODULE_SUBSCRIPTION_ACCESS_BYSUBSCRIPTION exists
Status:  WontFix
Owner: ----
Closed:  Jan 2013
Reported by wer...@beroux.com, Sep 24, 2012
During java -jar  gerrit-full-2.5-rc0.war init
...

Upgrading database schema from version 67 to 68 ...
warning: Cannot create index for submodule subscriptions
Index "SUBMODULE_SUBSCRIPTION_ACCESS_BYSUBSCRIPTION" already exists; SQL statement:
CREATE INDEX submodule_subscription_access_bySubscription ON submodule_subscriptions (submodule_project_name, submodule_branch_name) [42111-147]
Ignore warning and proceed with schema upgrade [y/N]? y
Upgrading database schema from version 68 to 69 ...
Upgrading database schema from version 69 to 70 ...
Upgrading database schema from version 70 to 71 ...
Upgrading database schema from version 71 to 72 ...
Execute the following SQL to drop unused objects:

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

No warning.

Running on Windows x64, Java7.
Started from Gerrit around version 2.3x and upgraded progressively.
Sep 24, 2012
#1 wer...@beroux.com
Differences found in that table between the default empty init and my *failed* upgrade:

MY UPGRADED:

Indexes on SUBMODULE_SUBSCRIPTIONS:
  PRIMARY_KEY_4B UNIQUE (SUPER_PROJECT_PROJECT_NAME, SUPER_PROJECT_BRANCH_NAME, SUBMODULE_PATH)
  SUBMODULE_SUBSCRIPTION_ACCESS_BYSUBSCRIPTION (SUBMODULE_PROJECT_NAME, SUBMODULE_BRANCH_NAME)

DEFAULT, HAS NO 'B':

Indexes on SUBMODULE_SUBSCRIPTIONS:
  PRIMARY_KEY_4 UNIQUE (SUPER_PROJECT_PROJECT_NAME, SUPER_PROJECT_BRANCH_NAME, SUBMODULE_PATH)
  SUBMODULE_SUBSCRIPTION_ACCESS_BYSUBSCRIPTION (SUBMODULE_PROJECT_NAME, SUBMODULE_BRANCH_NAME)
Jan 5, 2013
Project Member #3 edwin.ke...@gmail.com
The warning on schema-upgrade is indended and is documented in the Gerrit 2.5 release notes [1].

[1] http://gerrit-documentation.googlecode.com/svn/ReleaseNotes/ReleaseNotes-2.5.html#_warning_on_upgrade_to_schema_version_68
Status: WontFix