Mkql memory limit exceeded in ydb qa

[naspirato]

Error

Type annotation
severity level: 2
issue code: 1030
  At function: RemovePrefixMembers, At function: Take, At function: Sort, At function: PersistableRepr, At function: SqlProject, At function: Filter
    At function: AssumeColumnOrderPartial, At function: Aggregate
    severity level: 2
    issue code: 0
      At function: Filter, At function: FlatMap, At function: AsList, At function: AddMember, At function: ForceRemoveMember, At function: AddMember, At function: If, At function: If
        At function: If
        severity level: 2
        issue code: 0
          At function: Coalesce, At function: SqlCall, At function: PositionalArgs, At function: ListHead, At function: Skip, Failed to convert type: Int32 to Uint64
            Consider using explicit CAST or BITCAST to convert from Int32 to Uint64
            severity level: 2
            issue code: 1107

          At function: ListHead, At function: Skip, Failed to convert type: Int32 to Uint64
            Consider using explicit CAST or BITCAST to convert from Int32 to Uint64
            severity level: 2
            issue code: 1107

          At function: ListHead, At function: Skip, Failed to convert type: Int32 to Uint64
            Consider using explicit CAST or BITCAST to convert from Int32 to Uint64
            severity level: 2
            issue code: 1107

      At function: Filter, At function: Coalesce, At function: And, At function: And, At function: Or, At function: Not, At function: SqlIn
        IN may produce unexpected result when used with nullable arguments. Consider adding 'PRAGMA AnsiInForEmptyOrNullableItemsCollections;'
        severity level: 2
        issue code: 1108

Mkql memory limit exceeded, limit: 384827392, host: vm-etnvsjbk7kh1jc6bbfi8-ru-central1-a-wdcm-yzoj, canAllocateExtraMemory: 1, memory manager details: TxResourcesInfo{ TxId: 1408139140992455, memory initially granted resources: 0, extra allocations 10733223936, execution units: 87, started at: 2024-11-20T15:00:11.576270Z }
severity level: 1
issue code: 2029

query https://nda.ya.ru/t/Vcyt5k4d79nrrR db monitoring https://nda.ya.ru/t/qO-4rUNt78RtEx Cloud of db https://nda.ya.ru/t/JZwCs8zs79nrsc

[Hor911]

AI: Enable Basic Stats for Cluster (collect and use)

[azevaykin]

AI: Enable Basic Stats for Cluster (collect and use)

"EnableStatistics = Enabled" on this database