Files
PhilandClaude Opus 5.5 aa88db50b2 feat: admin Log and Settings pages, decluttered Webmentions page (v2.18.0)
Notifications move to /admin/settings. /admin/log lists everything failing
now (crossposts, response checks, outgoing webmentions, reply contexts,
WebSub, notifications, refused silo credentials) with the affected post,
the error and Retry/Check now. Back to Dashboard button removed; nav gains
Webmentions, Log (with error count) and Settings.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-11-12 13:05:26 -07:00

128 lines
5.3 KiB
Python

"""
Error log for the admin Log page (v2.18.0)
Collects what is failing right now from the tables that already record it:
crossposts, response checks (backfeed), outgoing webmentions, reply-context
fetches, WebSub deliveries and notifications. Nothing new is stored. An entry
disappears once the next attempt succeeds, so the page lists only problems
that still need attention.
Each entry is a dict:
when -- timestamp text (UTC) or "" when unknown
area -- short label, e.g. "Crosspost to Bluesky"
note -- the affected Note, or None for site-wide problems
detail -- extra context (a URL or "retrying"), may be ""
error -- the recorded error message
action -- optional (endpoint, id, label) for a retry button
"""
from flask import current_app
from starpunk.database import get_db
SILOS = {"gotosocial": "GoToSocial", "bluesky": "Bluesky", "threads": "Threads"}
def _silo(target: str) -> str:
return SILOS.get(target, target)
def _notes(ids) -> dict:
"""Load the affected notes once each (deleted notes come back as None)"""
from starpunk.notes import get_note
return {i: get_note(id=i) for i in set(ids) if i is not None}
def entries() -> list:
"""Every current error, newest first; site-wide problems come first"""
from starpunk import backfeed, notifications
db = get_db(current_app)
rows = []
for r in db.execute(
"SELECT id, note_id, target, state, last_error, updated_at FROM syndications "
"WHERE last_error IS NOT NULL AND state != 'synced'"
):
rows.append({
"when": r["updated_at"], "area": f"Crosspost to {_silo(r['target'])}",
"note_id": r["note_id"], "detail": "retrying" if r["state"] == "pending" else "",
"error": r["last_error"],
"action": ("admin.retry_syndication", r["id"], "Retry"),
})
for r in db.execute(
"SELECT id, note_id, target, backfeed_error, backfeed_checked_at, remote_url FROM syndications "
"WHERE backfeed_error IS NOT NULL"
):
rows.append({
"when": r["backfeed_checked_at"], "area": f"Response check on {_silo(r['target'])}",
"note_id": r["note_id"], "detail": r["remote_url"] or "", "error": r["backfeed_error"],
"action": ("admin.check_syndication_responses", r["id"], "Check now"),
})
for r in db.execute(
"SELECT source_note_id, target_url, status, last_error, COALESCE(started_at, created_at) AS at "
"FROM webmention_queue WHERE last_error IS NOT NULL AND status IN ('pending', 'failed')"
):
rows.append({
"when": r["at"], "area": "Webmention sent", "note_id": r["source_note_id"],
"detail": r["target_url"] + (" (retrying)" if r["status"] == "pending" else ""),
"error": r["last_error"], "action": None,
})
for r in db.execute(
"SELECT n.id AS note_id, rc.url, rc.fetch_error, rc.fetched_at, rc.created_at "
"FROM reply_contexts rc JOIN notes n ON n.in_reply_to = rc.url "
"WHERE rc.fetch_status = 'error' AND n.deleted_at IS NULL"
):
rows.append({
"when": r["fetched_at"] or r["created_at"], "area": "Reply context fetch",
"note_id": r["note_id"], "detail": r["url"], "error": r["fetch_error"] or "fetch failed",
"action": None,
})
for r in db.execute(
"SELECT topic, callback, last_error, COALESCE(last_success_at, verified_at, created_at) AS at "
"FROM websub_subscriptions WHERE last_error IS NOT NULL"
):
rows.append({
"when": r["at"], "area": "WebSub delivery", "note_id": None,
"detail": f"{r['topic']} → {r['callback']}", "error": r["last_error"], "action": None,
})
rows.sort(key=lambda e: str(e["when"] or ""), reverse=True)
site = []
for silo, message in backfeed.denied.items():
site.append({"when": "", "area": f"Response checks on {_silo(silo)}", "note_id": None,
"detail": "paused", "error": message, "action": None})
notify_error = notifications.last_error(db)
if notify_error:
when, _, message = notify_error.partition(" UTC ")
site.append({"when": when if message else "", "area": "Notifications", "note_id": None,
"detail": "", "error": message or notify_error, "action": None})
entries = site + rows
notes = _notes(e["note_id"] for e in entries)
for e in entries:
e["note"] = notes.get(e.pop("note_id"))
return entries
def count() -> int:
"""Cheap total for the admin nav badge"""
from starpunk import backfeed, notifications
db = get_db(current_app)
total = db.execute(
"SELECT (SELECT COUNT(*) FROM syndications WHERE last_error IS NOT NULL AND state != 'synced')"
" + (SELECT COUNT(*) FROM syndications WHERE backfeed_error IS NOT NULL)"
" + (SELECT COUNT(*) FROM webmention_queue WHERE last_error IS NOT NULL AND status IN ('pending', 'failed'))"
" + (SELECT COUNT(*) FROM reply_contexts rc JOIN notes n ON n.in_reply_to = rc.url"
" WHERE rc.fetch_status = 'error' AND n.deleted_at IS NULL)"
" + (SELECT COUNT(*) FROM websub_subscriptions WHERE last_error IS NOT NULL)"
).fetchone()[0]
return total + len(backfeed.denied) + (1 if notifications.last_error(db) else 0)