2.0 KiB
【E21现场】Network Zodiac系统界面22.07版本Asset models：TSG-9K-NPB展示时显示两次TSG-9140-NPB-FIREWALL
| ID | Creation Date | Assignee | Status |
|---|---|---|---|
| OMPUB-635 | 2022-09-21T15:36:44.000+0800 | 方顺健 | 已关闭 |
Network Zodiac系统界面22.07版本Asset models：TSG-9K-NPB展示时显示两次TSG-9140-NPB-FIREWALL，目前看到所有的TSG-9K-NPB Asset 都存在这种情况
以10.219.11.2为例，2022-08-12 E现场数据并没有出现重复的情况，
今天查询结果，10.219.11.2 dashboard内容展示显示两次TSG-9140-NPB-FIREWALL图表数据。
详情见附件。fangshunjian commented on 2022-09-21T16:57:25.501+0800:
[~liuju] 暂时通过执行sql 删除重复内容修复，待bug修复后更新
ssh 10.224.11.3 执行以下命令
{code:java} mysql -unezha -pNezha@02! -D nz -e "DELETE FROM visual_chart_element WHERE chart_id IN (SELECT id FROM visual_chart vc WHERE vc.group_id IN (SELECT vc.maxId FROM (SELECT panel_id,NAME,count(1) c,max(id) maxId,min(id) minId FROM visual_chart vc WHERE vc.panel_id !=0 AND vc.NAME='TSG-9140-NPB-FIREWALL' GROUP BY panel_id,NAME ORDER BY c DESC) vc WHERE vc.c> 1));DELETE FROM visual_chart WHERE group_id IN (SELECT maxId FROM (SELECT panel_id,NAME,count(1) c,max(id) maxId,min(id) minId FROM visual_chart vc WHERE vc.panel_id !=0 AND vc.NAME='TSG-9140-NPB-FIREWALL' GROUP BY panel_id,NAME ORDER BY c DESC) vc WHERE vc.c> 1);DELETE FROM visual_chart WHERE id IN (SELECT maxId FROM (SELECT panel_id,NAME,count(1) c,max(id) maxId,min(id) minId FROM visual_chart vc WHERE vc.panel_id !=0 AND vc.NAME='TSG-9140-NPB-FIREWALL' GROUP BY panel_id,NAME ORDER BY c DESC) vc WHERE vc.c> 1);" {code}
liuju commented on 2022-09-21T19:49:46.220+0800:
好的，已执行完毕，现在已无重复内容。
Attachments
Attachment: 微信图片_20220921103450.png
