[jira] [Created] (IOTDB-1836) Execute time range query : Msg: 500: [INTERNAL_SERVER_ERROR]

["刘珍 (Jira)" <ji...@apache.org>]

刘珍 created IOTDB-1836:
-------------------------

             Summary: Execute time range query : Msg: 500: [INTERNAL_SERVER_ERROR] 
                 Key: IOTDB-1836
                 URL: https://issues.apache.org/jira/browse/IOTDB-1836
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Query
    Affects Versions: 0.12.2
            Reporter: 刘珍
         Attachments: config.properties, iotdb-engine.properties, iotdb_log.tar.gz, tracing.txt

rel/0.12  24cc07dffdaf79fda8290c24e8329e20a53015df

Exception message:
Msg: 500: [INTERNAL_SERVER_ERROR] Exception occurred while executing "{color:#DE350B}SELECT s_0 FROM root.test.g_15.d_2890 WHERE time >= 1537377860000 AND time <= 1537377865000{color}". null

Reproduce steps :
1. iotdb-engine.properties
compaction_strategy=NO_COMPACTION
enable_unseq_compaction=false
enable_last_cache=false
enable_wal=false
max_deduplicated_path_num=10000
query_timeout_threshold=60000000

2. Start iotdb

3. Run benchmark （See attachment config.properties for configuration parameters）
cd ${benchmark_dir}
# First test  第1轮测试（读写混合/乱序）
./benchmark.sh > 1013_1.out
sleep 2s
# 删除所有存储组
${iotdb_dir}/sbin/start-cli.sh -e "delete storage group root.*"
sleep 2s
# show.out 结果显示存储组全部删除成功
${iotdb_dir}/sbin/start-cli.sh -e "show storage group" > show.out
sleep 2s
mv data data_1

# Second test 第2轮测试（读写混合/乱序），bm配置同第1轮测试
./benchmark.sh > 1013_2.out

{color:#DE350B}*第2轮测试，查询报错*{color}(1013_2.out )： 
2021-10-13 15:54:25,978 ERROR cn.edu.tsinghua.iotdb.benchmark.iotdb012.IoTDB:608 - exception occurred when execute query=SELECT s_0 FROM root.test.g_5.d_930 WHERE time >= 1537377805000 AND time <= 1537377810000
org.apache.iotdb.jdbc.IoTDBSQLException: 500: [INTERNAL_SERVER_ERROR] Exception occurred while executing executeQueryStatement. null








--
This message was sent by Atlassian Jira
(v8.3.4#803005)