Some time ago we discussed in discord that this template should be able to be used with the ai-beta image from n8n. However, i used to have it deployed and it is crashing now that i made updates to the images. However, i did try a fresh install of this template and then changed the image to the one with the ai tag and i am having the following error:
```Last session crashed

Initializing n8n process

n8n ready on 0.0.0.0, port 5678

Version: 1.26.0

QueryFailedError: column cd43bc0fc97c506c5de0ef87852dc2be75e194ca.globalRoleId does not exist

at PostgresQueryRunner.query (/usr/local/lib/nodemodules/n8n/nodemodules/.pnpm/typeorm@0.3.17ioredis@5.3.2mysql2@2.3.3pg@8.8.0sqlite3@5.1.6/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)

at processTicksAndRejections (node:internal/process/task_queues:95:5)

at SelectQueryBuilder.loadRawResults (/usr/local/lib/nodemodules/n8n/nodemodules/.pnpm/typeorm@0.3.17ioredis@5.3.2mysql2@2.3.3pg@8.8.0sqlite3@5.1.6/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2183:25)

at SelectQueryBuilder.executeEntitiesAndRawResults (/usr/local/lib/nodemodules/n8n/nodemodules/.pnpm/typeorm@0.3.17ioredis@5.3.2mysql2@2.3.3pg@8.8.0sqlite3@5.1.6/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2034:26)

at SelectQueryBuilder.getRawAndEntities (/usr/local/lib/nodemodules/n8n/nodemodules/.pnpm/typeorm@0.3.17ioredis@5.3.2mysql2@2.3.3pg@8.8.0sqlite3@5.1.6/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29)

at SelectQueryBuilder.getMany (/usr/local/lib/nodemodules/n8n/nodemodules/.pnpm/typeorm@0.3.17ioredis@5.3.2mysql2@2.3.3pg@8.8.0sqlite3@5.1.6/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25)

at WorkflowRepository.getAllActive (/usr/local/lib/node_modules/n8n/packages/cli/dist/databases/repositories/workflow.repository.js:34:16)

at ActiveWorkflowRunner.addActiveWorkflows (/usr/local/lib/node_modules/n8n/packages/cli/dist/ActiveWorkflowRunner.js:295:29)

at ActiveWorkflowRunner.init (/usr/local/lib/node_modules/n8n/packages/cli/dist/ActiveWorkflowRunner.js:73:9)

at Start.run (/usr/local/lib/node_modules/n8n/packages/cli/dist/commands/start.js:239:9)

Error: Exiting due to an error.

QueryFailedError: column cd43bc0fc97c506c5de0ef87852dc2be75e194ca.globalRoleId does not exist

User settings loaded from: /home/node/.n8n/config

Last session crashed

Initializing n8n process

n8n ready on 0.0.0.0, port 5678
```

Any idea of what it can be?

Some time ago we discussed in discord that this template should be able to be used with the ai-beta image from n8n. However, i used to have it deployed and it is crashing now that i made updates to the images. However, i did try a fresh install of this template and then changed the image to the one with the ai tag and i am having the following error:

Any idea of what it can be?

Are you running the latest n8n version? Now, the stable n8n version includes AI features…

this was solved via discord, and indeed the solution was using the latest n8n image. thanks for the help!

how to increase concurrency from 10 to 20?

how to increase concurrency from 10 to 20?

In the worker settings check the start command. You should be able to change it from there. Just a small tip: a high concurrency is not always the best solution. Sometimes if tasks are too intensive you want to add extra workers instead of increasing the concurrency.

how to increase concurrency from 10 to 20?

In the worker settings check the start command. You should be able to change it from there. Just a small tip: a high concurrency is not always the best solution. Sometimes if tasks are too intensive you want to add extra workers instead of increasing the concurrency.

Thanks. I got it.
My n8n reads and writes to a database and responds to the Telegram API. I believe it can handle a maximum of 20 concurrent requests since it is a light load.
Feedbacks are welcome.

Quick Question: what's the easiest way to change the webhooks and my whole app to myurl.mydomain.com instead of https://primary-production-xxxxx.up.railway.app/webhook-test/xxxxx … I was able to add my name, but I can't seem to see where In the app I can change all the tests, webhooks and main URL of the app to myurl.mydomain.com .. thanks fo your help!

Quick Question: what's the easiest way to change the webhooks and my whole app to myurl.mydomain.com instead of https://primary-production-xxxxx.up.railway.app/webhook-test/xxxxx … I was able to add my name, but I can't seem to see where In the app I can change all the tests, webhooks and main URL of the app to myurl.mydomain.com .. thanks fo your help!

