You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2021/11/19 08:43:00 UTC

[jira] [Created] (IOTDB-2034) The IOTDB process was killed by the operating system (Query)

刘珍 created IOTDB-2034:
-------------------------

             Summary: The IOTDB process was killed by the operating system (Query)
                 Key: IOTDB-2034
                 URL: https://issues.apache.org/jira/browse/IOTDB-2034
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Query
    Affects Versions: master branch
            Reporter: 刘珍
         Attachments: config.properties, q_limit.sh

h1. 1. master
commit d63539b7ec78576b12484a731ac3ff2894f922ed
Author: Jackie Tien <Ja...@foxmail.com>
Date:   Fri Nov 19 10:50:06 2021 +0800

    Support RawQueryWithoutValueFilter in aligned timeseries (#4422)

h1. 2. 10sg/100dev/100sensor
   10dev/sg
    1 sensor/dev
     200000000 points/sensor

h1. 3. Query
h2.  cat run_limit.sh
#!/bin/bash
echo "  PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND">./virt.txt
*pid_iotdb=29485*

./clear.sh
top -b -n 1 | grep ${pid_iotdb} >>./virt.txt

for i in {1..10}
do
   ./q_limit.sh
   top -b -n 1 | grep ${pid_iotdb} >>./virt.txt
   ./clear.sh
done
-------------
 cat clear.sh

#!/bin/bash
sudo su root <<EOF
 echo 3 >/proc/sys/vm/drop_caches
EOF

-------------------------
cat q_limit.sh
./sbin/start-cli.sh -p 6667 -e "select s_0 from  root.ip5.ip50.d_0  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_10  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_20  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_30  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_40  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_50  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_60  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_70  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_80  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip50.d_90  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from  root.ip5.ip51.d_1  limit 1 offset 100000000" >> count_2.out
./sbin/start-cli.sh -p 6667 -e "select s_0 from root.ip5.ip51.d_11  limit 1 offset 100000000" >> count_2.out

.....(See the attachment)

{color:#DE350B}*The iotdb pid's VIRT usage keeps increasing  gradually until it is killed by the operating system
*{color}

{color:#DE350B}*iotdb 的VIRT使用一直增加直到被操作系统杀死(iotdb 查询堆外内存没有控制)*{color}





--
This message was sent by Atlassian Jira
(v8.20.1#820001)