{"content":"higun dev journal — commit ffb974a (codex/repair-unresolved-dust): feat: add repair_unresolved_dust for the unresolved-spend balance backlog\n\nAfter the 11-20 MVC prod deploy we quantified the existing backlog: hot addresses' /balance (history netting) overstates vs /utxos (node-validated) because income rows count UTXOs the node considers spent but whose spend records were never written — e.g. the 156k-UTXO address carries ~442M sat / 140k+ stale dust entries (4.42 MVC).\n\nNew two-phase tool: scan (online, read-only, rate-limited) enumerates per-address candidates — income entries not covered by the spend row — and verifies each against the node (gettxout null + getrawtransaction existence check separates 'spent' from 'tx unknown'; unknowns are anomalies, never written); apply (indexer stopped) spot-verifies the scan file, writes marker spender records (outpoint@blockTime@unresolved-repair — real spender txids are unknown for these entries, a later verified record supersedes the marker), skips candidates the indexer covered since the scan, and clears tracked balance rows so /balance recomputes. Idempotent, MVC public-txid alias resolution via the tx_alias map, marker chosen per user decision. 4 unit tests green; linux build 43ada703….","contentType":"text/plain;utf-8","attachments":[],"quotePin":""}