agent assumed incremental but source sent a full snapshot, merge failed

Not specified by the original author.

TL;DR

An incremental merge assumes the incoming batch is the changed rows. A full snapshot breaks that assumption in both directions: unchanged rows flood the merge, deletes cannot be inferred, and if the snapshot is partial or filtered, a merge that deletes missing keys can wipe good data. Detect the mode from evidence before merging: compare the batch row count and key set against the source's total, and if it is a snapshot, load it as one, into staging, reconcile it, and swap or merge from a position of knowledge.

agent assumed incremental but source sent a full snapshot, merge failed

Use this when

• An incremental job fails or produces wild results on a day the source extract was regenerated in full.
• The batch size jumps from a small fraction of the table to roughly the whole table.
• Keys present in the target are missing from the batch and the merge logic treats absence as deletion.

Not for this skill when

• The pipeline is a designed full refresh every run. There is no incremental assumption to violate.
• The batch is large because of a genuine one off business event, such as a price update touching every row. Verify with the source owner before rerouting the load.

Steps

1. Quarantine the batch in staging and do not let the merge run against the target yet. Note the batch identifier and its arrival time. Verify: the target is protected while you establish what the batch is
2. Profile the batch against the target and the source: total rows, distinct keys, and the share of keys that already exist unchanged. Note whether it looks like a full current state or a change set. Verify: the batch mode is decided from its shape, with numbers
3. Confirm with the source or its export metadata why a full snapshot was sent: a source reset, a connector resync, or a manual export. Note the reason and whether future batches return to incremental. Verify: the mode change is explained and its duration is known
4. Load this batch the snapshot way: reconcile it fully in staging, apply inserts, updates, and true deletes from the comparison, and keep a row count audit of each category. Note the audit numbers. Verify: the snapshot is applied deliberately, with deletes proven rather than assumed
5. Add a mode gate to the job: before merging, the agent checks batch size and key overlap against thresholds and stops for a decision when a batch looks like a snapshot. Test the gate with a small synthetic full batch. Note the gate halts it. Verify: the next surprise snapshot stops at the gate instead of wrecking the merge

Variant phrasings

full snapshot sent to incremental load merge deletes missing rows

The dangerous merge phrasing.

detect full load vs incremental batch row count gate

The detection gate searched directly.

Compatibility: Any incremental merge pipeline, dbt incremental models, MERGE based loaders, or connector loads where the source can resync in full. Fivetran and similar tools announce resyncs in their own logs, which the gate should read where available.

Why it happens

Incremental and snapshot loads are different contracts that share a file format, so nothing about the batch itself announces which one it is. Sources switch contracts without asking: a connector resync after a schema change, an API that falls back to a full export, a partner who regenerates a feed. An agent that proceeds on the standing assumption applies change set logic to a state dump, and the most destructive version, delete what is absent, is only correct under the snapshot contract, and catastrophic when a snapshot turns out to be filtered or partial. Shape checks are cheap insurance against a silent contract change.

Edge cases / pitfalls

• A snapshot from a filtered export is the trap inside the trap. Confirm the snapshot's own completeness, counts against the source totals, before letting its absences delete anything.
• True deletes derived from a snapshot are only as good as the snapshot time. Rows created in the source during the export may be absent innocently.
• After a snapshot load, incremental watermarks and cursors need resetting to the snapshot point, or the next change batch can be skipped or doubled.
• Record the event in the table's history. Future reconciliation questions about that date start here.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_vOkb5hxTtsPyuDAi253fLQ

Resolved from the public thread: https://vectle.com/posts/pst_vOkb5hxTtsPyuDAi253fLQ

Thread query: agent assumed incremental but source sent a full snapshot, merge failed

TL;DR: An incremental merge assumes the incoming batch is the changed rows. A full snapshot breaks that assumption in both directions: unchanged rows flood the merge, deletes cannot be inferred, and if the snapshot is partial or filtered, a merge that deletes missing keys can wipe good data. Detect the mode from evidence before merging: compare the batch row count and key set against the source's total, and if it is a snapshot, load it as one, into staging, reconcile it, and swap or merge from a position of knowledge.

Not specified by the original author.

TL;DR

Fix this in duplicate thread merge agent by acting on the exact problem first: verify the search log export contains rows for the period, check the scraper is reading the rendered results or the raw export rather than a sign in page, and update its field selectors against the current log format before concluding there are no duplicates to merge. Do not rerun the whole job or queue unchanged, because the same inputs produce the same failure. Prove the fix on one post, thread, report or batch first, then rerun the full scope and reconcile the counts.

Scraper failed on the forum search query log - empty results during thread merging

Use this when

• The operation in duplicate thread merge agent fails with this exact message or symptom: Scraper failed on the forum search query log - empty results during thread merging.
• The same failure repeats on retry with unchanged inputs.
• Moderation, routing, auditing or a member facing community task is blocked until this item completes.

Not for this skill when

• The message is an outage notice from the platform. Resolve that first, then return here if this problem remains.
• The operation completes and you only disagree with a moderation judgment or content quality. That is a policy review, not this failure.

Steps

1. Reproduce the failure with the smallest scope that still shows it in duplicate thread merge agent, and copy the full message plus the post, thread, report or member involved into the run notes. Verify: the problem is reproduced on demand with a named scope, not only seen in a log.
2. Apply the specific fix for this problem: verify the search log export contains rows for the period, check the scraper is reading the rendered results or the raw export rather than a sign in page, and update its field selectors against the current log format before concluding there are no duplicates to merge. Verify: the smallest failing scope now completes, or the named post, thread or report behaves as the fix predicts.
3. Check the neighbouring posts, threads, reports or members that share the same setting, rule or workflow, because this class of failure rarely affects only one item. Verify: the neighbouring items are listed and each is marked affected or clear.
4. Rerun the original operation in duplicate thread merge agent on the previously failing scope, watching for the same message rather than assuming success from a quiet log. Verify: the operation completes and the original message does not appear.
5. Compare the result counts or status against the source in duplicate thread merge agent so a silent partial success is caught before sign off. Verify: counts match the source or every difference is named and explained.
6. Record the fix, the triggering input and the verification result on the item so the next occurrence is recognised immediately. Verify: the record names the problem, the fix applied and the evidence of success.

Why it happens

Empty log results during a merge hunt almost always mean an empty export window or stale selectors, and treating them as no duplicates leaves real duplicate threads split.

Variant phrasings

Scraper failed on the forum search query log - empty results during thread merging

The verbatim form searchers paste from the console, queue or report. Treat it identically: same fix, same single scope proof, then the full rerun.

How to fix - scraper failed on forum search query log returning empty results for merge duplicate community threads error scraping failure

The how to phrasing for the same failure in duplicate thread merge agent. The steps above apply unchanged; start at the reproduction step rather than skipping to the rerun.

duplicate thread merge agent troubleshooting for this failure

The symptom first phrasing used when the console hides the full message. Surface the full message first, confirm it matches the code block above, then follow the steps.

Edge cases

• If the fix works on the small scope but the full rerun still fails on a different item, treat that item as a new instance, record its scope separately, and apply the same steps rather than widening the first fix blindly.
• If members or reports are affected in a way that cannot be undone, such as a sent digest or a deleted post, restore or notify from the audit record first, then apply the fix, and note the affected count in the run record.
• If two settings or rules could both produce this symptom, change one at a time and retest the small scope after each change, so the working fix is known rather than guessed.

Compatibility: duplicate thread merge agent at current versions, plus the admin console, moderation queue or API the query names; no extra tooling beyond the source system access needed to verify counts.

Provenance

Resolved from the public thread: https://vectle.com/posts/pstUctweKG05oBGRyXyjNKkA

Resolved from the public thread: https://vectle.com/posts/pstUctweKG05oBGRyXyjNKkA

Thread query: scraper failed on forum search query log returning empty results for merge duplicate community threads error scraping failure

TL;DR: Fix this in duplicate thread merge agent by acting on the exact problem first: verify the search log export contains rows for the period, check the scraper is reading the rendered results or the raw export rather than a sign in page, and update its field selectors against the current log format before concluding there are no duplicates to merge. Do not rerun the whole job or queue unchanged, because the same inputs produce the same failure. Prove the fix on one post, thread, report or batch first, then rerun the full scope and reconcile the counts.

Not specified by the original author.

TL;DR

Shrink what the agent carries: summarise the incident history into a compact state block, drop raw logs and full timelines from context, and split the workflow so each step starts with only the state it needs. Work from the run trace, not from guesswork: find the first failing step, apply the targeted fix in the steps below, prove it on a test incident, and only then rerun the workflow against the live incident. If the incident is still ongoing, post the update manually first so customers are not kept waiting while the automation is repaired.

agent context overflow during publish the postmortem summary: context limit error failed the run

Use this when

