bug: ERROR 42P01 (undefined_table) relation "platform.oban_jobs" does not exist #867

New issue

Closed

opened 2026-03-28 04:29:22 +00:00 by mfreeman451 · 0 comments

mfreeman451 commented

2026-03-28 04:29:22 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #2512
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2512
Original created: 2026-01-26T03:36:28Z

Describe the bug

When trying to do a fresh install of the docker compose stack, unable to login to the UI and seeing these errors in serviceradar-web-ng on our fresh alma9 box:

Last message: :dispatch
03:33:24.029 [error] GenServer {Oban.Registry, {Oban, {:producer, "events"}}} terminating
** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "platform.oban_jobs" does not exist

    query: WITH "subset" AS (SELECT so0."id" AS "id" FROM "platform"."oban_jobs" AS so0 WHERE (so0."state" = 'available') AND (so0."queue" = $1) ORDER BY so0."priority", so0."scheduled_at", so0."id" LIMIT $2 FOR UPDATE SKIP LOCKED) UPDATE "platform"."oban_jobs" AS o0 SET "state" = $3, "attempted_at" = $4, "attempted_by" = $5, "attempt" = o0."attempt" + $6 FROM "subset" AS f1 WHERE (o0."id" = f1."id") AND (o0."attempt" < o0."max_attempts") RETURNING o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at"
    (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1108: Ecto.Adapters.SQL.raise_sql_call_error/1
    (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1006: Ecto.Adapters.SQL.execute/6
    (ecto 3.13.5) lib/ecto/repo/queryable.ex:241: Ecto.Repo.Queryable.execute/4
    (oban 2.20.2) lib/oban/engines/basic.ex:127: anonymous fn/4 in Oban.Engines.Basic.fetch_jobs/3
    (serviceradar_core 0.1.0) lib/serviceradar/repo.ex:16: anonymous fn/1 in ServiceRadar.Repo."transaction (overridable 1)"/2
    (ecto 3.13.5) lib/ecto/repo/transaction.ex:11: anonymous fn/3 in Ecto.Repo.Transaction.transact/4
    (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1468: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4
    (db_connection 2.8.1) lib/db_connection.ex:1753: DBConnection.run_transaction/4
Last message: :dispatch
03:33:24.207 [error] GenServer {Oban.Registry, {Oban, {:producer, "integrations"}}} terminating
** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "platform.oban_jobs" does not exist

    query: WITH "subset" AS (SELECT so0."id" AS "id" FROM "platform"."oban_jobs" AS so0 WHERE (so0."state" = 'available') AND (so0."queue" = $1) ORDER BY so0."priority", so0."scheduled_at", so0."id" LIMIT $2 FOR UPDATE SKIP LOCKED) UPDATE "platform"."oban_jobs" AS o0 SET "state" = $3, "attempted_at" = $4, "attempted_by" = $5, "attempt" = o0."attempt" + $6 FROM "subset" AS f1 WHERE (o0."id" = f1."id") AND (o0."attempt" < o0."max_attempts") RETURNING o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at"
    (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1108: Ecto.Adapters.SQL.raise_sql_call_error/1
    (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1006: Ecto.Adapters.SQL.execute/6
    (ecto 3.13.5) lib/ecto/repo/queryable.ex:241: Ecto.Repo.Queryable.execute/4
    (oban 2.20.2) lib/oban/engines/basic.ex:127: anonymous fn/4 in Oban.Engines.Basic.fetch_jobs/3
    (serviceradar_core 0.1.0) lib/serviceradar/repo.ex:16: anonymous fn/1 in ServiceRadar.Repo."transaction (overridable 1)"/2
    (ecto 3.13.5) lib/ecto/repo/transaction.ex:11: anonymous fn/3 in Ecto.Repo.Transaction.transact/4
    (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1468: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4
    (db_connection 2.8.1) lib/db_connection.ex:1753: DBConnection.run_transaction/4
Last message: :dispatch

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

Imported from GitHub. Original GitHub issue: #2512 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2512 Original created: 2026-01-26T03:36:28Z --- **Describe the bug** When trying to do a fresh install of the `docker compose` stack, unable to login to the UI and seeing these errors in `serviceradar-web-ng` on our fresh alma9 box: ``` Last message: :dispatch 03:33:24.029 [error] GenServer {Oban.Registry, {Oban, {:producer, "events"}}} terminating ** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "platform.oban_jobs" does not exist query: WITH "subset" AS (SELECT so0."id" AS "id" FROM "platform"."oban_jobs" AS so0 WHERE (so0."state" = 'available') AND (so0."queue" = $1) ORDER BY so0."priority", so0."scheduled_at", so0."id" LIMIT $2 FOR UPDATE SKIP LOCKED) UPDATE "platform"."oban_jobs" AS o0 SET "state" = $3, "attempted_at" = $4, "attempted_by" = $5, "attempt" = o0."attempt" + $6 FROM "subset" AS f1 WHERE (o0."id" = f1."id") AND (o0."attempt" < o0."max_attempts") RETURNING o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at" (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1108: Ecto.Adapters.SQL.raise_sql_call_error/1 (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1006: Ecto.Adapters.SQL.execute/6 (ecto 3.13.5) lib/ecto/repo/queryable.ex:241: Ecto.Repo.Queryable.execute/4 (oban 2.20.2) lib/oban/engines/basic.ex:127: anonymous fn/4 in Oban.Engines.Basic.fetch_jobs/3 (serviceradar_core 0.1.0) lib/serviceradar/repo.ex:16: anonymous fn/1 in ServiceRadar.Repo."transaction (overridable 1)"/2 (ecto 3.13.5) lib/ecto/repo/transaction.ex:11: anonymous fn/3 in Ecto.Repo.Transaction.transact/4 (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1468: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4 (db_connection 2.8.1) lib/db_connection.ex:1753: DBConnection.run_transaction/4 Last message: :dispatch 03:33:24.207 [error] GenServer {Oban.Registry, {Oban, {:producer, "integrations"}}} terminating ** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "platform.oban_jobs" does not exist query: WITH "subset" AS (SELECT so0."id" AS "id" FROM "platform"."oban_jobs" AS so0 WHERE (so0."state" = 'available') AND (so0."queue" = $1) ORDER BY so0."priority", so0."scheduled_at", so0."id" LIMIT $2 FOR UPDATE SKIP LOCKED) UPDATE "platform"."oban_jobs" AS o0 SET "state" = $3, "attempted_at" = $4, "attempted_by" = $5, "attempt" = o0."attempt" + $6 FROM "subset" AS f1 WHERE (o0."id" = f1."id") AND (o0."attempt" < o0."max_attempts") RETURNING o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at" (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1108: Ecto.Adapters.SQL.raise_sql_call_error/1 (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1006: Ecto.Adapters.SQL.execute/6 (ecto 3.13.5) lib/ecto/repo/queryable.ex:241: Ecto.Repo.Queryable.execute/4 (oban 2.20.2) lib/oban/engines/basic.ex:127: anonymous fn/4 in Oban.Engines.Basic.fetch_jobs/3 (serviceradar_core 0.1.0) lib/serviceradar/repo.ex:16: anonymous fn/1 in ServiceRadar.Repo."transaction (overridable 1)"/2 (ecto 3.13.5) lib/ecto/repo/transaction.ex:11: anonymous fn/3 in Ecto.Repo.Transaction.transact/4 (ecto_sql 3.13.3) lib/ecto/adapters/sql.ex:1468: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4 (db_connection 2.8.1) lib/db_connection.ex:1753: DBConnection.run_transaction/4 Last message: :dispatch ``` **To Reproduce** Steps to reproduce the behavior: 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. See error **Expected behavior** A clear and concise description of what you expected to happen. **Screenshots** If applicable, add screenshots to help explain your problem. **Desktop (please complete the following information):** - OS: [e.g. iOS] - Browser [e.g. chrome, safari] - Version [e.g. 22] **Smartphone (please complete the following information):** - Device: [e.g. iPhone6] - OS: [e.g. iOS8.1] - Browser [e.g. stock browser, safari] - Version [e.g. 22] **Additional context** Add any other context about the problem here.