Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-1836

Execute time range query : Msg: 500: [INTERNAL_SERVER_ERROR]

    XMLWordPrintableJSON

Details

    • 2021-10-Tian

    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

      Attachments

        1. iotdb_log.tar.gz
          492 kB
          刘珍
        2. config.properties
          12 kB
          刘珍
        3. iotdb-engine.properties
          28 kB
          刘珍
        4. tracing.txt
          0.9 kB
          刘珍

        Activity

          People

            jackietien Yuan Tian
            刘珍 刘珍
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: