19645679 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.257
Run Time -
Inserted 1d ago
Scheduled 1d ago
Completed —
Cancelled 1d ago
Discarded —

Args 

%{
  "account_id" => "63687",
  "segment_id" => "83216b21-8fb2-454d-be01-ee09e1ccb14a"
}

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" => "B8jJTk3EuI75yVFV2OnTw6SDP/6ydJxT0/KMEXSlWEk"
}

Errors

Attempt 1—1d ago 

** (Oban.CrashError) ** (exit) exited in: DBConnection.Holder.checkout({:via, PartitionSupervisor, {ClickClient.Repo.PartitionSupervisor, #PID<0.307101.0>}}, [log: #Function<14.108441648/1 in Ecto.Adapters.SQL.with_log/4>, source: "final_query", command: :select, cast_params: [63687, "has_active_uncancelled_subscription", "false", 63687, "signed-up-for-account", ~N[2026-02-02 16:04:54.115599], 1, 63687, "Completed Order", ~N[2026-02-02 16:04:54.115616], 1, 63687, "plan_name", "Free", 63687, "Completed Order", ~N[2026-02-02 16:04:54.115622], 1, 63687, "plan_name", "Growth", 63687, "plan_name", "Advanced", 63687, "Completed Order", ~N[2026-02-02 16:04:54.115628], 1, 63687, "plan_name", "Starter", 63687, "started-trial", ~N[2026-02-02 16:04:54.115632], 1, 63687, "Completed Order", ~N[2026-02-18 16:04:54.115634], 1, 63687, "plan_name", "Creator", "plan_name", 63687, "Completed Order", ~N[2026-02-02 16:04:54.116319], 1, 63687, "plan_name", "Basics", 63687, "started-trial", ~N[2026-02-17 16:04:54.116336], 1, 63687, "attempted-connecting-instagram-account", ~N[2026-02-02 16:04:54.116339], 1, 63687, "added-instagram-account", ~N[2026-02-02 16:04:54.116342], 1, 63687, "test_group_id", "51", 63687, "_deviceType", "desktop", 63687, "email", "later.com", 63687, "plan_name", "Free", 63687, "plan_name", "Starter", 63687, "plan_name", "Growth", 63687, "plan_name", "Advanced", 63687, "plan_name", "Scale 15", 63687, "plan_name", "Scale 30", 63687], settings: [log_comment: "{\"env\":\"prod\",\"app\":\"customer_api\",\"account_id\":\"63687\",\"feature\":\"segment_memberships\",\"sub_feature\":\"count_conditions_users_execute\"}"], pool: DBConnection.ConnectionPool, repo: ClickClient.Repo, timeout: 60000, pool_size: 8, ...])
    ** (EXIT) killed
    (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