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
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
