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)