Help about alert rule metadata table alert_rule column guid's generation

  1. My Grafana has been upgraded several times, perhaps from version 8.X to 10.X.
  2. Now, let me introduce my environment and how to start Grafana.
  3. Grafana: 10.4.15, OS: Ubuntu 22.04, Browser: Chrome Version 134.0.6998.35 (Official Build) (64-bit)
  4. docker run -d --name=grafana -p 3000:3000 -v /opt/grafana/grafana.ini:/etc/grafana/grafana.ini -v /data1/grafana-data/plugins:/var/lib/grafana/plugins grafana/grafana:10.4.15
  5. What is the incorrect visualization?
  6. When adding a new alert rule, there seems to be an issue. In fact, the value of the guid column in the alert_rule table is empty, and the value of the rule_guid column in the alert_rule_version table is also empty. Currently, for the unique constraint UQE_alert_rule_version_rule_guid_version, the rule_guid value is empty and the version column value is set to ‘1’.
  7. I just added one alert rule.
SELECT  * from alert_rule  order by id desc limit 1;
id |org_id|title|condition|data                                                                                                                                                                                                                                                           |updated            |interval_seconds|version|uid           |namespace_uid|rule_group|no_data_state|exec_err_state|for         |annotations                                       |labels|dashboard_uid|panel_id|rule_group_idx|is_paused|notification_settings|record|metadata|updated_by|guid|
---+------+-----+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------+----------------+-------+--------------+-------------+----------+-------------+--------------+------------+--------------------------------------------------+------+-------------+--------+--------------+---------+---------------------+------+--------+----------+----+
829|     1|空间使用率|D        |[{"refId":"A","queryType":"","relativeTimeRange":{"from":3600,"to":0},"datasourceUid":"5VBDG8eMz","model":{"datasource":{"type":"prometheus","uid":"5VBDG8eMz"},"disableTextWrap":false,"editorMode":"builder","exemplar":true,"expr":"address_device_fstype_mo|2025-03-14 02:27:54|             300|      1|defru3x8cc4xsf|78kYmsuMz    |5m        |NoData       |Error         |300000000000|{"__dashboardUid__":"4Qv2-YBnk","__panelId__":"9"}|{}    |4Qv2-YBnk    |       9|             1|        0|null                 |      |        |          |    |

SELECT  * from alert_rule_version   order by id desc limit 1;
id  |rule_org_id|rule_uid      |rule_namespace_uid|rule_group|parent_version|restored_from|version|created            |title|condition|data                                                                                                                                                                                                                                                           |interval_seconds|no_data_state|exec_err_state|for         |annotations                                       |labels|rule_group_idx|is_paused|notification_settings|record|metadata|created_by|rule_guid|
----+-----------+--------------+------------------+----------+--------------+-------------+-------+-------------------+-----+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-------------+--------------+------------+--------------------------------------------------+------+--------------+---------+---------------------+------+--------+----------+---------+
1308|          1|defru3x8cc4xsf|78kYmsuMz         |5m        |             0|            0|      1|2025-03-14 02:27:54|空间使用率|D        |[{"refId":"A","queryType":"","relativeTimeRange":{"from":3600,"to":0},"datasourceUid":"5VBDG8eMz","model":{"datasource":{"type":"prometheus","uid":"5VBDG8eMz"},"disableTextWrap":false,"editorMode":"builder","exemplar":true,"expr":"address_device_fstype_mo|             300|NoData       |Error         |300000000000|{"__dashboardUid__":"4Qv2-YBnk","__panelId__":"9"}|{}    |             0|        0|null                 |      |        |          |         |
  1. Now, when I try to add the second alert rule, it shows the error Failed to save rule: conflicting alert rule found [rule_uid: 'eefruevl38wzkc', title: 'Load5', namespace_uid: '78kYmsuMz']: rule title under the same organisation and folder should be unique.