Have you configured your domain first in the Main instance settings?

Quick Question: what's the easiest way to change the webhooks and my whole app to myurl.mydomain.com instead of [https://primary-production-xxxxx.up.railway.app/webhook-test/xxx](https://primary-production-xxxxx.up.railway.app/webhook-test/xxx)xx … I was able to add my name, but I can't seem to see where In the app I can change all the tests, webhooks and main URL of the app to myurl.mydomain.com .. thanks fo your help!

Have you configured your domain first in the Main instance settings?

thanks for your help… yes I have… In the main (which I believe is called "Primary" in the template) I see the variables:
RAILWAYPUBLICDOMAIN and WEBHOOK_URL set to myurl.mydomain.com (which is correct) … but when I go to create a webhook I still see: https://primary-production-xxxxx.up.railway.app/webhook-test/xxx in the n8n interface

On the railway app under Public Networking I have both domains my custom domain + the one that the app used to install… should I delete that and leave only my custom domain ? Thanks for your help!

have you redeployed since adding the custom domain?

that worked!! Thanks a lot !!!

hey, i get this error for both worker and application. happened after adding a new workflow:

Initializing n8n process

Error: There was an error initializing DB

DatabaseError: the database system is not yet accepting connections

User settings loaded from: /home/node/.n8n/config

Last session crashed

Any hints?

did the database crash?

did the database crash?

sort of, it's up but throws errors. see here: https://drive.google.com/uc?id=1zpZalc3HE5CuoCO6b7C9SgiHizBKtN1J

your database has no disk space left. check to see if you have an option to grow the volume in the volume's settings.

if you don't, you would need to upgrade your plan, and then grow the database.

that would make sense. I was downlaoding a bunch of pdfs and analysing them. Sorry not a developer, any pointers on where I do that? Note: my usage plan seems okay though.

you can find the volume's settings by clicking on the volume, this would be the little tab-like feature attached to the database service with "Postgres data" written on it.

got it thanks so much. Got now 5gb but it keeps throwing errors: https://drive.google.com/uc?id=15OXZqdt6bsszwUBgUUB1fAFa8lMjaBcp I did redeploy and restart.

try re-deploying the database again.

try re-deploying the database again.

it works! Cheers mate

no problem!

Sorry if this is a stupid question, how would I go about updating n8n using this? I've tried hosting on DO and I remember it being a nightmare.

Have you tried just redeploying primary and worker? If that doesn't work, maybe change the source image to n8nio/n8n:latest

yep, what lrrrrr said, this template doesn't use the :latest tag but not specifying the :latest tag should for all intents and purposes use the latest image on redeploy

Absolute legends, thank you!

In n8n if I go to Settings>Workers I see it is only available on Enterprise plan. Using the community edition (the free one), should I Remove the active deployment of the "Worker" service of this template to cut unnecessary project usage? and the "Redis"? Or will the deployment stop working properly without these services? Thank you

just curious, what happens to the local files I downloaded? I'd like to delete the local files I download once the workflow is completed. Same for the files I downloaded in the past across workflows. Found this discussions on the forum: https://community.n8n.io/t/delete-downloaded-files-in-workflow-after-ran/33043/4 & https://community.n8n.io/t/how-to-automatically-clean-binarydata-in-self-hosted-n8n-tip-for-manually-delete-binarydata-inside/29440/7

They're stored in the 100gb of empherial storage that is not part of your operating costs (aka it's included in your plan)

A simple redeploy will wipe all those files.

Hello, firstly I apologize if the English is not right, I am using the translator!

I'm using the Template and when I went to change the domain, my N8N stopped working, and I went to check and some variables were left empty, and I don't know where to find these variables and how to fill them in, as I'm new to both railway and postgress.

I'm attaching some prints and if you can help me!

Setting the PGHOST_PRIVATE variable in your Postgres service to ${{RAILWAY_PRIVATE_DOMAIN}} should hopefully resolve the issue.

Setting the PGHOST_PRIVATE variable in your Postgres service to ${{RAILWAY_PRIVATE_DOMAIN}} should hopefully resolve the issue.

It worked, thank you very much!

Hello how are you? Maybe it's a little outside the scope of the template, but I didn't know where to ask this question.

I have my N8N on the railway and my client has shared hosting, and I need to connect to his mysql database so I can make changes and the system works, however his database asks for the IP to authorize third party access and I noticed that the railway does not provide a static IP, is there any configuration I can do or has anyone already faced a problem like this?

You would need to whitelist all IPs or whitelist all CIDR ranges in the region your app is deployed to - https://utilities.up.railway.app/cidr-list?value=us-west1

Hello guys!
I'm a totaly newbie in this terms and steps here… I just want to know how can i update my N8N deployed with this template with simple steps.

I have the 1.29.1 version and want to stay up to date!

Can some one try to make an fast tutorial how to do this? Can be in topics steps 1,2,3…

Will help a lot me and possible new users :)

You simply click redeploy from the active deployments 3-dot menu.

Couldn't update it to the latest release no matter how many times i redeployed :(

Hey guys
Thanks jack for this wonderful deployment, much appreciated.
Everyone having issues upgrading to the latest version just add to the Source Image : n8nio/n8n:latest and redeploy, it would to the latest version.

Also guys, I am having two issues:
1) I am unable to make the "/webhook-test" endpoint work, but it is working upon making the workflow live, "/webhook" endpoint is working for some reason
Response for '/webhook-test/idme" :
Cannot GET /webhook-test/idme

Response for '/webhook/idme" :
"Workflow Started"

2) I am also unable to make the callback url for Google OAuth work as well
Response:
Cannot GET /rest/oauth2-credential/callback

@nozelle I tried n8nio/n8n:latest before posting here but to no avail :(

2) I am also unable to make the callback url for Google OAuth work as well
Response:
Cannot GET /rest/oauth2-credential/callback

Anyone figure out a solution to this? I am having the same issue. I can connect my OpenAI account fine but google responds with that message every time.

Has anyone encountered a situation where the database remains in a connecting state but fails to load, even though the database logs show it was deployed successfully?

1) I am unable to make the "/webhook-test" endpoint work, but it is working upon making the workflow live, "/webhook" endpoint is working for some reason
Response for '/webhook-test/idme" :
Cannot GET /webhook-test/idme

Same as nozelle here

I have same error, i think this is a networking error because when i add new postgre db from scratch i can see database logs.

Hello, did you find the solution on how to update?

How can i update my N8N deployed version to the latest version? my version is 1.74.3

The 'Telegram - Send Message and Wait' node (which basically wait for response from the telegram user) is not working. It appears to be a callback/webhook issue. I have tried the same template on n8n servers and it worked like a charm.. Please help!

Jack, thanks for the template, it has been a great help to me in my work with N8N.
I have this template deployed for about 1 year by now.
@Dear friends, a few weeks ago I noticed that after I update the services (I use to do it at lease once a week) services Redis and PostgreSQL are presenting a message when I select the service. See the messages below:

Redis Data UI Deployment Online
This service has an active deployment
Required Variables
Ensure that the following variables are configured
REDISHOST
REDISPORT
REDISUSER
REDISPASSWORD
REDIS_URL

Postgres Data UI
This service has an active deployment
Required Variables
Ensure that the following variables are configured
PGHOST
PGPORT
PGUSER
PGPASSWORD
PGDATABASE
DATABASE_URL

The services are working normally but I am concerned with following points:
- do it mean I have a risk in my environment?
- are these variables supposed to be required?
- in the case they are required, why they have not been asked before? The template should not bring those variables filled?
- what are the instructions to populate these variables?

If any of you may have any suggestion on how I can manage this, I´d really appreciate your comments. Thanks

your not alone bro, im having the same issue too! will be keeping an eye on this thread. I see another template on here by jack that has the webhook processors built in but it meant me adding all API and credentials again to another environment so for now im waiting to confirm if its a template issue or if im just being thick and missing something. ive checked multiple things for many hours lol and still stuck with my webhooks from wait nodes and telegrams getting hung and stuck. @jack any suggestion dude? Use the other template?? lol

Suspicions were confirmed use Jack's other template on here which includes the web hooks it's worked for me now all of my triggers are working just fine

Did you ever fix this, I also have the same issue upon installing for the first time.

What issue are you having?

Redis and PostgreSQL are presenting error messages when I select the service. Messages below:

Redis Data UI Deployment Online
This service has an active deployment
Required Variables
Ensure that the following variables are configured
REDISHOST
REDISPORT
REDISUSER
REDISPASSWORD
REDIS_URL

Postgres Data UI
This service has an active deployment
Required Variables
Ensure that the following variables are configured
PGHOST
PGPORT
PGUSER
PGPASSWORD
PGDATABASE
DATABASE_URL

The services are working however I am concerned that this may cause more complex problems.

No I have not.

