[ https://issues.apache.org/jira/browse/IOTDB-1836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuan Tian reassigned IOTDB-1836: -------------------------------- Assignee: Yuan Tian > 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: master branch, 0.12.2 > Reporter: 刘珍 > Assignee: Yuan Tian > Priority: Major > Labels: pull-request-available > 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)