Initiating a Deploy or Destroy a stream fails. Dataflow dashboard or logs shows the error:
OUT org.springframework.cloud.skipper.SkipperException: Statemachine is not in state ready to do DELETE
Tanzu Application Services
Spring Cloud Dataflow Tanzu
The following steps cleans up the state of the stream. Note that you will need admin role.
1. Connect to the backend skipper database
2. From the mysql CLI - select the stream(s) that failed to install or delete
mysql> select machine_id, state from state_machine where machine_id in (<'STREAM_NAME_1'>, <'STREAM_NAME_2'>);
3. Confirm the list of stream to delete. Then proceed with the deletion.
Delete the state_machine records then commit deletion
mysql> delete from state_machine where machine_id in (<'STREAM_NAME_1'>, <'STREAM_NAME_2'>);
mysql> commit;
4. Using cf CLI, target the backend org/space. Then restage skipper application. Note: Backend application are located in the p-dataflow org.
$ cf restage skipper
5. Wait for the skipper application to start successfully. Then test by deploying or destroying the stream. If the problem persists, please open a Broadcom Support request.