unbinding SCS service fails due to incorrect state in CCDB

Products

• VMware Tanzu Application Service for VMs

Issue/Introduction

When attempting to unbind a service, we are getting the following error:

user@W10BZV84B3:~$ cf8 unbind-service notifications-orchestrator-service-dit2-green1 notifications-spring-cloud-config-server

Unbinding app notifications-orchestrator-service-dit2-green1 from service notifications-spring-cloud-config-server in org SvcITCustmrCommOrg / space DIT2 as admuser...

There is an operation in progress for the service binding. FAILED

user@W10BZV84B3:~$ cf8 delete notifications-orchestrator-service-dit2-green1 -f -r

Deleting app notifications-orchestrator-service-dit2-green1 in org SvcITCustmrCommOrg / space DIT2 as admuser...

Job (3d58c0fb-a466-497d-8a98-62e7960993f0) failed: The delete request was rejected due to an operation being in progress for the service binding. FAILED

user@W10BZV84B3:~$ cf8 service notifications-spring-cloud-config-server

Showing info of service notifications-spring-cloud-config-server in org SvcITCustmrCommOrg / space DIT2 as admuser...

name: notifications-spring-cloud-config-server guid: 1d25a3ca-15f9-4a37-ab6f-11bdba2ce8ae type: managed broker: scs-service-broker offering: p.config-server plan: standard tags: offering tags: configuration, spring-cloud description: Service to provide configuration to applications at runtime. documentation: dashboard url: https://config-server-1d25a3ca-15f9-4a37-ab6f-11bdba2ce8ae.host.pcf.redactedfqdn.com/dashboard

Showing status of last operation: status: update failed message: Pool#acquire(Duration) has been pending for more than the configured timeout of 45000ms

started: 2022-02-19T16:29:33Z updated: 2022-02-19T16:35:08Z

Showing bound apps: name binding name status message

notif-auth-server-dit2 create succeeded notif-communication-sender-dit2 create succeeded notifications-integrator-dit2 create succeeded notif-health-monitor-dit2 create succeeded notifications-emc-contact-dit2 create succeeded sdp-partner-manager-service-dit2 create succeeded notif-knowledgebase-server-dit2 create succeeded notif-sms-integration-dit2 create succeeded notifications-event-gateway-dit2 create succeeded notifications-rule-engine-dit2 create succeeded s360-paging-custom-activities-dit2 create succeeded notif-supplier-feedback-dit2 create succeeded notif-mktcloud-service-dit2 create succeeded notifications-event-callback-dit2 create succeeded notif-subscription-manager-dit2 create succeeded notif-resource-server-dit2 create succeeded marketing-cloud-adapter-dit2 create succeeded roster-shift-manager-dit2 create succeeded notifications-ols-service-dit2 create succeeded notif-mq-forwarder-dit2 create succeeded notifications-orchestrator-service-dit2-green1 create initial sms-reply-code-service-dit2 create succeeded notification-rules-engine-dit2 create succeeded notifications-orchestrator-service-dit2 create succeeded

Showing sharing info: This service instance is not currently being shared. Showing upgrade status: Upgrades are not supported by this broker. 

 

Environment

Product Version: 3.0

Resolution

In order to successfully unbind the service, we changed the state of the binding operation to "failed" in the CCDB

UPDATE service_binding_operations SET state='failed' WHERE service_binding_id=2704306;

 

This enabled customer to complete the cf unbind-service operation, and allowed his customer to delete the application which had been bound to that service.