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

Args 

%{
  "account_id" => "143483",
  "segment_id" => "55adedf0-dd22-45b7-a130-f01c230e24b8"
}

Meta 

%{
  "batch" => true,
  "batch_id" => "019cb995-c6bf-75dd-b8e7-9c9946a961e1",
  "callback_opts" => %{"args" => %{"account_id" => "143483"}},
  "orig_scheduled_at" => 1772640126656222,
  "partition" => true,
  "partition_key" => "djsE2/4XP5OiNYNY59BniuKOLz8gBW2SP1SiixJtwok",
  "uniq" => true,
  "uniq_bmp" => [0, 1, 2, 3, 4, 6, 5],
  "uniq_key" => "xUzhfBAG7Bzel+gthqRXa+ZKXCxnEBJfAy2tEYLnbaI"
}

Errors

Attempt 1—3d ago 

** (Oban.CrashError) ** (exit) exited in: DBConnection.Holder.checkout({:via, PartitionSupervisor, {ClickClient.Repo.PartitionSupervisor, #PID<0.325075.0>}}, [log: #Function<14.108441648/1 in Ecto.Adapters.SQL.with_log/4>, source: "final_query", command: :select, cast_params: [143483, "_lastBrowserLanguage", "es", 143483, "country", "Mexico", 143483, "country", "Puerto Rico", 143483, "country", "Colombia", 143483, "country", "Peru", 143483, "country", "Equador", 143483, "country", "Spain", 143483, "country", "Panama", 143483, "country", "Guatemala", 143483, "country", "Dominican Republic", 143483, "country", "Argentina", 143483, "country", "Chile", 143483, "country", "Honduras", 143483, "country", "Nicaragua", 143483, "country", "Costa Rica", 143483, "country", "Bolivia", 143483, "country", "El Salvador", 143483, "country", "Venezuela", 143483, "country", "Paraquay", 143483, "country", "Uruguay", 143483], settings: [log_comment: "{\"env\":\"prod\",\"app\":\"customer_api\",\"account_id\":\"143483\",\"feature\":\"segment_memberships\",\"sub_feature\":\"count_conditions_users_execute\"}"], pool: DBConnection.ConnectionPool, repo: ClickClient.Repo, timeout: 60000, pool_size: 8, queue_target: 5000, queue_interval: 30000])
    ** (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