Anna V:

Verkar fortfarande vara något tokigt @Kristian Cofinder architecture

Kristian:

Broken Opportunity Links From Slack/Airtable (404) Symptoms:

  • Some /opportunities/ links return 404 in the portal.
  • Not all links fail, only some.

What happened:

  • Link data existed in Snowflake (core.obt_evaluated_job_ads / core.obt_consultant_matches).
  • The same opportunities were missing in backend Postgres (evaluatedjobads), which is what /jobpostings/{id} uses.
  • Daily sync automation (cofinder-cronjob) runs /fetch_latest, but on March 6, 2026 the API pod was in CrashLoopBackOff, and the cron job hung (0/1 completion).
  • Result: Snowflake was up to date, Postgres was stale, so links 404’d.

How we fixed it:

  1. Ran manual full sync on backend:

curl -i “https://cofinder-api.platform.datadrivet.ai/fetch_tables”
-H “Authorization: Bearer "

  1. Sync inserted missing rows and links started working again.

    How to diagnose quickly next time:

  2. Pick a failing UUID.
  3. Verify it exists in Snowflake.
  4. Verify it exists in Postgres.
  5. Check cron job status:

kubectl -n cofinder-api get cronjob kubectl -n cofinder-api get job –sort-by=.metadata.creationTimestamp | tail -n 5

If latest job is 0/1, sync likely failed/hung.

Updated: