sqle icon indicating copy to clipboard operation
sqle copied to clipboard

翻页和扫描中止问题

Open windking1125 opened this issue 1 year ago • 2 comments

SQLe Version main 1ba554527d4320646c7bb29a0bb14996f87b5fb0

Describe the bug 1.sql审核页面,审核结果无法翻页 2.执行sql审核时(扫描mybatis文件),异常中止:failed to upload sql: audit result error

To Reproduce

Expected behavior

Suggestion

windking1125 avatar Feb 05 '24 09:02 windking1125

问题1

来自:@windking1125 现象:SQL审核结果有4页,翻到第四页后再点前面几页就点不动了 尝试:刷新浏览器缓存,解决不了,分页控件都点不动 浏览器版本: 2e8655a5fbf2644ea51aec824e88a44 UI: main aeee2f9d 最后一次的应答结果

(/sqle/v2/projects/default/audit_plans/JACL/reports/188/sqls?page_index=4&page_size=20):
{
    "code": 0,
    "message": "ok",
    "data": [
        {
            "audit_plan_report_sql": "UPDATE `t_pul_tdxid` SET `PASSWORD`=?, `UPDATE`=current_date(), `UPTIME`=current_time() WHERE `TDXID`=?",
            "audit_plan_report_sql_audit_result": null,
            "number": 61
        }
    ],
    "total_nums": 61
}

winfredLIN avatar Feb 06 '24 03:02 winfredLIN

问题2

来自:@windking1125 执行sql审核时(扫描mybatis文件),异常中止:failed to upload sql: audit result error

排查方案

可以尝试,使用scanner时加上 skip-audit=true,不在扫描阶段审核,在智能扫描页面里审核

winfredLIN avatar Feb 06 '24 05:02 winfredLIN

  1. 问题1,未能复现
  2. 问题2,报错的原因是sql审核不通过因此不上传,需要添加skip-audit=true来跳过在采集时的审核

winfredLIN avatar Mar 04 '24 05:03 winfredLIN