N8n - ai-beta - mysql migration issue

Questions
,
1

Hi everyone,

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
2

Hi @emrek :wave:

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 :+1:

2 Likes
3

Hi @EmeraldHerald :wave:

Thanks for the reply. I was not aware of that case. I will migrate our n8n instance with postgres.

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.