generator_tick: add 15-min spawnSync timeout (was unbounded — hang risk); stage batch-2 orphan reclaim SQL (19 vision-triaged keepers, Steve-gated)

cba45291ae83c36ef371412ca03b964935c6a91b · 2026-06-09 12:34:57 -0700 · Steve Abrams
Files touched

M scripts/generator_tick.js
A scripts/orphan-reclaim-batch2-20260609.sql
Diff

commit cba45291ae83c36ef371412ca03b964935c6a91b
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 9 12:34:57 2026 -0700

    generator_tick: add 15-min spawnSync timeout (was unbounded — hang risk); stage batch-2 orphan reclaim SQL (19 vision-triaged keepers, Steve-gated)
---
 scripts/generator_tick.js                  |   5 +-
 scripts/orphan-reclaim-batch2-20260609.sql | 142 +++++++++++++++++++++++++++++
 2 files changed, 146 insertions(+), 1 deletion(-)

diff --git a/scripts/generator_tick.js b/scripts/generator_tick.js
index 2d5d032..a92c8cc 100644
--- a/scripts/generator_tick.js
+++ b/scripts/generator_tick.js
@@ -217,7 +217,10 @@ function main() {
     '--n', '1', '--kind', 'seamless_tile',
     '--category', (recipe.style_tags && recipe.style_tags[0]) || 'mixed',
     '--prompts', prompt,
-  ], { cwd: ROOT, env, encoding: 'utf8' });
+  // 15-min ceiling: without a timeout a hung ComfyUI blocks this tick forever.
+  // (Sibling drunk_animals_tick's 4-min timeout was the Jun 3-4 orphan-maker —
+  // SIGTERM between watermark and insert; 15 min is 2x the worst-case pipeline.)
+  ], { cwd: ROOT, env, encoding: 'utf8', timeout: 15 * 60_000 });
 
   if (r.status !== 0) {
     const errOut = (r.stderr || r.stdout || '').slice(-1000);
diff --git a/scripts/orphan-reclaim-batch2-20260609.sql b/scripts/orphan-reclaim-batch2-20260609.sql
new file mode 100644
index 0000000..de4a3e5
--- /dev/null
+++ b/scripts/orphan-reclaim-batch2-20260609.sql
@@ -0,0 +1,142 @@
+-- Orphan reclaim batch 2 — 2026-06-09.
+-- 19 visually-clean tiles from the Jun 3-4 timeout-orphan cluster (debugger verdict:
+-- ALL 71 orphans were 4-min SIGTERM kills BEFORE gates/insert ran — gates never judged them).
+-- Triaged by 3 vision agents: 20 KEEP of 71; seed 669061550 excluded (256px source).
+-- Staged is_published=FALSE -> normal curator + settlement flow. NO auto-publish.
+BEGIN;
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Damask acanthus scroll, ivory on black (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 193789138,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780553757959_193789138.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Damask acanthus with floral bloom, greige on black (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 305291363,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780554753024_305291363.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Large-scale Jacobean trailing floral vine with rose blooms, teal on cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 491490142,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780547838952_491490142.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Art-nouveau botanical swirl with central bloom, green on cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 553810349,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780498429705_553810349.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Peony and acanthus damask, black and white fine linework (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 900260111,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780589960349_900260111.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Bird and scroll damask, white on forest green [PART-B BIRD — settlement gate must rule before publish] (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 979043724,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780586437673_979043724.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Brush-style damask scroll, dark teal on cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1040013006,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780592349941_1040013006.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Dense fine-line floral toile, black and white (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1095075943,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780554352261_1095075943.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Rose floral scroll, black and white (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1099123802,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780588744225_1099123802.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Acanthus scroll damask, cream on forest green (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1113938255,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780552443266_1113938255.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Scroll damask, white on navy (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1415919229,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780552640406_1415919229.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Abstract crackle line-network, two-tone (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1488626861,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780549072364_1488626861.png',
+ 'geometric', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Damask acanthus scroll, dark green on cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1523873497,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780590455668_1523873497.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Abstract stained-glass floral allover, black and taupe (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1685400637,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780549773923_1685400637.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Hand-drawn diamond trellis lattice, navy on cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 1965836513,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780549976580_1965836513.png',
+ 'geometric', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Damask scroll silhouette, navy on cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 2000630003,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780588149667_2000630003.png',
+ 'damask', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Modern magnolia botanical, navy slate cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 2039463419,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780506094277_2039463419.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Bold abstract floral lattice, navy on cream (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 2050808203,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780553952193_2050808203.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+ 'Floral toile with songbird, white on slate gray [PART-B BIRD — settlement gate must rule before publish] (reconstructed — orphan reclaim; original run timeout-killed before insert Jun 3-4 2026)',
+ 2066312879,
+ '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780548044420_2066312879.png',
+ 'floral', FALSE,
+ 'orphan-reclaim batch-2 2026-06-09: 4-min tick SIGTERM orphan, vision-triaged KEEP — staged for curator review.');
+COMMIT;
+UPDATE all_designs SET image_url='/designs/img/by-id/'||id WHERE seed IN (193789138,305291363,491490142,553810349,900260111,979043724,1040013006,1095075943,1099123802,1113938255,1415919229,1488626861,1523873497,1685400637,1965836513,2000630003,2039463419,2050808203,2066312879) AND image_url IS NULL;
+SELECT id, seed, category FROM all_designs WHERE seed IN (193789138,305291363,491490142,553810349,900260111,979043724,1040013006,1095075943,1099123802,1113938255,1415919229,1488626861,1523873497,1685400637,1965836513,2000630003,2039463419,2050808203,2066312879) ORDER BY id;
← ff8c30c Harden refresh_designs_snapshot.py summary print against Non · back to Wallco Ai · home hero: slides click through to their design PDP (role=li b449bb8 →