Good day!
Try to update n8n on my server today, but catch errors, because disk was full
Searched here probllems and undurstand, that problem is in database.sqlite
But the probles is that i can not vacuum it, because disk is full.
That looks like you might not have enough space to perform a vacuum, When the vacuum works it makes a copy of the data then does some magic and copies the data back so you would need to make sure you have enough space for this to happen.
You can find more information on the sqlite vacuum process here: VACUUM
What I would do is export the workflows and credentials from the database, delete the database file then start up n8n and import the data again then make sure the vacuum option is set and everything should be good to go or use it as an opportunity to move to something like Postgres instead.
I tried to update n8n today, but an error came up during migration (that the database takes up a lot of space)
I am a complete 0 in programming and command lines, so I don’t even know how to answer you exactly
Your post showed that you had manually ran the sqlite command, Do you still have that command connected to the database? If in doubt I would restart the server and see if that helps.
Are you still seeing the database locked message when using the CLI tool? You could try downgrading to an earlier version of n8n and seeing if that will start up to allow you to export the workflows.
As a possible future thing we do have n8n cloud where all of this is managed for you so you don’t need to have any experience managing a server and dealing with issues like this.
Same way you would with other docker images, In your compose add the version you want to use at the end of the image name so if you were using an image of n8nio/n8n:latest you would change it to something like n8nio/n8n:0.210.0 or whatever your previous version was.