Skip to content
This repository was archived by the owner on Mar 12, 2026. It is now read-only.
This repository was archived by the owner on Mar 12, 2026. It is now read-only.

Inconsistent query results of partitioned table when loading data multiple times #1196

@Rachelint

Description

@Rachelint

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: b0d7c2c
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

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions