Sergey Korotkov created IGNITE-25008:
----------------------------------------
Summary: Calcite. TPC-H query #5: scale=1.0: too long execTime,
high heap usage, full GC pauses
Key: IGNITE-25008
URL: https://issues.apache.org/jira/browse/IGNITE-25008
Project: Ignite
Issue Type: Bug
Reporter: Sergey Korotkov
Load test with:
* scale=1.0
* 3 server nodes
* 1 client node
* 5Gb heap on all nodes
Query doesn't finish in 5 minutes.
GC takes all the time (95%)
| *{color:#000000}{color}*
|*{color:#000000}args{color}*|*{color:#000000}scale=0.01{color}*|*{color:#000000}scale=0.1{color}*|*{color:#000000}scale=1.0{color}*|
|*{color:#000000}benchmark{color}*|*{color:#000000}metric{color}*|*{color:#000000}value{color}*|*{color:#000000}value{color}*|*{color:#000000}value{color}*|
|{color:#000000}Q05{color}|{color:#000000}client_gc_fullGCPausePc_%_mean{color}|{color:#000000}0.00{color}|{color:#000000}0.00{color}|{color:#000000}99.20{color}|
|{color:#000000}Q05{color}|{color:#000000}client_gc_inTestPauseAverage_ms_mean{color}|{color:#000000}10.67{color}|{color:#000000}21.12{color}|{color:#000000}566.23{color}|
|{color:#000000}Q05{color}|{color:#000000}client_gc_inTestPauseCount_-_mean{color}|{color:#000000}1.00{color}|{color:#000000}11.00{color}|{color:#000000}764.00{color}|
|{color:#000000}Q05{color}|{color:#000000}client_gc_inTestPauseSum_ms_mean{color}|{color:#000000}10.67{color}|{color:#000000}232.33{color}|{color:#000000}432,596.00{color}|
|{color:#000000}Q05{color}|{color:#000000}client_gc_throughput_%_mean{color}|{color:#000000}98.63{color}|{color:#000000}97.48{color}|{color:#000000}5.68{color}|
|{color:#000000}Q05{color}|{color:#000000}client_heap_inTestAllocatedPerCall_MB/call_mean{color}|{color:#000000}25.60{color}|{color:#000000}1,958.88{color}|{color:#000000}16,798.14{color}|
|{color:#000000}Q05{color}|{color:#000000}client_heap_inTestTotalAllocated_MB_mean{color}|{color:#000000}675.25{color}|{color:#000000}3,917.75{color}|{color:#000000}16,798.14{color}|
|{color:#000000}Q05{color}|{color:#000000}count{color}|{color:#000000}26.67{color}|{color:#000000}2.00{color}|{color:#000000}1.00{color}|
|{color:#000000}Q05{color}|{color:#000000}failed_count{color}|{color:#000000}
{color}|{color:#000000} {color}|{color:#000000}1.00{color}|
|{color:#000000}Q05{color}|{color:#000000}server_gc_fullGCPausePc_%_mean{color}|{color:#000000}0.00{color}|{color:#000000}0.00{color}|{color:#000000}0.00{color}|
|{color:#000000}Q05{color}|{color:#000000}server_gc_inTestPauseAverage_ms_mean{color}|{color:#000000}8.59{color}|{color:#000000}11.61{color}|{color:#000000}15.26{color}|
|{color:#000000}Q05{color}|{color:#000000}server_gc_inTestPauseCount_-_mean{color}|{color:#000000}1.56{color}|{color:#000000}1.22{color}|{color:#000000}18.67{color}|
|{color:#000000}Q05{color}|{color:#000000}server_gc_inTestPauseSum_ms_mean{color}|{color:#000000}13.44{color}|{color:#000000}13.56{color}|{color:#000000}282.67{color}|
|{color:#000000}Q05{color}|{color:#000000}server_gc_throughput_%_mean{color}|{color:#000000}99.77{color}|{color:#000000}99.78{color}|{color:#000000}99.94{color}|
|{color:#000000}Q05{color}|{color:#000000}server_heap_inTestAllocatedPerCall_MB/call_mean{color}|{color:#000000}127.60{color}|{color:#000000}1,385.12{color}|{color:#000000}21,427.22{color}|
|{color:#000000}Q05{color}|{color:#000000}server_heap_inTestTotalAllocated_MB_mean{color}|{color:#000000}3,379.20{color}|{color:#000000}2,770.25{color}|{color:#000000}21,427.22{color}|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
