Skip to content
Almanac
Menu
⚽

Football

  • 159 competitions
  • 72 countries
  • 113 active leagues
  • 1,388 season tables
  • 91,514 matches

Last night

Jobs that started in the last 24 hours
  • Faileddaily-stats-refreshMarked failed: still running after 6 hours, so the process that ran it ended without recording a finish
  • Doneheartbeat1 beats
  • Failedevents-backfill20 matches · 20 with lineups · 20 pending matches · 20 with event rowsError: Failed query: insert into "job_cursors" ("job_name", "cursor", "created_at", "updated_at") values ($1, $2, default, default) on conflict ("job_name") do update set "cursor" = excluded.cursor, …
  • Donetransfers-backfill389 players · 111 failed players · 2,393 transfers written · 131 unresolved transfers
  • Doneingest129 due · 39 errors · 8 queued · 128 planned
  • Donedissolved-backfill1 not due
  • Doneplayer-profiles176 players · 10 not found · 166 filled names · 166 filled photos
  • Runningsmoke

Stuck: 15 items automation couldn't finish

Stuck

3 failed run · 5 skipped · 2 held · 5 duplicate
  • Failed rundaily-stats-refresh run failed
    • Marked failed: still running after 6 hours, so the process that ran it ended without recording a finish
    Next: Runs again 20 Oct
  • Failed runevents-backfill run failed
    • Error: Failed query: insert into "job_cursors" ("job_name", "cursor", "created_at", "updated_at") values ($1, $2, default, default) on conflict ("job_name") do update set "cursor" = excluded.cursor, …
    Next: Runs again 20 Oct
  • Failed runquality-scan run failed
    • Marked failed: still running after 6 hours, so the process that ran it ended without recording a finish
    Next: Runs again 20 Oct
    • Wikipedia page not found: 2024_Peruvian_Primera_División
    Next: Retries 24 Oct, or sooner if its config changes
    • Wikipedia page not found: 2024_Venezuelan_Primera_División
    Next: Retries 24 Oct, or sooner if its config changes
Show all (+10)
  • Skipped TFF Second League 2024-25Wikipedia page not found: 2024–25_TFF_Second_League · Next: Retries 24 Oct, or sooner if its config changes
  • Skipped Major League Soccer 2024Direct parser could not read the standings table · Next: Retries 24 Oct, or sooner if its config changes
  • Skipped Major League Soccer 2023Direct parser could not read the standings table · Next: Retries 26 Oct, or sooner if its config changes
  • Held Nigeria Professional Football League 2022-23, 2021-22The ingestion config builds 2022 where the coverage grid expects 2022-23; check seasonFormat · Next: Retries when its config changes
  • Held Campeonato Brasileiro Série C 2021Multi-phase competition (promotion-group-b, promotion-group-c): the ingest job only imports single-table seasons · Next: Retries when its config changes
  • Duplicate Real Valladolid II and Valladolid PromesasOne name contains the other · Next: No automatic fix yet
  • Duplicate Dukla Banská Bystrica and Dukla Banská BystricaSame name after normalising · Next: No automatic fix yet
  • Duplicate FK Kukësi and KukësiOne name contains the other · Next: No automatic fix yet
  • Duplicate FK Voždovac and VoždovacOne name contains the other · Next: No automatic fix yet
  • Duplicate Kecskeméti TE and KecskemétOne name contains the other · Next: No automatic fix yet

17 more suspected duplicate pairs in Suspected duplicate stubs.

Goals

What each nightly job is working towards
  • Events68,372 of 68,637 finished API-Football matches have eventslast night +20 matches
    22 still to fetch.
  • Transfers689 of 76,412 players checkedlast night +389 players
    1,635 players have 5,580 transfer rows stored.
  • Player profiles2,670 of 78,746 API-Football players have a full name and birth datelast night +166 players
    76,076 still to fill.
  • Gap planner66 of 113 leagues have 5 complete seasons
    128 league-seasons to go, 40 picked for tonight.
  • Ingest queue0 of 8 queued seasons donelast night +0 imported
    0 imported, 0 skipped. Seasons come from the files in apps/jobs/ingest-queue.

Every automatic data change the nightly jobs make is listed in the changelog.