Hello, I had an issue few months ago with reducing the size of my DATABASE. I managed to reduce the size manually the first time and then vacuum it. Now that I tried to manually empty it again and I guess I had an error( I have tried to delete rows with “DELETE FROM execution_entity” ) which then makes the program stuck. I used DB Browser for SQLite on my Raspberry Pi. I guess theres too much data in table…once I ended the process there was a file names databasename.journal something and I deleted it since my database didnt get any smaller. (Dont know what that file is)
After starting n8n process again and trying to execute my workflow I get a an error database is locked … file is corrupted something.
How do I fix this?
Fyi. My database is filled with execution logs → i rly dont need this tho but nevertheless I just need it to work. Also I am not a skilled programmer so please keep language as simple as possible. Thanks!