Not able to delete ci-pipeline

[pawan-59]

If you are trying to resolve an environment-specific issue or have a one-off question about the edge case that does not require a feature then please consider asking a question in Devtron Discord channel.

Checklist:

• I've searched in the docs and FAQ for my answer
• I've included steps to reproduce the bug.

Describe the bug

Not able to delete ci-pipeline for one of the applications on devtron which do not have any cd-pipeline linked, however getting cd-pipeline exist error on deleting.

Expected behavior

It should get deleted.

Screenshots

Logs

orchestrator-cd-devtroncd-64754855d9-29fp5: {"level":"info","ts":1656666898.2420037,"caller":"app/BuildPipelineRestHandler.go:156","msg":"request payload, PatchCiPipelines","PatchCiPipelines":{"ciPipeline":{"isManual":true,"dockerArgs":{},"isExternal":false,"parentCiPipeline":0,"parentAppId":0,"externalCiConfig":{"id":0,"webhookUrl":"","payload":"","accessKey":""},"ciMaterial":[{"source":{"type":"SOURCE_TYPE_BRANCH_FIXED","value":"master"},"gitMaterialId":223,"id":364,"gitMaterialName":""}],"name":"ci-lens","id":354,"active":true,"linkedCount":0,"scanEnabled":false,"appWorkflowId":373,"preBuildStage":{"id":0,"steps":null},"postBuildStage":{"id":0,"steps":null}},"appId":819,"action":2,"appWorkflowId":373}}
orchestrator-cd-devtroncd-64754855d9-29fp5: {"level":"error","ts":1656666898.2570112,"caller":"app/BuildPipelineRestHandler.go:197","msg":"service err, PatchCiPipelines","err":"cd pipeline exists for this CI","PatchCiPipelines":{"ciPipeline":{"isManual":true,"dockerArgs":{},"isExternal":false,"parentCiPipeline":0,"parentAppId":0,"externalCiConfig":{"id":0,"webhookUrl":"","payload":"","accessKey":""},"ciMaterial":[{"source":{"type":"SOURCE_TYPE_BRANCH_FIXED","value":"master"},"gitMaterialId":223,"id":364,"gitMaterialName":""}],"name":"ci-lens","id":354,"active":true,"linkedCount":0,"scanEnabled":false,"appWorkflowId":373,"preBuildStage":{"id":0,"steps":null},"postBuildStage":{"id":0,"steps":null}},"appId":819,"action":2,"appWorkflowId":373},"stacktrace":"github.com/devtron-labs/devtron/api/restHandler/app.PipelineConfigRestHandlerImpl.PatchCiPipelines\n\t/go/src/github.com/devtron-labs/devtron/api/restHandler/app/BuildPipelineRestHandler.go:197\nnet/http.HandlerFunc.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:2049\ngithub.com/devtron-labs/devtron/internal/middleware.PrometheusMiddleware.func1\n\t/go/src/github.com/devtron-labs/devtron/internal/middleware/instrument.go:72\nnet/http.HandlerFunc.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:2049\ngithub.com/gorilla/mux.(*Router).ServeHTTP\n\t/go/src/github.com/devtron-labs/devtron/vendor/github.com/gorilla/mux/mux.go:210\ngithub.com/devtron-labs/authenticator/middleware.Authorizer.func1.1\n\t/go/src/github.com/devtron-labs/devtron/vendor/github.com/devtron-labs/authenticator/middleware/AuthMiddleware.go:62\nnet/http.HandlerFunc.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:2049\nnet/http.serverHandler.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:2867\nnet/http.(*conn).serve\n\t/usr/local/go/src/net/http/server.go:1932"}
orchestrator-cd-devtroncd-64754855d9-29fp5: {"level":"info","ts":1656666898.2571259,"caller":"common/apiError.go:113","msg":"ERROR RES","TYPE":"API-ERROR","RES":500,"ERROR-MSG":[{"internalMessage":"cd pipeline exists for this CI","userMessage":"cd pipeline exists for this CI","userDetailMessage":"cd pipeline exists for this CI"}],"err":null}
orchestrator-cd-devtroncd-64754855d9-29fp5: /service-worker.js

[kartik-579]

query for checking parent is wrong - AppWorkflowRepository:223