This topic provides basic instructions for app developers troubleshooting On-Demand MySQL for PCF.
MySQL for PCF service instances can become temporarily inaccessible during upgrades and VM or network failures. See Service Interruptions for more information.
You may see an error when using the Cloud Foundry Command-Line Interface (cf CLI) to perform basic operations on a MySQL for PCF service instance:
Failed operations (create, update, bind, unbind, delete) result in an error message. You can retrieve the error message later by running the cf CLI command
cf service INSTANCE-NAME.
$ cf service myservice Service instance: myservice Service: super-db Bound apps: Tags: Plan: dedicated-vm Description: Dedicated Instance Documentation url: Dashboard: Last Operation Status: create failed Message: Instance provisioning failed: There was a problem completing your request. Please contact your operations team providing the following information: service: redis-acceptance, service-instance-guid: ae9e232c-0bd5-4684-af27-1b08b0c70089, broker-request-id: 63da3a35-24aa-4183-aec6-db8294506bac, task-id: 442, operation: create Started: 2017-03-13T10:16:55Z Updated: 2017-03-13T10:17:58Z
Use the information in the
Message field to debug further. Provide this information to Pivotal Support when filing a ticket.
task-id field maps to the BOSH task id. For further information on a failed BOSH task, use the
bosh task TASK-ID command in v1 of the BOSH CLI. For v2, use
bosh2 task TASK-ID.
broker-request-guid maps to the portion of the On-Demand Broker log containing the failed step. Access the broker log through your syslog aggregator, or access BOSH logs for the broker by typing
bosh logs broker 0. If you have more than one broker instance, repeat this process for each instance.
Log into the space containing the instance or failed instance.
$ cf login
If you do not know the name of the service instance, run
cf servicesto see a listing of all service instances in the space. The service instances are listed in the
$ cf services Getting services in org my-org / space my-space as firstname.lastname@example.org... OK name service plan bound apps last operation my-instance p.mysql db-small create succeeded
cf service SERVICE-INSTANCE-NAMEto retrieve more information about a specific instance.
cf service SERVICE-INSTANCE-NAME --guidto retrieve the GUID of the instance, which is useful for debugging.
This is an additional troubleshooting option for BOSH CLI v1 only. It does not apply to the BOSH CLI v2.
Retrieve the GUID of your service instance with the command
cf service YOUR-SERVICE-INSTANCE --guid.
To download your BOSH manifest for the service, run
bosh download manifest service-instance_SERVICE-INSTANCE-GUID myservice.ymlusing the GUID you just obtained and a file name you want to use when saving the manifest.
bosh deployment MY-SERVICE.ymlto select the deployment.
Find the answer to your question and browse product discussions and solutions by searching the Pivotal Knowledge Base.
You can file a support ticket here. Be sure to provide the error message from
cf service YOUR-SERVICE-INSTANCE.
To help expedite troubleshooting, if possible also provide your service broker logs, service instance logs, and BOSH task output. Your cloud operator should be able to obtain these from your error message.