karthikbhat0307 opened a new issue, #7615: URL: https://github.com/apache/incubator-devlake/issues/7615
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened I'm getting this error while deleting the connection for the pagerduty. ``` time="2024-06-13 07:50:10" level=info msg="try locking tables with timeout 2s"time="2024-06-13 07:50:10" level=info msg="\x1b[31;1m/app/impls/dalgorm/dalgorm.go:277 \x1b[35;1mError 1054 (42S22): Unknown column 'connection_id' in 'where clause'\n\x1b[0m\x1b[33m[0.524ms] \x1b[34;1m[rows:0]\x1b[0m DELETE FROM `_tool_pagerduty_scope_configs` WHERE connection_id = 2"time="2024-06-13 07:50:10" level=error msg="Error 1054 (42S22): Unknown column 'connection_id' in 'where clause' (500)\n\tWraps: (2) Error 1054 (42S22): Unknown column 'connection_id' in 'where clause'\n\tError types: (1) *hintdetail.withDetail (2) *mysql.MySQLError" ``` The main highlighted error is this. ``` DELETE FROM `_tool_pagerduty_scope_configs` WHERE connection_id = 2" ``` ### What do you expect to happen I want to successfully delete the connection for pagerduty if not needed anymore ### How to reproduce Create a pagerduty connection Add scopes Attach it to any project Remove the connection from project Try to delete the connection post deleting the scopes ### Anything else _No response_ ### Version v1.0.0-beta10@18009e2 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
