Issue 2788: Failed on upgrade to 2.10rc0 on mysql db
Status:  Released
Owner: ----
Closed:  Jul 2014
Reported by Mashintsev, Jul 21, 2014
Affected Version: 2.10RC0

Problem in com.google.gerrit.server.schema.Schema_98.migrateData(Schema_98.java:37).
For MySQL DB table "ACCOUNTS" should be lowercase.

What steps will reproduce the problem?
1. Build gerrit project by buck
2. run java -jar gerrit.war init -d site_path

Output:

Upgrading schema to 98 ...
Migrating data to schema 98 ...
Migrate user preference showUserInReview to reviewCategoryStrategy
Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot upgrade schema
	at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:66)
	at com.google.gerrit.pgm.BaseInit$SiteRun.upgradeSchema(BaseInit.java:254)
	at com.google.gerrit.pgm.BaseInit.run(BaseInit.java:112)
	at com.google.gerrit.pgm.util.AbstractProgram.main(AbstractProgram.java:64)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.google.gerrit.launcher.GerritLauncher.invokeProgram(GerritLauncher.java:166)
	at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:93)
	at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:50)
	at Main.main(Main.java:25)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'reviewdb.ACCOUNTS' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1794)
	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1712)
	at com.google.gerrit.server.schema.Schema_98.migrateData(Schema_98.java:37)
	at com.google.gerrit.server.schema.SchemaVersion.migrateData(SchemaVersion.java:143)
	at com.google.gerrit.server.schema.SchemaVersion.upgradeFrom(SchemaVersion.java:88)
	at com.google.gerrit.server.schema.SchemaVersion.check(SchemaVersion.java:79)
	at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:64)
	... 11 more


Jul 21, 2014
Project Member #1 David.Os...@gmail.com
https://gerrit-review.googlesource.com/58746
Status: ChangeUnderReview
Jul 22, 2014
Project Member #2 david.pu...@sonymobile.com
(No comment was entered for this change.)
Status: Submitted
Labels: FixedIn-2.10
Jan 27, 2015
Project Member #3 ziv...@gmail.com
(No comment was entered for this change.)
Status: Released