Docker7530
17 KiB
17 KiB
日期, 来源
| 日期 | 来源 |
|---|---|
| 2024-03-01 14:55 | 客响 |
问题详情
批量域名删除卡单
处理过程
SELECT code AS '工单号',
corp_name AS '公司名称',
create_time AS '创建时间',
REPLACE(details, '自助配置域名: ', '') AS '域名信息'
FROM work_order
WHERE (corp_name LIKE '%江苏%')
AND type = 'DOMAIN_DELETE'
AND status = 'config'
AND details LIKE '%自助%'
AND create_time >= '2024-02-29 00:00:00'
AND create_time <= '2024-02-29 23:59:59';
select *
from pipe_config_entity
where target_name in ('ycsp.yancheng.gov.cn',
'fgw.yancheng.gov.cn',
'cgj.yancheng.gov.cn',
'sheyang.yancheng.gov.cn',
'mzj.yancheng.gov.cn',
'ycsports.yancheng.gov.cn',
'ylbzj.yancheng.gov.cn',
'kfq.yancheng.gov.cn',
'funing.yancheng.gov.cn',
'czj.yancheng.gov.cn',
'cxjsj.yancheng.gov.cn',
'kjj.yancheng.gov.cn',
'dafeng.yancheng.gov.cn',
'ycga.yancheng.gov.cn',
'wsb.yancheng.gov.cn',
'dongtai.yancheng.gov.cn',
'mzzjj.yancheng.gov.cn',
'ycedu.yancheng.gov.cn',
'wsj.yancheng.gov.cn',
'binhai.yancheng.gov.cn',
'jsycgzw.yancheng.gov.cn',
'snw.yancheng.gov.cn',
'slj.yancheng.gov.cn',
'jsychrss.yancheng.gov.cn',
'swj.yancheng.gov.cn',
'scjgj.yancheng.gov.cn',
'zfhcxjsj.yancheng.gov.cn',
'gxj.yancheng.gov.cn',
'jianhu.yancheng.gov.cn',
'xiangshui.yancheng.gov.cn',
'swglj.yancheng.gov.cn',
'cnxq.yancheng.gov.cn',
'jsychb.yancheng.gov.cn',
'sjj.yancheng.gov.cn',
'ajj.yancheng.gov.cn',
'xfj.yancheng.gov.cn',
'tyjr.yancheng.gov.cn',
'jrb.yancheng.gov.cn',
'ycgjj.yancheng.gov.cn',
'sfj.yancheng.gov.cn',
'wjw.zhenjiang.gov.cn',
'whgdj.yancheng.gov.cn',
'ycjtj.yancheng.gov.cn',
'gxhzw.yancheng.gov.cn',
'slj.zhenjiang.gov.cn',
'tjj.yancheng.gov.cn',
'www.ycjgdj.gov.cn',
'www.jsyczfw.gov.cn',
'hrss.zhenjiang.gov.cn',
'gxs.zhenjiang.gov.cn',
'snyncj.zhenjiang.gov.cn');
# group by message_id;
select *
from sys_task_process_alarm
where tag like '%pmc5c7e721c9cc488dbf25c292b21f8fed%';
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"hrss.zhenjiang.gov.cn"}],"messageId":"pm262e2e422ff5485b90a884a9a200ee4b"}
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"swglj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"mzzjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"gxj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"kfq.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"kjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"xfj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"sheyang.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ajj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"wsj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"czj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"dafeng.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycjtj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jsychb.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"scjgj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"cnxq.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycga.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"xiangshui.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"fgw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ylbzj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"cxjsj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycgjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"sfj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jianhu.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jsycgzw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"zfhcxjsj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"snw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jrb.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"slj.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"cgj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"www.jsyczfw.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"slj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"swj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"sjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"www.ycjgdj.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"wjw.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"whgdj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"dongtai.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"funing.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycsp.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jsychrss.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"tyjr.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"gxhzw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"mzj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"binhai.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycsports.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycedu.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"wsb.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"tjj.yancheng.gov.cn"}],"messageId":"pm79dd63120c3045e3b277534aa8dd5b28"}
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"gxs.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"snyncj.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"www.healtang.com"}],"messageId":"pmdd72d99c8572443ab0ff17b38323de0e"}
总结
117 服务器同时接收到 6 个任务回调
rabbit 会在多台服务器上消费
2024-02-29 at 17:29:41
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"swglj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"mzzjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"gxj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"kfq.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"kjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"xfj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"sheyang.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ajj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"wsj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"czj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"dafeng.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycjtj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jsychb.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"scjgj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"cnxq.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycga.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"xiangshui.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"fgw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ylbzj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"cxjsj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycgjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"sfj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jianhu.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jsycgzw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"zfhcxjsj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"snw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jrb.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"slj.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"cgj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"www.jsyczfw.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"slj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"swj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"sjj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"www.ycjgdj.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"wjw.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"whgdj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"dongtai.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"funing.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycsp.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jsychrss.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"tyjr.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"gxhzw.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"mzj.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"binhai.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycsports.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"ycedu.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"wsb.yancheng.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"tjj.yancheng.gov.cn"}],"messageId":"pm79dd63120c3045e3b277534aa8dd5b28"}
2024-02-29 at 17:29:41
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"hrss.zhenjiang.gov.cn"}],"messageId":"pm262e2e422ff5485b90a884a9a200ee4b"}
2024-02-29 at 17:29:41
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"gxs.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"snyncj.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"www.healtang.com"}],"messageId":"pmdd72d99c8572443ab0ff17b38323de0e"}
2024-02-29 at 17:29:41
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"swj.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"jgswj.zhenjiang.gov.cn"}],"messageId":"pm0f585328b8554757850ca3d14c9a4484"}
2024-02-29 at 17:49:41
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"sjj.zhenjiang.gov.cn"},{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"wgl.zhenjiang.gov.cn"}],"messageId":"pm69e392c579a44fcdbb346354f7284141"}
2024-02-29 at 17:49:41
{"data":[{"percent":1.0,"process":false,"reqType":"SELF_DOMAIN_DELETE","targetName":"www.jhrchem.cn"}],"messageId":"pmd6530e5801e1400db089bc0008d1d961"}
'pm262e2e422ff5485b90a884a9a200ee4b',(处理异常) 任务1（102）
'pmd6530e5801e1400db089bc0008d1d961', 任务2（102）一个域名
'pm0f585328b8554757850ca3d14c9a4484', 任务3（103）二个域名
'pmdd72d99c8572443ab0ff17b38323de0e',(处理异常) 任务4（116）
'pm79dd63120c3045e3b277534aa8dd5b28',(处理异常) 任务5（117）
'pm69e392c579a44fcdbb346354f7284141', 任务6（117）二个域名
102-2024-02-29 at 17:29:42 CST [org.springframework.amqp.rabbit.RabbitListenerEndpointContainer#15-1] INFO com.cmcc.cdn.platform.selfservice.service.impl.BigCloudBasicInfoServiceImpl 1302 lambda$getToken$4 - 【请求信安获取认证接口】TokenResponse:{"access_token":"hx8XS7MUh4EiPmMvXRIIwakkkVfYir","refresh_token":"mhatnuXwhaNhaG2elrQbEDWxkoHVKV","scope":"","token_type":"Bearer"}
103-2024-02-29 at 17:29:43 CST [org.springframework.amqp.rabbit.RabbitListenerEndpointContainer#15-1] INFO com.cmcc.cdn.platform.selfservice.service.impl.BigCloudBasicInfoServiceImpl 1302 lambda$getToken$4 - 【请求信安获取认证接口】TokenResponse:{"access_token":"KKg31bNDgEZt3vEqmQ6DpGDMq0Ji6I","refresh_token":"upYJSumqPlWFIqwPG3EqvMu8vrSvvX","scope":"","token_type":"Bearer"}
116-2024-02-29 at 17:29:42 CST [org.springframework.amqp.rabbit.RabbitListenerEndpointContainer#15-1] INFO com.cmcc.cdn.platform.selfservice.service.impl.BigCloudBasicInfoServiceImpl 1302 lambda$getToken$4 - 【请求信安获取认证接口】TokenResponse:{"access_token":"onEAWaluy7TvqSKoMABDUFGMDVv6Dn","refresh_token":"KjkkcUD42WMRuVVa60dui1pna7ITec","scope":"","token_type":"Bearer"}
117-2024-02-29 at 17:29:42 CST [org.springframework.amqp.rabbit.RabbitListenerEndpointContainer#15-1] INFO com.cmcc.cdn.platform.selfservice.service.impl.BigCloudBasicInfoServiceImpl 1302 lambda$getToken$4 - 【请求信安获取认证接口】TokenResponse:{"access_token":"B7OCyaiAyZpfNvdnzeQpCbUfRiFK6Q","refresh_token":"Lo3xb3O8RhphYjWYWtm8Y32n6LLxUr","scope":"","token_type":"Bearer"}
