Hello everyone,
I have a problem:
I am upgrading grafana version 11.5.7 to 12.2.1 and the error below occurs.
grafana | logger=migrator t=2025-11-09T01:44:13.743533549+07:00 level=error msg=“Exec failed” error=“Error 1062 (23000): Duplicate entry ‘1’ for key ‘alert_rule_version.UQE_alert_rule_version_rule_guid_version’” sql=“CREATE UNIQUE INDEX UQE_alert_rule_version_rule_guid_version ON alert_rule_version (rule_guid,version);”
grafana | logger=migrator t=2025-11-09T01:44:14.163103738+07:00 level=info msg=“Unlocking database”
grafana | Error: ✗ migration failed (id = add index in alert_rule_version table on rule_guid and version columns): Error 1062 (23000): Duplicate entry ‘1’ for key ‘alert_rule_version.UQE_alert_rule_version_rule_guid_version’
I hope everyone can help me. Thanks very much.
Enviroment:
Grafana v11.5.7
MySql: v8.0