Getting Errors while upgrading metabase version from 0.44.5 to 0.46.6 via docker image on Azure app services

When try to change the image under deployment center of azure app service of metabase to latest version(v0.46.6) got this error in the logs:-
Caused by: liquibase.exception.DatabaseException: ERROR: column "size_x" of relation "report_dashboardcard" does not exist [Failed SQL: (0) ALTER TABLE "public"."report_dashboardcard" ALTER COLUMN "size_x" SET DEFAULT '4']
liquibase.exception.DatabaseException: ERROR: column "size_x" of relation "report_dashboardcard" does not exist [Failed SQL: (0) ALTER TABLE "public"."report_dashboardcard" ALTER COLUMN "size_x" SET DEFAULT '4']??

Anyone have faced have similar issues??

Have you tried first upgrading to 45? I guess this is an issue that happened because you downgraded before restoring a DB backup at some point, is that the case?

Hi @Luiggi ,
Yes, we tried upgrading it to 0.45 version as well but got same errors.
No, downgrade happened to you other query.

Thanks

So clearly some migration didn’t happen. Please go to the table report_dashboardcard and rename the columns manually to what they should be, then upgrade

Hi @Luiggi ,

Thank you for your response. Already tried renaming of columns still migration fails.
Please advise.
Thanks

Which columns did you rename? To which name?

Hi @Luiggi
Tried renaming size_x to size_X as shown below:-
image

there's no underscore there, it's just sizeX and sizeY