Problem with the n8n database

[Gioller]

Describe the problem/error/question

Some nodes are returning an error, from what I can tell only in HTTP requests, and based on the error, it seems to be something in the n8n database itself. They even appeared in different flows.

What is the error message (if any)?

{
“errorMessage”: “column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not exist”,
“errorDetails”: {},
“n8nDetails”: {
“n8nVersion”: “1.112.5 (Self Hosted)”,
“binaryDataMode”: “default”,
“stackTrace”: [
“QueryFailedError: column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not exist”,
" at PostgresQueryRunner.query (/usr/local/lib/node_modules/n8n/node_modules/@n8n/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)“,
" at processTicksAndRejections (node:internal/process/task_queues:95:5)”,
" at SelectQueryBuilder.loadRawResults (/usr/local/lib/node_modules/n8n/node_modules/@n8n/typeorm/query-builder/SelectQueryBuilder.js:2192:25)“,
" at SelectQueryBuilder.getRawMany (/usr/local/lib/node_modules/n8n/node_modules/@n8n/typeorm/query-builder/SelectQueryBuilder.js:646:29)”,
" at SelectQueryBuilder.executeEntitiesAndRawResults (/usr/local/lib/node_modules/n8n/node_modules/@n8n/typeorm/query-builder/SelectQueryBuilder.js:1979:26)“,
" at SelectQueryBuilder.getRawAndEntities (/usr/local/lib/node_modules/n8n/node_modules/@n8n/typeorm/query-builder/SelectQueryBuilder.js:684:29)”,
" at SelectQueryBuilder.getOne (/usr/local/lib/node_modules/n8n/node_modules/@n8n/typeorm/query-builder/SelectQueryBuilder.js:711:25)“,
" at refreshFn (/usr/local/lib/node_modules/n8n/dist/credentials-helper.js:236:36)”,
" at CacheService.get (/usr/local/lib/node_modules/n8n/dist/services/cache/cache.service.js:166:34)“,
" at CredentialsHelper.credentialCanUseExternalSecrets (/usr/local/lib/node_modules/n8n/dist/credentials-helper.js:234:18)”
]
}
}

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

• n8n version: 1.112.5 [Self Hosted]
• Database (default: SQLite): postgresql
• n8n EXECUTIONS_PROCESS setting (default: own, main): EXECUTIONS_MODE=queue
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker

[krisn0x]

It appears the role column is missing from the Postgres DB. Are you running in scaling mode? If yes, you need to make sure they are on the same version as the main n8n instance and re-deploy them. Also check this thread:

Problem logging in column User.role does not exist

Describe the problem/error/question I am not able to log into my deployed version of n8n on RailWay What is the error message (if any)? Problem logging in column User.role does not exist Please share your workflow It is not a workflow problem, but rather that I am not able to access my n8n instance with all my workflows. Share the output returned by the last node Not a workflow problem Information on your n8n setup n8n version: 1.110.1 Database (default: SQLite): Postgres n8n EXECUTIONS_PR…

[krisn0x]

Also dropping this for reference if the previous one doesn’t help:

@hinzzx

Go to your deployment instance (in my case it was named “Primary”).
Click on Variables;
Then Add new Variable: N8N_RUN_MIGRATIONS
Set the value to “true“
Deploy

Then you can remove that variable!

[Gioller]

Yes it’s running in scaling mode. I just redeployed everything and that fixed it, thank you so much