fbgirardsherweb opened a new issue, #8463: URL: https://github.com/apache/incubator-devlake/issues/8463
### 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 Im testing DevLake with a fresh postgress database instead of MySQL , since i want to use Azure managed postgress Im using this version "Image": "devlake.docker.scarf.sh/apache/devlake@sha256:7e4797600ee66c9ee3031779d9e62dfc33e9071ce6ebe52908f6b1ddf65f9796", - I was not able to use the helm template without modifying it secrets.yaml (commented out?) {{- else if (eq .Values.option.database "pgsql")}} POSTGRES_USER: "{{ .Values.pgsql.username }}" POSTGRES_PASSWORD: "{{ .Values.pgsql.password }}" POSTGRES_DB: "{{ .Values.pgsql.database }}" DB_URL: "{{ include "database.url" . }}" + _helpers.tpl The value file lake: encryptionSecret: secret: "Something" grafana: adminPassword: "admin" option: database: pgsql autoCreateSecret: true mysql: enabled : false pgsql: useExternal: true externalServer: my-postgres-postgresql.default.svc.cluster.local externalPort: 5432 port: 5432 username: merico password: merico database: lake storage: class: "" size: 5Gi image: repository: postgres tag: 14.2-alpine pullPolicy: IfNotPresent resources: {} nodeSelector: {} tolerations: [] affinity: {} extraLabels: {} securityContext: {} containerSecurityContext: {} annotations: {} - I was only able to spawn the postgress db with his own helm release - Im not able to get past the migration , it seem like the SQL query are not valid 2025/06/05 20:21:54 [Recovery] 2025/06/05 - 20:21:54 panic recovered: GET /proceed-db-migration HTTP/1.1 Host: devlakepostgress-lake.default.svc.cluster.local:8080 Accept: application/json, text/plain, */* Accept-Encoding: gzip, deflate, br, zstd Accept-Language: en-US,en;q=0.9,en-CA;q=0.8 Referer: http://127.0.0.1:32001/db-migrate Sec-Ch-Ua: "Chromium";v="136", "Microsoft Edge";v="136", "Not.A/Brand";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Sec-Fetch-Dest: empty Sec-Fetch-Mode: cors Sec-Fetch-Site: same-origin User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0 failed to modify processed_time column (500) Wraps: (2) ERROR: syntax error at or near "MODIFY" (SQLSTATE 42601) (500) Wraps: (3) ERROR: syntax error at or near "MODIFY" (SQLSTATE 42601) Error types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *pgconn.PgError /app/core/errors/util.go:34 (0x1617f06) /app/server/api/api.go:126 (0x1617eb9) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x16157e2) /app/server/api/middlewares.go:95 (0x16157c6) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x1615c87) /app/server/api/middlewares.go:117 (0x1615b22) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x1255301) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/recovery.go:102 (0x12552ec) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x1254426) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/logger.go:240 (0x1254409) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x12532aa) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/gin.go:620 (0x1252f31) /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/gin.go:576 (0x1252a5c) /usr/local/go/src/net/http/server.go:2936 (0xce45b5) /usr/local/go/src/net/http/server.go:1995 (0xcdf751) ### What do you expect to happen No errors ### How to reproduce - Fresh helm install with latest version without mysql ### Anything else _No response_ ### Version 7e4797600ee66c9ee3031779d9e62dfc33e9071ce6ebe52908f6b1ddf65f9796 ### 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
