Loop tick 9: corrected auto-curator republish premise (no live bug); staged regression reconciler

78083e98d036d6da80f0aae612a8cfbf1d15490d · 2026-06-03 14:32:29 -0700 · Steve Abrams

Files touched

M yolo-queue/LOOP-2026-06-03.md
A yolo-queue/STAGED-reconcile-published-user-removed.sql

Diff

commit 78083e98d036d6da80f0aae612a8cfbf1d15490d
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Jun 3 14:32:29 2026 -0700

    Loop tick 9: corrected auto-curator republish premise (no live bug); staged regression reconciler
---
 yolo-queue/LOOP-2026-06-03.md                      | 12 ++++++++++++
 .../STAGED-reconcile-published-user-removed.sql    | 22 ++++++++++++++++++++++
 2 files changed, 34 insertions(+)

diff --git a/yolo-queue/LOOP-2026-06-03.md b/yolo-queue/LOOP-2026-06-03.md
index 69af440..f55bfda 100644
--- a/yolo-queue/LOOP-2026-06-03.md
+++ b/yolo-queue/LOOP-2026-06-03.md
@@ -100,3 +100,15 @@ oddball (id 100) is already covered by ②.
 - **Tick 6 (regression check, ~11:40): steady.** 0 new BLOCK/VISION-ERROR/REVIEW live; user_removed-yet-live still 658; /health 200; viewer serving; 0 Steve decisions yet.
 - **Tick 7 (regression check, ~12:31): steady.** 0 new blocks; user_removed-yet-live 658; /health 200; viewer serving; 0 Steve decisions.
 - **Tick 8 (regression check, ~13:22): steady.** 0 new blocks; 658 unchanged; /health 200; viewer serving; 0 decisions.
+
+## Tick 9 (2026-06-03) — focus A (DTD 2/2), premise corrected
+DTD verdict was A (fix auto-curator user_removed-republish bug). Empirical + code
+investigation CONTRADICTS the premise:
+- No server-side auto-publish timer (server.js:1269 = 30s designs.json reload only).
+- All is_published=true paths (bulk 2790, force-publish 2460) set user_removed=FALSE.
+- 0 user_removed-yet-live rows reappeared in ~40min post-② (no curator proc running;
+  only com.user.wallco-settlement-guard loaded; no com.steve.wallco-generator).
+- The 645 were heterogeneous historical drift (150 file-missing tag, etc.), not a live bug.
+ACTION: staged a low-urgency regression reconciler (STAGED-reconcile-published-user-removed.sql),
+no hot fix applied (would be cargo-cult against a non-running curator). ②'s unpublish is durable.
+In-flight: ③ settlement re-gate running; ① deploy pending its completion.
diff --git a/yolo-queue/STAGED-reconcile-published-user-removed.sql b/yolo-queue/STAGED-reconcile-published-user-removed.sql
new file mode 100644
index 0000000..7f2fcd3
--- /dev/null
+++ b/yolo-queue/STAGED-reconcile-published-user-removed.sql
@@ -0,0 +1,22 @@
+-- STAGED 2026-06-03 (loop tick 9, focus A — corrected) — NOT auto-executed.
+-- Belt-and-suspenders reconciler: unpublish any row that is BOTH is_published
+-- AND user_removed=true. This should normally be a no-op.
+--
+-- CONTEXT / CORRECTION: tick 9 investigated the assumed "auto-curator republishes
+-- user_removed rows every ~30min" bug and found it does NOT exist as stated:
+--   • No server-side auto-publish timer (server.js:1269 is a 30s designs.json
+--     RELOAD, not a publish). All is_published=true flips are request-handler
+--     driven (curator/admin endpoints).
+--   • Every publish path — bulk (server.js:2790) and force-publish (2460) —
+--     explicitly sets user_removed=FALSE, so it cannot create a published+removed row.
+--   • Empirically: 0 user_removed-yet-live rows reappeared in ~40min after ②
+--     unpublished the 645, with NO curator/generator process running.
+--   • The 645 were heterogeneous historical drift (150 tagged file-missing, etc.),
+--     not a single live bug.
+-- So this reconciler is a low-urgency regression guard, not a hot fix. Safe to wire
+-- into the already-running com.user.wallco-settlement-guard launchd as a periodic
+-- sweep if Steve wants the invariant enforced. Reversible (re-publish).
+UPDATE all_designs
+   SET is_published = false,
+       notes = COALESCE(notes,'') || ' | reconciler: is_published & user_removed -> unpublished'
+ WHERE is_published AND COALESCE(user_removed,false);

← 61159ee PDP live-theme takeover (/design/:id serving the active them · back to Wallco Ai · admin: /admin/mural-masters local review gallery for room-si 4cb93d5 →