[步骤]
-- allegro 队列报错分组降序
SELECT
'allegro',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.FailureReason
-- COUNT( 1 ) AS '失败次数统计'
FROM
ap_autopublish_allegro_queue a
WHERE
a.CustomerId = 1
and a.MarketId=67
AND `Status` = 'failure'
AND a.Time >'2023-05-12 00:00:00'
AND a.Time <'2023-05-17 00:00:00'
AND a.FailureReason LIKE'%标题%'


[结果]
系统SKU : 16024578刊登时还是报标题获取异常
[期望]
刊登成功
标题库接口调用失败,如下:
1、增加重试机制
2、清除标题错误队列以便重新执行刊登策略