Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

query TIDB_HOT_REGIONS return some unexpected result #50810

Closed
crazycs520 opened this issue Jan 30, 2024 · 1 comment · Fixed by #52180
Closed

query TIDB_HOT_REGIONS return some unexpected result #50810

crazycs520 opened this issue Jan 30, 2024 · 1 comment · Fixed by #52180
Assignees
Labels
affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. report/customer Customers have encountered this bug. severity/minor sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@crazycs520
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

related issue: #50809

select * from `TIDB_HOT_REGIONS`;

2. What did you expect to see? (Required)

the query result don't contain any system memory table, since memory table doesn't have any data in tikv regions.

3. What did you see instead (Required)

The query result contain some system memory table.

+---------------------+----------+--------------------+------------------------+------------+-----------+------+----------------+--------------+------------+
| TABLE_ID            | INDEX_ID | DB_NAME            | TABLE_NAME             | INDEX_NAME | REGION_ID | TYPE | MAX_HOT_DEGREE | REGION_COUNT | FLOW_BYTES |
+---------------------+----------+--------------------+------------------------+------------+-----------+------+----------------+--------------+------------+
| 4611686018427387996 | <null>   | INFORMATION_SCHEMA | TIDB_CHECK_CONSTRAINTS | <null>     | 52        | read | 87             | 0            | 31200      |
| 104                 | 0        | test               | t1                     | PRIMARY    | 14        | read | 86             | 0            | 230161     |
+---------------------+----------+--------------------+------------------------+------------+-----------+------+----------------+--------------+------------+

4. What is your TiDB version? (Required)

+-----------------------------------------------------------+
| tidb_version()                                            |
+-----------------------------------------------------------+
| Release Version: v8.0.0-alpha-143-g7087f70                |
| Edition: Community                                        |
| Git Commit Hash: 7087f702e18f811c98d5a276eace7bb69292c6aa |
| Git Branch: HEAD                                          |
| UTC Build Time: 2024-01-30 03:53:25                       |
| GoVersion: go1.21.4                                       |
| Race Enabled: false                                       |
| Check Table Before Drop: false                            |
| Store: tikv                                               |
+-----------------------------------------------------------+
@crazycs520 crazycs520 added type/bug The issue is confirmed as a bug. severity/minor help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. labels Jan 30, 2024
@ywqzzy ywqzzy assigned ywqzzy and unassigned ywqzzy Jan 31, 2024
@jebter jebter added the sig/sql-infra SIG: SQL Infra label Jan 31, 2024
@ywqzzy ywqzzy self-assigned this Feb 2, 2024
@ti-chi-bot ti-chi-bot added affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-5.4 This bug affects the 5.4.x(LTS) versions. labels Feb 5, 2024
@Defined2014 Defined2014 assigned Defined2014 and unassigned ywqzzy Mar 28, 2024
@seiya-annie
Copy link

/found customer

@ti-chi-bot ti-chi-bot bot added the report/customer Customers have encountered this bug. label Jun 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. report/customer Customers have encountered this bug. severity/minor sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants