Can not delete nova compute service if there are stale migrations

Issue

(overcloud) [stack@director ~]$ nova service-delete 4d9bf1e4-97c1-4e38-a78a-25072e2974ca
ERROR (Conflict): Unable to delete compute service that has in-progress migrations. Complete the migrations or delete the instances first. (HTTP 409) (Request-ID: req-b234bcdd-6340-4ee1-8a8d-ff2ae90489e8)
(overcloud) [stack@director ~]$

(undercloud) [stack@director ~]$  openstack overcloud node delete --stack overcloud xxxxxxxxxxxx004-xxxxxxxxxxx
Are you sure you want to delete these overcloud nodes [y/N]? y
Deleting the following nodes from stack overcloud:
- xxxxxxxxxxxx004-xxxxxxxxxxx
.............
2023-09-15 15:12:28.634816 | 52540003-9240-d691-61e3-0000000000a1 |       TASK | Delete nova-compute service
2023-09-15 15:12:30.797473 | 52540003-9240-d691-61e3-0000000000a1 |      FATAL | Delete nova-compute service | xxxxxxxxxxxx004-xxxxxxxxxxx -> localhost | error={"changed": true, "cmd": ["openstack", "compute", "service", "delete", "159"], "delta": "0:00:01.963864", "end": "2023-09-15 15:12:30.773808", "msg": "non-zero return code", "rc": 1, "start": "2023-09-15 15:12:28.809944", "stderr": "Failed to delete compute service with ID '159': Unable to delete compute service that has in-progress migrations. Complete the migrations or delete the instances first. (HTTP 409) (Request-ID: req-b234bcdd-6340-4ee1-8a8d-ff2ae90489e8)\n1 of 1 compute services failed to delete.", "stderr_lines": ["Failed to delete compute service with ID '159': Unable to delete compute service that has in-progress migrations. Complete the migrations or delete the instances first. (HTTP 409) (Request-ID: req-b234bcdd-6340-4ee1-8a8d-ff2ae90489e8)", "1 of 1 compute services failed to delete."], "stdout": "", "stdout_lines": []}
[WARNING]: ('xxxxxxxxxxxx004-xxxxxxxxxxx -> localhost',
'52540003-9240-d691-61e3-0000000000a1') missing from stats

PLAY RECAP *********************************************************************
xxxxxxxxxxxx004-xxxxxxxxxxx : ok=13   changed=3    unreachable=0    failed=1    skipped=1    rescued=0    ignored=0
................