機能 #54
高橋 徹 さんが約8年前に更新
GitBucket 3.10から、内蔵するH2 databaseのバージョンが1.8から1.9に変更されました。
それに伴い、GitBucket 3.9以前から3.10以降にアップデートするとデータベース（スキーマ？）の不整合で起動できなくなってしまいます。
そこで、h2 migrationツールをGitBucket PRMに含めます。
https://github.com/gitbucket/h2-migration
RPMの修正事項は次のとおり
* h2 migrationツールを含める
* h2 migrationスクリプトの修正（パス）
* RPMパッケージインストール後のサービス起動を抑止
（参考）エラーメッセージは次です。
<pre>
org.h2.jdbc.JdbcSQLException: テーブル "ACTIVITY" が見つかりません
Table "ACTIVITY" not found; SQL statement:
select x2.x3, x2.x4, x2.x5, x2.x6, x2.x7, x2.x8, x2.x9, x2.x10 from (select x11.x12 as x9, x11.x13 as
x6, x11.x14 as x5, x11.x15 as x4, x11.x16 as x8, x11.x17 as x10, x11.x18 as x3, x11.x19 as x7 from
(select x20."ACTIVITY_DATE" as x12, x20."ACTIVITY_TYPE" as x13, x20."ACTIVITY_USER_NAME" as x14,
x20."REPOSITORY_NAME" as x15, x20."ADDITIONAL_INFO" as x16, x20."ACTIVITY_ID" as x17, x20."USER_NAME" as
x18, x20."MESSAGE" as x19 from "ACTIVITY" x20) x11 inner join (select x21."UPDATED_DATE" as x22,
x21."PARENT_REPOSITORY_NAME" as x23, x21."DEFAULT_BRANCH" as x24, x21."DESCRIPTION" as x25,
x21."ORIGIN_REPOSITORY_NAME" as x26, x21."ORIGIN_USER_NAME" as x27, x21."PARENT_USER_NAME" as x28,
x21."PRIVATE" as x29, x21."REPOSITORY_NAME" as x30, x21."USER_NAME" as x31, x21."REGISTERED_DATE" as
x32, x21."LAST_ACTIVITY_DATE" as x33 from "REPOSITORY" x21) x34 on (x11.x18 = x34.x31) and (x11.x15 =
x34.x30) where x34.x29 = ? order by x11.x17 desc limit 30) x2 [42102-190]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
:（中略）
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:665)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:385)
at scala.slick.jdbc.JdbcBackend$SessionDef$class.prepareStatement(JdbcBackend.scala:152)
:（後略）
</pre>
戻る