[ https://issues.apache.org/jira/browse/IGNITE-25008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Korotkov updated IGNITE-25008: ------------------------------------- Labels: ise tpch (was: ) > 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 > Priority: Major > Labels: ise, tpch > > 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)