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:
Unfortunately, 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?
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_v4
Unfortunately, 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?
