a year ago
Got it 👍 — here’s a clear summary you can send to Railway support:
Issue Summary
I am running an n8n instance on Railway with PostgreSQL. After upgrading n8n, my workflows fail with the error:
QueryFailedError: column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not existThis indicates that the database schema migrations have not been applied. Starting from n8n v1.0, a role column was added to tables like shared_credentials and shared_workflows. Without running the migrations, n8n tries to query a column that doesn’t exist, causing the failure.
4 Replies
a year ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 URGENT - Database corruption after failed n8n upgrade
- 🧵 PostGress Error
- 🧵 Critical Issue: n8n Database Corruption After Automatic Update
- 🧵 Crashed suddenly for n8n
If you find the answer from one of these, please let us know by solving the thread!
a year ago
Apologies but this looks like an issue with the application level code. Due to volume, we can only answer platform level issues.
I've made this thread public so that the community might be able to help with you query.
Status changed to Awaiting User Response Railway • 11 months ago
a year 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 ray-chen • 11 months ago
a year ago
try migrating first
a year ago
This error happens because the n8n database migrations weren’t applied after the upgrade. Try running the migration command to fix it.