[mpp-version=1] [error="other error for mpp stream: From MPP<query:<query_ts:1728504882699720307, local_query_id:1399727, server_id:1124321, start_ts:453117183961071674>,task_id:2>: Code: 0, e.displayText() = DB::TiFlashException: Memory limit (total) exceeded caused by 'out of memory quota for data computing' : would use 231.12 GiB for data computing (attempt to allocate chunk of 16 bytes), limit of memory for data computing: 226.57 GiB, e.what() = DB::TiFlashException,"]
C查询失败:
[txn_mode=PESSIMISTIC] [timestamp=453117183961071674] [err="other
error for mpp stream: From MPP<query:<query_ts:1728504882699720307, local_query_id:13
99727, server_id:1124321, start_ts:453117183961071674>,task_id:2>: Code: 0, e.display
Text() = DB::TiFlashException: Memory limit (total) exceeded caused by 'out of memory
quota for data computing' : would use 231.12 GiB for data computing (attempt to allo
cate chunk of 16 bytes), limit of memory for data computing: 226.57 GiB,
B 查询在执行过程中占用了大量内存,而系统可用内存不足以支持 C 查询,即使 C 的内存占用很小,也可能导致内存分配失败。
TiFlash 通过 max_memory_usage_for_all_queries 参数限制查询的内存使用量。如果 B 查询的内存使用超过了这个限制,C 查询可能因为无法获得足够的内存资源而失败,即使 C 的内存占用很小,也可能导致查询失败。