`data/yolo-overnight/quarantine-sweep-20260525-1019.md`

71 lines
# Quarantine Sweep — 2026-05-25 10:19 UTC

Audit of `/api/designs` file-cache integrity. Looked for DESIGNS entries (from
`data/designs.json` — the snapshot loaded into the in-memory `DESIGNS` array
at server start) whose `filename` was missing from `data/generated/` (IMG_DIR)
but present in `data/generated_ghost_quarantine/`. Restored those via `cp`.

## Restoration delta

| Metric                                          | Value |
|-------------------------------------------------|------:|
| `designs.json` entries scanned                  | 38,302 |
| Entries missing from `data/generated/`          |    603 |
| ↳ Restorable from quarantine (cp'd back)        | **10** |
| ↳ Missing nowhere (truly gone — out of scope)   |    593 |
| Files in `data/generated/` before sweep         | 72,745 |
| Files in `data/generated/` after sweep          | 72,755 |
| Files in `data/generated_ghost_quarantine/`     |  6,546 |

## Restored files

| Design ID | Filename |
|-----------|----------|
| 39056 | cactus_pine_pass3_1779412751778_2032520579.png |
| 39120 | studio_joshua-valley-indigo_1779417516053_1020181959.png |
| 39136 | studio_cypress-windbreak-sage_1779417646790_351113967.png |
| 39140 | studio_cardon-grove-adobe_1779417681774_1450085074.png |
| 39289 | cropfix_33042_1779605219950_601183627.png |
| 39290 | cropfix_33036_1779605247780_912942478.png |
| 39295 | cropfix_33131_1779605328826_1876355276.png |
| 39297 | cropfix_31997_1779605591511_1084835695.png |
| 39298 | cropfix_29711_1779605687885_1866254735.png |
| 39299 | cropfix_39245_1779605802381_580032546.png |

Copy operation used (per file): `cp data/generated_ghost_quarantine/$fn data/generated/$fn`.
Quarantine copies were left in place; the operation is non-destructive on
the quarantine side.

## designs.json snapshot refresh

Ran `python3 scripts/refresh_designs_snapshot.py` per task instructions.

| Metric                          |        Before |         After |
|---------------------------------|--------------:|--------------:|
| `designs.json` entry count      |        38,302 |       **276** |
| `designs.json` byte size        |    25,184,174 |       180,415 |

**WARNING — major snapshot reduction (-38,026 entries).** The script pulls
only `WHERE generator IN ('replicate','gemini-2.5-flash-image-edit','comfy')`
from `spoon_all_designs`, which currently holds 338 rows total (201+72+3 =
276 matching the filter, +59 `dw-shopify`, +3 `stub`). The pre-existing
`designs.json` was built from a much larger historical source and is no
longer reproducible from PG alone. Live PM2 process `wallco-ai` (pid in
`pm2 list`) still serves the old 38K from its in-memory `DESIGNS` array
until a reload or restart — calling `/admin/reload-designs` (or `pm2 reload
wallco-ai`) will collapse the live grid to 276 entries.

Category breakdown of the new 276-entry snapshot:
`art deco:1, arts and crafts:1, cactus:1, cactus-11ft-mural:76,
cactus-pine-scenic:60, damask:31, dolce-gabbana:1, drunk-monkeys-v2:2,
floral:27, geometric:10, mixed:11, monterey-mural:2, pop art:2,
post-impressionism:4, tree-mural:47`.

## Commit

No git repository present at `/root/public-projects/wallco-ai` — this prod
box receives rsync deploys from Mac2 per `deploy-kamatera.sh` and is not a
git working copy. Commit step skipped on prod; changes to source-of-truth
files (`scripts/refresh_designs_snapshot.py`, `data/designs.json`) would
need to be committed on the Mac2 origin and redeployed.