Issue 916: Upgrade failed from 2.1.5 to 2.1.6.1
Status:  WontFix
Owner: ----
Closed:  Apr 2011
Reported by bryan.Leong.g@gmail.com, Apr 21, 2011
Affected Version:

What steps will reproduce the problem?
1. Current version 2.1.5.
2. java -jar gerrit-2.1.6.1.war init -d /opt/gerrit2/

What is the expected output? What do you see instead?
Please refer to the message below.


gerrit2@gerrit2:~$ java -jar ./gerrit-2.1.6.1.war init -d /opt/gerrit2/

*** Gerrit Code Review 2.1.6.1
*** 


*** Git Repositories
*** 

Location of Git repositories   [git]: 
Import existing repositories   [Y/n]? 

*** SQL Database
*** 

Database server type           [MYSQL/?]: 
Server hostname                [localhost]: 
Server port                    [(MYSQL default)]: 
Database name                  [reviewdb]: 
Database username              [gerrit2]: 
Change gerrit2's password      [y/N]? 

*** User Authentication
*** 

Authentication method          [OPENID/?]: 

*** Email Delivery
*** 

SMTP server hostname           [127.0.0.1]: 
SMTP server port               [(default)]: 
SMTP encryption                [NONE/?]: 
SMTP username                  [gerrit2]: 
gerrit2's password             : 
              confirm password : 

*** Container Process
*** 

Run as                         [gerrit2]: 
Java runtime                   [/usr/java/jre1.6.0_17]: 
Upgrade /opt/gerrit2/bin/gerrit.war [Y/n]? 
Copying gerrit.war to /opt/gerrit2/bin/gerrit.war

*** SSH Daemon
*** 

Listen on address              [*]: 
Listen on port                 [29418]: 

*** HTTP Daemon
*** 

Behind reverse proxy           [y/N]? 
Use SSL (https://             [y/N]? 
Listen on address              [*]: 
Listen on port                 [8080]: 
Canonical URL                  [http://att-review.8800.org:8080/]:

Upgrading database schema from version 40 to 41 ...
Upgrading database schema from version 41 to 42 ...
Upgrading database schema from version 42 to 43 ...
Upgrading database schema from version 43 to 44 ...
Upgrading database schema from version 44 to 45 ...
Upgrading database schema from version 45 to 46 ...
Exception in thread "main" com.google.gwtorm.client.OrmException: insert failure on account_group_names
        at com.google.gwtorm.schema.sql.SqlDialect.convertError(SqlDialect.java:122)
        at com.google.gwtorm.jdbc.JdbcAccess.convertError(JdbcAccess.java:331)
        at com.google.gwtorm.jdbc.JdbcAccess.doInsert(JdbcAccess.java:178)
        at com.google.gwtorm.jdbc.JdbcAccess.doInsert(JdbcAccess.java:35)
        at com.google.gwtorm.client.impl.AbstractAccess.insert(AbstractAccess.java:56)
        at com.google.gerrit.server.schema.Schema_46.migrateData(Schema_46.java:59)
        at com.google.gerrit.server.schema.SchemaVersion.upgradeFrom(SchemaVersion.java:95)
        at com.google.gerrit.server.schema.SchemaVersion.check(SchemaVersion.java:77)
        at com.google.gerrit.server.schema.SchemaVersion.upgradeFrom(SchemaVersion.java:86)
        at com.google.gerrit.server.schema.SchemaVersion.check(SchemaVersion.java:77)
        at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:56)
        at com.google.gerrit.pgm.Init$SiteRun.upgradeSchema(Init.java:190)
        at com.google.gerrit.pgm.Init.run(Init.java:85)
        at com.google.gerrit.pgm.util.AbstractProgram.main(AbstractProgram.java:76)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.google.gerrit.launcher.GerritLauncher.invokeProgram(GerritLauncher.java:155)
        at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:89)
        at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:47)
        at Main.main(Main.java:25)
Caused by: java.sql.BatchUpdateException: Duplicate entry 'Project Owners' for key 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
        at com.google.gwtorm.jdbc.JdbcAccess.execute(JdbcAccess.java:293)
        at com.google.gwtorm.jdbc.JdbcAccess.doInsert(JdbcAccess.java:171)
        ... 19 more

Apr 21, 2011
Project Member #1 edwin.ke...@gmail.com
The upgrade introduces a new system group called 'Project Owners'.
The error above occurs if you have already created a group with exactly this name before the migration...
As workaround, first rename your existing 'Project Owners' group and afterwards rerun the upgrade.
Apr 21, 2011
#2 sop@google.com
(No comment was entered for this change.)
Status: WontFix