JMeter-在JDBC请求中检索百万条记录时出现OutOfMemoryError

2024-05-20 • 问答

当我试图在JDBC请求中获得超过一百万条记录时，我得到了OutOfMemoryError：

 ERROR o.a.j.JMeter: Uncaught exception: 
java.lang.OutOfMemoryError: Java heap space
    at java.util.Arrays.copyOf(Unknown Source) ~[?:1.8.0_191]
    at java.lang.AbstractStringBuilder.ensureCapacityInternal(Unknown Source) ~[?:1.8.0_191]
    at java.lang.AbstractStringBuilder.append(Unknown Source) ~[?:1.8.0_191]
    at java.lang.StringBuilder.append(Unknown Source) ~[?:1.8.0_191]
    at java.lang.StringBuilder.append(Unknown Source) ~[?:1.8.0_191]
    at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.getStringFromResultSet(AbstractJDBCTestElement.java:563) ~[ApacheJMeter_jdbc.jar:5.1.1 r1855137]
    at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.execute(AbstractJDBCTestElement.java:175) ~[ApacheJMeter_jdbc.jar:5.1.1 r1855137]
    at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:84) ~[ApacheJMeter_jdbc.jar:5.1.1 r1855137]
    at org.apache.jmeter.threads.JMeterThread.doSampling(JMeterThread.java:622) ~[ApacheJMeter_core.jar:5.1.1 r1855137]
    at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:546) ~[ApacheJMeter_core.jar:5.1.1 r1855137]
    at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:486) ~[ApacheJMeter_core.jar:5.1.1 r1855137]
    at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:253) ~[ApacheJMeter_core.jar:5.1.1 r1855137]
    at java.lang.Thread.run(Unknown Source) [?:1.8.0_191]

JDBC是否有这样的限制？是JMeter错误，应该因相关错误而停止执行？

例如，对于较小的记录，它返回

Response too large to be displayed. Size: 26848889 > Max: 10485760,Start of message:

if not defined HEAP ( rem See the unix startup file for the rationale of the following parameters,rem including some tuning recommendations set HEAP=-Xms1g -Xmx1g -XX:MaxMetaspaceSize=256m )

JMeter-在JDBC请求中检索百万条记录时出现OutOfMemoryError

uwycny 回答：JMeter-在JDBC请求中检索百万条记录时出现OutOfMemoryError

大家都在问