Error when installing gerrit on debian system

[mürşit orhan]

Hi everybody,

I got the following error when the first time installing the gerrit. my system is debian and I have the open-jdk as java jdk.

what is the problem I do not understand?





 java -jar gerrit-2.8-rc3.war init -d /home/ma3/gerrit_site

*** Gerrit Code Review 2.8-rc3
***


*** Git Repositories
***

Location of Git repositories   [Git]:

*** SQL Database
***

Database server type           [h2]:

*** User Authentication
***

Authentication method          [DEVELOPMENT_BECOME_ANY_ACCOUNT/?]:

*** Email Delivery
***

SMTP server hostname           [localhost]:
SMTP server port               [(default)]:
SMTP encryption                [NONE/?]:
SMTP username                  :

*** Container Process
***

Run as                         [ma3]:
Java runtime                   [/usr/lib/jvm/java-6-openjdk/jre]:
Upgrade /home/ma3/gerrit_site/bin/gerrit.war [Y/n]?
Copying gerrit-2.8-rc3.war to /home/ma3/gerrit_site/bin/gerrit.war








*** SSH Daemon
***

Listen on address              [*]: Listen on port                 [29418]:
*** HTTP Daemon
***

Behind reverse proxy           [y/N]? Use SSL (https://)             [y/N]? Listen on address              [*]: Listen on port                 [8085]: Canonical URL                  [http://ma3groupsrv:8085/]:
*** Plugins
***


Install plugin reviewnotes version v2.8-rc3 [y/N]? Install plugin download-commands version v2.8-rc3 [y/N]?
Install plugin replication version v2.8-rc3 [y/N]?
Install plugin commit-message-length-validator version v2.8-rc3 [y/N]?


Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL
ALTER TABLE account_diff_preferences ADD context SMALLINT DEFAULT 0 NOT NULL
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)
        at com.google.gwtorm.schema.sql.DialectH2.addColumn(DialectH2.java:86)
        at com.google.gwtorm.jdbc.JdbcSchema.addColumns(JdbcSchema.java:97)
        at com.google.gwtorm.jdbc.JdbcSchema.updateSchema(JdbcSchema.java:58)
        at com.google.gerrit.server.schema.SchemaCreator.create(SchemaCreator.java:82)
        at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:55)
        at com.google.gerrit.pgm.BaseInit$SiteRun.upgradeSchema(BaseInit.java:212)
        at com.google.gerrit.pgm.BaseInit.run(BaseInit.java:91)
        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:616)
        at com.google.gerrit.launcher.GerritLauncher.invokeProgram(GerritLauncher.java:170)
        at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:94)
        at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:52)
        at Main.main(Main.java:25)
Caused by: org.h2.jdbc.JdbcSQLException: Duplicate column name "CONTEXT"; SQL statement:
ALTER TABLE account_diff_preferences ADD context SMALLINT DEFAULT 0 NOT NULL [42121-173]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
        at org.h2.message.DbException.get(DbException.java:171)
        at org.h2.message.DbException.get(DbException.java:148)
        at org.h2.table.Table.setColumns(Table.java:383)
        at org.h2.table.TableBase.<init>(TableBase.java:44)
        at org.h2.table.RegularTable.<init>(RegularTable.java:75)
        at org.h2.schema.Schema.createTable(Schema.java:566)
        at org.h2.command.ddl.AlterTableAlterColumn.cloneTableStructure(AlterTableAlterColumn.java:311)
        at org.h2.command.ddl.AlterTableAlterColumn.copyData(AlterTableAlterColumn.java:220)
        at org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:156)
        at org.h2.command.CommandContainer.update(CommandContainer.java:79)
        at org.h2.command.Command.executeUpdate(Command.java:235)
        at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)
        ... 16 more

[Shawn Pearce]

On Wed, Dec 4, 2013 at 6:36 AM, mürşit orhan <orhan...@gmail.com> wrote:
> I got the following error when the first time installing the gerrit. my
> system is debian and I have the open-jdk as java jdk.
>
> what is the problem I do not understand?
>
>
>
>
>
> java -jar gerrit-2.8-rc3.war init -d /home/ma3/gerrit_site

2.8 final was just released. I would try again using the final release version.

Are you sure the directory was a new empty directory? The error seems
like a schema upgrade was running twice.

[Michael Zhou]

Built from current master:

$: java -jar buck-out/gen/gerrit.war init -d /path/to/test_site

*** Gerrit Code Review 2.8-592-g45049a7

***

(All defaults)

...

...

No plugins found.

Upgrading schema to 88 ...

Upgrading schema to 89 ...

Migrating data to schema 88 ...

Migrating data to schema 89 ...

