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

[Enhancement]: 关于巡检中的table.information_schema_tables_two_data中报错的问题详解 #390

Closed
wayyoungboy opened this issue Aug 14, 2024 · 1 comment · Fixed by #460

Comments

@wayyoungboy
Copy link
Contributor

Description

现象:一张表在information_schema.tables 中查到的有两条记录,两条记录的原因是__all_table_stat 中同时存在两条object_type=1的记录。
原因分析: 非分区表转分区表 ddl,导致一些视图(如 information_schema.tables/all_tables)会多显示一条记录
observer修复版本: 421bp5/423/431
应急方法:手动删除 __all_table_stat/__all_column_stat 中不符合预期的行(分区表不应该存在 table_id=partition_id=该表id 的记录)

  1. 登录到 sys 租户上
  2. 切到用户租户:alter system change tenant 租户名
  3. 删内部统计信息的行
    delete from __all_table_stat where table_id=partition_id and table_id=分区表table_id;
    delete from __all_column_stat where table_id=partition_id and table_id=分区表table_id;
@Teingi
Copy link
Contributor

Teingi commented Aug 14, 2024

  1. 补充到知识库;
  2. obdiag 巡检中也可以给出该issue的链接;

@wayyoungboy wayyoungboy changed the title [Enhancement]: 关于巡检中的cluster.mod_too_large中报错的问题详解 [Enhancement]: 关于巡检中的table.information_schema_tables_two_data中报错的问题详解 Sep 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants