My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 1580: Upgrade 2.4.2 to 2.5-rc0 warning SUBMODULE_SUBSCRIPTION_ACCESS_BYSUBSCRIPTION exists
2 people starred this issue and may be notified of changes. Back to list
Status:  WontFix
Owner:  ----
Closed:  Jan 2013


Sign in to add a comment
 
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
Sign in to add a comment

Powered by Google Project Hosting