Your outreach queue still contains a listing that the latest exact-ID lookup marked inactive. The ingestion job finished. Your database is perfectly available. Somehow, that makes it more annoying.

The quiet failure can sit inside your validator: it requires title , rejects the sparse status record, and leaves the previous listing eligible for outreach.

An inactive tombstone must update outreach eligibility without replacing the last listing snapshot. A successful explicit lookup can produce that tombstone when the requested ID is absent. A failed lookup can't establish inactivity.

Keep the lookup narrower than the search

A listing disappearing from a filtered search proves very little. Its price might have changed. It might no longer match your filters.

An explicit lookup gives you a narrower observation: whether that lookup returned the requested advertisement.…