f89e074dd1
Governed substrate for autonomous agents: scoped identity (passports), audited actions, MCP workspace. Infra IPs and secrets redacted for public release.
73 lines
2.8 KiB
Bash
Executable file
73 lines
2.8 KiB
Bash
Executable file
#!/usr/bin/env bash
|
|
# ADR-0030 Phase 2 — Rollback / disable script.
|
|
#
|
|
# Phase 2 introduces:
|
|
# - backend/services/agent-run-dispatcher/index.js (new file)
|
|
# - backend/routes/v3/agentRunDispatcher.js (new file)
|
|
# - server.js: import + init + shutdown + route mount (in-place edits)
|
|
#
|
|
# There is NO new DB schema in Phase 2 — all schema lives in Phase 1
|
|
# (rollback there: scripts/rollback/adr-0030-p1-down.sql). This script
|
|
# clears any run_state values left behind by dry-run cancellations and
|
|
# disables the worker via env-flag flip — code stays in place, behavior
|
|
# does not.
|
|
#
|
|
# Idempotent. Safe to run multiple times.
|
|
#
|
|
# Usage:
|
|
# bash scripts/rollback/adr-0030-p2-down.sh # disable + cleanup
|
|
# DRY_RUN=1 bash scripts/rollback/adr-0030-p2-down.sh # show what it would do
|
|
# PG_DB=godcrm_test bash scripts/rollback/adr-0030-p2-down.sh # custom DB target
|
|
#
|
|
# To revert the code itself (delete the dispatcher service + route): use
|
|
# git revert / git reset to the P2 commit. This script only handles
|
|
# runtime + DB-state rollback.
|
|
|
|
set -euo pipefail
|
|
|
|
PG_HOST="${PG_HOST:-localhost}"
|
|
PG_USER="${PG_USER:-godcrm}"
|
|
PG_DB="${PG_DB:-godcrm_prod}"
|
|
DRY_RUN="${DRY_RUN:-0}"
|
|
|
|
echo "ADR-0030 P2 rollback — target DB: ${PG_USER}@${PG_HOST}/${PG_DB} (dry_run=${DRY_RUN})"
|
|
|
|
run_sql() {
|
|
local sql="$1"
|
|
if [[ "${DRY_RUN}" == "1" ]]; then
|
|
echo "[DRY-RUN] ${sql}"
|
|
return 0
|
|
fi
|
|
PGPASSWORD="${PGPASSWORD:-}" psql -h "${PG_HOST}" -U "${PG_USER}" -d "${PG_DB}" \
|
|
-v ON_ERROR_STOP=1 -c "${sql}"
|
|
}
|
|
|
|
# 1. Clear any phase2_dryrun terminals + run_* keys left on tickets.
|
|
# Spec: only touch rows whose run_terminal_reason is 'phase2_dryrun' so
|
|
# we don't disturb anything Phase 3+ might have left on real runs.
|
|
echo "1/2 Clearing phase2_dryrun residue from tickets 1708…"
|
|
run_sql "UPDATE table_rows
|
|
SET data = data
|
|
- 'run_state'
|
|
- 'run_attempt'
|
|
- 'run_thread_id'
|
|
- 'run_workspace_path'
|
|
- 'run_started_at'
|
|
- 'run_finished_at'
|
|
- 'run_last_event_at'
|
|
- 'run_terminal_reason'
|
|
- 'run_next_attempt_after'
|
|
- 'run_pending_approval_token'
|
|
- 'run_audit_log',
|
|
updated_at = NOW()
|
|
WHERE table_id = 1708
|
|
AND data->>'run_terminal_reason' = 'phase2_dryrun';"
|
|
|
|
# 2. Verify dispatcher health endpoint reports disabled (informational).
|
|
echo "2/2 Reminder: also flip env flag in PM2 ecosystem and reload:"
|
|
echo " pm2 set godcrm:env.AGENT_RUN_DISPATCHER_ENABLED false"
|
|
echo " pm2 reload godcrm --update-env"
|
|
echo ""
|
|
echo "(Or set AGENT_RUN_DISPATCHER_ENABLED=false in .env and restart godcrm.)"
|
|
|
|
echo "Done."
|