# undo case (the load fails) — 2026-09-30T12:47:25+0200
before: PG_VERSION=16 pinned={'rallly': 'lukevella/rallly:4.11.1', 'rallly-postgres': 'postgres:16-alpine'}
    rallly: readback of the seeded poll http=200 found=True
before: seed reads back through the front door = True
setup: CREATE EXTENSION adminpack -> CREATE EXTENSION
setup: extensions now: adminpack citext pgcrypto plpgsql
control: 18 has no adminpack: 0
  phase +0.0s backing-up | err=None
  phase +18.5s safety-dump | err=None
  phase +20.5s pulling | err=None
  phase +21.6s copying | err=None
  phase +32.8s converting | err=None
  phase +39.0s undoing | err=None
  phase +57.5s undone | err=None
result: {"accepted": true, "http": "202", "duration_s": 57.5, "final_phase": "undone", "update_error": null, "hold_reason": null, "state": "running"}
    rallly: readback of the seeded poll http=200 found=True
after: PG_VERSION=16 pinned={'rallly': 'lukevella/rallly:4.11.1', 'rallly-postgres': 'postgres:16-alpine'} state=running
after: seed reads back through the front door = True
controller lines:
2026/09/30 10:47:39 update.go:536: [INFO] [stacks] update rallly: accepted — guarded update started
2026/09/30 10:47:39 update.go:1365: [INFO] [stacks] update rallly: phase checking
2026/09/30 10:47:39 update.go:786: [INFO] [stacks] update rallly: ladder — the last step (1 of 1) — the catalog's current definition
2026/09/30 10:47:39 update.go:800: [INFO] [stacks] update rallly: this step CONVERTS rallly-postgres PostgreSQL 16 → 18 (the ladder entry's mark); database volume rallly_rallly_postgres_data
2026/09/30 10:47:39 update.go:816: [INFO] [stacks] update rallly: no usable copy on any tier — younger than 24h0m0s and not older than this install's deploy (2026-09-30T10:41:37Z) (found: none) — backing up first
2026/09/30 10:47:39 update.go:1365: [INFO] [stacks] update rallly: phase backing-up
2026/09/30 10:47:58 update.go:831: [INFO] [stacks] update rallly: precondition met after the backup — Tier 2 (second drive) copy from 2026-09-30T10:47:40Z
2026/09/30 10:47:58 update.go:1365: [INFO] [stacks] update rallly: phase safety-dump
2026/09/30 10:47:58 update.go:846: [INFO] [stacks] update rallly: safety dump done (1 file(s)) [/mnt/sys_drive/felhom-data/backups/primary/rallly/db-dumps/pre-restore-20260930T104758Z-rallly-postgres.sql]
2026/09/30 10:47:59 undo.go:287: [INFO] [stacks] update rallly: the undo copy will hold 1 named volume(s), 64.1 MiB
2026/09/30 10:47:59 pgconvert.go:340: [INFO] [stacks] update rallly: conversion space — database volume rallly_rallly_postgres_data is 64 MB; the dump needs up to 80 MB + the 2 GB floor; 27.7 GB free beside the stack dir
2026/09/30 10:47:59 update.go:1365: [INFO] [stacks] update rallly: phase pinning
2026/09/30 10:47:59 pin.go:373: [INFO] [stacks] update rallly: pin advanced to /opt/docker/felhom-controller/data/catalog-cache/templates/rallly/docker-compose.yml (rallly=lukevella/rallly:4.11.1, rallly-postgres=postgres:18-alpine)
2026/09/30 10:47:59 update.go:1365: [INFO] [stacks] update rallly: phase pulling
2026/09/30 10:48:00 update.go:1365: [INFO] [stacks] update rallly: phase copying
2026/09/30 10:48:11 update.go:1365: [INFO] [stacks] update rallly: phase copying
2026/09/30 10:48:12 undo.go:437: [INFO] [stacks] update rallly: copied rallly_rallly_postgres_data → rallly_rallly_postgres_data.pre-update-20260930T104811Z in 772ms
2026/09/30 10:48:12 update.go:1365: [INFO] [stacks] update rallly: phase converting
2026/09/30 10:48:12 pgconvert.go:423: [INFO] [stacks] update rallly: CONVERTING rallly-postgres PostgreSQL 16 → 18 (volume rallly_rallly_postgres_data, kept copy rallly_rallly_postgres_data.pre-update-20260930T104811Z)
2026/09/30 10:48:13 pgconvert.go:468: [INFO] [stacks] update rallly: pg_dumpall from 16 done in 509ms — 90 kB, completion line present; before: 2 database(s), 31 table(s), 138 row(s)
2026/09/30 10:48:14 update.go:1365: [INFO] [stacks] update rallly: phase converting
2026/09/30 10:48:14 pgconvert.go:484: [INFO] [stacks] update rallly: database volume rallly_rallly_postgres_data emptied (its copy rallly_rallly_postgres_data.pre-update-20260930T104811Z holds the old datadir, marker checked twice)
2026/09/30 10:48:18 update.go:1066: [ERROR] [stacks] update rallly FAILED after the new version was started: conversion failed: loading the dump into 18: exit status 3 (psql: ERROR:  extension "adminpack" is not available)
2026/09/30 10:48:18 update.go:1058: [INFO] [stacks] update rallly: kept 6057 bytes of the app's own log at /opt/docker/stacks/rallly/hold-logs/20260930T104818Z/compose-logs.txt before stopping it (R-621)
2026/09/30 10:48:18 update.go:1365: [INFO] [stacks] update rallly: phase undoing
2026/09/30 10:48:18 undo.go:515: [WARN] [stacks] update rallly: UNDO — putting back the previous version and its 1 volume copy(ies) (reason: conversion failed: loading the dump into 18: exit status 3 (psql: ERROR:  extension "adminpack" is not available))
2026/09/30 10:48:36 unattended.go:511: [INFO] [stacks] update rallly: step rallly=lukevella/rallly:4.11.1, rallly-postgres=postgres:18-alpine recorded as undone — the automatic leg will not press it again until the catalog's ladder changes (ladder 556df1b26b7fa6c0)
2026/09/30 10:48:36 undo.go:640: [INFO] [stacks] update rallly: event app_update_undone
2026/09/30 10:48:36 undo.go:568: [INFO] [stacks] update rallly: UNDONE in 18s — the previous version is running on the data from before the update (the app's health check passed)

cleanup: DROP EXTENSION adminpack -> DROP EXTENSION
RESULT undo case ok=True final_phase=undone PG_VERSION=16 seed_after=True
