[
https://issues.apache.org/jira/browse/IGNITE-24756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ilya Shishkov reassigned IGNITE-24756:
--------------------------------------
Assignee: (was: Ilya Shishkov)
> Calcite. TPC-H query #19: too long execTime and high heap memory usage on
> client
> --------------------------------------------------------------------------------
>
> Key: IGNITE-24756
> URL: https://issues.apache.org/jira/browse/IGNITE-24756
> Project: Ignite
> Issue Type: Bug
> Reporter: Sergey Korotkov
> Priority: Major
> Labels: ise, tpch
> Attachments: TpchQ19Test.patch
>
>
> Works for s = 0.01 but do not complete in 5 minutes for s=0.1 and s=1.0
> Use a lot of heap on client side (look similar to the query #16 case at
> IGNITE-24753)
> ***
> Load test (1 client node, 3 server nodes) shows that there is huge HEAP
> memory usage on the client side.
>
> | **
> |*{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}Q19{color}|{color:#000000}client_heap_inTestAllocatedPerCall_MB/call_mean{color}|{color:#000000}27,770.28{color}|{color:#000000}745,501.73{color}|{color:#000000}662,648.99{color}|
> |{color:#000000}Q19{color}|{color:#000000}client_heap_inTestTotalAllocated_MB_mean{color}|{color:#000000}27,770.28{color}|{color:#000000}745,501.73{color}|{color:#000000}662,648.99{color}|
> |{color:#000000}Q19{color}|{color:#000000}count{color}|{color:#000000}1.00{color}|{color:#000000}1.00{color}|{color:#000000}1.00{color}|
> |{color:#000000}Q19{color}|{color:#000000}failed_count{color}|{color:#000000}
> {color}|{color:#000000}1.00{color}|{color:#000000}1.00{color}|
> |{color:#000000}Q19{color}|{color:#000000}server_heap_inTestAllocatedPerCall_MB/call_mean{color}|{color:#000000}2,032.93{color}|{color:#000000}15,484.44{color}|{color:#000000}8,241.25{color}|
> |{color:#000000}Q19{color}|{color:#000000}server_heap_inTestTotalAllocated_MB_mean{color}|{color:#000000}2,032.93{color}|{color:#000000}15,484.44{color}|{color:#000000}8,241.25{color}|
> For scale=0.01 one query was executed. With average 27Gb and 2Gb of heap
> allocation per request (on client and server correspondingly).
> For scales 0.1 and 1.0 single query was cancelled after 5 minutes, having
> handreds of gigabytes allocated on the client side.
> Reproducer: [^TpchQ19Test.patch]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
