3 months ago
I was attempting to complete configuration of an n8n Workflow Backup imported from an Enterprise template which required various adjustments for the n8n Community Edition. All was going well until and I was using Perplexity w/ DeepSeek R1 to provide assistance until Perplexity had me add a series of Shared Variables. Then after specifically adding the variables “N8NENDPOINTREST” and “N8NENDPOINTREST_OLD”, the system crashed and now Primary fails upon deployment and redeployment. It looks like a communication conflict with connecting to Postgres. I have subsequently updated the Shared Variables in an attempt to correct them, but it appears that the Key: Value pairs register if the value is text, but will not register and resolve the values using Templated values, showing in the main Variables sections in Primary and Postgres when clicking the view icon. Conversely, if I select the Edit field control, the Templated value is displayed.
I am running n8n Community Edition in Queue Mode w/ Webhook processors on the Hobby Plan.
I have a number of n8n workflows I have installed and partially configured and why I was installing to execute a backup workflow as my first executable.
Any assistance is greatly appreciated as I don’t want to have to start over, and the Postgres database itself appears to be okay if I needed to make a backup of the JSON files to reimport with a new instance of n8n should this not be fixable.
Note I am a low code/no guy and am in deep water within Railway, albeit is a very cool hosting app. So step by step guidance would be greatly appreciated.
Thanks in advance for your assistance,
DC
Logs (Excerpt):
Primary
620a447d-803f-40a4-9f6a-5c8f238f9dda
FAILED primary-production-b0359.up.railway.app
Deployment failed during the network process > Network > Healthcheck > Healthcheck failure
Deploy Logs:
Feb 01 23:35:51
connect ECONNREFUSED ::1:5432
Feb 01 23:35:55
User settings loaded from: /home/node/.n8n/config
Feb 01 23:35:57
Last session crashed
Feb 01 23:36:17
Initializing n8n process
Feb 01 23:36:17
There was an error initializing DB
Feb 01 23:36:17
connect ECONNREFUSED ::1:5432
Feb 01 23:36:17
User settings loaded from: /home/node/.n8n/config
Feb 01 23:36:17
Last session crashed
Feb 01 23:36:24
Initializing n8n process
Feb 01 23:36:25
There was an error initializing DB
Feb 01 23:36:25
connect ECONNREFUSED ::1:5432
Feb 01 23:41:36
Stopping Container
23 Variables
DBPOSTGRESDBPORT = ${{shared.DBPOSTGRESDBPORT}}
repopath = ${{shared.repopath}}
ENABLEALPINEPRIVATENETWORKING = true N8NENCRYPTIONKEY = roqmicVQhJyJ-Idr95g2!UgbI5-ItZ8
DBPOSTGRESDBPASSWORD = ${{shared.DBPOSTGRESDBPASSWORD}}
QUEUEBULLREDISHOST = ${{shared.QUEUEBULLREDISHOST}}
DBTYPE = ${{shared.DBTYPE}}
DBPOSTGRESDBHOST = ${{shared.DBPOSTGRESDBHOST}}
PORT = 5678
QUEUEBULLREDISUSERNAME = ${{28e7c8af-f77e-43b6-8ed1-2eeb565798af.REDISUSER}} QUEUEBULLREDISPORT = ${{shared.QUEUEBULLREDISPORT}} DBPOSTGRESDBCONNECTIONTIMEOUT = ${{shared.DBPOSTGRESDBCONNECTIONTIMEOUT}} N8NTRUSTPROX = ${{shared.N8NTRUSTPROX}} repoowner = ${{shared.repoowner}} EXECUTIONSMODE = queue
N8NLISTENADDRESS = ::
DBPOSTGRESDBDATABASE = ${{shared.DBPOSTGRESDBDATABASE}}
DBPOSTGRESDBUSER = ${{shared.DBPOSTGRESDBUSER}}
N8NDISABLEPRODUCTIONMAINPROCESS = true
N8NEDITORBASEURL = https://${{RAILWAYPUBLICDOMAIN}} N8NENFORCESETTINGSFILEPERMISSIONS = ${{shared.N8NENFORCESETTINGSFILEPERMISSIONS}} reponame = ${{shared.reponame}} WEBHOOKURL = https://${{f4d1b7da-997c-43ff-8657-c2297da562e1.RAILWAYPUBLICDOMAIN}}
> ⓘ Deployment information is only viewable by project members and Railway employees.
19 Replies
3 months ago
wonder if your issue and mine are related: https://help.railway.com/questions/n8n-database-connection-issues-f804a0db
3 months ago
I thought the same potentially, and subscribed to your thread just before posting last night. I'm new to n8n CE on Railway, been running ~one week. How responsive does getting support tend to be?
3 months ago
For Hobby, within a few days, for Pro, within 12 hours, for enterprise, within 1 hour.
Looking now though.
3 months ago
Now that was a perfectly timed segue. Thank you, brody, for getting to this so quickly. Please let me know if you need additional details.
3 months ago
So you had made a lot of incorrect configurations, mainly promoting a bunch of variables to be shared variables.
I have undone all that for you.
Going forward, please do not do such things with deployed templates again.
brody
So you had made a lot of incorrect configurations, mainly promoting a bunch of variables to be shared variables.I have undone all that for you.Going forward, please do not do such things with deployed templates again.
3 months ago
Thank you, brody, great job and it is very much appreciated. Moving forward, I'll stick with sourcing assistance here instead of LLMs.
brody
So you had made a lot of incorrect configurations, mainly promoting a bunch of variables to be shared variables.I have undone all that for you.Going forward, please do not do such things with deployed templates again.
3 months ago
brody, looks like I have one additional issue. I cannot login to the n8n app itself, but I am able to login to Railway and my Ghost instance. Error message says Recover Email - Please contact your admin. n8n isn’t set up to send email right now. Please advise when you can. Thanks - DC
brody
You forgot your N8N login?
3 months ago
Actually no, it's in Microsoft Wallet, it's just not working for n8n, but is for Ghost. Same login, difference password of course.
3 months ago
I'm not sure why you are mentioning Ghost?
N8N and Ghost are completely different software.
brody
I'm not sure why you are mentioning Ghost?N8N and Ghost are completely different software.
3 months ago
Simply because they're both deployed on Railway.
3 months ago
Gotcha, there's no real relevance there.
You perhaps changed your encryption key incorrectly too, I will look into that when I'm back at my laptop in a few minutes.
brody
Gotcha, there's no real relevance there.You perhaps changed your encryption key incorrectly too, I will look into that when I'm back at my laptop in a few minutes.
3 months ago
You are golden, Brother. Thanks so much. Maybe it would be good for me to reset my password if possible. i know I wigged things out quite a bit last night.
3 months ago
Please try logging in with the new password set in the NEW_PASSWORD
variable on the Primary service.
Please note, that variable has nothing to do with how you change passwords in N8N or software hosted on Railway, I am just using that variable as a simple way to give you the new password given this a public thread.
brody
Please try logging in with the new password set in the NEW_PASSWORD variable on the Primary service.Please note, that variable has nothing to do with how you change passwords in N8N or software hosted on Railway, I am just using that variable as a simple way to give you the new password given this a public thread.
3 months ago
Will do, standby
dc-aaia
Will do, standby
3 months ago
Still not letting me in with the new password. And I am using my Gmail account.
3 months ago
Then you are using the wrong email, the email you signed up to N8N with was not a gmail address.
brody
Then you are using the wrong email, the email you signed up to N8N with was not a gmail address.
3 months ago
Perfect, that got it. Thanks so much but not sure what happened as it was cached to my Gmail account and password. Just recently started using Wallet so maybe it's a browser conflict on my end. I've got it logged separately now. Outstanding support, brody. Thanks so much. Lunch is on me next time Brother - DC
3 months ago
Means your original password would have also likely worked if used the correct email.
Either way, happy it's working now!
Status changed to Solved brody • 3 months ago