Migrations stuck projections.users14 when upgrading to 2.70.*
Hi, I have recently attempted to upgrade from v2.61.0 to either v2.70.14 or v2.71.13 to get the fix for "permission checks on session API (17f033f)". Unfortunately, I am having some troubles:
- level=info msg="projection is prefilling" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/handler.go:83" projection=projections.users14
and then
- level=warning msg="migration already started, will check again in 5 seconds" caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:130" migration step=projections.users14
I have tried restarting the docker container and executing the command zitadel setup cleanup, but this didn't fix it. Going to version v2.68.0 seems to work.
Selfhosted Zitadel with docker compose with an external PostgreSQL database here. I've read the technical advisories, but couldn't find something that relates to this.
Could I get some help with this?
5 Replies
hey @arobs thanks for your question, I will take a look at it
Thanks @Rajat !
hey @arobs you didnt do anything wrong on yur setup and pointed out a known common issue that has occured with the users before, for now, maybe try looking https://github.com/zitadel/zitadel/discussions/9525 and https://github.com/zitadel/zitadel/discussions/6856
you can also check your migrations table in eventstore and see if any migration is in progress, do you have enough CPU/memory on your machine btw?.
Hey @Rajat ! I have parked it for a while and now rememberd that I might got a reaction from you, so here I am.
I have 8 CPU cores and 32GB RAM for the database, so this should be enough.
Regarding the posts, zitadel setup cleanup didn't work for me before.
Can you tell me which migration table to check in eventstore? I am not seeing any migration table in the database and in the eventstore schema I see only three tables: events2, fields and unique_constraints.
Sorry for the bump but I encountered this issue recently as well but for a different table:
https://discord.com/channels/927474939156643850/1408442015452233862/1409225649532440727
maybe this helps