CCM not able to remove a LB in ERROR state

If the Openstack Loadbalancer is moved to error status, CCM is not able to remove it:

E1117 11:25:09.920626       1 controller.go:320] error processing service e2e-test-openstack-crkht/udp-lb-etplocal-svc (will retry): failed to delete load balancer: load balancer 9f555a63-a166-4f80-82fa-f38cf2b96db2 is not ACTIVE, current provisioning status: ERROR

4.12.0-0.nightly-2022-11-07-181244
RHOS-16.2-RHEL-8-20220804.n.1

Always

1. Apply  [^default-manifests.yaml] 
2. Modify on the OSP database the LB status to ERROR:

$ ssh heat-admin@192.168.24.40
$ sudo podman exec -it galera-bundle-podman-0 mysql
MariaDB [(none)]> use octavia;
MariaDB [octavia]> update load_balancer set provisioning_status='ERROR' where id='9f555a63-a166-4f80-82fa-f38cf2b96db2';

3. Destroy the project:

$ oc delete project e2e-test-openstack-crkht
project.project.openshift.io "e2e-test-openstack-crkht" deleted

The project deletion is stuck and the logs are reported on openshift-cloud-controller-manager pod

The LB is removed