51 lines
1.7 KiB
Markdown
51 lines
1.7 KiB
Markdown
# 福建项目：导入监控图表模板后，仪表盘如图位置出错
|
||
|
||
| ID | Creation Date | Assignee | Status |
|
||
|----|----------------|----------|--------|
|
||
| OMPUB-793 | 2023-02-06T14:09:56.000+0800 | 史振东 | 已关闭 |
|
||
|
||
|
||
---
|
||
|
||
按照附件中的xlsx导入图表模板后，仪表盘下图位置出错，出现了很多”流量曲线图“
|
||
需求：可以从数据库中把所有”流量曲线图“删除么？目前从界面只能一个一个删，一共100多条
|
||
!image-2023-02-06-14-03-21-628.png|thumbnail! **shizhendong** commented on *2023-02-07T14:23:20.977+0800*:
|
||
|
||
问题原因：功能异常，代码问题。详情如：[NEZ-2537|https://jira.geedge.net/projects/NEZ/issues/NEZ-2537] 所示
|
||
解决方式：
|
||
|
||
|
||
{code:java}
|
||
# 登录 192.168.10.100，执行以下命令删除异常数据
|
||
[root@localhost ~]# mysql -h192.168.10.100 -uroot -p****** -D nezha -e "DELETE panel, chart, element FROM visual_panel panel LEFT JOIN visual_chart chart ON panel.id = chart.panel_id LEFT JOIN visual_chart_element element ON chart.id = element.chart_id WHERE panel.name = '流量曲线图';"{code}
|
||
数据库连接用户：root
|
||
|
||
数据库用户密码：111111
|
||
|
||
|
||
|
||
执行后登录 192.168.10.100，在 Dashboards 页面确认 ’流量曲线图‘ 相关内容是否删除
|
||
|
||
|
||
|
||
|
||
|
||
---
|
||
|
||
|
||
|
||
# Attachments
|
||
|
||
Attachment: chart-2023-02-03_21-47-00.xlsx
|
||
|
||
[chart-2023-02-03_21-47-00.xlsx](https://gfwleak.exec.li/admin/geedge-jira/raw/branch/master/attachment/34765/chart-2023-02-03_21-47-00.xlsx)
|
||
|
||
|
||
|
||
Attachment: image-2023-02-06-14-03-21-628.png
|
||
|
||
|
||
|
||
|
||
|