写入doris时,经常内存不足 #47503
Unanswered
1181888200
asked this question in
Q&A
写入doris时,经常内存不足
#47503
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
现在mysql有2万个家庭数据,每天要进行一次快照数据,逐条写入doris里,发现doris经常有内存不足的问题,也会引起其他表无法写入的问题,尝试过批量50条写入,同样会有相同的问题,请问有其他更好的方法嘛??
Cause: java.sql.SQLException: errCode = 2, detailMessage = (172.31.3.190)[MEM_ALLOC_FAILED]Create Expr failed because [E11] Allocator sys memory check failed: Cannot alloc:64, consuming tracker:<Load#Id=585c408d13f9444f-a3d4cfc28709e17d>, peak used 0, current used 0, exec node:<>, process memory used 8.25 GB exceed limit 12.26 GB or sys available memory 1.50 GB less than low water mark 1.53 GB.
Beta Was this translation helpful? Give feedback.
All reactions