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

information_schema.tables returns table_rows as 0 #52883

Open
dengliu opened this issue Nov 13, 2024 · 2 comments
Open

information_schema.tables returns table_rows as 0 #52883

dengliu opened this issue Nov 13, 2024 · 2 comments
Labels
type/bug Something isn't working

Comments

@dengliu
Copy link
Contributor

dengliu commented Nov 13, 2024

Steps to reproduce the behavior (Required)

+-----------+------------+------------+--------------+----------+
| TableName | IndexName  | Size       | ReplicaCount | RowCount |
+-----------+------------+------------+--------------+----------+
| FILL      | FILL_INDEX | 425.333 GB | 324          | 0        |
|           | Total      | 425.333 GB | 324          |          |
+-----------+------------+------------+--------------+----------+

Expected behavior (Required)

Real behavior (Required)

StarRocks version (Required)

  • You can get the StarRocks version by executing SQL select current_version()
@dengliu dengliu added the type/bug Something isn't working label Nov 13, 2024
@rohitrs1983
Copy link
Contributor

@dengliu this update happens as part of background job which runs every 5 min. if you want faster refresh then you can adjust the config item tablet_stat_update_interval_second

@dengliu
Copy link
Contributor Author

dengliu commented Nov 20, 2024

It seems not to be a slow refresh problem. we have a program that query it every minute, the RowCount is always 0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants