[
https://issues.apache.org/jira/browse/IOTDB-2517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Haonan Hou reassigned IOTDB-2517:
---------------------------------
Assignee: Liuxuxin
> [compaction & query] The count(sensor) query result is less than expected
> -------------------------------------------------------------------------
>
> Key: IOTDB-2517
> URL: https://issues.apache.org/jira/browse/IOTDB-2517
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Server
> Affects Versions: 0.13.0-SNAPSHOT
> Reporter: 刘珍
> Assignee: Liuxuxin
> Priority: Major
> Labels: 0.13.0
> Attachments: iotdb-engine.properties, iotdb-env.sh, q.sh
>
>
> master-0207 / f16f8348b7ec0f5a97ab04d64f7684693006ebb0
> 合并过程中执行100条count(s_4)查询，{color:#DE350B}有2条查询的结果少于预期{color}：
> +-----------------------------+
> |count(root.test.g_4.d_34.s_4)|
> +-----------------------------+
> | 747040000|
> +-----------------------------+
> Total line number = 1
> +-----------------------------+
> |count(root.test.g_5.d_55.s_4)|
> +-----------------------------+
> | 746250000|
> +-----------------------------+
> Total line number = 1
> It costs 0.856s
> 期望值是1200000000。
> {color:#00875A}但是，等合并完成，再执行这2条少数据的查询，查询结果是正确的。{color}
> 复现方法：
> 1. copy数据备份到被测数据库
> 数据备份在192.168.10.68
> /data/liuzhen_test/db13_pre_v1/data_bk_unseq_no_comp_0120
> 这个数据备份是在关合并生成的。
> 2. 启动被测数据库
> 启动成功（log_all.log出现enjoy）
> 执行q.sh （有100条查询）
> 3.查看q.sh的执行结果
> 100条sql的期望结果是1200000000。
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
