i have mirrored the crdb to psql, but getting some issue after migration, t
postres logs:
postgres | 2025-08-05 15:18:18.757 UTC [204] ERROR: duplicate key value violates unique constraint "idp_login_policy_links5_pkey"
postgres | 2025-08-05 15:18:18.757 UTC [204] DETAIL: Key (instance_id, aggregate_id, idp_id)=(332018629145001986, 332018629145001986, 332019326171217922) already exists.
postgres | 2025-08-05 15:18:18.757 UTC [204] STATEMENT: INSERT INTO projections.idp_login_policy_links5 (idp_id, aggregate_id, creation_date, change_date, sequence, resource_owner, instance_id, provider_type) VALUES ($1, $2, $3, $4, $5, $6, $7, $8)
postgres | 2025-08-05 15:18:18.765 UTC [204] ERROR: duplicate key value violates unique constraint "idp_login_policy_links5_pkey"
postgres | 2025-08-05 15:18:18.765 UTC [204] DETAIL: Key (instance_id, aggregate_id, idp_id)=(332018629145001986, 332018629145001986, 332019326171217922) already exists.
postgres | 2025-08-05 15:18:18.765 UTC [204] STATEMENT: INSERT INTO projections.idp_login_policy_links5 (idp_id, aggregate_id, creation_date, change_date, sequence, resource_owner, instance_id, provider_type) VALUES ($1, $2, $3, $4, $5, $6, $7, $8)
postgres | 2025-08-05 15:18:18.769 UTC [204] ERROR: duplicate key value violates unique constraint "idp_login_policy_links5_pkey"
postgres | 2025-08-05 15:18:18.769 UTC [204] DETAIL: Key (instance_id, aggregate_id, idp_id)=(332018629145001986, 332018629145001986, 332019326171217922) already exists.
and when i login with admin user its not working, i mean its asking for User and pass but after login the UI stuck in loop,
while the logs arre saying follows
3 Replies
My setup is done with docker compose,
and using postgres:17-alpine and zitadel v2.67.2
@Rajat Singh and @adlerhurst can you please check what can be done
Hi @fireblazerš„
Just to verify you used zitadel v2.67.2 for the mirror command?
would it be possible to test mirroring with the latest v2 release? (https://github.com/zitadel/zitadel/releases/tag/v2.71.14)
GitHub
Release v2.71.14 Ā· zitadel/zitadel
2.71.14 (2025-08-05)
Bug Fixes
enable OpenTelemetry metrics for river queue and improve session projection handling (#10391) (5d1185b)