I can't upgrade beyond 1.42.1

[russellkg]

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
• Operating system: Ubuntu 22

[ria]

Hi @russellkg

which versions have you tried?

[netroy]

Do you have DB_POSTGRESDB_SCHEMA env variable set? if yes, what is the value of it?

[russellkg]

Hi @ria,

I’ve tried 1.44.1, 1.45.1, and 1.46.0.

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.

Thanks in advance.

-Russ

[russellkg]

Hi @netroy,

I do not have that environment variable specified.

Thanks in advance.

-Russ

[netroy]

@russellkg

permission denied for schema public

I suspect the postgres use n8n is using does not have the permissions to perform certain operations.

Can you please try granting all permissions to this user on the database?

[russellkg]

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.

Now I’m off to break things some more!

Thanks again for the help.

-Russ