# Help about alert rule metadata table alert\_rule column guid's generation

**URL:** <https://community.grafana.com/t/help-about-alert-rule-metadata-table-alert-rule-column-guids-generation/146319>\
**Category:** Alerting\
**Created:** [March 14, 2025, 2:36am UTC](https://community.grafana.com/t/help-about-alert-rule-metadata-table-alert-rule-column-guids-generation/146319 "2025-03-14T02:36:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![heretac](https://avatars.discourse-cdn.com/v4/letter/h/f0a364/32.png) [@heretac](https://community.grafana.com/u/heretac)\
**Post date:** [March 14, 2025, 2:36am UTC](https://community.grafana.com/t/help-about-alert-rule-metadata-table-alert-rule-column-guids-generation/146319/1 "2025-03-14T02:36:35Z")

</div>

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.

```auto
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`.
