19827158
CustomerApi.Jobs.GenerateAccountMetrics
Queue
clickhouse_account_metrics
Attempt
8 of 10
Priority
0
Tags
...
Node
customer_api@10.10.1.109
Queue Time
00:00.259
Run Time
00:04.857
Inserted
12h ago
Scheduled
10h ago
Completed
10h ago (00:05)
Cancelled
—
Discarded
—
Args
%{
"account_id" => "201392",
"date" => "2026-03-06",
"query" => "event_counts",
"window_days" => 1
}
Meta
%{
"deps" => ["generate_user_counts"],
"name" => "generate_event_counts",
"on_hold" => false,
"orig_scheduled_at" => 1772758219839916,
"recorded" => true,
"return" => "g1AAAAGZeJxVkM1uxCAMhHPqod2NVlUPfTtEyGwWFWxkQ7J9+xKI0vaCPB/+G+dhGD63F6ygrHaokQjLHl03Py/IJrCdMVfwdg+8qdEHb1TlZWEb1ESv2r6vXQusezQwUlIzI4t1ube87IRQKgptxK6TcOSMlvCa7AKzemwtXZ0AdOr3yJMPMHgmiAc59BpPv1vd9pZaZMX3yT7+MIEmJm2VN0Tr68o2Z8SUu8mDab3H7uGQE5c6rtk8yL2+/wAnUPd9ABe8++opkyWqDs+NRpuSK1Bz3n2cig8z5CQ/hs2W9w",
"structured" => true,
"workflow" => true,
"workflow_id" => "019cc07f-79b3-706d-8508-a88c399956ce"
}
Recorded Output
%{
events: 0,
errors: 0,
widget_loaded: 0,
flows_shown: 0,
goals_missed: 0,
goals_reached: 0,
nps_detractors: 0,
nps_neutrals: 0,
nps_promoters: 0,
page_views: 0,
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: 0,
builder_events: 0
}
Errors
Attempt 7—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
"ld))\n"
# 2
53
# 3
67
# 4
["ReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (official bui", "ryable error happened, or data is corrupted. Please retry the query: While executing MergeTreeSelect(pool: Prefetche", "pt to read data part all_247561_250168_8_112386651 (state Active) failed with error. It can mean that some re", "reading column timestamp): (atte", "a4a7e8ce9:44794, kind: Regular, unbound: 0: (while", "eserved size: 4194304, downloader id: None, current write offset: 738197504, caller id: d20a10c4-73c6-4d2e-8c07-78", "5f, state: DOWNLOADED, downloaded size: 4194304, ", ", 738197503], key: 3faf4d000cdb6e326f845e3da9c30", "e8ce9:44794, file segment info: File segment: [73400320", "osition: 736421635, internal buffer end: 2386009, read_type: CACHED, last caller: d20a10c4-73c6-4d2e-8c07-782a4a", "hjibn, hash key: 3faf4d000cdb6e326f845e3da9c3015f, file_offset_of_buffer_end: 736389209, read_until_", "put error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/uoj/erraqrbtvaxkauhtvnwybdz", "da9c3015f/734003200: , errno: 5, strerror: Input/ou", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/3fa/3faf4d000cdb6e326f845e"]
(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 6—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
"PTOR) (version 25.10.1.7375 (official build))\n"
# 2
54
# 3
67
# 4
["uery: While executing MergeTreeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRI", "d with error. It can mean that some retryable error happened, or data is corrupted. Please retry the ", "ading column timestamp): (attempt to read data part all_247561_250168_8_112386651 (state Active) fail", "42f1a7706:42738, kind: Regular, unbound: 0: (while r", "eserved size: 4194304, downloader id: None, current write offset: 738197504, caller id: 413a4171-3c94-44d5-b126-7b", "015f, state: DOWNLOADED, downloaded size: 4194304, ", "003200, 738197503], key: 3faf4d000cdb6e326f845e3da9c", "a7706:42738, file segment info: File segment: [73", "osition: 736421635, internal buffer end: 2386009, read_type: CACHED, last caller: 413a4171-3c94-44d5-b126-7b442f", "hjibn, hash key: 3faf4d000cdb6e326f845e3da9c3015f, file_offset_of_buffer_end: 736389209, read_until_", "put error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/uoj/erraqrbtvaxkauhtvnwybdz", "da9c3015f/734003200: , errno: 5, strerror: Input/ou", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/3fa/3faf4d000cdb6e326f845e"]
(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 5—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
"build))\n"
# 2
53
# 3
67
# 4
["ool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (official ", "While executing MergeTreeSelect(", "ed with error. It can mean that some retryable error happened, or data is corrupted. Please retry the query:", " reading column timestamp): (attempt to read data part all_22755_25266_8_112386651 (state Active) fai", "rrent write offset: 657457152, caller id: 18a834f1-3e44-4932-a7fd-f212bd523437:2088, kind: Regular, unbound: 0: (whil", "5728, reserved size: 3145728, downloader id: None, c", "7, state: PARTIALLY_DOWNLOADED, downloaded size: 31", "4, 658505727], key: 024a3edc523278b67232fd28ef083f", "23437:2088, file segment info: File segment: [6543114", "sition: 656402438, internal buffer end: 2064445, read_type: CACHED, last caller: 18a834f1-3e44-4932-a7fd-f212bd", "beeyi, hash key: 024a3edc523278b67232fd28ef083f37, file_offset_of_buffer_end: 656375869, read_until_p", "tput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/xiv/umapyarqztyrrfttlfzkire", "8ef083f37/654311424: , errno: 5, strerror: Input/o", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/024/024a3edc523278b67232fd"]
(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 4—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
"fficial build))\n"
# 2
55
# 3
67
# 4
["eeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (o", " mean that some retryable error happened, or data is corrupted. Please retry the query: While executing MergeT", "mp): (attempt to read data part all_3338_9352_9_112386651 (state Active) failed with error. It ca", ": 6bfd629f-530d-43e8-af71-167480816fe7:2098, kind: Regular, unbound: 0: (while reading column timest", "oaded size: 4194304, reserved size: 4194304, downloader id: None, current write offset: 1543503872, caller i", "t info: File segment: [1539309568, 1543503871], key: d6885aa0b610d6df8c2c764e05edb5da, state: DOWNLOADED, down", ", last caller: 6bfd629f-530d-43e8-af71-167480816fe7:2098, file segme", "57558, internal buffer end: 119938, read_type: CACHE", "nypwb, hash key: d6885aa0b610d6df8c2c764e05edb5da, file_offset_of_buffer_end: 1539429506, read_until_position: 1539", "put error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/vfb/iyoctuohxwcfvxxdgephxbu", "e05edb5da/1539309568: , errno: 5, strerror: Input/ou", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/d68/d6885aa0b610d6df8c2c76"]
(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 3—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
"fficial build))\n"
# 2
55
# 3
67
# 4
["eeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (o", " mean that some retryable error happened, or data is corrupted. Please retry the query: While executing MergeT", "mp): (attempt to read data part all_3338_9352_9_112386651 (state Active) failed with error. It ca", ": 0b8f817b-34c9-4171-86d4-9ffec370d1b9:2092, kind: Regular, unbound: 0: (while reading column timest", "oaded size: 4194304, reserved size: 4194304, downloader id: None, current write offset: 1543503872, caller i", "t info: File segment: [1539309568, 1543503871], key: d6885aa0b610d6df8c2c764e05edb5da, state: DOWNLOADED, down", ", last caller: 0b8f817b-34c9-4171-86d4-9ffec370d1b9:2092, file segme", "57558, internal buffer end: 119938, read_type: CACHE", "nypwb, hash key: d6885aa0b610d6df8c2c764e05edb5da, file_offset_of_buffer_end: 1539429506, read_until_position: 1539", "put error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/vfb/iyoctuohxwcfvxxdgephxbu", "e05edb5da/1539309568: , errno: 5, strerror: Input/ou", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/d68/d6885aa0b610d6df8c2c76"]
(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—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
"ld))\n"
# 2
53
# 3
67
# 4
["dReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (official bui", "yable error happened, or data is corrupted. Please retry the query: While executing MergeTreeSelect(pool: Prefetch", "error. It can mean that some ret", "ng column timestamp): (attempt to read data part all_247561_250168_8_112386651 (state Active) failed with", "e3c713e31:44241, kind: Regular, unbound: 0: (while read", "eserved size: 4194304, downloader id: None, current write offset: 738197504, caller id: 8acb8f6a-c852-471b-97ad-ca", "5f, state: DOWNLOADED, downloaded size: 4194304, ", ", 738197503], key: 3faf4d000cdb6e326f845e3da9c30", "13e31:44241, file segment info: File segment: [73400320", "osition: 736421635, internal buffer end: 2386009, read_type: CACHED, last caller: 8acb8f6a-c852-471b-97ad-ca7e3c", "hjibn, hash key: 3faf4d000cdb6e326f845e3da9c3015f, file_offset_of_buffer_end: 736389209, read_until_", "put error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/uoj/erraqrbtvaxkauhtvnwybdz", "da9c3015f/734003200: , errno: 5, strerror: Input/ou", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/3fa/3faf4d000cdb6e326f845e"]
(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—11h ago
** (FunctionClauseError) no function clause matching in Ch.RowBinary.decode_names/4
The following arguments were given to Ch.RowBinary.decode_names/4:
# 1
".10.1.7375 (official build))\n"
# 2
53
# 3
67
# 4
["g MergeTreeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25", "n that some retryable error happened, or data is corrupted. Please retry the query: While executi", "386651 (state Active) failed with error. It can me", "ind: Regular, unbound: 0: (while reading column timestamp): (attempt to read data part all_39948_43205_8_11", ", caller id: 8c649979-357e-4535-95d4-393dc3b60f9e:2093, ", "4304, downloader id: None, current write offset: 84724940", "size: 4194304, reserved size: 41", "fo: File segment: [843055104, 847249407], key: 46bc736f8eb066835ef878a52dca5c52, state: DOWNLOADED, downloaded", ": 2466570, read_type: CACHED, last caller: 8c649979-357e-4535-95d4-393dc3b60f9e:2093, file segment i", "74, read_until_position: 845550246, internal buffer en", "xwondkgsgxpsvhatmfuemrmqxt, hash key: 46bc736f8eb066835ef878a52dca5c52, file_offset_of_buffer_end: 845521", "29e2-f47e-4b75-bbcb-8441591d3836/mergetree/fol/sf", "52dca5c52/843055104: , errno: 5, strerror: Input/output error: Cache info: Buffer path: ch-s3-aa8", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/46b/46bc736f8eb066835ef878"]
(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