Проблемы запуска tpcds 10 на нагрузочных кластреах

[iddqdex]

Сасово

Стабильно падает 6 запросов: 09, 13, 14, 23, 24, 87
Пример отчета

09

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 3552017960, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-9, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 2097152, extra allocations 10717495296, execution units: 0, started at: 2024-07-16T04:23:16.125363Z }, code: 2029

13

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 5549588480, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-1, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 2621440, extra allocations 10723786752, execution units: 0, started at: 2024-07-16T04:26:25.824264Z }, code: 2029

14

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 524288, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-8, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 8388608, extra allocations 0, execution units: 0, started at: 2024-07-16T04:27:40.067453Z }, code: 2029

23

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 5445779456, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-8, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 2621440, extra allocations 10735321088, execution units: 0, started at: 2024-07-16T04:34:38.013759Z }, code: 2029

24

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 524288, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-10, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 13107200, extra allocations 0, execution units: 0, started at: 2024-07-16T04:35:50.593650Z }, code: 2029

87

Ошибка:

Failed: <main>: Fatal: Execution, code: 1060
    <main>: Fatal: ydb/library/yql/ast/yql_expr.cpp:1969  BuildValueNode(): requirement ctx.AllowFreeArgs failed, message: Free arguments are not allowed, code: 1
<main>: Fatal: Execution, code: 1060
    <main>: Fatal: ydb/library/yql/ast/yql_expr.cpp:1969  BuildValueNode(): requirement ctx.AllowFreeArgs failed, message: Free arguments are not allowed, code: 1
<main>: Fatal: Internal error while executing transaction., code: 1
    <main>: Error: ydb/core/kqp/executer_actor/kqp_executer_impl.h:1319  BuildComputeTasks(): requirement false failed, message: Unexpected connection type: 4
[KqpExecuter], type: Data, Database: /olap-testing-sas-perf/kikimr/olap/benchmark, TxId: 562950263911449, TxCnt: 1, Transactions: <См в отчете>

Владимир

Стабильно падает 7 запросов: 09, 13, 23, 32, 73, 87, часто 14

09

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 3552017960, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-9, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 2097152, extra allocations 10717495296, execution units: 0, started at: 2024-07-16T04:23:16.125363Z }, code: 2029

13

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 5549588480, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-1, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 2621440, extra allocations 10723786752, execution units: 0, started at: 2024-07-16T04:26:25.824264Z }, code: 2029

14

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 524288, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-8, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 8388608, extra allocations 0, execution units: 0, started at: 2024-07-16T04:27:40.067453Z }, code: 2029

23

Ошибка:

Failed: <main>: Error: Mkql memory limit exceeded, limit: 5445779456, host: d-c0f9g9voc9o4o1m4sj49-ydb-testing-sas-0-8, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ Memory initially granted resources: 2621440, extra allocations 10735321088, execution units: 0, started at: 2024-07-16T04:34:38.013759Z }, code: 2029

32

Таймаут, успевают пройти 2 итерации по 15 минут, третья не успевает.

34

Ошибка:

Failed: <main>: Error: Internal error while compiling query.
    <main>: Error: ydb/core/kqp/query_data/kqp_prepared_query.cpp:219: GetInfo(): requirement info failed.

73

Ошибка:

Failed: <main>: Error: Internal error while compiling query.
    <main>: Error: ydb/core/kqp/query_data/kqp_prepared_query.cpp:219: GetInfo(): requirement info failed.

87

Ошибка:

Failed: <main>: Fatal: Execution, code: 1060
    <main>: Fatal: ydb/library/yql/ast/yql_expr.cpp:1969  BuildValueNode(): requirement ctx.AllowFreeArgs failed, message: Free arguments are not allowed, code: 1
<main>: Fatal: Execution, code: 1060
    <main>: Fatal: ydb/library/yql/ast/yql_expr.cpp:1969  BuildValueNode(): requirement ctx.AllowFreeArgs failed, message: Free arguments are not allowed, code: 1
<main>: Fatal: Internal error while executing transaction., code: 1
    <main>: Error: ydb/core/kqp/executer_actor/kqp_executer_impl.h:1319  BuildComputeTasks(): requirement false failed, message: Unexpected connection type: 4
[KqpExecuter], type: Data, Database: /olap-testing-sas-perf/kikimr/olap/benchmark, TxId: 562950263911449, TxCnt: 1, Transactions: <См в отчете>