""" 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)