Problem with upgrade from 2.66.1 to 2.67.6
Selfhosted Zitadel user with docker compose with an external PostgreSQL database here.
I just tried upgrading in two steps from 2.66.1 to 2.66.9 and from there to 2.67.6.
Only in the second step I realized that there was an error in the migration, so I am not sure whether it occured already when I upgraded to 2.66.9.
The error occured in a migration step mentioning "40_init_push_func_v4" which kept being repeated.
I tried to go back to 2.66.9 and to 2.66.1, but the migration scripts know, they already did something.
Returning to 2.67.6 again gives me:
msg="migration failed" caller="/home/runner/work/zitadel/zitadel/cmd/setup/setup.go:269" error="ERROR: structure of query does not match function result type (SQLSTATE 42804)" name=40_init_push_func_v4Unfortunately, in addition I just realized this night's backup of the database is not usable. Somebody with any useful hints, how to go on about this?
2 Replies
I just found that this is a known bug, that is being investigated:
https://github.com/zitadel/zitadel/issues/9180
GitHub
[Bug]: 40_init_push_func_v2 migration hangs with PostgreSQL · Issue...
Preflight Checklist I could not find a solution in the documentation, the existing issues or discussions I have joined the ZITADEL chat Environment Self-hosted Version 2.67.2 Database PostgreSQL Da...
Is there a way to cancel this database update and return to the previous state?
I managed to return to 2.66.1 using the methods described in the issue.