[Bug]: Delete pipeline run method can be waiting to delete a non-deletable state

[tanyakoganoracle]

Oracle-ads version used

• I have checked that this issue has not already been reported.

• I have confirmed this bug exists on the latest version of oracle-ads.

• I have confirmed this bug exists on the main branch of oracle-ads.

• I agree to follow Code of Conduct.

Description

If a CancelPipelineRun ends within a few seconds of the DeletePipelineRun beginning, it will be waiting to delete a pipeline where the state will not go to LIFECYCLE_STATE_DELETED.

How to Reproduce

If you run cancel and then delete in the row in the different processes/threads, i.e. change the state of the Pipeline run during issuing of delete command.
Also 
CancelPipelineRun.end occurs less than 3 seconds before DeletePipelineRun.begin starts, it will cause a lock. 
Result:
CreatePipelineRun.end will fail
DeletePipelineRun.end will fail

For more details, speak with my team

What was Observed

SDd

What was Expected

sdgds

Version

Paste here the output of ads.__version__