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’.
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 | | | | |
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.
