narrowizard opened a new issue, #5687: URL: https://github.com/apache/incubator-devlake/issues/5687
### 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 After upgrading from DevLake v0.17 to v0.18, an error occurred. The error message was: "ALTER TABLE "_tool_azuredevops_gitpullrequests" ALTER COLUMN "connection_id" DROP NOT NULL panic: ERROR: column "connection_id" is in a primary key (SQLSTATE 42P16)". ### What do you expect to happen The upgrade should have been completed successfully without any errors. The "connection_id" column should have been altered without causing a panic error. ### How to reproduce Start with a DevLake v0.17 instance using Postgres as the database. Upgrade the instance to DevLake v0.18. Observe the error message. ### Anything else  ### Version release-v0.18 ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
