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: 11 items automation couldn't finish

Stuck

3 failed run · 1 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
  • SkippedTFF Second League 2024-25
    • Wikipedia page not found: 2024–25_TFF_Second_League
    Next: Retries 24 Oct, or sooner if its config changes
  • HeldNigeria Professional Football League 2022-23, 2021-22
    • The ingestion config builds 2022 where the coverage grid expects 2022-23; check seasonFormat
    • The ingestion config builds 2021 where the coverage grid expects 2021-22; check seasonFormat
    Next: Retries when its config changes
Show all (+6)
  • 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,387 of 68,647 finished API-Football matches have eventslast night +20 matches
    17 still to fetch.
  • Transfers689 of 76,416 players checkedlast night +389 players
    1,635 players have 5,580 transfer rows stored.
  • Player profiles2,670 of 78,750 API-Football players have a full name and birth datelast night +166 players
    76,080 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.