19833490
CustomerApi.Jobs.GenerateAccountMetrics
Queue
clickhouse_account_metrics
Attempt
3 of 10
Priority
0
Tags
...
Node
customer_api@10.10.1.109
Queue Time
08:52.943
Run Time
00:03.457
Inserted
8h ago
Scheduled
6h ago
Completed
6h ago (00:04)
Cancelled
—
Discarded
—
Args
%{
"account_id" => "221599",
"date" => "2026-03-06",
"query" => "event_counts",
"window_days" => 30
}
Meta
%{
"deps" => ["generate_user_counts"],
"name" => "generate_event_counts",
"on_hold" => false,
"orig_scheduled_at" => 1772758557501566,
"recorded" => true,
"return" => "g1AAAAGoeJxVkUFOwzAURF2pQipNogqx4BCs2XALNqyQ9e1MUwvHtvydGI7BAbkLTmIq2Fiap/nfM3YSQjzkG8xwiZU4PL8UEaOPTI+5zaYfkKT11KNXYvdF+Xi2PrPki89OCbE75GbwZFmOhhk9idxuOoL0ZQWdCyx7pEg6LYtFbhbiMBVkF90uOkQ/+oTVcBtogJwNcgm1/37NDesIuA0Vw93olbGQ+AiIBk5jGzOuZivqtGzlKc74vLL7PyyCg3e8Tp4wkimpKSWMIa25j5VxeZulRpXKT+W6tWkl53L+Az7AbdUr0Nbo982iyLlS8pqooxD0BJa/f7B/e8qdmoztESsk8QNBvJqK",
"structured" => true,
"workflow" => true,
"workflow_id" => "019cc07f-7a63-729a-85b3-906de1a19ad9"
}
Recorded Output
%{
events: 605010,
errors: 44,
widget_loaded: 102753,
flows_shown: 265,
goals_missed: 0,
goals_reached: 0,
nps_detractors: 0,
nps_neutrals: 0,
nps_promoters: 0,
page_views: 318807,
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: 286006,
builder_events: 0
}
Errors
Attempt 2—6h ago
** (FunctionClauseError) no function clause matching in Ch.RowBinary.decode_names/4
The following arguments were given to Ch.RowBinary.decode_names/4:
# 1
""
# 2
43
# 3
67
# 4
["eeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_OPEN_FILE) (version 25.10.1.7375 (official build))\n", " mean that some retryable error happened, or data is corrupted. Please retry the query: While executing MergeT", "0_22488012 (state Active) failed with error. It ca", "data part all_12661296_12746905_", "nchronousBoundedReadBuffer, compressed data header: <uninitialized>): (while reading column attributes): (attempt to read", "-8441591d3836/mergetree/qgx/cntihuflqgvmiglrrdawumkrbuhdn (position: 38538472899, typename: DB::As", "ch-s3-660/aa8129e2-f47e-4b75-bbc", "ler id: d5c74e0a-b9cd-4185-8275-1658a426809f:2301, kind: Regular, unbound: 0: While reading or decompressing", "ved size: 1048576, downloader id: d5c74e0a-b9cd-4185-8275-1658a426809f:2301, current write offset: 38537265152, ca", "74b9c9401e4b14d7512160e71c27, state: PARTIALLY_DOWNLOADED_NO_CONTINUATION, downloaded size: 0, rese", ": d5c74e0a-b9cd-4185-8275-1658a426809f:2301, file segment info: File segment: [38537265152, 38541459455], key: 49a", "on: 38538657894, internal buffer end: 38538313728, read_type: REMOTE_FS_READ_AND_PUT_IN_CACHE, last calle", "krbuhdn, hash key: 49ac74b9c9401e4b14d7512160e71c27, file_offset_of_buffer_end: 38538472899, read_until_posit", "5-bbcb-8441591d3836/mergetree/qgx/cntihuflqgvmiglrrdawu", "path: ch-s3-660/aa8129e2-f47e-4b", "301, kind: Regular, unbound: 0: Cache info: Buffer", ", caller id: d5c74e0a-b9cd-4185-8275-1658a426809f:", ": 1048576, downloader id: d5c74e0a-b9cd-4185-8275-1658a426809f:2301, current write offset: 3853726515", ", key: 49ac74b9c9401e4b14d7512160e71c27, state: DOWNLOADING, downloaded size: 0, reserved siz", "ead-only file system, current cache state: File segment: [38537265152, 38541459455", "ckhouse-cache/sharedS3DiskCache/49a/49ac74b9c9401e4b14d7512160e71c27/38537265152: , errno: 30, strerror: ", "system: Cannot open file /mnt/cl", "1c27/38537265152: , errno: 30, strerror: Read-only file", "de: 76. DB::Exception: Cannot open file /mnt/clickhouse-cache/sharedS3DiskCache/49a/49ac74b9c9401e4b14d7512160e"]
(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—6h ago
** (FunctionClauseError) no function clause matching in Ch.RowBinary.decode_names/4
The following arguments were given to Ch.RowBinary.decode_names/4:
# 1
" (official build))\n"
# 2
45
# 3
67
# 4
[" MergeTreeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_OPEN_FILE) (version 25.10.1.7375", "ith error. It can mean that some retryable error happened, or data is corrupted. Please retry the query: While executin", "7842_14421488_16_22488012 (state Active) failed ", "ffer, compressed data header: <uninitialized>): (while reading column attributes): (attempt to read data part all_144", "tree/rtc/jwxvtpsfvvamdcvzjdbwltreicsdf (position: 28434943727, typename: DB::AsynchronousBoundedReadB", "gular, unbound: 0: While reading or decompressing ch-s3-514/aa8129e2-f47e-4b75-bbcb-8441591d3836/merg", "053e3c3-5518-4b30-97fc-c59b5e3b8b2f:2280, kind: R", "der id: 1053e3c3-5518-4b30-97fc-c59b5e3b8b2f:2280, current write offset: 28433186816, caller id: ", "D_NO_CONTINUATION, downloaded size: 0, reserved size: 1048576, downlo", "fo: File segment: [28433186816, 28437381119], key: 2238f5ba3f058f06194727b96165d143, state: PARTIALLY_DOWNLOAD", "_CACHE, last caller: 1053e3c3-5518-4b30-97fc-c59b5e3b8b2f:2280, file segment i", "ad_until_position: 28435058786, internal buffer end: 28434235392, read_type: REMOTE_FS_READ_AND_PUT_I", "4727b96165d143, file_offset_of_buffer_end: 28434943727, r", "3-514/aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/rtc/jwxvtpsfvvamdcvzjdbwltreicsdf, hash key: 2238f5ba3f058f061", ": 1053e3c3-5518-4b30-97fc-c59b5e3b8b2f:2280, kind: Regular, unbound: 0: Cache info: Buffer path: ch-", "ownloader id: 1053e3c3-5518-4b30-97fc-c59b5e3b8b2f:2280, current write offset: 28433186816, caller i", " DOWNLOADING, downloaded size: 0, reserved size: 1048576, ", ", current cache state: File segment: [28433186816, 28437381119], key: 2238f5ba3f058f06194727b96165d143, state", "186816: , errno: 30, strerror: Read-only file syste", "e system: Cannot open file /mnt/clickhouse-cache/sharedS3DiskCache/223/2238f5ba3f058f06194727b96165d143/2843", "d143/28433186816: , errno: 30, strerror: Read-only fi", "de: 76. DB::Exception: Cannot open file /mnt/clickhouse-cache/sharedS3DiskCache/223/2238f5ba3f058f06194727b9616"]
(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