alertsnitch+grafana_prometheus告警数据持久化到MySQL 的问题
参照
https://blog.csdn.net/L_15156024189/article/details/124858301
https://blog.51cto.com/u_13747676/5323538
https://grafana.com/grafana/dashboards/15833-prometheus-alert-history/
安装alertsnitch 安装完毕后
始终报错 db query error: Error 1146: Table 'alertsnitch.alert' doesn't exist,除了这个其他一切正常
哪位能指点一下,我装的数据库是mysql5.7和mysql8.0.26都是这个报错,经过测试似乎是 alertsnitch.alert 这个表不存在,还有办法解决吗?谢谢各位
mysql> use alertsnitch;
mysql> show tables;
+-----------------------+
| Tables_in_alertsnitch |
+-----------------------+
| Alert |
| AlertAnnotation |
| AlertGroup |
| AlertLabel |
| CommonAnnotation |
| CommonLabel |
| GroupLabel |
| Model |
+-----------------------+
8 rows in set (0.00 sec)
mysql> select * from Alert ;
Empty set (0.00 sec)
mysql> repair table alertsnitch.alert;
+-------------------+--------+----------+-----------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+--------+----------+-----------------------------------------+
| alertsnitch.alert | repair | Error | Table 'alertsnitch.alert' doesn't exist |
| alertsnitch.alert | repair | status | Operation failed |
+-------------------+--------+----------+-----------------------------------------+
2 rows in set (0.01 sec)