From 8fd569c6c0a39761f7ddda3c6e145d90534b4300 Mon Sep 17 00:00:00 2001 From: Dennis Fink Date: Fri, 30 Oct 2026 20:13:42 +0100 Subject: fix(receiver): recover stale Webmention verifications Add a periodic recovery sweep for Webmentions left in received or verifying states after worker crashes, lost queue entries, or interrupted processing. Use atomic lease-style updates so stale workers cannot overwrite newer results, and index verification state for efficient recovery scans. --- ...272f25ce17_index_received_verification_queue.py | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py (limited to 'webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py') diff --git a/webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py b/webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py new file mode 100644 index 0000000..cbb40ef --- /dev/null +++ b/webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py @@ -0,0 +1,26 @@ +"""Index received webmentions for expired verification recovery. + +Revision ID: c0272f25ce17 +Revises: 85f2b226ec99 +""" + +from alembic import op + +revision = "c0272f25ce17" +down_revision = "85f2b226ec99" +branch_labels = None +depends_on = None + + +def upgrade(): + op.create_index( + "ix_received_webmentions_status_updated_at", + "received_webmentions", + ["status", "updated_at"], + ) + + +def downgrade(): + op.drop_index( + "ix_received_webmentions_status_updated_at", table_name="received_webmentions" + ) -- cgit v1.3.1