Execute the following SQL to drop unused objects:

  ALTER TABLE patch_set_approvals DROP COLUMN change_open;

  ALTER TABLE patch_set_approvals DROP COLUMN change_sort_key;

Execute now [Y/n]? Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL

ALTER TABLE patch_set_approvals DROP COLUMN change_open

at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)

at com.google.gerrit.pgm.BaseInit$SiteRun.upgradeSchema(BaseInit.java:259)

at com.google.gerrit.pgm.BaseInit.run(BaseInit.java:91)

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

at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:96)

at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:53)

at Main.main(Main.java:25)

Caused by: org.h2.jdbc.JdbcSQLException: Column may be referenced by "PUBLIC.PATCH_SET_APPROVALS_OPENBYUSER"; SQL statement:

ALTER TABLE patch_set_approvals DROP COLUMN change_open [90083-173]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)

at org.h2.message.DbException.get(DbException.java:171)

at org.h2.message.DbException.get(DbException.java:148)

at org.h2.table.Table.dropSingleColumnConstraintsAndIndexes(Table.java:542)

at org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:163)

at org.h2.command.CommandContainer.update(CommandContainer.java:79)

at org.h2.command.Command.executeUpdate(Command.java:235)

at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)

at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)

at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)

... 11 more

 

Seems like an upgrade was indeed running twice.

[Michael Zhou]

No it's not running twice.. I couldn't read :(

[Shawn Pearce]

...

> Caused by: org.h2.jdbc.JdbcSQLException: Column may be referenced by
> "PUBLIC.PATCH_SET_APPROVALS_OPENBYUSER"; SQL statement:
> ALTER TABLE patch_set_approvals DROP COLUMN change_open [90083-173]

This is a different error than the original poster's problem. But I am
confused about why it happened. I have a test site using H2 and I ran
the 88->89 upgrade on it today. Or at least I thought I did. Maybe I
only ran 87->88? *sigh*

Looks like 89 needs a statement added to drop the index.

[mürşit orhan]

Thanks Shawn for the quick response.
I tried to install gerrit 2.8 as you said, but I'm still getting the following error. Also the directory is created at the beginnig of the installation as you can see.



java -jar gerrit-2.8.war init -d reviewsite

*** Gerrit Code Review 2.8
***

Create '/home/ma3/reviewsite'  [Y/n]?

*** Git Repositories
***

Location of Git repositories   [git]:

*** SQL Database
***

Database server type           [h2]:

*** User Authentication
***

Authentication method          [OPENID/?]: ?
       Supported options are:
         openıd
         openıd_sso
         http
         http_ldap
         clıent_ssl_cert_ldap
         ldap
         ldap_bınd
         custom_extensıon
         development_become_any_account
Authentication method          [OPENID/?]: development_become_any_account

*** Email Delivery
***

SMTP server hostname           [localhost]:
SMTP server port               [(default)]:
SMTP encryption                [NONE/?]:
SMTP username                  :

*** Container Process
***

Run as                         [ma3]:
Java runtime                   [/usr/lib/jvm/java-6-openjdk/jre]:

Copy gerrit-2.8.war to /home/ma3/reviewsite/bin/gerrit.war [Y/n]?
Copying gerrit-2.8.war to /home/ma3/reviewsite/bin/gerrit.war

*** SSH Daemon
***

Listen on address              [*]:
Listen on port                 [29418]:

Gerrit Code Review is not shipped with Bouncy Castle Crypto v144
  If available, Gerrit can take advantage of features
  in the library, but will also function without it.
Download and install it now [Y/n]?
Downloading http://www.bouncycastle.org/download/bcprov-jdk16-144.jar ...
 OK
Checksum bcprov-jdk16-144.jar OK
Generating SSH host key ... rsa... dsa... done

*** HTTP Daemon
***

Behind reverse proxy           [y/N]? Use SSL (https://)             [y/N]?
Listen on address              [*]:

Listen on port                 [8080]:
Canonical URL                  [http://ma3groupsrv:8080/]:

*** Plugins
***

Install plugin reviewnotes version v2.8 [y/N]?
Install plugin download-commands version v2.8 [y/N]?
Install plugin replication version v2.8 [y/N]?
Install plugin commit-message-length-validator version v2.8 [y/N]?

Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL

ALTER TABLE account_diff_preferences ADD context SMALLINT DEFAULT 0 NOT NULL
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)
        at com.google.gwtorm.schema.sql.DialectH2.addColumn(DialectH2.java:86)
        at com.google.gwtorm.jdbc.JdbcSchema.addColumns(JdbcSchema.java:97)
        at com.google.gwtorm.jdbc.JdbcSchema.updateSchema(JdbcSchema.java:58)
        at com.google.gerrit.server.schema.SchemaCreator.create(SchemaCreator.java:82)
        at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:55)
        at com.google.gerrit.pgm.BaseInit$SiteRun.upgradeSchema(BaseInit.java:212)

        at com.google.gerrit.pgm.BaseInit.run(BaseInit.java:91)
        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:616)
        at com.google.gerrit.launcher.GerritLauncher.invokeProgram(GerritLauncher.java:171)
        at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:95)
        at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:52)
        at Main.main(Main.java:25)

