重现步骤
反馈人：袁慧斌
严重级别：严重
所属项目：战略
问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引
SELECT
DATE(b.create_time) AS 日期,
CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型,
COUNT(*) AS 进队列总数,
SUM(b.business_status = 2) AS 成功数,
SUM(b.business_status = 3) AS 失败数,
SUM(b.business_status NOT IN (2, 3)) AS 其余状态数,
CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率,
CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率
FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b
FORCE INDEX (idx_create_time)
INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id
WHERE b.create_time >= DATE_SUB(CURDATE(), INTERVAL 2 DAY)
GROUP BY DATE(b.create_time), a.source_type
ORDER BY a.source_type, DATE(b.create_time)
解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
历史记录  
  1. 2025-06-18 08:29:43, 由 陈莉珍 创建。
  2. 2025-06-18 08:31:45, 由 刘瀚泽 指派给 任芳涛。
    修改了 指派给，旧值为 "liuhanze"，新值为 "renfangtao"。
    确认看下，统一再数仓查询是否可以，不在生产库查询
  3. 2025-06-18 09:24:07, 由 任芳涛 解决，方案为 非BUG-纯属误判 。
    修改了 解决方案，旧值为 ""，新值为 "feibug"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2025-06-18 09:23:16"。
    修改了 指派给 ，旧值为 "renfangtao"，新值为 "chenlizhen"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "renfangtao"。
    手动统计sql、可使用starrocks查询
  4. 2025-06-19 17:37:37, 由 陈莉珍 编辑。
    修改了 所属模块 ，旧值为 "0"，新值为 "1872"。
    修改了 业务部门 ，旧值为 "0"，新值为 "2"。
    修改了 测试责任人，旧值为 ""，新值为 "chenlizhen"。
    修改了 解决时效 ，旧值为 "0"，新值为 "0.89"。
    修改了 重现步骤 ，区别为：
    001- 反馈人：袁慧斌
    001+ 反馈人：袁慧斌 严重级别：严重 所属项目：战略 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引 SELECT DATE(b.create_time) AS 日期, CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型, COUNT(*) AS 进队列总数, SUM(b.business_status = 2) AS 成功数, SUM(b.business_status = 3) AS 失败数, SUM(b.business_status NOT IN (2, 3)) AS 其余状态数, CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率, CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率 FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b FORCE INDEX (idx_create_time) INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id WHERE b.create_time >= DATE_SUB(CURDATE(), INTERVAL 2 DAY) GROUP BY DATE(b.create_time), a.source_type ORDER BY a.source_type, DATE(b.create_time) 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
    002- 严重级别：严重
    003- 所属项目：战略
    004- 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引
    005- SELECT
    006- DATE(b.create_time) AS 日期,
    007- CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型,
    008- COUNT(*) AS 进队列总数,
    009- SUM(b.business_status = 2) AS 成功数,
    010- SUM(b.business_status = 3) AS 失败数,
    011- SUM(b.business_status NOT IN (2, 3)) AS 其余状态数,
    012- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率,
    013- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率
    014- FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b
    015- FORCE INDEX (idx_create_time)
    016- INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id
    017- WHERE b.create_time >= DATE_SUB(CURDATE(), INTERVAL 2 DAY)
    018- GROUP BY DATE(b.create_time), a.source_type
    019- ORDER BY a.source_type, DATE(b.create_time)
    020- 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
    001- 反馈人：袁慧斌<br />
    001+ 反馈人：袁慧斌<br /> 严重级别：严重<br /> 所属项目：战略<br /> 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引 <br /> SELECT<br /> DATE(b.create_time) AS 日期,<br /> CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型,<br /> COUNT(*) AS 进队列总数,<br /> SUM(b.business_status = 2) AS 成功数,<br /> SUM(b.business_status = 3) AS 失败数,<br /> SUM(b.business_status NOT IN (2, 3)) AS 其余状态数,<br /> CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率,<br /> CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率<br /> FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b<br /> FORCE INDEX (idx_create_time)<br /> INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id<br /> WHERE b.create_time &gt;= DATE_SUB(CURDATE(), INTERVAL 2 DAY)<br /> GROUP BY DATE(b.create_time), a.source_type<br /> ORDER BY a.source_type, DATE(b.create_time)<br /> 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
    002- 严重级别：严重<br />
    003- 所属项目：战略<br />
    004- 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引 <br />
    005- SELECT<br />
    006- DATE(b.create_time) AS 日期,<br />
    007- CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型,<br />
    008- COUNT(*) AS 进队列总数,<br />
    009- SUM(b.business_status = 2) AS 成功数,<br />
    010- SUM(b.business_status = 3) AS 失败数,<br />
    011- SUM(b.business_status NOT IN (2, 3)) AS 其余状态数,<br />
    012- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率,<br />
    013- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率<br />
    014- FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b<br />
    015- FORCE INDEX (idx_create_time)<br />
    016- INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id<br />
    017- WHERE b.create_time &gt;= DATE_SUB(CURDATE(), INTERVAL 2 DAY)<br />
    018- GROUP BY DATE(b.create_time), a.source_type<br />
    019- ORDER BY a.source_type, DATE(b.create_time)<br />
    020- 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
  5. 2025-06-19 17:37:40, 由 陈莉珍 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-06-19 17:37:40"。
所属项目 技术中心-需求池
所属模块 多平台   walmart
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 任芳涛
测试责任人 陈莉珍
解决时效 0.89
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-06-19 17:37:40
截止日期 0000-00-00
上线时间 2025-06-18 09:25:00
上线时效 0.92
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-06-18 08:29:43
影响环境 生产环境-业务反馈
由谁解决 任芳涛 于 2025-06-18 09:23:16
解决版本 主干
解决方案 非BUG-纯属误判
由谁关闭 陈莉珍 于 2025-06-19 17:37:40
最后修改 陈莉珍 于 2025-06-19 17:37:40
相关Bug