19658436
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.128
Run Time
-
Inserted
1d ago
Scheduled
1d ago
Completed
—
Cancelled
1d ago
Discarded
—
Args
%{
"account_id" => "143483",
"segment_id" => "734b5e82-f16c-4949-b43d-e9baca04f2aa"
}
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" => "a92l001BfiwI0wrmmQDaF/ujTozQvQRNiqrkpwDtxLc"
}
Errors
Attempt 1—1d ago
** (Oban.CrashError) ** (exit) exited in: DBConnection.Holder.checkout({:via, PartitionSupervisor, {ClickClient.Repo.PartitionSupervisor, #PID<0.287918.0>}}, [log: #Function<14.108441648/1 in Ecto.Adapters.SQL.with_log/4>, source: "final_query", command: :select, cast_params: [143483, "jobTitle", "S8", 143483, "jobTitle", "S6", 143483, "jobTitle", "S5", 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