19814903 CustomerApi.Jobs.GenerateAccountMetrics
Queue clickhouse_account_metrics
Attempt 5 of 10
Priority 0
Tags ...
Node customer_api@10.10.1.214
Queue Time 01:33.197
Run Time 00:03.457
Inserted 12h ago
Scheduled 10h ago
Completed 10h ago (00:04)
Cancelled —
Discarded —

Args 

%{
  "account_id" => "82304",
  "date" => "2026-03-06",
  "query" => "users_reached",
  "window_days" => 30
}

Meta 

%{
  "deps" => ["generate_event_counts"],
  "name" => "generate_users_reached",
  "on_hold" => false,
  "orig_scheduled_at" => 1772758740670081,
  "recorded" => true,
  "return" => "g1AAAABReJwrYWBgYC7nLS1OLSqOL0pNTM5ITUnUL5dOKs3MSUktik8tS80riUeVti+XyCsoji8uLSpLrUSTYwAAoU8eSQ",
  "structured" => true,
  "workflow" => true,
  "workflow_id" => "019cc07f-7860-7615-a24d-74ed004c8aac"
}

Recorded Output 

%{
  users_reached: 47,
  builder_event_users_reached: 63,
  nps_survey_users_reached: 0
}

Errors

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
    54

    # 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", "0_22488012 (state Active) failed with error. It ca", "ind: Regular, unbound: 0: (while reading column user_id): (attempt to read data part all_12661296_12746905_", "er id: None, current write offset: 893386752, caller id: 47c880fa-451f-4dd4-bb72-0b42e3447ce9:2115, ", "OWNLOADED, downloaded size: 4194304, reserved size: 4194304, downloa", "], key: 7e6ed40c8c070c9f71dcd85cf523d801, state: ", "ast caller: 47c880fa-451f-4dd4-bb72-0b42e3447ce9:2115, file segment info: File segment: [889192448, 89338675", "455, internal buffer end: 2620723, read_type: CACHED, ", "shhlbc, hash key: 7e6ed40c8c070c9f71dcd85cf523d801, file_offset_of_buffer_end: 891813171, read_until_position: 89183", "t error: Cache info: Buffer path: ch-s3-848/aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/opa/pohbsqawitsrmddymegqht", "cf523d801/889192448: , errno: 5, strerror: Input/outp", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/7e6/7e6ed40c8c070c9f71dcd8"]

    (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
    "5 (official build))\n"

    # 2
    53

    # 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", "12 (state Active) failed with error. It can mean", "ound: 0: (while reading column user_id): (attempt to read data part all_14444612_14452525_16_22488", "a-857c-4538-a1fa-c630f51b04d2:2114, kind: Regular, un", "nloaded size: 4194304, reserved size: 4194304, downloader id: None, current write offset: 1178599424, caller id: e9082c", "a8e1318d70c36480b5617c5ba64b1a6, state: DOWNLOADED, do", " caller: e9082c5a-857c-4538-a1fa-c630f51b04d2:2114, file segment info: File segment: [1174405120, 1178599423], key: ", "nd: 1176802930, read_until_position: 1176816672, internal buffer end: 2397810, read_type: CACHED, las", "8d70c36480b5617c5ba64b1a6, file_offset_of_buffer_", "a8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/ygv/guhztoazxncysivasiihihojqyaun, hash key: 6a8e13", "5ba64b1a6/1174405120: , errno: 5, strerror: Input/output error: Cache info: Buffer path: ch-s3-c04/", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/6a8/6a8e1318d70c36480b5617"]

    (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
    "ol, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (official build))\n"

    # 2
    56

    # 3
    67

    # 4
    ["ror happened, or data is corrupted. Please retry the query: While executing MergeTreeSelect(pool: PrefetchedReadPo", "ead data part all_14519220_14519526_9_22488012 (state Active) failed with error. It can mean that some retryable e", "e1-970c-6a29837b50e3:2061, kind: Regular, unbound: 0: (while reading column user_id): (attempt to ", "served size: 4194304, downloader id: None, current write offset: 20971520, caller id: 1ef8a30b-0559-4", "t: [16777216, 20971519], key: a6aa40706db9c66935296153565d80d5, state: DOWNLOADED, downloaded size: 4194304, r", "_type: CACHED, last caller: 1ef8a30b-0559-4be1-970c-6a29837b50e3:2061, file segment info: File segme", "internal buffer end: 257574, rea", "qjufyc, hash key: a6aa40706db9c66935296153565d80d5, file_offset_of_buffer_end: 17034790, read_until_position: 17086959,", " error: Cache info: Buffer path: ch-s3-c59/aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/bqi/jjivrglipcksuwyllcgkws", "3565d80d5/16777216: , errno: 5, strerror: Input/outpu", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/a6a/a6aa40706db9c669352961"]

    (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
    "tchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (official build))\n"

    # 2
    55

    # 3
    67

    # 4
    ["ppened, or data is corrupted. Please retry the query: While executing MergeTreeSelect(pool: Prefe", "ctive) failed with error. It can mean that some retryable error h", "bound: 0: (while reading column user_id): (attempt to read data part all_14444612_14452525_16_22488012 (state ", "e-e539-4437-abd3-704f40a50e91:1819, kind: Regular, u", "nloaded size: 4194304, reserved size: 4194304, downloader id: None, current write offset: 1178599424, caller id: ac23f8", "a8e1318d70c36480b5617c5ba64b1a6, state: DOWNLOADED, do", " caller: ac23f84e-e539-4437-abd3-704f40a50e91:1819, file segment info: File segment: [1174405120, 1178599423], key: ", "nd: 1176802930, read_until_position: 1176816672, internal buffer end: 2397810, read_type: CACHED, las", "8d70c36480b5617c5ba64b1a6, file_offset_of_buffer_", "a8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/ygv/guhztoazxncysivasiihihojqyaun, hash key: 6a8e13", "5ba64b1a6/1174405120: , errno: 5, strerror: Input/output error: Cache info: Buffer path: ch-s3-c04/", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/6a8/6a8e1318d70c36480b5617"]

    (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