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 1d ago
Scheduled 1d ago
Completed —
Cancelled 1d 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—1d 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