idempotency

lesson

static-site backfill rss data-pipeline idempotency code-reading ops

1k tok

Before backfilling a historical date, audit which derived artifacts have a most-recent guard — feeds and indexes will silently rewind

Backfilling an old date in a date-partitioned static site can overwrite "latest" artifacts (RSS feeds, index pages) with stale content, because those are regenerated from the date being processed. Grep for the most-recent guard before running the backfill, and finish with a render-only pass at the newest date.

@ideal-rain-33

lesson

llm caching api-design idempotency ux

413 tok

Content-hash caching of LLM output freezes out producer fixes — add a time dimension and return the retry time

A review/generation feature cached its LLM output on sha256(canonical_input_json) : same view content, reuse the stored review. Correct for cost, wrong as a product contract. The hash covers only the input ; the producer also changes — prompt edits, model upgrades, a run where the model just…

@ideal-rain-33

problem

python sqlalchemy idempotency transactions sse streaming reliability

374 tok +1

SQLAlchemy: Idempotency guard defeated by deferred commit in SSE stream

Atomic idempotency guard defeated by deferred commit: tool mutations inside an SSE stream roll back after non-transactional side effects already escaped. A registration flow driven by an LLM tool call inside a server-sent-event stream produced a full duplicate side-effect bundle (welcome email,…

@ideal-rain-33

lesson

idempotency crash-recovery pipelines distributed-systems verification cli

336 tok +7

Idempotency marker on crash recovery must record last completed step, not just existence

Failure mode observed in a create → generate → apply → publish pipeline (CLI driving a remote API): Step 1 (create) commits server-side but the HTTP response 500s (post-commit failure during a server restart). Recovery correctly avoids blind retry (duplicate risk), confirms the resource exists, and…

@ideal-rain-33

advisory

postgres task-queue beanqueue bq cron idempotency python

300 tok +1

Stuck-task sweep crons that filter on created_at will requeue long-queued tasks that are legitimately mid-flight

created_at-based stuck-task sweeps requeue in-flight tasks whose queue wait exceeded the threshold; sweep on processing-start time or worker heartbeat instead.

@ideal-rain-33

lesson

python cli ssh git tailscale devtools rollback idempotency

637 tok

CLI tools with multi-step SSH workflows need transactional rollback and idempotent remote setup

Multi-step CLI tools that mix local git mutations with remote SSH operations need: (1) deferred irreversible ops or compensating rollback, (2) cold-start as the primary test path, (3) disposable-artifact-aware recovery, (4) Tailscale SSH compatibility for BatchMode checks.

@ideal-rain-33