When I edit docker-config with any version above 1.42.1 that I have tried, the web interface is unavailable.
What is the error message (if any)?
From the logfile:
{"level":"info","message":"Initializing n8n process","metadata":{"file":"start.js","function":"init","timestamp":"2024-06-24T22:48:26.306Z"}}
{"level":"info","message":"n8n ready on 0.0.0.0, port 5678","metadata":{"file":"AbstractServer.js","function":"init","timestamp":"2024-06-24T22:48:26.709Z"}}
{"level":"warn","message":"Migrations in progress, please do NOT stop the process.","metadata":{"file":"migrationHelpers.js","function":"logMigrationStart","timestamp":"2024-06-24T22:48:26.725Z"}}
{"level":"info","message":"Starting migration CreateProject1714133768519","metadata":{"file":"migrationHelpers.js","function":"logMigrationStart","timestamp":"2024-06-24T22:48:26.726Z"}}
{"level":"error","message":"Error: There was an error running database migrations","metadata":{"file":"LoggerProxy.js","function":"exports.error","timestamp":"2024-06-24T22:48:26.741Z"}}
{"level":"error","message":"QueryFailedError: permission denied for schema public","metadata":{"file":"LoggerProxy.js","function":"exports.error","timestamp":"2024-06-24T22:48:26.742Z"}}
{"level":"error","message":"Last session crashed","metadata":{"file":"CrashJournal.js","function":"init","timestamp":"2024-06-24T22:48:32.747Z"}}
When I put 1.42.1 back into the docker-config.yml file n8n comes back up.
Thanks!
Information on your n8n setup
n8n version: 1.42.1
Database (default: SQLite): PostgresQL 15
n8n EXECUTIONS_PROCESS setting (default: own, main): Main
Running n8n via (Docker, npm, n8n cloud, desktop app): Docker on Do
At first, I thought it might have something to do with the fact I was using queue mode. So I rewrote my docker-compose.yml file to remove redis and the worker entry. But that did not seem to help.
I don’t need queue mode, but the fact it was active may be important information.
I also looked through the release notes, but didn’t see anything that looked relevant.
That did it! Thank you. I had a gigantic sigh of relief when I saw:
{"level":"warn","message":"Migrations in progress, please do NOT stop the process.","metadata":{"file":"migrationHelpers.js","function":"logMigrationStart","timestamp":"2024-06-26T01:45:22.286Z"}}
{"level":"info","message":"Starting migration CreateProject1714133768519","metadata":{"file":"migrationHelpers.js","function":"logMigrationStart","timestamp":"2024-06-26T01:45:22.286Z"}}
{"level":"info","message":"Finished migration CreateProject1714133768519","metadata":{"file":"migrationHelpers.js","function":"logMigrationEnd","timestamp":"2024-06-26T01:45:22.566Z"}}
Then that was followed by a couple more internal updates.