Pain point · Self-hosting & upgrades · Causes churn
occ upgrade fails on a not-null column default check
2 source threads · first seen 2020-10 · last seen 2023-11
Summary
The upgrade aborts with an exception about a NotNull column having an empty default, forcing the user to patch a core script.
- Affects
- admins on PostgreSQL
- Workaround
- Patched the migration script by reverting a commit.
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“DB error when running migration [...] collides with the constraint [...]”
“Column name oc_flow_operations.entity is NotNull, but has empty string or null as default”