3 months ago
I get this error in N8n when connecting to Postgress DB "column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not exist". Please assist workflow cannot run.
QueryFailedError: column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not exist at PostgresQueryRunner.query (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+typeorm@0.3.20-12_@sentry+node@9.42.1_ioredis@5.3.2_mongodb@6.11.0_@aws-sdk+creden_329e05b6e8a99552a7cbe5b57cc4aa61/node_modules/src/driver/postgres/PostgresQueryRunner.ts:331:19) at processTicksAndRejections (node:internal/process/task_queues:105:5) at SelectQueryBuilder.loadRawResults (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+typeorm@0.3.20-12_@sentry+node@9.42.1_ioredis@5.3.2_mongodb@6.11.0_@aws-sdk+creden_329e05b6e8a99552a7cbe5b57cc4aa61/node_modules/src/query-builder/SelectQueryBuilder.ts:3805:25) at SelectQueryBuilder.getRawMany (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+typeorm@0.3.20-12_@sentry+node@9.42.1_ioredis@5.3.2_mongodb@6.11.0_@aws-sdk+creden_329e05b6e8a99552a7cbe5b57cc4aa61/node_modules/src/query-builder/SelectQueryBuilder.ts:1626:29) at SelectQueryBuilder.executeEntitiesAndRawResults (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+typeorm@0.3.20-12_@sentry+node@9.42.1_ioredis@5.3.2_mongodb@6.11.0_@aws-sdk+creden_329e05b6e8a99552a7cbe5b57cc4aa61/node_modules/src/query-builder/SelectQueryBuilder.ts:3467:26) at SelectQueryBuilder.getRawAndEntities (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+typeorm@0.3.20-12_@sentry+node@9.42.1_ioredis@5.3.2_mongodb@6.11.0_@aws-sdk+creden_329e05b6e8a99552a7cbe5b57cc4aa61/node_modules/src/query-builder/SelectQueryBuilder.ts:1670:29) at SelectQueryBuilder.getOne (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+typeorm@0.3.20-12_@sentry+node@9.42.1_ioredis@5.3.2_mongodb@6.11.0_@aws-sdk+creden_329e05b6e8a99552a7cbe5b57cc4aa61/node_modules/src/query-builder/SelectQueryBuilder.ts:1697:25) at refreshFn (/usr/local/lib/node_modules/n8n/src/credentials-helper.ts:494:25) at CacheService.get (/usr/local/lib/node_modules/n8n/src/services/cache/cache.service.ts:199:25) at CredentialsHelper.credentialCanUseExternalSecrets (/usr/local/lib/node_modules/n8n/src/credentials-helper.ts:492:5)3 Replies
3 months ago
Hey there! We've found the following might help you get unblocked faster:
🧵 Critical Issue: n8n Database Corruption After Automatic Update
🧵 n8n → Postgres connection issue: “Role ‘postgres’ does not exist
If you find the answer from one of these, please let us know by solving the thread!
3 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 3 months ago
3 months ago
Still need help
2 months ago
I got the same issue