Gerrit 安装过程中遇到的问题汇总。

最新推荐文章于 2021-08-25 09:58:31 发布

Richard_X

最新推荐文章于 2021-08-25 09:58:31 发布

阅读量2.8k

点赞数

CC 4.0 BY-SA版权

分类专栏： SCM 文章标签： ubuntu mysql gerrit

本文链接：https://blog.youkuaiyun.com/qq_34213699/article/details/72540843

SCM 专栏收录该内容

1 篇文章

订阅专栏

本文解决MySQL中timestamp字段默认值问题及Ubuntu系统SSH连接旧版主机时遇到的密钥交换方法不匹配问题，提供了详细的步骤说明。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

１．　MySQL Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper

错误信息：

　　Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL
CREATE TABLE account_group_by_id_aud (
added_by INT DEFAULT 0 NOT NULL,
removed_by INT,
removed_on TIMESTAMP NULL DEFAULT NULL,
group_id INT DEFAULT 0 NOT NULL,
include_uuid VARCHAR(255) BINARY DEFAULT '' NOT NULL,
added_on TIMESTAMP NOT NULL
,PRIMARY KEY(group_id,include_uuid,added_on)
)
   at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)
   at com.google.gwtorm.jdbc.JdbcSchema.createRelations(JdbcSchema.java:119)
   at com.google.gwtorm.jdbc.JdbcSchema.updateSchema(JdbcSchema.java:89)
   at com.google.gerrit.server.schema.SchemaCreator.create(SchemaCreator.java:77)
   at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:99)
   at com.google.gerrit.pgm.init.BaseInit$SiteRun.upgradeSchema(BaseInit.java:339)
   at com.google.gerrit.pgm.init.BaseInit.run(BaseInit.java:120)
   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:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   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: Invalid default value for 'added_on'
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   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.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:888)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:730)
   at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)
   ... 15 more

　　解决方法：

　　使用MySQL root用户登录设置
set global explicit_defaults_for_timestamp=1; 重新安装gerrit即可新版本的mysql timestamp默认值的问题需要手动配置一下

2. ubuntu 16.04 ssh 7.0 issue

error message:
Unable to negotiate with legacyhost: no matching key exchange method found.
Their offer: diffie-hellman-group1-sha1

solution:
ssh -oKexAlgorithms=+diffie-hellman-group1-sha1 user@legacyhost

or in the ~/.ssh/config file:

Host somehost.example.org
	KexAlgorithms +diffie-hellman-group1-sha1

ssh legacy document:

http://www.openssh.com/legacy.html

gerrit 配置文档

https://gerrit-documentation.storage.googleapis.com/Documentation/2.11/config-gerrit.html#index