19645676 CustomerApi.Jobs.SegmentUserCountBatchJob
Queue segment_user_counts_queue
Attempt 1 of 3
Priority 0
Tags ...
Node customer_api@10.10.0.159
Queue Time 00:18.139
Run Time -
Inserted 2d ago
Scheduled 2d ago
Completed —
Cancelled 2d ago
Discarded —

Args 

%{
  "account_id" => "63687",
  "segment_id" => "f5848cfa-3200-4fa0-b801-c23a55f92747"
}

Meta 

%{
  "batch" => true,
  "batch_id" => "019cb950-c1e1-7a63-a6a8-85acdb8e22f3",
  "callback_opts" => %{"args" => %{"account_id" => "63687"}},
  "orig_scheduled_at" => 1772635603425647,
  "partition" => true,
  "partition_key" => "DAg4AyKYFbm1MJB6Jq6FLmedtnrmZS7O3/TsPspmb4A",
  "uniq" => true,
  "uniq_bmp" => [0, 1, 2, 3, 4, 6, 5],
  "uniq_conflict" => true,
  "uniq_key" => "Fv/D2dOF8gzsIImUOQFl8LW3jEnOhPUKUkLFdiKRktU"
}

Errors

Attempt 1—2d ago 

** (Oban.CrashError) ** (exit) exited in: DBConnection.Holder.checkout({:via, PartitionSupervisor, {ClickClient.Repo.PartitionSupervisor, #PID<0.306053.0>}}, [log: #Function<14.108441648/1 in Ecto.Adapters.SQL.with_log/4>, source: "final_query", command: :select, cast_params: [63687, "plan_name", "Advanced", 63687, "plan_name", "Growth", 63687, "plan_name", "Scale", 63687, "has_active_uncancelled_subscription", "false", 63687, "signed-up-for-account", ~N[2026-02-02 16:04:53.507799], 1, 63687, "Completed Order", ~N[2026-02-02 16:04:53.507816], 1, 63687, "plan_name", "Free", 63687, "Completed Order", ~N[2026-02-02 16:04:53.507830], 1, 63687, "plan_name", "Growth", 63687, "plan_name", "Advanced", 63687, "Completed Order", ~N[2026-02-02 16:04:53.508391], 1, 63687, "plan_name", "Starter", 63687, "started-trial", ~N[2026-02-02 16:04:53.508404], 1, 63687, "Completed Order", ~N[2026-02-18 16:04:53.508408], 1, 63687, "plan_name", "Creator", "plan_name", 63687, "Completed Order", ~N[2026-02-02 16:04:53.508418], 1, 63687, "plan_name", "Basics", 63687, "started-trial", ~N[2026-02-17 16:04:53.508426], 1, 63687, "_deviceType", "desktop", 63687, "test_group_id", "50", 63687, "team_size", "2_3_people", 63687, "team_size", "4_6_people", 63687, "team_size", "more_than_6_people", 63687, "company_size", "2_10_people", 63687, "company_size", "11_50_people", 63687, "company_size", "51_100_people", 63687, "company_size", "over_100_people", 63687, "signed-up-for-account", 0, 0, 63687, "_lastBrowserLanguage", ...], ...])
    ** (EXIT) shutdown
    (db_connection 2.9.0) lib/db_connection/holder.ex:99: DBConnection.Holder.checkout/3
    (db_connection 2.9.0) lib/db_connection.ex:1335: DBConnection.checkout/3
    (db_connection 2.9.0) lib/db_connection.ex:1584: DBConnection.run_with_retries/5
    (db_connection 2.9.0) lib/db_connection.ex:848: DBConnection.execute/4
    (ch 0.7.1) lib/ch.ex:94: Ch.query/4
    (ecto_sql 3.13.4) lib/ecto/adapters/sql.ex:620: Ecto.Adapters.SQL.query!/4
    (ecto_ch 0.8.6) lib/ecto/adapters/clickhouse.ex:323: Ecto.Adapters.ClickHouse.execute/5
    (ecto 3.13.5) lib/ecto/repo/queryable.ex:241: Ecto.Repo.Queryable.execute/4