N8N isn’t starting anymore. Stuck in migration if I look at the logs. It finds a duplicate column.
What is the error message (if any)?
Migration “CreateLdapEntities1674509946020” failed, error: Duplicate column name ‘disabled’
Information on your n8n setup
n8n version: docker:latest
Database you’re using (default: SQLite): mariadb 10.6
Running n8n with the execution process [own(default), main]:
Running n8n via [Docker, npm, n8n.cloud, desktop app]: docker
[edit]
I fixed it by adding a line to the ‘migrations’ table in the database, specifying that specific migration with a timestamp of now() …
It pushed through after that - but I don’t know if it broke something.
The migration itself kept adding the “disabled” column to the user table.
Yeah. CreateLdapEntities1674509946020 was part of the LDAP test image, and is not included in any of the released images.
Generally when testing custom images, and then reverting back to a stable image, I highly recommend manually reverting any migrations using n8n db:revert to make sure that there are no invalid migrations in place.
I simply did an docker:latest - so that was probably at the wrong time.
I’ve since moved away from MariaDB and moved everything over to Postgres. It’s running fine now.