I just updated n8n from 0.164.1 to the latest docker image.
Stopped and removed the docker. Restarted the Docker image and receive 502 Bad Gateway nginx.
Domain managed over reverse proxy towards raspi
n8n running with docker on raspi
worked perfectly for over a year…
used the docker command which worked before, restarted nginx and ckecked if the docker is running.
Any suggestions what else i can try?
Initializing n8n process
Migrations in progress, please do NOT stop the process.
Migration “CreateUserManagement1646992772331” failed, error: SQLITE_ERROR: table “role” already exists
There was an error initializing DB: “SQLITE_ERROR: table “role” already exists”
do you have a tipp how to solve this?
Or do I have to set the whole thing up again? If yes I’ve seen the CLI commands to export the Workflows and Credentials but will that work if the docker is not running?
Did you downgrade at some point? I suspect that has put the database in a bit of an odd state. If the container isn’t running you won’t be able to connect to it to run the commands. A quick option would be to downgrade to the version that was working then use the CLI to export the workflows and from there you can then stop the instance, move the old database and let it make a new one then import the workflows and upgrade.
It could be a good time to move to Postgres or similar as well if you wanted to move away from SQLite.
Sadly no official steps on that one, I think you could get away with doing a dump on the workflow_entity and credential_entity table then having n8n make a new database and stopping the container and importing the dumped data into the new database.