3 months 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
3 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
3 months 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 • 3 months ago
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 ray-chen • 3 months ago
3 months ago
try migrating first
3 months ago
This error happens because the n8n database migrations weren’t applied after the upgrade. Try running the migration command to fix it.