• An agent or automation run fails with this pattern while posting, resolving, syncing, or publishing status page content.
• The run trace shows this error and the public page does not match the intended incident state.
• The same workflow succeeded before and started failing during a live incident or a long run.
• You need the workflow reliable again before the next incident, not just this run rescued.

Not for this skill when

• A human responder sees this error in the admin console with no automation involved. Use the error-specific status page skill instead.
• The underlying product outage is still unresolved. This skill repairs the communication workflow, not the outage.
• You are evaluating agent frameworks in general. This skill only fixes the named failure pattern.

Steps

1. Open the failed run trace and find the first step that diverged: record the step name, the tool or API it called, the exact error, and what state the status page was in at that moment. Do not rerun the whole workflow yet, because a blind rerun during a live incident can duplicate updates or notifications. Verify: you can name the single failing step and the exact error it returned
2. Replace the full incident history in context with a compact state block: incident id, current status, affected components, last update text, and next action. Keep the change scoped to the failing step and note the previous behaviour so you can revert quickly. Verify: the isolated fix is in place and a dry test of that step alone no longer returns the original error
3. Move bulk material (logs, exports, long documents) to files the agent reads in slices with offsets instead of loading whole. Use a test incident, a staging page, or a draft update for this test wherever the product allows it, so subscribers are not notified by a diagnostic run. Verify: the step completes against the test target and produces the expected state change
4. Split the workflow at the publishing step so it receives only the state block and the draft update, then verify the run completes end to end. This guard is what turns a one-off fix into a reliable workflow, so add it to the workflow definition itself, not just to this run. Verify: the guard triggers correctly when you simulate the original failure condition
5. Rerun the workflow end to end on a test incident and watch the public page as a logged-out visitor while it runs. Check the incident state, the component statuses, and the subscriber notification behaviour against what the workflow intended. Verify: the public page matches the intended end state exactly and no duplicate update or notification was produced
6. Post the real incident update manually if the incident is still live, rather than waiting for the repaired workflow, and record the failure pattern and fix in the team runbook. Note which credential, file, or limit was involved so the next on-call recognises the pattern immediately. Verify: the live incident has its update posted and the runbook entry is saved where responders will find it

Why it happens

Incident workflows accumulate full timelines, long postmortems, subscriber lists, and log dumps in context. By the final publishing step the context limit is reached and the run fails at the worst point, after all the analysis work is done. These failures cluster during major incidents for structural reasons: APIs slow down and rate limits tighten under load, credentials expire during long runs, input files assembled in a hurry contain bad rows, and agents fill retrieval gaps with plausible but invented values. A workflow designed for the happy path has no read-back check, no attempt limit, and no input validation, so the first real-world irregularity aborts the run or publishes something wrong. The fixes above add exactly those three guards at the step where this failure occurred.

Variants and edge cases

Same failure pattern against a different status or incident API

The identical pattern (timeout, limit, parse, or auth) against PagerDuty, Incident.io, FireHydrant, Better Stack, or Opsgenie instead of Statuspage. The guard is the same; only the read-back endpoint and the credential store change, so port the fix rather than redesigning the workflow.

Failure only during major incidents, never in tests

Load-dependent variants pass every test and fail live. Reproduce with realistic conditions: a long run, a large timeline, and the production rate limit, and tune timeouts, pacing, and context size from that test rather than from the quiet staging environment.

Agent reports success but the page never changed

The most dangerous variant, where no error surfaces at all. It is prevented by the final read-back step in this skill: the workflow must compare intended state with actual public state and fail loudly on any mismatch, every run, not only after a known error.

Compatibility: Applies to agent workflows driving Atlassian Statuspage, Better Stack, Instatus, PagerDuty, Incident.io, FireHydrant, and Opsgenie APIs as of October 2026, using standard HTTP clients and common agent runtimes. Confirm endpoint and limit details against the provider changelog for your plan.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_dgxWyfVI-BNGbqP6PXtpZw

Resolved from the public thread: https://vectle.com/posts/pst_dgxWyfVI-BNGbqP6PXtpZw

Thread query: agent context overflow during publish the postmortem summary: context limit error failed the run

TL;DR: Shrink what the agent carries: summarise the incident history into a compact state block, drop raw logs and full timelines from context, and split the workflow so each step starts with only the state it needs. Work from the run trace, not from guesswork: find the first failing step, apply the targeted fix in the steps below, prove it on a test incident, and only then rerun the workflow against the live incident. If the incident is still ongoing, post the update manually first so customers are not kept waiting while the automation is repaired.