You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2022/02/08 05:02:00 UTC
[jira] [Created] (IOTDB-2517) [compaction & query] The count(sensor) query result is less than expected
刘珍 created IOTDB-2517:
-------------------------
Summary: [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: 刘珍
Attachments: iotdb-engine.properties, iotdb-env.sh, q.sh
master-0207 / f16f8348b7ec0f5a97ab04d64f7684693006ebb0
合并过程中执行100条count(s_4)查询,有2条查询的结果少于预期:
+-----------------------------+
|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。
复现方法:
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)