Caused by: org.h2.jdbc.JdbcSQLException: Duplicate column name "CONTEXT"; SQL statement:
ALTER TABLE account_diff_preferences ADD context SMALLINT DEFAULT 0 NOT NULL [42121-173]

        at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
        at org.h2.message.DbException.get(DbException.java:171)
        at org.h2.message.DbException.get(DbException.java:148)

        at org.h2.table.Table.setColumns(Table.java:383)
        at org.h2.table.TableBase.<init>(TableBase.java:44)
        at org.h2.table.RegularTable.<init>(RegularTable.java:75)
        at org.h2.schema.Schema.createTable(Schema.java:566)
        at org.h2.command.ddl.AlterTableAlterColumn.cloneTableStructure(AlterTableAlterColumn.java:311)
        at org.h2.command.ddl.AlterTableAlterColumn.copyData(AlterTableAlterColumn.java:220)
        at org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:156)

        at org.h2.command.CommandContainer.update(CommandContainer.java:79)
        at org.h2.command.Command.executeUpdate(Command.java:235)
        at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)

        ... 16 more

5 Aralık 2013 Perşembe 07:52:46 UTC+2 tarihinde Shawn Pearce yazdı:

[mürşit orhan]

Another detail Shawn I want to say when I retry to install gerrit the first error disappeared and another one occured:

java -jar gerrit-2.8.war init -d reviewsite

*** Gerrit Code Review 2.8
***

*** Git Repositories
***

Location of Git repositories   [git]:

*** SQL Database
***

Database server type           [h2]:

*** User Authentication
***

Authentication method          [DEVELOPMENT_BECOME_ANY_ACCOUNT/?]:

*** Email Delivery
***

SMTP server hostname           [localhost]:
SMTP server port               [(default)]:
SMTP encryption                [NONE/?]:
SMTP username                  :

*** Container Process
***

Run as                         [ma3]:
Java runtime                   [/usr/lib/jvm/java-6-openjdk/jre]:

Upgrade /home/ma3/reviewsite/bin/gerrit.war [Y/n]?

Copying gerrit-2.8.war to /home/ma3/reviewsite/bin/gerrit.war

*** SSH Daemon
***

Listen on address              [*]:
Listen on port                 [29418]:

*** HTTP Daemon
***

Behind reverse proxy           [y/N]?
Use SSL (https://)             [y/N]?
Listen on address              [*]:
Listen on port                 [8080]:
Canonical URL                  [http://ma3groupsrv:8080/]:

*** Plugins
***

Install plugin reviewnotes version v2.8 [y/N]?
Install plugin download-commands version v2.8 [y/N]?
Install plugin replication version v2.8 [y/N]?
Install plugin commit-message-length-validator version v2.8 [y/N]?

Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL

CREATE SEQUENCE account_group_id
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)
        at com.google.gwtorm.jdbc.JdbcSchema.createSequences(JdbcSchema.java:73)
        at com.google.gwtorm.jdbc.JdbcSchema.updateSchema(JdbcSchema.java:54)

        at com.google.gerrit.server.schema.SchemaCreator.create(SchemaCreator.java:82)
        at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:55)
        at com.google.gerrit.pgm.BaseInit$SiteRun.upgradeSchema(BaseInit.java:212)
        at com.google.gerrit.pgm.BaseInit.run(BaseInit.java:91)
        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:616)
        at com.google.gerrit.launcher.GerritLauncher.invokeProgram(GerritLauncher.java:171)
        at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:95)
        at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:52)
        at Main.main(Main.java:25)

Caused by: org.h2.jdbc.JdbcSQLException: Sequence "ACCOUNT_GROUP_ID" already exists; SQL statement:
CREATE SEQUENCE account_group_id [90035-173]

        at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
        at org.h2.message.DbException.get(DbException.java:171)
        at org.h2.message.DbException.get(DbException.java:148)

        at org.h2.command.ddl.CreateSequence.update(CreateSequence.java:51)

        at org.h2.command.CommandContainer.update(CommandContainer.java:79)
        at org.h2.command.Command.executeUpdate(Command.java:235)
        at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
        at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)

        ... 15 more




5 Aralık 2013 Perşembe 08:34:20 UTC+2 tarihinde mürşit orhan yazdı: