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

10

Hi @Luiggi ,
Tried this as well but same issue.
Can we first use the latest version of metabase with new database and then we can migrate our existing database data to this newly version of metabase would that be possible or any challenges in that??
Please confirm also any documentation for the same if you can share that would be great.
Thanks

11

You can try, but I think it’s going to hit some bumps as the entities you migrate won’t be compliant to the new schema