Error for migrations

### Improvement

Set the status to error if a migration is failing after x time. Should be configured by crd

### Reason

We want to fail if a migration is broken

### Information

_No response_

### Definition of Done

- Have a status error for a migration failing