drill icon indicating copy to clipboard operation
drill copied to clipboard

DRILL-8490: Sender operator fake memory leak result to sql failed and memory statistics error when ChannelClosedException

Open shfshihuafeng opened this issue 1 year ago • 0 comments

DRILL-8490: Sender operator fake memory leak result to sql failed and memory statistics error when ChannelClosedException

Description

when ChannelClosedException, .ReconnectingConnection#CloseHandler release sendingAccountor reference counter before netty release buffer, so operator was closed before memory is released by netty

Documentation

later

Testing

  1. TPCH test condition (1) script
i run sql8 (sql detail as Additional context) with 20 concurrent
tpch test script

fileName=/data/drill/tpch_sql/1s/shf.txt

random_sql(){
#for i in `seq 1 30`
while true
do

  num=$((RANDOM%22+1))
  if [ -f $fileName ]; then
  echo "$fileName" " is exit"
  exit 0
  else
    $drill_home/sqlline -u \"jdbc:drill:zk=ip:2181/drill/drillbits1_performance_test_shf\" -f tpch_sql8.sql >>/tpch1s_sql${num}.log 2>&1
  fi
done
}

(2) parameter

{DRILL_MAX_DIRECT_MEMORY:-"5G"} open debug : set drill.memory.debug.allocator =true (Check for memory leaks ) (3) sql8

select o_year, sum(case when nation = 'CHINA' then volume else 0 end) / sum(volume) as mkt_share from ( select extract(year from o_orderdate) as o_year, l_extendedprice * 1.0 as volume, n2.n_name as nation from hive.tpch1s.part, hive.tpch1s.supplier, hive.tpch1s.lineitem, hive.tpch1s.orders, hive.tpch1s.customer, hive.tpch1s.nation n1, hive.tpch1s.nation n2, hive.tpch1s.region where p_partkey = l_partkey and s_suppkey = l_suppkey and l_orderkey = o_orderkey and o_custkey = c_custkey and c_nationkey = n1.n_nationkey and n1.n_regionkey = r_regionkey and r_name = 'ASIA' and s_nationkey = n2.n_nationkey and o_orderdate between date '1995-01-01' and date '1996-12-31' and p_type = 'LARGE BRUSHED BRASS') as all_nations group by o_year order by o_year

  1. test step (1) run script (2) when the log contains exception information ,stop script

shfshihuafeng avatar Jun 20 '24 10:06 shfshihuafeng