You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Yuan Tian (Jira)" <ji...@apache.org> on 2022/01/23 14:54:00 UTC

[jira] [Commented] (IOTDB-2445) select count(*) execution failed : overlapped data should be consumed first

    [ https://issues.apache.org/jira/browse/IOTDB-2445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17480645#comment-17480645 ] 

Yuan Tian commented on IOTDB-2445:
----------------------------------

 我尝试在本地复现,没有复现出;

!image-2022-01-23-22-52-44-597.png!

但是我生成的数据,用原始数据查询,select s_0 from root.test.g_0.d_0,查出来时间戳是乱的;我扫了一遍文件,发现文件就合坏了,应该是乱序合并的问题,因为我把乱序合并关了之后,就没这个问题了;

> select count(*)  execution failed :  overlapped data should be consumed first
> -----------------------------------------------------------------------------
>
>                 Key: IOTDB-2445
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2445
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Core/Server
>    Affects Versions: 0.13.0
>            Reporter: 刘珍
>            Assignee: Yuan Tian
>            Priority: Major
>              Labels: 0.13.0, pull-request-available
>             Fix For: 0.13.0
>
>         Attachments: 2_config.properties, image-2022-01-19-18-54-45-825.png, image-2022-01-19-18-55-24-711.png, image-2022-01-23-22-52-44-597.png, unseq_config.properties
>
>
> 0.13.0 预发版1
> 复现用例:
> 测试机器:私有云32g内存,8cpu。benchmark和iotdb在同一台机器。
> iotdb-env.sh :
> MAX_HEAP_SIZE="16G"
> MAX_DIRECT_MEMORY_SIZE="6G"
> 数据库engine参数默认:
> # enable_seq_space_compaction=true
> # enable_unseq_space_compaction=false
> # 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执行失败:
> {color:#DE350B}*time ./sbin/start-cli.sh -e "select count from root.test.g_0.d_0; "*{color}
> 失败:
> {color:#DE350B}*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
> *{color}
>  !image-2022-01-19-18-54-45-825.png! 
> 日志:
>  !image-2022-01-19-18-55-24-711.png! 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)