Reassigning Case Role Gives DB Constraint on Membership
Based on chat discussion there was a missing database field for unknown reasons. Running this helped:

ALTER TABLE civicrm_membership ADD COLUMN status_override_end_date date DEFAULT NULL COMMENT 'Then end date of membership status override if ''Override until selected date'' override type is selected.';