Upgrading server from 5.39 to 6.0.2 fails

Hey @elpatron68 - as you can see from the error message, it says “default for column cannot be cast automatically”.

If we look at your schema, we can see that the default value is '{}'::character varying. Therefore, it is failing to change the column type to json.

The fix is to run alter table channelmembers alter column notifyprops drop default; and then run the migration again.

I am not sure how your db got into that state, as we don’t set the default by our side.

1 Like