robgutsopedra opened a new issue, #6179: URL: https://github.com/apache/incubator-devlake/issues/6179
### 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 upgraded from 0.16-RC9 to 0.18 and I’m getting some… Weird scenarios. First: I added the encryption secret at: ``` lake: image: ... encryptionSecret: secret: {obtained from the previous pod as per the error message/docs} ``` Then: ``` time="2023-10-02 15:43:43" level=info msg="/app/impls/dalgorm/dalgorm.go:230 Error 1054 (42S22): Unknown column 'id' in 'where clause' [0.491ms] [rows:0] UPDATE `_tool_jira_boards` SET `connection_id`=1 WHERE id = 1" time="2023-10-02 15:43:43" level=error msg="HTTP 500 error caused by: error executing migration (500) Wraps: (2) Error 1054 (42S22): Unknown column 'id' in 'where clause' (500) Wraps: (3) Error 1054 (42S22): Unknown column 'id' in 'where clause' Error types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *mysql.MySQLError" Which I “solved” by adding ID field *manually* to _tool_jira_boards Then I got some “info” logs which seemed problematic, but are at info level. time="2023-10-02 15:51:10" level=info msg="/app/impls/dalgorm/dalgorm.go:174 invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret; invalid encryptionSecret ``` Now I have devLake, supposedly, up and running, but after creating the token (And successfully testing the notification) I’m stuck at GitHub connection - no repositories appear, no organizations/owners, nothing. I’m using the same token (refreshed, but same) I was using before.  I’m slightly surprised it is able to connect to the DB (hosted in gcloud), but it’s not able to retrieve any data from it! That’s partially okay, I can re-do that work, but I’m wondering what’s wrong now with the installation. This is the only thing I see in the pod logs, but maybe I can look somewhere else: ``` GIN] 2023/10/02 - 16:02:28 | 200 | 1.13µs | 10.21.19.218 | GET "/ping" time="2023-10-02 16:02:29" level=error msg="HTTP 500 error caused by: Key: 'GithubConn.MultiAuth.AuthMethod' Error:Field validation for 'AuthMethod' failed on the 'required' tag Wraps: (2) Key: 'GithubConn.MultiAuth.AuthMethod' Error:Field validation for 'AuthMethod' failed on the 'required' tag Error types: (1) *hintdetail.withDetail (2) validator.ValidationErrors" [GIN] 2023/10/02 - 16:02:29 | 500 | 245.23µs | 10.21.19.245 | POST "/plugins/github/test" time="2023-10-02 16:02:33" level=error msg="HTTP 404 error caused by: record not found (404) Wraps: (2) record not found Error types: (1) *hintdetail.withDetail (2) *errors.errorString" [GIN] 2023/10/02 - 16:02:33 | 404 | 3.50676ms | 10.21.19.245 | GET "/plugins/github/connections/1/remote-scopes" [GIN] 2023/10/02 - 16:02:38 | 200 | 1.14µs | 10.21.19.218 | GET "/ping" [GIN] 2023/10/02 - 16:02:48 | 200 | 1.09µs | 10.21.19.218 | GET "/ping" [GIN] 2023/10/02 - 16:02:55 | 404 | 2.57µs | 172.16.70.14 | GET "/" [GIN] 2023/10/02 - 16:02:58 | 200 | 1.12µs | 10.21.19.218 | GET "/ping" [GIN] 2023/10/02 - 16:03:08 | 200 | 1.4µs | 10.21.19.218 | GET "/ping" [GIN] 2023/10/02 - 16:03:18 | 200 | 1.21µs | 10.21.19.218 | GET "/ping" [GIN] 2023/10/02 - 16:03:25 | 404 | 2.74µs | 172.16.70.14 | GET "/" ``` Any ideas or suggestions are greatly appreciated! ### What do you expect to happen Upgraded version should work! ### How to reproduce Upgrade from 0.16-RC9 to v0.18 * With PVs * With gcloud sql DB (Try to have some contents on the DB) ### Anything else _No response_ ### Version v0.18.0 ### 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]
