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. --- webmentions_ssg/models.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'webmentions_ssg/models.py') diff --git a/webmentions_ssg/models.py b/webmentions_ssg/models.py index 4f688e5..58f95bc 100644 --- a/webmentions_ssg/models.py +++ b/webmentions_ssg/models.py @@ -17,6 +17,7 @@ from sqlalchemy import ( DateTime, Enum, ForeignKey, + Index, Integer, String, Text, @@ -116,6 +117,7 @@ class ReceivedWebmention(Base): __table_args__ = ( UniqueConstraint("source", "target", name="uq_webmention_source_target"), + Index("ix_received_webmentions_status_updated_at", "status", "updated_at"), ) def __repr__(self) -> str: @@ -246,9 +248,7 @@ class SentWebmention(Base): status_url: Mapped[str | None] = mapped_column(Text(), nullable=True, default=None) # Retry state belongs to the desired revision, not to the target forever. - attempt_count: Mapped[int] = mapped_column( - Integer(), nullable=False, default=0 - ) + attempt_count: Mapped[int] = mapped_column(Integer(), nullable=False, default=0) next_retry_at: Mapped[datetime | None] = mapped_column( DateTime(timezone=True), nullable=True, default=None ) -- cgit v1.3.1