7 months ago
Hi everyone 👋
I'm having an issue deploying n8n on Railway. During the startup, I keep getting this error:
column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not exist
I've tried several things but haven't been able to fix it yet. It seems related to database migrations or a missing column in PostgreSQL.
If anyone has experienced this before, could you please share a step-by-step guide or solution to fix it?
I’ve seen some mentions of setting N8N_RUN_MIGRATIONS=true, but I’m not sure where exactly to add that or if that’s the correct fix in Railway.
Any help would be greatly appreciated
Thanks in advance!
— Melvin
3 Replies
7 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 My n8n service is failing. PostgreSQL is missing the "role" column in the "user" table.
- 🧵 posgres database problems
- 🧵 column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not exist
If you find the answer from one of these, please let us know by solving the thread!
Have you tried adding that variable here?samgordon
Have you tried adding that variable here?
7 months ago
Yes, I've added it to both the primary and Postgress nodes. I'm still getting the error. When I edit a node and save it to the output of the previous node, it returns null.