Thibaut mfr-fix: flag jobs are in wrong queue DB (worker reads separate Kamatera-side queue); re-enqueue needed

298b81b115fbf1135f8c60335dd0309067ef6c52 · 2026-06-11 13:45:17 -0700 · Steve Abrams

Files touched

M thibaut-mfr-fix/BACKLOG.md

Diff

commit 298b81b115fbf1135f8c60335dd0309067ef6c52
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Jun 11 13:45:17 2026 -0700

    Thibaut mfr-fix: flag jobs are in wrong queue DB (worker reads separate Kamatera-side queue); re-enqueue needed
---
 thibaut-mfr-fix/BACKLOG.md | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git a/thibaut-mfr-fix/BACKLOG.md b/thibaut-mfr-fix/BACKLOG.md
index 3dd02a8..3c31b1a 100644
--- a/thibaut-mfr-fix/BACKLOG.md
+++ b/thibaut-mfr-fix/BACKLOG.md
@@ -20,3 +20,14 @@ Need the real pattern name sourced from Thibaut's catalog, then rebuild + de-SKU
 ## B) Junk parenthetical tags — ~160 active Thibaut products
 Tags contain a garbage entry like `Thibaut Taluk Sisal(T41170)` (SKU embedded in a parenthetical name).
 The clean mfr token has now been added alongside; these junk tags should be stripped in a follow-up pass.
+
+## C) ⚠️ Jobs are in the WRONG queue DB — re-enqueue needed (2026-06-11)
+The 1,096 jobs (1,027 tags + 69 titles) were enqueued into **Mac2 `dw_unified.shopify_api_queue`**, but the
+`shopify-queue-worker` on Kamatera reads a **different** queue DB — proven: it processes `arte-title-rebuild`
+jobs (ids ~873157) that do NOT exist in Mac2's `dw_unified`, and writes no completions back to Mac2.
+**They will NOT drain.** The bidirectional replication does not carry this table to the worker's node.
+
+**Next session:** find the worker's DB via `/root/DW-Agents/shopify-queue-worker/.env` `DB_URL`, then
+regenerate the inserts from `thibaut_mfr_fix_staging` (lives on Mac2) against that DB. Worker is now
+online + `pm2 save`d. Separately: `arte-title-rebuild` jobs are erroring `Product does not exist` on the
+worker's DB (pre-existing stale-ID issue, not ours).

← bdd29b7 Thibaut mfr-SKU fix: queue 1027 tag backfills, stage 69 titl · back to Dw Yolo Loop · Thibaut mfr-fix: direct Shopify Admin REST pusher (DTD verdi cd8b70e →