Issue with 2.8.5 -> 2.12.7 upgrade with postgres

23 views
Skip to first unread message

RJ

unread,
Sep 5, 2018, 7:26:54 PM9/5/18
to Repo and Gerrit Discussion

Hello,

Trying to upgrade instance from 2.8.5 to 2.12.7  with Postgres 8.4.20 as DB. Stuck with below error.  

Not sure why it is looking for DROP INDEX patch_set_approvals_openByUser as am not able to observe this on DB with 2.8.5 version.  Had other instance with MYSQL which have no issues with the upgrade


Appreciate on suggestions to bypass below error


Migrating data to schema 88 ...
Migrating data to schema 89 ...
Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL
DROP INDEX patch_set_approvals_openByUser
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)
        at com.google.gwtorm.schema.sql.SqlDialect.dropIndex(SqlDialect.java:399)
        at com.google.gerrit.server.schema.Schema_89.migrateData(Schema_89.java:38)
        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)
        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(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: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.postgresql.util.PSQLException: ERROR: index "patch_set_approvals_openbyuser" does not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)
        ... 17 more

Matthias Sohn

unread,
Sep 5, 2018, 7:46:41 PM9/5/18
to RJ, Repo and Gerrit Discussion
I found the following conversation in the Gerrit mailing list archive:

You should also read the release notes [1] for all the versions between 2.8.5 and 2.12.7

I think you should consider to upgrade to at least 2.12.8 (latest release is 2.15.3) since this service release
contains more fixes including a fix for a jsch vulnerability.


-Matthias 

Ravi Jaladi

unread,
Sep 5, 2018, 8:47:12 PM9/5/18
to matthi...@gmail.com, repo-d...@googlegroups.com
Hello Matthias,

    Thanks for the info. After making below changes  moved fwd, but stuck with "index "changes_byprojectopen" does not exist"

Any suggestions on what could be the "Create" command here? as below command did not work

CREATE INDEX changes_byprojectopen ON changes (change_open);





Worked :

#CREATE INDEX patch_set_approvals_openbyuser ON patch_set_approvals (change_open);
#CREATE INDEX patch_set_approvals_closedbyu ON patch_set_approvals (change_open);


error :


done
Migrating data to schema 102 ...
Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL
DROP INDEX changes_byProjectOpen
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)
        at com.google.gwtorm.schema.sql.SqlDialect.dropIndex(SqlDialect.java:399)
        at com.google.gerrit.server.schema.Schema_102.migrateData(Schema_102.java:57)
        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)
        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(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: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.postgresql.util.PSQLException: ERROR: index "changes_byprojectopen" does not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)



Thanks,
Ravi Jaladi

RJ

unread,
Sep 5, 2018, 9:04:08 PM9/5/18
to Repo and Gerrit Discussion


Bellow changed worked. Able to move fwd with the upgrade

#CREATE INDEX changes_byProjectOpen ON changes (dest_project_name);

Thanks


#CREATE INDEX changes_byProjectOpen ON changes (dest_project_name);
Reply all
Reply to author
Forward
0 new messages