michaelawarren opened a new issue, #6958: URL: https://github.com/apache/incubator-devlake/issues/6958
### 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 trying to run Dev lake in an azure kubernetes cluster using azure flexible server mysql (my sql version 8.0) I'm using helm 0.19.0 (also tried 0.21.0-beta3). When i start up it prompts me to do a db migration. when i do that i get the following error. Error is specific to 0.19.0. I get a different but similar error on 0.21.0-beta3). I'm starting with a fresh install. ``` time="2024-02-13 23:22:50" level=info msg="\x1b[31;1m/app/impls/dalgorm/dalgorm.go:138 \x1b[35;1mError 1054 (42S22): Unknown column 'custom_field6' in '_tool_tapd_stories'\n\x1b[0m\x1b[33m[1.730ms] \x1b[34;1m[rows:0]\x1b[0m ALTER TABLE `_tool_tapd_stories` RENAME COLUMN `custom_field6` TO `custom_field_six`" time="2024-02-13 23:22:50" level=error msg="HTTP 500 error\n\tcaused by: error executing migration (500)\n\tWraps: (2) Error 1054 (42S22): Unknown column 'custom_field6' in '_tool_tapd_stories' (500)\n\tWraps: (3) Error 1054 (42S22): Unknown column 'custom_field6' in '_tool_tapd_stories'\n\tError types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *mysql.MySQLError" ``` slack link to where question was asked and bug report asked for https://devlake-io.slack.com/archives/C03APJ20VM4/p1707867572707049 ### What do you expect to happen For the service to start up and work properly. ### How to reproduce created an azure mysql flexible server via azure (must start with at least 2 cpus) disable require_secure_transport and sql_generate_invisible_primary_key deploy dev lake via helm to kube cluster ``` - name: Deploy with Helm id: helm-deploy run: | helm upgrade --install -f ${{ github.workspace }}/charts/devlake/values.yaml -n ${{ env.KUBE_NAMESPACE }} ${{ env.APPNAME }} ${{ github.workspace }}/charts/devlake \ --set mysql.useExternal=true \ --set mysql.externalServer=server-name.mysql.database.azure.com \ --set mysql.externalPort=3306 \ --set mysql.username=${{ secrets.MYSQL_SERVER_USERNAME }} \ --set mysql.password=${{ secrets.MYSQL_SERVER_PASSWORD }} \ --set mysql.database=devlake \ --set grafana."grafana\.ini".database.type=mysql \ --set grafana."grafana\.ini".database.host=server-name.mysql.database.azure.com \ --set grafana."grafana\.ini".database.user=${{ secrets.MYSQL_SERVER_USERNAME }} \ --set grafana."grafana\.ini".database.password=${{ secrets.MYSQL_SERVER_PASSWORD }} \ --set grafana."grafana\.ini".database.name=grafana \ --set ui.basicAuth.enabled=true \ --set ui.basicAuth.user=${{ secrets.DEVLAKE_UI_USERNAME }} \ --set ui.basicAuth.password=${{ secrets.DEVLAKE_UI_PASSWORD }} \ --set lake.encryptionSecret.secret=${{ secrets.DEVLAKE_ENCRYPTION_SECRET }} \ --set ui.livenessProbe.httpGet=null \ --set "ui.livenessProbe.exec.command={touch,/tmp/healthy}" \ --set ui.readinessProbe.httpGet=null \ --set "ui.readinessProbe.exec.command={touch,/tmp/healthy}" \ --set lake.readinessProbe.httpGet=null \ --set "lake.readinessProbe.exec.command={touch,/tmp/healthy}" ``` attempt to go to the devlake-ui it will prompt for migration select ok error will occur (i pulled error from logs) ### Anything else _No response_ ### Version v0.19.0 and v0.21.0-beta3 ### 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]
