upgrade: Allow single failed or pending migration log

Created by: efritz

This PR prevents an interrupted upgrade from blocking future attempts. Effort towards #40741 (closed).

Test plan

This is a pre-requisite to work that has been tested locally. Unit tests have also been updated.