19654066 CustomerApi.Jobs.SegmentUserCountBatchJob
Queue segment_user_counts_queue
Attempt 3 of 3
Priority 0
Tags ...
Node customer_api@10.10.1.214
Queue Time 00:01.094
Run Time 00:48.478
Inserted 22h ago
Scheduled 22h ago
Completed —
Cancelled —
Discarded 22h ago

Args 

%{"account_id" => "88035", "segment_id" => "-Mz-LYCJRfCgb9gPF0TV"}

Meta 

%{
  "batch" => true,
  "batch_id" => "019cb98a-c486-747f-a5e6-132f7cf67da0",
  "callback_opts" => %{"args" => %{"account_id" => "88035"}},
  "orig_scheduled_at" => 1772639405190835,
  "partition" => true,
  "partition_key" => "xOSA6nhyXo1s3j5We7f3HQyhimMLEYhPG0XNzekJK8c",
  "uniq" => true,
  "uniq_bmp" => [0, 1, 2, 3, 4, 6, 5],
  "uniq_conflict" => true,
  "uniq_key" => "9S3Da7s7xNyazXa8Ap1Ur7oUhFCK54fh3JpQB9Nzcyw"
}

Errors

Attempt 3—22h ago 

** (Oban.CrashError) ** (exit) exited in: DBConnection.Holder.checkout({:via, PartitionSupervisor, {ClickClient.Repo.PartitionSupervisor, #PID<0.369885.0>}}, [log: #Function<14.108441648/1 in Ecto.Adapters.SQL.with_log/4>, source: "final_query", command: :select, cast_params: [88035, "created_at", 86400, 88035, "Store Connected", 0, 0, 88035, "is_selling", "false", 88035, "group", "merchant", 88035], settings: [log_comment: "{\"env\":\"prod\",\"app\":\"customer_api\",\"account_id\":\"88035\",\"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) 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

Attempt 2—22h ago 

** (Oban.CrashError) ** (exit) exited in: DBConnection.Holder.checkout({:via, PartitionSupervisor, {ClickClient.Repo.PartitionSupervisor, #PID<0.352895.0>}}, [log: #Function<14.108441648/1 in Ecto.Adapters.SQL.with_log/4>, source: "final_query", command: :select, cast_params: [88035, "created_at", 86400, 88035, "Store Connected", 0, 0, 88035, "is_selling", "false", 88035, "group", "merchant", 88035], settings: [log_comment: "{\"env\":\"prod\",\"app\":\"customer_api\",\"account_id\":\"88035\",\"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) 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

Attempt 1—22h ago 

** (Oban.CrashError) ** (exit) exited in: DBConnection.Holder.checkout({:via, PartitionSupervisor, {ClickClient.Repo.PartitionSupervisor, #PID<0.281773.0>}}, [log: #Function<14.108441648/1 in Ecto.Adapters.SQL.with_log/4>, source: "final_query", command: :select, cast_params: [88035, "created_at", 86400, 88035, "Store Connected", 0, 0, 88035, "is_selling", "false", 88035, "group", "merchant", 88035], settings: [log_comment: "{\"env\":\"prod\",\"app\":\"customer_api\",\"account_id\":\"88035\",\"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) 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