19825982 CustomerApi.Jobs.GenerateAccountMetrics
Queue clickhouse_account_metrics
Attempt 6 of 10
Priority 0
Tags ...
Node customer_api@10.10.0.170
Queue Time 00:17.289
Run Time 00:09.670
Inserted 12h ago
Scheduled 10h ago
Completed 10h ago (00:10)
Cancelled —
Discarded —

Args 

%{
  "account_id" => "114036",
  "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" => 1772758089330984,
  "recorded" => true,
  "return" => "g1AAAAGieJxVkM1OwzAQhH1ARaJpVBBCvJ21caaphWNbXicuz86FjR0KXCzN5/2Z2ayUei8HrPCZB6XeDiJSColJlVOx44SsXaARo4DjxYXCmq+heJHdFMixni1z/T41nUDmKuCx9D6yHpETmdxGdhvxWAS5umLTMYU5ZNSCp0gT9GpRNjvPX6VjkwDfkBS8zGGwDhq3iGThDVqb9b/GzttUXtKKzzt7/cMSOAbPtfOMmay4ppwxx9xy7ozlKiL7XQ5hkXU16U4u8v4DIcJX8NNjnDUfrWQg7yXk3VFPMZoFrO/XfziWflisG5F2SOobMYSYOA",
  "structured" => true,
  "workflow" => true,
  "workflow_id" => "019cc07f-799b-707f-9006-954e537c09ac"
}

Recorded Output 

%{
  events: 5638,
  errors: 0,
  widget_loaded: 0,
  flows_shown: 0,
  goals_missed: 0,
  goals_reached: 7,
  nps_detractors: 0,
  nps_neutrals: 0,
  nps_promoters: 0,
  page_views: 4603,
  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: 1035,
  builder_events: 0
}

