About gerrit upgrade from 2.4.2 to 2.9 SOP

Sam Lin

unread,

Aug 10, 2014, 11:57:52 PM8/10/14

to repo-d...@googlegroups.com

Dear Sir,

Could you provide the "gerrit upgrade from 2.4.2 to 2.9" SOP to me?

Because I had follow the step " java -jar gerrit.war init -d site_path" of Release notes for Gerrit 2.9

to upgrade, the gerrit 2.9 will can't add reviewer in patch, maybe I miss some upgrade gerrit step.

Thanks a lot!

B.Regards,
Sam Lin

Sam Lin

unread,

Aug 13, 2014, 10:36:45 PM8/13/14

to repo-d...@googlegroups.com

Could you give me a hand >"<

Sam Lin於 2014年8月11日星期一UTC+8上午11時57分52秒寫道：

Zaro

unread,

Aug 14, 2014, 11:34:41 AM8/14/14

to Sam Lin, repo-d...@googlegroups.com

please describe your specific problem then maybe someone can help.

--
--
To unsubscribe, email repo-discuss...@googlegroups.com
More info at http://groups.google.com/group/repo-discuss?hl=en

---
You received this message because you are subscribed to the Google Groups "Repo and Gerrit Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to repo-discuss...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Sam Lin

unread,

Aug 14, 2014, 9:38:57 PM8/14/14

to repo-d...@googlegroups.com, samli...@gmail.com

Dear Khai,

OK~ I will update to here, ASAP!!

Thanks for your support!

B.Regards,

Sam Lin

Khai Do於 2014年8月14日星期四UTC+8下午11時34分41秒寫道：

Sam Lin

unread,

Sep 3, 2014, 6:23:54 AM9/3/14

to repo-d...@googlegroups.com, samli...@gmail.com

Dear Khai Sir,

I had got some error in gerrit upgrade process from gerrit 2.4.2 to 2.9.

Could you help me to solve it?

Please see the attache file of error screen and the error message as below:

Migrating data to schema 76 ...

Migrating data to schema 77 ...

Migrated label types from database to All-Projects project.config

Migrating data to schema 78 ...

Migrating data to schema 79 ...

Migrating data to schema 80 ...

Migrating data to schema 81 ...

Migrating data to schema 82 ...

Migrating data to schema 83 ...

Migrating data to schema 84 ...

Migrating data to schema 85 ...

Migrating data to schema 86 ...

Migrating data to schema 87 ...

Migrating data to schema 88 ...

Migrating data to schema 89 ...

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:63)

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: Can't DROP 'patch_set_approvals_closedByU'; check that column/key exists

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_89.migrateData(Schema_89.java:45)

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

gitosis@old-mickey:~$

Sam Lin於 2014年8月15日星期五UTC+8上午9時38分57秒寫道：

error_1.jpg

Bassem Rabil

unread,

Sep 3, 2014, 8:24:29 AM9/3/14

to repo-d...@googlegroups.com, samli...@gmail.com

In Gerrit 2.9, it is assumed that there exists 2 DB indexes patch_set_approvals_openbyuser and patch_set_approvals_closedbyu. Unfortunately the upgrade is aborted if these indexes do not exist.

You can workaround this by creating these indexes prior to upgrade, for example if you use PoseGreSQL here below the commands to create these indexes:

#CREATE INDEX patch_set_approvals_openbyuser ON patch_set_approvals (change_open);

#CREATE INDEX patch_set_approvals_closedbyu ON patch_set_approvals (change_open);

Thanks and Regards

Bassem Guendy

Sam Lin

unread,

Sep 3, 2014, 11:42:08 PM9/3/14

to repo-d...@googlegroups.com, samli...@gmail.com

Dear Bassem Sir,

It's works as below! Happy!

root@old-mickey:~/Gerrit 2.9# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 11922

Server version: 5.5.35-0ubuntu0.12.04.2 (Ubuntu)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use reviewdb;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> CREATE INDEX patch_set_approvals_openbyuser ON patch_set_approvals (change_open);

Query OK, 893660 rows affected (31.60 sec)

Records: 893660 Duplicates: 0 Warnings: 0

mysql> CREATE INDEX patch_set_approvals_closedbyu ON patch_set_approvals (change_open);

Query OK, 893660 rows affected (34.69 sec)

Records: 893660 Duplicates: 0 Warnings: 0

mysql> quit

Bye

root@old-mickey:~/Gerrit 2.9#

Thanks for your great support!

B.Regards

Sam YM Lin

Bassem Rabil於 2014年9月3日星期三UTC+8下午8時24分29秒寫道：

Sam Lin

unread,

Sep 4, 2014, 4:46:57 AM9/4/14

to repo-d...@googlegroups.com, samli...@gmail.com

Dear Bassem Sir,

I had got another problem when I finish gerrit 2.9 upgrade process.

When I check gerrit error log (path: vim /srv/gitosis/gerrit/logs/error_log) , I find one error always this one as below information.

Could you help me to solve it >"<

[2014-09-04 13:12:46,014] INFO com.google.gerrit.pgm.Daemon : Gerrit Code Review 2.9 ready

[2014-09-04 13:13:00,474] ERROR com.google.gerrit.server.git.ChangeMergeQueue : Merge attempt for platform/hardware/pni,refs/heads/master failed

java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

at java.util.ArrayList.rangeCheck(ArrayList.java:635)

at java.util.ArrayList.remove(ArrayList.java:474)

at com.google.common.collect.AbstractMapBasedMultimap$WrappedList.remove(AbstractMapBasedMultimap.java:811)

at com.google.gerrit.server.git.strategy.MergeIfNecessary._run(MergeIfNecessary.java:37)

at com.google.gerrit.server.git.strategy.SubmitStrategy.run(SubmitStrategy.java:114)

at com.google.gerrit.server.git.MergeOp.preMerge(MergeOp.java:363)

at com.google.gerrit.server.git.MergeOp.merge(MergeOp.java:251)

at com.google.gerrit.server.git.ChangeMergeQueue$2.call(ChangeMergeQueue.java:210)

at com.google.gerrit.server.git.ChangeMergeQueue$2.call(ChangeMergeQueue.java:207)

at com.google.gerrit.server.util.RequestScopePropagator$5.call(RequestScopePropagator.java:222)

at com.google.gerrit.server.util.RequestScopePropagator$4.call(RequestScopePropagator.java:201)

at com.google.gerrit.server.git.PerThreadRequestScope$Propagator$1.call(PerThreadRequestScope.java:75)

at com.google.gerrit.server.git.ChangeMergeQueue.mergeImpl(ChangeMergeQueue.java:207)

at com.google.gerrit.server.git.ChangeMergeQueue.access$200(ChangeMergeQueue.java:54)

at com.google.gerrit.server.git.ChangeMergeQueue$MergeEntry.run(ChangeMergeQueue.java:250)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

at com.google.gerrit.server.git.WorkQueue$Task.run(WorkQueue.java:364)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

[2014-09-04 13:18:00,105] ERROR com.google.gerrit.server.git.ChangeMergeQueue : Merge attempt for platform/hardware/pni,refs/heads/master failed