loop tick1: fleet compliance sweep — 0 settlement-block live, 658 user_removed-yet-live staged

2be769b2a3fd7887bdbc35cca46e81ff01c331ea · 2026-06-03 08:50:22 -0700 · Steve Abrams

Files touched

A yolo-queue/LOOP-2026-06-03.md
A yolo-queue/STAGED-unpublish-user-removed-live.sql

Diff

commit 2be769b2a3fd7887bdbc35cca46e81ff01c331ea
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Jun 3 08:50:22 2026 -0700

    loop tick1: fleet compliance sweep — 0 settlement-block live, 658 user_removed-yet-live staged
---
 yolo-queue/LOOP-2026-06-03.md                     | 24 +++++++++++++++++++++++
 yolo-queue/STAGED-unpublish-user-removed-live.sql | 10 ++++++++++
 2 files changed, 34 insertions(+)

diff --git a/yolo-queue/LOOP-2026-06-03.md b/yolo-queue/LOOP-2026-06-03.md
new file mode 100644
index 0000000..e90dbec
--- /dev/null
+++ b/yolo-queue/LOOP-2026-06-03.md
@@ -0,0 +1,24 @@
+# Autonomous loop — 2026-06-03 (focus A: fleet-wide catalog compliance)
+
+DTD verdict: **A** (Claude+Codex 2/2, Qwen errored). Guardrails: read-only audit
++ stage SQL + 1 local commit/tick + CNCP log. NO deploy/publish/destructive/
+bulk-unpublish. Steve away ~hours.
+
+## Tick 1 — settlement/removed compliance sweep (LIVE rows)
+Total live: **5,706**. Verdict distribution among live:
+- `(null/never-gated)` 2,867 · `OK` 1,492 · `BLEED_GHOST_OK` 1,347
+
+**Hard legal gate is CLEAN:** 0 live rows are settlement BLOCK / VISION-ERROR /
+REVIEW. (`BLEED_GHOST_OK` is a *passing* quality verdict, not a settlement fail —
+don't conflate.)
+
+### 🔴 Actionable: 658 `user_removed=true` yet `is_published=true`
+Removed content still live. Concentrated in: designer-scenic 363 · stoned-animals
+125 · drunk-animals-designer 110 · face-skull-damask 27 · damask 13 · cactus 9 ·
+(rest ≤4). May include auto-curator force-publish overrides → **needs Steve go**.
+Staged (NOT executed): `yolo-queue/STAGED-unpublish-user-removed-live.sql`.
+
+### 🟡 Note: 2,867 never-settlement-gated live rows
+Legacy / auto-curator publishes. NOT a violation (no BLOCK), but un-gated.
+Recommend a settlement-gating pass (not bulk-unpublish — would gut catalog).
+Deferred to a later tick / Steve decision.
diff --git a/yolo-queue/STAGED-unpublish-user-removed-live.sql b/yolo-queue/STAGED-unpublish-user-removed-live.sql
new file mode 100644
index 0000000..7c9a2fb
--- /dev/null
+++ b/yolo-queue/STAGED-unpublish-user-removed-live.sql
@@ -0,0 +1,10 @@
+-- STAGED 2026-06-03 (autonomous loop tick 1, focus A) — NOT EXECUTED.
+-- 658 rows are user_removed=true yet is_published=true (removed content still live).
+-- Bulk-unpublish of pre-existing rows needs Steve's explicit go (standing rule).
+-- These may include auto-curator force-publish overrides — review before running.
+BEGIN;
+UPDATE all_designs
+   SET is_published=false,
+       notes = COALESCE(notes,'') || ' | unpublished (audit): user_removed=true but was live'
+ WHERE is_published AND COALESCE(user_removed,false);
+COMMIT;

← d43631e mural-master: --estimate dry-run cost estimator (no-spend) — · back to Wallco Ai · mural-batch: curate-monterey-batch.py → 12 hue-spread publis 52b7c2f →