Issue 1817: update ownerGroupID to ownerGroupUUID failing
Status:  AwaitingInformation
Owner: ----
Reported by simon.ga...@scilab-enterprises.com, Mar 7, 2013
************************************************************
***** 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:
upgrade from 2.4.2 to 2.5.2
What steps will reproduce the problem?
1.java -jar gerrit-full-2.5.2.war init -d /home/git/gerrit-2.5.2
2.
3.

What is the expected output? What do you see instead?
upgrade of the different schemas work fine until the 66 to 67. at 66 to 67, I get the Update ownerGroupID to ownerGroupUUID, then

Exception in thread "main" java.lang.NullPointerException
	at com.google.gerrit.server.schema.Schema_67.migrateData(Schema_67.java:87)
	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.SchemaVersion.upgradeFrom(SchemaVersion.java:86)
	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.SchemaVersion.upgradeFrom(SchemaVersion.java:86)
	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.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:64)
	at com.google.gerrit.pgm.Init$SiteRun.upgradeSchema(Init.java:181)
	at com.google.gerrit.pgm.Init.run(Init.java:79)
	at com.google.gerrit.pgm.util.AbstractProgram.main(AbstractProgram.java:67)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.google.gerrit.launcher.GerritLauncher.invokeProgram(GerritLauncher.java:168)
	at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:92)
	at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:50)
	at Main.main(Main.java:25)

from the git repo of gerrit here (https://code.google.com/p/gerrit/source/browse/gerrit-server/src/main/java/com/google/gerrit/server/schema/Schema_67.java?spec=svn60b7fbe665f555dd4d539db0c87188319928c281&r=60b7fbe665f555dd4d539db0c87188319928c281), I looked if the SELECT was working or not, it returns:
+----------+----------------+
| group_id | owner_group_id |
+----------+----------------+
|        1 |             27 |
|        2 |             27 |
|        3 |             27 |
|        6 |             27 |
|        5 |              5 |
|        7 |             27 |
|        8 |             27 |
|        9 |             27 |
|       10 |             27 |
|       12 |             12 |
|       14 |              1 |
|       13 |              1 |
|       16 |             16 |
|       17 |             17 |
|       18 |             18 |
|       19 |             19 |
|       20 |             20 |
|       21 |             21 |
|       22 |             22 |
+----------+----------------+

If the owner_group_id columns indicates the id of the owner of a group (hence, the id of an account), most of them are disabled. I tried changing all the owners to the administrator account (27), to no success. I would greatly appreciate some help to fix this and be able to finish the upgrade.



Mar 7, 2013
#1 sop@google.com
Looks like group 27 is not defined in the groups table.
The owner_group_id must be a valid value from group_id.

I think you meant to set owner_group_id=1 where you
used 27. On most installations group 1 is Administrators.
IIRC in this schema version you can look at system_config
and still find the administrator group id.
Status: AwaitingInformation
Mar 8, 2013
#2 simon.ga...@scilab-enterprises.com
Indeed, this fixed the problem, the installation went on successfully.
Thanks a lot for the help, and for the tool!

Simon