[IOTDB-1836] Execute time range query : Msg: 500: [INTERNAL_SERVER_ERROR]

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master branch, 0.12.2
• Fix Version/s: 0.13.0, 0.12.3
• Component/s: Core/Query
• Labels: pull-request-available
• Sprint: 2021-10-Tian
• Assignee: Yuan Tian
• Reporter: 刘珍
• Created: 13/Oct/21 08:47
• Updated: 14/Oct/21 06:37
• Resolved: 14/Oct/21 05:59

Description

rel/0.12 24cc07dffdaf79fda8290c24e8329e20a53015df

Exception message:
Msg: 500: [INTERNAL_SERVER_ERROR] Exception occurred while executing "SELECT s_0 FROM root.test.g_15.d_2890 WHERE time >= 1537377860000 AND time <= 1537377865000". 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

第2轮测试，查询报错(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

Issue Links

• links to: GitHub Pull Request #4158
• links to: GitHub Pull Request #4159