URGENT - Database corruption after failed n8n upgrade

cosentini55
HOBBY

15 days ago

The n8n upgrade to 1.110.1 failed and corrupted the database.
Now getting "column User.role does not exist" errors.
Please restore the latest backup from before the upgrade attempt.
$10 Bounty

19 Replies

Railway
BOT

15 days 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!


irazvan2745
PROTop 5% Contributor

15 days ago

did you make a backup?


cosentini55
HOBBY

15 days ago

Unfortunately not, I saw the update available and thought it would work!


15 days ago

Hey there!
Unless you are using Railway's backup feature or a custom backup system, Railway is unable to provide a fix for lost, deleted, or corrupted data. Please note that the backup feature is available only for the pro and enterprise plan not the hobby.

For restoring the actual data, I am unsure the depth that it was corrupted. I suggest reaching out to the n8n forums! They might have people there who deal with these types of issues more frequently then us.


Anonymous
HOBBY

14 days ago

The same problem happening to me. Has anyone solved it?


urahernandezf-droid
HOBBY

14 days ago

I have de same problem: Problem logging in column User.role does not exist.
does anybody noks how to solve this? pls


Anonymous
HOBBY

14 days ago

I can't go back to previous versions either. I'm desperate... can anyone help?


proyectos2025ia
PRO

14 days ago

What is Railway's support channel? They've only been answering me so far. It's been half a day and nothing. Terrible service.


error

Hey there! Unless you are using Railway's backup feature or a custom backup system, Railway is unable to provide a fix for lost, deleted, or corrupted data. Please note that the backup feature is available only for the pro and enterprise plan not the hobby. For restoring the actual data, I am unsure the depth that it was corrupted. I suggest reaching out to the n8n forums! They might have people there who deal with these types of issues more frequently then us.

proyectos2025ia
PRO

14 days ago

Please can you help us with a roadmap, so far no one has given an answer at least to get out of the problem.


14 days ago

Does anyone have a link to a deployment that is failing with this error? We want to make sure the auto updates feature is not breaking services, but whether or not an update is supported is based on the actual service being deployed. Railway does not have any control over n8n or how it handles updates


proyectos2025ia
PRO

14 days ago

i just redeploy this two and make some hard runs, i think its ok for now.
It would have been helpful if someone had at least provided some test cases, especially for those new to railway. It's been almost 10 hours since the incident, and I haven't received a direct response.

Attachments


14 days ago

Railway does not control n8n, so for any application specific issues (like the column User.role does not exist error) we rely on community support. Apologizes that it took so long to get a proper fix. If anyone else comes across this issue, can you explain what you did to fix. Then we can share your response with other users experiencing similar problems with n8n.


proyectos2025ia
PRO

14 days ago

Sure, I'll send you a log.

1. I woke up to a version update that was generating random errors in various areas, from database queries to Open AI nodes, all very random.

2. Go to "primary", select the three points, and select Redeploy.

3. Go to "postgres" and do the same.

4. Test with database queries in N8N and AI agents.


proyectos2025ia
PRO

14 days ago

its happening again, i send some info of the logs


jr

Railway does not control n8n, so for any application specific issues (like the column User.role does not exist error) we rely on community support. Apologizes that it took so long to get a proper fix. If anyone else comes across this issue, can you explain what you did to fix. Then we can share your response with other users experiencing similar problems with n8n.

proyectos2025ia
PRO

14 days ago


I'm a bit stuck, I don't have the technical skills for any of these solutions.


14 days ago

I am by no means an n8n export, but I see that your worker and primary n8n services are different versions. Can you try redeploying the worker. I think they need to be on the same version


jr

I am by no means an n8n export, but I see that your worker and primary n8n services are different versions. Can you try redeploying the worker. I think they need to be on the same version

proyectos2025ia
PRO

14 days ago

done, ill make some test


ufukcicekdev
PRO

10 days ago

Hi, I updated the database and redid it. I also redid it for Redis, Workers, and Primary in the same way. I didn't get the role error. Could you try it?


ufukcicekdev

Hi, I updated the database and redid it. I also redid it for Redis, Workers, and Primary in the same way. I didn't get the role error. Could you try it?

proyectos2025ia
PRO

9 days ago

its working, thkns!