Files
zhengwr 3b59e90504 P3-3: Flowable 5.13-SNAPSHOT→6.8.1 升级工具链产品化 + 演练全绿
一键链(tools/flowable-upgrade/):
  ①前置校验→②版本串规范化→③Flowable 5.23→④6.8.1 兼容层→⑤后置校验
  全步骤幂等可重入;参数化 host/port/db/schema;JAVA_HOME 强制传 Maven。

完整重演(eip4flow_rehearsal,客户库只读口径):
  import_5x 63s | 一键链 21s | 后置全绿
  1515 定义 / 9386 执行 / 9324 任务 / 26761 历史 全量就地保留
  schema.version: 5.13-SNAPSHOT → 5.23.0.0 → 6.8.1.0
  engineVer=v5 标记: 1515/1515

迁移手册新增坑6.4: Maven exec:java 在多 JDK 环境不走脚本 JAVA_HOME。

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
2026-06-11 14:31:29 +08:00

56 lines
2.6 KiB
Bash
Executable File

#!/usr/bin/env bash
# 01_precheck.sh —— ① 前置校验:源库版本串 / 表清单 / 行数快照 + 备份确认
# 幂等:纯只读 + 写快照文件(覆盖);可任意重跑。
set -euo pipefail
HERE="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
source "${HERE}/common.sh"
log "① 前置校验 @ ${TGT_HOST}:${TGT_PORT}/${TGT_DB} (schema=${TGT_SCHEMA})"
begin_timer
# --- 连通性 + schema 存在 ---
tpsql -tc "SET search_path TO ${TGT_SCHEMA}; SELECT 1" >/dev/null \
|| die "目标库不可达或 schema ${TGT_SCHEMA} 不存在"
ok "目标库连通,schema ${TGT_SCHEMA} 存在"
# --- 当前引擎版本串(坑6.1 判定) ---
VER=$(tpsql -tA -c "SELECT value_ FROM ${TGT_SCHEMA}.act_ge_property WHERE name_='schema.version'")
log "当前 schema.version = ${VER:-<空>}"
case "${VER}" in
5.13-SNAPSHOT) ok "命中已知形态 5.13-SNAPSHOT —— 需 ② 规范化(坑6.1)" ;;
5.13) warn "已是 5.13(规范化已做过?)—— ② 步将幂等跳过" ;;
5.2[0-9]*|5.23*) warn "已达 v5 末版,③ 步可能已执行" ;;
6.*) warn "已是 v6,升级链疑似已完成" ;;
"") die "act_ge_property 无 schema.version 行 —— 非 Flowable/Activiti 库或未初始化" ;;
*) warn "未知版本串 ${VER},继续前请人工确认升级路径" ;;
esac
# --- 表清单核对(全量运行时表必须存在) ---
MISSING=""
for t in ${ACT_FULL}; do
exist=$(tpsql -tA -c "SELECT to_regclass('${TGT_SCHEMA}.${t}') IS NOT NULL")
[ "${exist}" = "t" ] || MISSING="${MISSING} ${t}"
done
[ -z "${MISSING}" ] && ok "全量运行时表齐全(${ACT_FULL// /, } 共 $(echo ${ACT_FULL}|wc -w|tr -d ' ') 张)" \
|| warn "缺表:${MISSING}(若为 act_id_* 等空表,5.13 库可能本就未建,后续引擎会补建)"
# --- 行数快照(前置基线) ---
SNAP="${WORK_DIR}/snapshot_pre.tsv"
tpsql -c "SET search_path TO ${TGT_SCHEMA}" -f "${TOOL_DIR}/sql/snapshot.sql" > "${SNAP}" 2>/dev/null \
|| die "行数快照失败"
ok "前置行数快照 -> ${SNAP}"
column -t -s $'\t' "${SNAP}" | sed 's/^/ /'
# --- 备份确认(不自动备份;要求显式确认或环境标记) ---
if [ "${ASSUME_BACKED_UP:-}" = "1" ]; then
ok "ASSUME_BACKED_UP=1 —— 跳过交互(演练/CI 场景)"
else
warn "生产红线:不可逆变更前必须有【已验证可恢复】的全量备份(回退点 A)"
warn "确认源库已物理冷备并验证后,重跑并加 ASSUME_BACKED_UP=1,或在此回车继续"
read -r -p " 已完成备份?(yes 继续 / 其它中止): " ans
[ "${ans}" = "yes" ] || die "未确认备份,中止"
fi
end_timer "01_precheck"
log "① 前置校验通过"