dosubot[bot] commented on issue #8564: URL: https://github.com/apache/incubator-devlake/issues/8564#issuecomment-3253665979
<!-- Greeting --> Hi @jcg-juan! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the incubator-devlake team. <!-- Answer --> The migration failure is caused by MySQL-specific SQL in `20250320_modify_file_meta.go`, which uses `ALTER TABLE ... MODIFY` and `DATETIME`—these are not valid in PostgreSQL. The script does not include any logic to handle different SQL dialects, so PostgreSQL migrations will fail on DevLake v1.0.2+ as you described. There are currently no fixes, workarounds, or open PRs addressing this issue in the repository, and the migration script has not been updated for PostgreSQL compatibility as of the latest commit [source](https://github.com/apache/incubator-devlake/blob/2c15ad880dce830c6512fa58039527cbf4745b8b/backend/plugins/q_dev/models/migrationscripts/20250320_modify_file_meta.go). To resolve this, migration scripts should detect the database dialect and run compatible SQL for each engine (for example, use `ALTER TABLE ... ALTER COLUMN ... TYPE TIMESTAMP` for PostgreSQL). The DevLake DAL interface supports dialect detection, but it's not used in this migration. Until the script is updated, PostgreSQL support for this migration remains broken. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/85a63558-c075-4afd-9e0b-686fb0baa219?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/85a63558-c075-4afd-9e0b-686fb0baa219?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/85a63558-c075-4afd-9e0b-686fb0baa219?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/85a63558-c075-4afd-9e0b-686fb0baa219?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/85a63558-c075-4afd-9e0b-686fb0baa219?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/85a63558-c075-4afd-9e0b-686fb0baa219?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/85a63558-c075-4afd-9e0b-686fb0baa219?feedback_type=other)</sup> [](https://app.dosu.dev/b4e8e847-d479-4541-83a8-d88d83fea5c9/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/incubator-devlake/issues/8564) -- 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]
