Skip to content

智能扫描任务: processlist任务误触发表不存在问题 #2862

New issue

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

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

Already on GitHub? # to your account

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

Comments

@LordofAvernus
Copy link
Collaborator

LordofAvernus commented Jan 9, 2025

版本信息(Version)

3.2412.0

问题描述(Describe)

智能扫描任务开启processlist列表任务,采集到的一些SQL审核结果显示表不存在。实际表在数据库能查询到。

截图或日志(Log)

img_v3_02ia_7a8a5345-ab56-4918-8c1c-6d7adf7f3bcg

如何复现(To Reproduce)

  • 执行SQL
use test
select sleep(10),name from no-test.users; 
  • 该sql被processlist任务查询出来后,使用其中的db字段作为SQL所在的schema,实际上并不正确
    fad09caf-1aac-49aa-a3ff-1e5cf03fc2f4

问题原因

由于是通过show full process获取的processlist时候,结果中的db和实际的执行SQL所属的db不符合的时候。审核的时候,就会找不到对应的表

解决方案

变更影响面

受影响的模块或功能

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

版本兼容性

测试建议

@LordofAvernus LordofAvernus added the bug Something isn't working label Jan 9, 2025
@ColdWaterLW ColdWaterLW added this to the v3.2502.0 milestone Jan 9, 2025
@ColdWaterLW ColdWaterLW modified the milestones: v4.2502.0, v4.2503.0 Feb 24, 2025
@ColdWaterLW ColdWaterLW modified the milestones: v4.2503.0, 4.2504.0 Mar 26, 2025
@ColdWaterLW ColdWaterLW modified the milestones: v4.2504.0, v4.2505.0 Apr 21, 2025
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants