Issue 3740: Error upgrading from 2.9 to 2.12
Status:  Duplicate
Merged:  issue 3669
Owner: ----
Closed:  Jan 3
Reported by org...@gmail.com, Dec 29, 2015
Affected Version: 2.12

What steps will reproduce the problem?
1. Upgrade gerrit from 2.9 to 2.12

What is the expected output? What do you see instead?
It should work. It raises an exception.

Upgrading schema to 115 ...
Migrating data to schema 115 ...
Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot upgrade schema
        at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:109)
        at com.google.gerrit.pgm.init.BaseInit$SiteRun.upgradeSchema(BaseInit.java:341)
        at com.google.gerrit.pgm.init.BaseInit.run(BaseInit.java:127)
        at com.google.gerrit.pgm.util.AbstractProgram.main(AbstractProgram.java:64)
        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:159)
        at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:100)
        at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:56)
        at Main.main(Main.java:25)
Caused by: org.h2.jdbc.JdbcSQLException: Column "HIDE_EMPTY_PANE" not found; SQL statement:
SELECT id, context, expand_all_comments, hide_line_numbers, hide_top_menu, ignore_whitespace, intraline_difference, line_length, manual_review, render_entire_file, retain_header, show_line_endings, show_tabs, show_whitespace_errors, skip_deleted, skip_uncommented, syntax_highlighting, tab_size, theme, hide_empty_pane,auto_hide_diff_table_header FROM account_diff_preferences [42122-176]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
        at org.h2.message.DbException.get(DbException.java:178)
        at org.h2.message.DbException.get(DbException.java:154)
        at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:148)
        at org.h2.command.dml.Select.prepare(Select.java:831)
        at org.h2.command.Parser.prepareCommand(Parser.java:248)
        at org.h2.engine.Session.prepareLocal(Session.java:442)
        at org.h2.engine.Session.prepareCommand(Session.java:384)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
        at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:75)
        at com.google.gerrit.server.schema.Schema_115.migrateData(Schema_115.java:74)
        at com.google.gerrit.server.schema.SchemaVersion.migrateData(SchemaVersion.java:141)
        at com.google.gerrit.server.schema.SchemaVersion.upgradeFrom(SchemaVersion.java:80)
        at com.google.gerrit.server.schema.SchemaVersion.check(SchemaVersion.java:71)
        at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:107)
        ... 11 more


Please provide any additional information below.
Upgrading from 2.9 to 2.11, then from 2.11 to 2.12 works fine.
Jan 3 (6 days ago)
Project Member #2 u.wol...@gmail.com
(No comment was entered for this change.)
Status: Duplicate
Mergedinto: 3669