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

select count(*) execution failed : overlapped data should be consumed first

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • 2022-2-Tian

    Description

      0.13.0 预发版1

      复现用例:

      测试机器:私有云32g内存,8cpu。benchmark和iotdb在同一台机器。

      iotdb-env.sh :
      MAX_HEAP_SIZE="16G"
      MAX_DIRECT_MEMORY_SIZE="6G"

      数据库engine参数默认:

      1. enable_seq_space_compaction=true
      2. enable_unseq_space_compaction=false
      3. enable_cross_space_compaction=true

      1. benchmark产生乱序数据,配置文件见附件。
      2.benchmark执行完成后,接着在cli执行下面的4条SQL(整个复制粘贴)
      time ./sbin/start-cli.sh -e "flush "
      time ./sbin/start-cli.sh -e "select s_0,s_1,s_2,s_3,s_4,s_5 into root.db.dev.s_0,root.db.dev.s_1,root.db.dev.s_2,root.db.dev.s_3,root.db.dev.s_4,root.db.dev.s_5 from root.test.g_0.d_0; "
      time ./sbin/start-cli.sh -e "select count from root.test.g_0.d_0; "
      time ./sbin/start-cli.sh -e "select count from root.db.dev; "

      其中第3条sql执行失败:
      time ./sbin/start-cli.sh -e "select count from root.test.g_0.d_0; "
      失败:
      *Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "select count from root.test.g_0.d_0". executeStatement failed. java.io.IOException: overlapped data should be consumed first
      *


      日志:

      Attachments

        1. 1642935779065-46-1-2.tsfile
          10.99 MB
          Yuan Tian
        2. 2_config.properties
          14 kB
          刘珍
        3. image-2022-01-19-18-54-45-825.png
          78 kB
          刘珍
        4. image-2022-01-19-18-55-24-711.png
          260 kB
          刘珍
        5. image-2022-01-23-22-52-44-597.png
          382 kB
          Yuan Tian
        6. image-2022-01-26-11-12-51-870.png
          179 kB
          刘珍
        7. screenshot-1.png
          83 kB
          刘珍
        8. unseq_config.properties
          14 kB
          刘珍

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Agile

                Completed Sprint:
                2022-2-Tian ended 07/Mar/22
                View on Board

                Slack

                  Issue deployment