Ohh, you guys are talking about the data tab. It has no impact on the service, the databases intentionally use different variables so you cannot connect via the data tab. Last I known, it wasn’t as reliable and could impose additional issues.

Hello Jack and rest of the members.

I have an issue that I guess it will be simple to solve but I dont know how.
In order to upgrade my n8n to the latest version, I redeploy n8n. This is the correct way, right?

However, whenever I do this upgrade, I lose all my credentials and I have to reconnect every single one of them?

How do I solve this issue?
Is there any other way to upgrade n8n without re-deploying or is there a way to not lose the credentials when I re-deploy?

When I have to update the N8N version I just execute a redeploy in my services (all of them). It works fine for me and I have never lost any valuable data. I suggest you to try it on a safe environment first.

Curious if anyone knows if it is OK to set each of the 4 services in the group to "serverless"? I see that I can set even the postgres service to "serverless" but it isn't clear to me if this will wipe all data after sleeping. I can test this, but it would be nice to have a definitive way to know this.

From a data loss prospective, given this template is correctly setup with volumes for persistence, you won't lose any data from the app going to sleep or waking up.

From a functionality perspective, it's extremely unlikely that N8N was ever designed with app sleep (serverless) in mind, for example, N8N may not be able to cope with Postgres or Redis being asleep, for that to work N8N would need to know that it needs to retry requests to the databases as to give time for them to wake up, and the worker definitely can't be slept given it's not an HTTP service so it can never wake up.

The best I think you could do here is to enable serverless on the primary service, so that at least when it wakes up, it will have an immediate connection to the databases.

Question it's okay to redeploy? or restart? or i will lose eveything? i have been the template for like 5 months

Yes, worked out for me, the data is saved.

Recently updated the template to make use of n8n@1.79.0 allowing Redis over IPv6, supporting private networking.

If you want to take advantage of this change, make sure to deploy the latest versions and update your environment variables as example.

Redis (disable TCP public networking, do not modify REDIS_PASSWORD variable)
REDISHOST="${{RAILWAY_PRIVATE_DOMAIN}}"

REDISPORT="6379"

REDISUSER="default"

REDIS_URL="redis://${{REDISUSER}}:${{REDIS_PASSWORD}}@${{REDISHOST}}:${{REDISPORT}}"

RAILWAY_RUN_UID="0"

Primary
QUEUE_BULL_REDIS_DUALSTACK="true"

OFFLOAD_MANUAL_EXECUTIONS_TO_WORKERS="true"

N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS="true"

Worker
QUEUE_BULL_REDIS_DUALSTACK="true"

OFFLOAD_MANUAL_EXECUTIONS_TO_WORKERS="true"

N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS="true"

Jack, thank you for taking the time to update it and explain.

Quick question, do I still leave this in Redis?

REDIS_PRIVATE_URL="redis://${{REDISUSER}}:${{REDIS_PASSWORD}}@${{REDISHOST_PRIVATE}}:${{REDISPORT_PRIVATE}}"

REDISPORT="${{RAILWAY_TCP_PROXY_PORT}}"

REDISPORT_PRIVATE="6379"

or just 5 vars and a pass?

You'll only need the variables listed in the example above, plus the password variable. Assuming the main services still used the "public" version of the variables, the private ones are no longer necessary.

Youtube Upload node issue.
I have this n8n template deployed in my railway and having issues with my workflow that has a Youtube Upload node. there are only 2 main nodes in my workflow. first is trigger, 2nd is the Http Get node for the mp4 file which outputs into binary, third is the Youtube Upload node. Credentials are okay. There's a 'ghost' upload in my youtube channel for the video - with the description and title each time I run it but YT does not receive the video. I get the error after execution (error on the YT Upload node)

Converting circular structure to JSON --> starting at object with constructor 'TLSSocket' | property '_httpMessage' -> object with constructor 'ClientRequest' --- property 'socket' closes the circle

I've tried different things, like setting 2 variables in my Primary instance. and adding a Code node between my Http Get and YT Node to only output the binary.data

To add, this same workflow works on the n8n cloud version. Is there a bug with this node or am I missing something?

I'm sorry but this forum is not for 3rd party software support, for help with N8N, please ask in their forums.

I have been using this template without problems until I started to test MCP Server, it seems that there is some problem on the n8n side as MCP works with SSE and this is not compatible with gzip, so it is a functionality that right now cannot be used with this template.

From what I have seen in other forums, there are people using Traefik with n8n and disabling gzip in the Traefik configuration, from there you can use MCP.