19821210
CustomerApi.Jobs.GenerateAccountMetrics
Queue
clickhouse_account_metrics
Attempt
4 of 10
Priority
0
Tags
...
Node
customer_api@10.10.1.214
Queue Time
05:58.360
Run Time
00:03.993
Inserted
11h ago
Scheduled
9h ago
Completed
9h ago (00:04)
Cancelled
—
Discarded
—
Args
%{
"account_id" => "88742",
"date" => "2026-03-06",
"query" => "event_counts",
"window_days" => 7
}
Meta
%{
"deps" => ["generate_user_counts"],
"name" => "generate_event_counts",
"on_hold" => false,
"orig_scheduled_at" => 1772757404503833,
"recorded" => true,
"return" => "g1AAAAGueJxVkT1OxDAUhA3FFmwSrRAF1PR0iIob0HEAy3ZmsxaObfk5MRyAG3EOjsEpKHj5IYLG0nya9zxjZyHEddlhhM+kRX7/ZpFSSCzOPu5LXWzbIUsXVItWi7ub87I/ulBI0ikUr4W4fSpVF5Qj2VsitEqUetEJypxm0PhIskVOymTezaSaiMfAyE26nnRMoQ8Zs+Eiqg5ytCgc5SF8lopMAvyC2HDZB20dJF4jkoU3WMasX7OxOkxbaUgj3jZ29YclUAye5skDemU5tcoZfcxz7v3KiJ9nqrFKHQa+bm66kiOf/0CI8Ev1FRhnzcti0cp7LrklalSMZgDJ3294rL5KowfrWqQNit3zD2mfnZE",
"structured" => true,
"workflow" => true,
"workflow_id" => "019cc07f-7902-79ce-81f0-f30f11a7eac8"
}
Recorded Output
%{
events: 7636476,
errors: 111669,
widget_loaded: 3021058,
flows_shown: 9036,
goals_missed: 0,
goals_reached: 0,
nps_detractors: 0,
nps_neutrals: 0,
nps_promoters: 0,
page_views: 3633102,
screen_views: 0,
mobile_experiences: 0,
pins_shown: 0,
nps_survey_shown: 0,
nps_survey_responses: 0,
emails_attempted: 0,
emails_sent: 0,
emails_bounced: 0,
emails_failed: 0,
emails_opened: 0,
emails_clicked: 0,
banners_shown: 0,
appcues_events: 4000998,
builder_events: 1619
}
Errors
Attempt 3—9h ago
** (FunctionClauseError) no function clause matching in Ch.RowBinary.decode_names/4
The following arguments were given to Ch.RowBinary.decode_names/4:
# 1
"5 (official build))\n"
# 2
52
# 3
67
# 4
["ool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.737", "d, or data is corrupted. Please retry the query: While executing MergeTreeSelect(pool: PrefetchedRead", "that some retryable error happen", "mn timestamp): (attempt to read data part all_171053_173527_8_112386651 (state Active) failed with error. It can mean", "38a:39982, kind: Regular, unbound: 0: (while reading col", "a74cda13-b5a5-47b9-8ae5-a9b2dd87", " current write offset: 452984832, caller id:", "WNLOADED, downloaded size: 8388608, reserved size: 8388608, downloader id: None", "1], key: 474209e71fcebdb4a5e2f2286e8e6f85, state: D", "ast caller: a74cda13-b5a5-47b9-8ae5-a9b2dd87838a:39982, file segment info: File segment: [444596224, 4529848", "5, internal buffer end: 6729801, read_type: CACHED, ", "imgxz, hash key: 474209e71fcebdb4a5e2f2286e8e6f85, file_offset_of_buffer_end: 451326025, read_until_position: 4513574", "tput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/yrk/jmzrtdbkdteqfvjdajbzjcv", "86e8e6f85/444596224: , errno: 5, strerror: Input/o", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/474/474209e71fcebdb4a5e2f2"]
(ch 0.7.1) lib/ch/row_binary.ex:789: Ch.RowBinary.decode_names/4
(ch 0.7.1) lib/ch/query.ex:290: DBConnection.Query.Ch.Query.decode/3
(db_connection 2.9.0) lib/db_connection.ex:1470: DBConnection.decode/4
(db_connection 2.9.0) lib/db_connection.ex:849: 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—9h ago
** (FunctionClauseError) no function clause matching in Ch.RowBinary.decode_names/4
The following arguments were given to Ch.RowBinary.decode_names/4:
# 1
"PTOR) (version 25.10.1.7375 (official build))\n"
# 2
53
# 3
67
# 4
["uery: While executing MergeTreeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRI", " with error. It can mean that some retryable error happened, or data is corrupted. Please retry the ", "ing column timestamp): (attempt to read data part all_171053_173527_8_112386651 (state Active) faile", "8f8:42750, kind: Regular, unbound: 0: (while rea", "e77da159-d2cb-47b6-b2bd-5eb2a90e", " current write offset: 452984832, caller id:", "WNLOADED, downloaded size: 8388608, reserved size: 8388608, downloader id: None", "1], key: 474209e71fcebdb4a5e2f2286e8e6f85, state: D", "ast caller: e77da159-d2cb-47b6-b2bd-5eb2a90e08f8:42750, file segment info: File segment: [444596224, 4529848", "5, internal buffer end: 6729801, read_type: CACHED, ", "imgxz, hash key: 474209e71fcebdb4a5e2f2286e8e6f85, file_offset_of_buffer_end: 451326025, read_until_position: 4513574", "tput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/yrk/jmzrtdbkdteqfvjdajbzjcv", "86e8e6f85/444596224: , errno: 5, strerror: Input/o", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/474/474209e71fcebdb4a5e2f2"]
(ch 0.7.1) lib/ch/row_binary.ex:789: Ch.RowBinary.decode_names/4
(ch 0.7.1) lib/ch/query.ex:290: DBConnection.Query.Ch.Query.decode/3
(db_connection 2.9.0) lib/db_connection.ex:1470: DBConnection.decode/4
(db_connection 2.9.0) lib/db_connection.ex:849: 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—10h ago
** (FunctionClauseError) no function clause matching in Ch.RowBinary.decode_names/4
The following arguments were given to Ch.RowBinary.decode_names/4:
# 1
"OM_FILE_DESCRIPTOR) (version 25.10.1.7375 (official build))\n"
# 2
53
# 3
67
# 4
[" query: While executing MergeTreeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FR", "ate Active) failed with error. It can mean that some retryable error happened, or data is corrupted. Please retry th", "all_171053_173527_8_112386651 (s", "756:41338, kind: Regular, unbound: 0: (while reading column timestamp): (attempt to read data part", "e8e1b636-9e02-4646-bf8c-c5c60858", " current write offset: 452984832, caller id:", "WNLOADED, downloaded size: 8388608, reserved size: 8388608, downloader id: None", "1], key: 474209e71fcebdb4a5e2f2286e8e6f85, state: D", "ast caller: e8e1b636-9e02-4646-bf8c-c5c60858b756:41338, file segment info: File segment: [444596224, 4529848", "5, internal buffer end: 6729801, read_type: CACHED, ", "imgxz, hash key: 474209e71fcebdb4a5e2f2286e8e6f85, file_offset_of_buffer_end: 451326025, read_until_position: 4513574", "tput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/yrk/jmzrtdbkdteqfvjdajbzjcv", "86e8e6f85/444596224: , errno: 5, strerror: Input/o", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/474/474209e71fcebdb4a5e2f2"]
(ch 0.7.1) lib/ch/row_binary.ex:789: Ch.RowBinary.decode_names/4
(ch 0.7.1) lib/ch/query.ex:290: DBConnection.Query.Ch.Query.decode/3
(db_connection 2.9.0) lib/db_connection.ex:1470: DBConnection.decode/4
(db_connection 2.9.0) lib/db_connection.ex:849: 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