horaedb icon indicating copy to clipboard operation
horaedb copied to clipboard

Inconsistent query results of partitioned table when loading data multiple times

Open Rachelint opened this issue 1 year ago • 0 comments

Describe this problem

I want to introduce tsbs to integration test of partitioned table. Howerver, I found Inconsistent query results when loading data multiple times(will drop table after new loading).

Server version

CeresDB Server Version: 1.2.6-alpha Git commit: b0d7c2ca Git branch: main Opt level: 0 Rustc version: 1.74.0-nightly Target: aarch64-apple-darwin Build date: 2023-09-06T03:13:57.949975000Z

Steps to reproduce

  • pull the branch in my pr #1195
  • start cluster and load data
cd integration_tests 
make run-dist-query
  • query data using following sql:
SELECT
    time_bucket(timestamp, 'PT60S') as minute,
    max(usage_user) AS max_usage_user, max(usage_system) AS max_usage_system, max(usage_idle) AS max_usage_idle, max(usage_nice) AS max_usage_nice, max(usage_iowait) AS max_usage_iowait
FROM cpu
WHERE (hostname = 'host_2987' OR hostname = 'host_2302' OR hostname = 'host_3182' OR hostname = 'host_3215' OR hostname = 'host_248' OR hostname = 'host_3701' OR hostname = 'host_1103' OR hostname = 'host_3837') AND (timestamp >= '2022-09-05T00:00:00Z') AND (timestamp < '2022-09-05T01:00:00Z')
GROUP BY minute
ORDER BY minute ASC
  • drop table and load data again
cd dist_query 
NO_INIT=true ./run.sh
  • query data again using above sql
  • you may found the inconsistent query results ...

Expected behavior

No response

Additional Information

No response

Rachelint avatar Sep 06 '23 03:09 Rachelint