We faced an issue while deploying n8n ai-beta with mysql.
Describe the problem/error/question
Problem: When we try to deploy n8n ai-beta branch to a docker container with mysql support. Migration throw error
What is the error message (if any)?
main_1 | Error: There was an error running database migrations
main_1 | QueryFailedError: Cannot change column ‘workflowId’: used in a foreign key constraint ‘fk_execution_entity_workflow_id’
Please share your workflow
It is for first install of n8n with mysql support
Information on your n8n setup
- **n8n version:1.11.0
- **Database (default: SQLite): Mysql
- **n8n EXECUTIONS_PROCESS setting (default: own, main):default
- **Running n8n via (Docker, npm, n8n cloud, desktop app):Docker
- **Operating system:Ubuntu
One thing that might be happening here - we mention it on the docs for Docker installs ( Docker | n8n Docs ) but both MariaDB and MySQL support have been deprecated since 0.227.0, and are no longer supported. It might be worth trying to migrate your database to Postgres and trying again
Thanks for the reply. I was not aware of that case. I will migrate our n8n instance with postgres.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.