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

TDSQL规则:该查询使用了全表扫描,并且扫描行数为xxx 重复触发 #2870

Open
winfredLIN opened this issue Jan 13, 2025 · 0 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@winfredLIN
Copy link
Collaborator

版本信息(Version)

sqle 3.2408 zjrc
插件 tdsql

问题描述(Describe)

截图或日志(Log)

image
image

如何复现(To Reproduce)

  1. 使用tdsql
  2. 审核一条SQL,该SQL的扫描行数在多个节点都超过阈值
  3. 该规则被重复触发

问题原因

解决方案

产品预期

记录多个分片上的结果
如果多个分片均未触发,则不触发规则
如果存在一个分片触发,则触发规则,且仅记录为一条规则
在此基础上,可以考虑定位出问题的分片,对于排查来讲会比较有效

变更影响面

受影响的模块或功能

外部引用的潜在问题或风险

版本兼容性

测试建议

@winfredLIN winfredLIN added the bug Something isn't working label Jan 13, 2025
@ColdWaterLW ColdWaterLW added this to the v4.2502.0 milestone Jan 16, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants