Describe the problem/error/question
I am trying to upgrade my n8n instance from 1.115 to 2.1.1
I had to rollback to the version 1.121.3 as discussed in Docker image n8nio/n8n:stable migration failure
What is the error message (if any)?
Migration "AddActiveVersionIdColumn1763047800000" failed, error: SQLITE_IOERR: disk I/O error
Information on your n8n setup
- n8n version:
2.1.1
- Database (default: SQLite):
SQLite
- n8n EXECUTIONS_PROCESS setting (default: own, main):
own
- Running n8n via (Docker, npm, n8n cloud, desktop app):
Docker (AWS ECS Service) - image: n8nio/n8n:2.1.1
If you are able to upgrade to 1.121.6, does that fix it?
Failing that, I had the same issue and ended up deactivating the offending workflows (workflows which were active but hadn’t been changed since the history had been pruned) prior to completing the upgrade. This removed them from the scope of the migration script and I reactivated afterwards.
I just tested with the version 2.2.1
Even deactivating all my workflows, the same issue happened
Okay, judging by the error message, it sounds like it might be an error with the disk or filesystem rather than the script specifically.
Whilst a bit of a sledgehammer approach, I guess you could take either a backup of the db directly or an n8n export and restore to a new db?
The only other possibility I saw when googling around was potentially filesystem permissions on either the db or the journal file not being set correctly and causing a disk error.