tfmm•6mo ago

Upgrade from 2.70.x to 2.71.x fails with migration errors

When upgrading from 2.70.7 to 2.71.5 running in docker from the official GHCR image, I get this error, and the container fails:

time="2025-03-28T17:41:50Z" level=info msg="starting migration" caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=52_idp_templates6_ldap2
time="2025-03-28T17:41:50Z" level=error msg="migration failed" caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:68" error="ERROR: relation \"idp_templates6_ldap2\" already exists (SQLSTATE 42P07)" name=52_idp_templates6_ldap2
time="2025-03-28T17:41:50Z" level=fatal msg="migration failed" caller="/home/runner/work/zitadel/zitadel/cmd/setup/setup.go:304" code=42P07 detail= error="ERROR: relation \"idp_templates6_ldap2\" already exists (SQLSTATE 42P07)" hint= message="relation \"idp_templates6_ldap2\" already exists" name=52_idp_templates6_ldap2 severity=ERROR

time="2025-03-28T17:41:50Z" level=info msg="starting migration" caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=52_idp_templates6_ldap2
time="2025-03-28T17:41:50Z" level=error msg="migration failed" caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:68" error="ERROR: relation \"idp_templates6_ldap2\" already exists (SQLSTATE 42P07)" name=52_idp_templates6_ldap2
time="2025-03-28T17:41:50Z" level=fatal msg="migration failed" caller="/home/runner/work/zitadel/zitadel/cmd/setup/setup.go:304" code=42P07 detail= error="ERROR: relation \"idp_templates6_ldap2\" already exists (SQLSTATE 42P07)" hint= message="relation \"idp_templates6_ldap2\" already exists" name=52_idp_templates6_ldap2 severity=ERROR

6 Replies

tfmmOP•6mo ago

looks potentially related to https://github.com/zitadel/zitadel/pull/9292 but i'm not certain

GitHub

feat(ldap): adding root ca option to ldap config by kkrime · Pull ...

Which Problems Are Solved Adding ability to add a root CA to LDAP configs Additional Context Closes [Bug]: Identity Provider - LDAP cannot use LDAPS when certificate signed by unknown authority #7888

Unknown User•6mo ago

Message Not Public

tfmmOP•6mo ago

Thanks @stebenz !

Unknown User•6mo ago

Message Not Public

tfmmOP•6mo ago

Yep, just tested, works great for me.

Unknown User•6mo ago

Message Not Public

Upgrade from 2.70.x to 2.71.x fails with migration errors

Did you find this page helpful?