matrixorigin / matrixorigin/matrixone

[Bug]: No statement is returned when query from statement_info at t1 and get 34 rows when query at t2

Open
#14,298 14 comments 0 reactions 1 assignee Assigned to @xzxiong View on GitHub
impact/1.0 kind/bug severity/s0 to-next-release
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

### Is there an existing issue for the same bug?

- [X] I have checked the existing issues.

### Branch Name

v1.0.2

### Commit ID

8081e0516

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

Run the following query at `2024/01/19 07:25:05.305830 +0000` and get 0 result:
```
2024/01/19 07:25:05.305830 +0000 DEBUG worker/controller.go:378 trace {"elapsed": "33.518872ms", "rows": 0, "sql": "SELECT `statement_id`,any_value(`stats`) as `stats`,any_value(`duration`) as `duration`,any_value(`sql_source_type`) as `sql_source_type`,any_value(`account`) as `account`,any_value(`response_at`) as `response_at` FROM `system`.`statement_info` WHERE status != 'Running' and account != 'sys' and account != 'mocloud_mo_ob' and response_at >= '2024-01-19 07:19:00' and response_at < '2024-01-19 07:20:00' GROUP BY `statement_id`"}
```

Run the same query now and get 34 rows.

### Expected Behavior

Get the same query result for the query at any time

### Steps to Reproduce

```Markdown
NA
```

### Additional information

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.