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

1

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']??

2

Anyone have faced have similar issues??

3

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?

4

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

5

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

6

Hi @Luiggi ,

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

7

Which columns did you rename? To which name?

8

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

9

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