I have just updated from 2023.10.5 to 2023.10.6 but when running the upgraded docker compose containers, both server and worker crash due to a migration failing:
postgresql_1 | 2024-01-09 19:13:18.416 UTC [33] ERROR: relation "otp_static_staticdevice_user_id_7f9cff2b" already exists
postgresql_1 | 2024-01-09 19:13:18.416 UTC [33] STATEMENT: CREATE INDEX "otp_static_staticdevice_user_id_7f9cff2b" ON "otp_static_staticdevice" ("user_id")
Reverting the version back to 2023.10.5 resolves this issue and authentik is running again. However I am unable to upgrade. I don't know what changed during the upgrade, is this an issue on my end and if yes do you have any tips on how to reslve this?