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

[jira] [Commented] (IOTDB-2454) [select .. into ] select .. into 2 target devices, one of which has less data than expected

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

Liuxuxin commented on IOTDB-2454:
---------------------------------

https://github.com/apache/iotdb/pull/4919

> [select .. into ] select .. into 2 target devices, one of which has less data than expected
> -------------------------------------------------------------------------------------------
>
>                 Key: IOTDB-2454
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2454
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Core/Server
>    Affects Versions: 0.13.0-SNAPSHOT
>            Reporter: 刘珍
>            Assignee: Liuxuxin
>            Priority: Major
>         Attachments: config.properties, screenshot-1.png
>
>
> 问题描述:
> 0.13.0 预发版1,顺序数据,select 的结果 into到2个device,其中1个device的记录数少于预期(预期结果:每个序列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产生顺序数据,配置文件见附件。
> 写入完成,cli执行flush
> 2.benchmark执行完成后,接着在cli执行下面的SQL :
> select 的结果into 到2个device。
> select  s_0,s_1,s_2 ,s_3,s_4,s_5 into aligned root.db.dev1.s_0,root.db.dev1.s_1,root.db.dev1.s_2,root.db.dev2.s_0,root.db.dev2.s_1,root.db.dev2.s_2 from root.test.g_0.d_0;
> 目标设备,有1个设备的记录数少于预期,期望是每个序列1亿个点:
>  !screenshot-1.png! 
> 再接着执行1遍少数据的device:
> 记录数从13450000降到了100000



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