Errors

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
    "ead). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25.10.1.7375 (official build))\n"

    # 2
    54

    # 3
    67

    # 4
    ["pool: PrefetchedReadPool, algorithm: Thr", "tryable error happened, or data is corrupted. Please retry the query: While executing MergeTreeSelect", "d data part all_14144_16861_7_112386651 (state Active) failed with error. It can mean that some r", "fbb-e17e5242e3aa:1718, kind: Regular, unbound: 0: (while reading column timestamp): (attempt to re", "d size: 4194304, downloader id: None, current write offset: 591396864, caller id: 52ee0229-e49a-4a1f-", "downloaded size: 4194304, reserv", "99f5ec01fa7c70cdcb8df66f9e32530, state: DOWNLOADED,", "t caller: 52ee0229-e49a-4a1f-bfbb-e17e5242e3aa:1718, file segment info: File segment: [587202560, 591396863], key: ", "012, internal buffer end: 298134, read_type: CACHED, la", "vg, hash key: 399f5ec01fa7c70cdcb8df66f9e32530, file_offset_of_buffer_end: 587500694, read_until_position: 58753", " error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/xie/huyytmmoqanicvwnbdijzcnfyq", "6f9e32530/587202560: , errno: 5, strerror: Input/outpu", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/399/399f5ec01fa7c70cdcb8df"]

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

    # 2
    54

    # 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:", "ile reading column timestamp): (attempt to read data part all_77434_80721_8_112386651 (state Active) fai", "5-455b73d1fb68:1564, kind: Regular, unbound: 0: (w", "e: 4194304, reserved size: 4194304, downloader id: None, current write offset: 721420288, caller id: dbfb1d32-8dec-4794-b1", ": File segment: [717225984, 721420287], key: 6bb99577f9b9a1fa548e9b15d898eaf1, state: DOWNLOADED, downloaded si", "4794-b125-455b73d1fb68:1564, file segment inf", "position: 717726150, internal buffer end: 464570, read_type: CACHED, last caller: dbfb1d32-8dec", "whbhmjgpbfte, hash key: 6bb99577f9b9a1fa548e9b15d898eaf1, file_offset_of_buffer_end: 717690554, read_until", "utput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/lnc/jrnguwjkrbhebqym", "5d898eaf1/717225984: , errno: 5, strerror: Input/", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/6bb/6bb99577f9b9a1fa548e9b"]

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

    # 2
    55

    # 3
    67

    # 4
    ["g MergeTreeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 25", "h error. It can mean that some retryable error happened, or data is corrupted. Please retry the query: While executi", "e reading column timestamp): (attempt to read data part all_77434_80721_8_112386651 (state Active) failed wi", "7-31a2497c6379:2113, kind: Regular, unbound: 0: (whi", "e: 4194304, reserved size: 4194304, downloader id: None, current write offset: 721420288, caller id: ae0f1d83-1596-4f21-b4", ": File segment: [717225984, 721420287], key: 6bb99577f9b9a1fa548e9b15d898eaf1, state: DOWNLOADED, downloaded si", "4f21-b447-31a2497c6379:2113, file segment inf", "position: 717726150, internal buffer end: 464570, read_type: CACHED, last caller: ae0f1d83-1596", "whbhmjgpbfte, hash key: 6bb99577f9b9a1fa548e9b15d898eaf1, file_offset_of_buffer_end: 717690554, read_until", "utput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/lnc/jrnguwjkrbhebqym", "5d898eaf1/717225984: , errno: 5, strerror: Input/", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/6bb/6bb99577f9b9a1fa548e9b"]

    (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
    "M_FILE_DESCRIPTOR) (version 25.10.1.7375 (official build))\n"

    # 2
    55

    # 3
    67

    # 4
    ["ergeTreeSelect(pool: PrefetchedReadPool, algorithm: Thread). (CANNOT_READ_FRO", "an that some retryable error happened, or data is corrupted. Please retry the query: While executing ", " timestamp): (attempt to read data part all_64800_68576_8_112386651 (state Active) failed with error. It can m", "unbound: 0: (while reading colum", "nloader id: None, current write offset: 830472192, caller id: cba12aa7-abcc-48dc-a484-7d086eb371ee:2085, kind: Regular,", "1bbe7dc71df44c4128ddb6eed, state: DOWNLOADED, downloaded size: 4194304, reserved size: 4194304, do", "c-48dc-a484-7d086eb371ee:2085, file segment info: File segment: [826277888, 830472191], key: dabfab", "_until_position: 826583949, internal buffer end: 274355, read_type: CACHED, last caller: cba12aa7-ab", "dqwoogjlqzro, hash key: dabfabb1bbe7dc71df44c4128ddb6eed, file_offset_of_buffer_end: 826552243, rea", "utput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/xmv/biarnhrpcpszeaeg", "28ddb6eed/826277888: , errno: 5, strerror: Input/", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/dab/dabfabb1bbe7dc71df44c4"]

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

    # 2
    55

    # 3
    67

    # 4
    ["ome retryable error happened, or data is corrupted. Please retry the query: While executing MergeTreeSelect(pool: P", "6651 (state Active) failed with error. It can mean that ", "data part all_77434_80721_8_1123", "4-16105849f65c:2040, kind: Regular, unbound: 0: (while reading column timestamp): (attempt to read", "e: 4194304, reserved size: 4194304, downloader id: None, current write offset: 721420288, caller id: 96262555-ae42-42fc-96", ": File segment: [717225984, 721420287], key: 6bb99577f9b9a1fa548e9b15d898eaf1, state: DOWNLOADED, downloaded si", "42fc-96b4-16105849f65c:2040, file segment inf", "position: 717726150, internal buffer end: 464570, read_type: CACHED, last caller: 96262555-ae42", "whbhmjgpbfte, hash key: 6bb99577f9b9a1fa548e9b15d898eaf1, file_offset_of_buffer_end: 717690554, read_until", "utput error: Cache info: Buffer path: ch-s3-aa8129e2-f47e-4b75-bbcb-8441591d3836/mergetree/lnc/jrnguwjkrbhebqym", "5d898eaf1/717225984: , errno: 5, strerror: Input/", "de: 74. DB::Exception: Cannot read from file /mnt/clickhouse-cache/sharedS3DiskCache/6bb/6bb99577f9b9a1fa548e9b"]

    (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