From df3b79e2c89978ec21dc2da7f90801dce33aeab2 Mon Sep 17 00:00:00 2001 From: Dennis Fink Date: Sat, 31 Oct 2026 19:00:17 +0100 Subject: fix(receiver): prevent endless verification recovery Cap stale verification requeues so repeatedly lost or crashing tasks eventually become terminal failures instead of cycling indefinitely. Reject URLs that httpx cannot safely fetch before enqueueing, and persist unexpected verification errors as terminal failures. --- ...a7c4d90_cap_received_verification_recoveries.py | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 webmentions_ssg/migrations/versions/e62b1a7c4d90_cap_received_verification_recoveries.py (limited to 'webmentions_ssg/migrations/versions/e62b1a7c4d90_cap_received_verification_recoveries.py') diff --git a/webmentions_ssg/migrations/versions/e62b1a7c4d90_cap_received_verification_recoveries.py b/webmentions_ssg/migrations/versions/e62b1a7c4d90_cap_received_verification_recoveries.py new file mode 100644 index 0000000..c516636 --- /dev/null +++ b/webmentions_ssg/migrations/versions/e62b1a7c4d90_cap_received_verification_recoveries.py @@ -0,0 +1,31 @@ +# SPDX-FileCopyrightText: 2026 Dennis Fink +# +# SPDX-License-Identifier: BSD-3-Clause + +"""Cap stale received Webmention verification recovery per row. + +Revision ID: e62b1a7c4d90 +Revises: d845aa7fbc19 +""" + +import sqlalchemy as sa +from alembic import op + +revision = "e62b1a7c4d90" +down_revision = "d845aa7fbc19" +branch_labels = None +depends_on = None + + +def upgrade(): + with op.batch_alter_table("received_webmentions") as batch_op: + batch_op.add_column( + sa.Column( + "recovery_attempts", sa.Integer(), nullable=False, server_default="0" + ) + ) + + +def downgrade(): + with op.batch_alter_table("received_webmentions") as batch_op: + batch_op.drop_column("recovery_attempts") -- cgit v1.3.1