ERROR: relation "idx_xxx" already exists (SQLSTATE 42P07)

[microyahoo]

GORM Playground Link

go-gorm/playground#1

Description

2022/12/28 02:48:33 /root/go/src/deeproute.ai/smd/vendor/gorm.io/driver/postgres/migrator.go:271 ERROR: relation "idx_cephfs_subvolumes_subvolume_name" already exists (SQLSTATE 42P07)
[0.650ms] [rows:0] ALTER TABLE "cephfs_subvolumes" ADD CONSTRAINT "idx_cephfs_subvolumes_subvolume_name" UNIQUE("subvolume_name")
I1228 02:48:33.476777       1 log.go:198] ERROR: relation "idx_cephfs_subvolumes_subvolume_name" already exists (SQLSTATE 42P07)

[microyahoo]

The probability of this problem occurring at pod startup is very high. It'd better to check whether the constraint has existed or not before create it.

[microyahoo]

The fix has been merged #145. Please help to create a new tag, thanks. @jinzhu