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>
128 lines
5.3 KiB
Python
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)
|