diff options
| author | Dennis Fink | 2026-10-30 20:13:42 +0100 |
|---|---|---|
| committer | Dennis Fink | 2026-10-30 20:13:42 +0100 |
| commit | 8fd569c6c0a39761f7ddda3c6e145d90534b4300 (patch) | |
| tree | f92209df1918fd5c9ac27efe25463afaef2a1a5f /webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py | |
| parent | a2992533873cb53acb052cdcd4288430b24af587 (diff) | |
| download | webmentions-ssg-8fd569c6c0a39761f7ddda3c6e145d90534b4300.tar.gz webmentions-ssg-8fd569c6c0a39761f7ddda3c6e145d90534b4300.zip | |
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.
Diffstat (limited to 'webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py')
| -rw-r--r-- | webmentions_ssg/migrations/versions/c0272f25ce17_index_received_verification_queue.py | 26 |
1 files changed, 26 insertions, 0 deletions
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" + ) |
