Migration task 'add-orgs' failes with error: pq: could not create unique index "UQE_secrets_s"

[lafriks]

Component

server

Describe the bug

Migration introduced in #1873 fails with error:

2023-08-02T12:43:03Z fatal could not migrate datastore | error=run tasks failed: migration task 'add-orgs' failed: sync old secrets models failed: pq: could not create unique index "UQE_secrets_s"

System Info

{"source":"https://github.com/woodpecker-ci/woodpecker","version":"next-aec20510"}

Additional context

2023-08-02T12:43:03Z LogLevel = info 
2023-08-02T12:43:03Z ERR migration task 'migrate-logs-to-log_entries' failed but is not required | error=Migrating logs to log_entries is skipped, as we have 108866 entries to convert. Set 'WOODPECKER_MIGRATIONS_ALLOW_LONG' to 'true' to migrate anyway
2023-08-02T12:43:03Z fatal could not migrate datastore | error=run tasks failed: migration task 'add-orgs' failed: sync old secrets models failed: pq: could not create unique index "UQE_secrets_s"

Validations

• Read the Contributing Guidelines.
• Read the docs.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Checked that the bug isn't fixed in the next version already [https://woodpecker-ci.org/faq#which-version-of-woodpecker-should-i-use]
• Check that this is a concrete bug. For Q&A join our Discord Chat Server or the Matrix room.

[6543]

can you test if it was #2104 (backport: #2106)

@lafriks ?

[lafriks]

can you test if it was #2104 (backport: #2106)

@lafriks ?

No, I use Gitea as forge