n8n Crashed
1topby
HOBBYOP

a year ago

Please help me to understand system crash. For some reason the Postgress node has abruptly run out of space. I attach screenshots. Increased the space, restarted (ReDeployed all the nodes), but nothing help.

Solved$10 Bounty

Pinned Solution

a year ago

To reduce postgres size you’ll have to adjust or add some of the following variables:

https://docs.n8n.io/hosting/configuration/environment-variables/executions/

Basically have the data prune enabled and reduce the total time to delete or the number of executions or both.

21 Replies

1topby
HOBBYOP

a year ago


a year ago

You can check via df -h inside the Postgres that Railway actually mounted the expanded volume. Have you tried that?


testuser123

You can check via df -h inside the Postgres that Railway actually mounted the expanded volume. Have you tried that?

a year ago

They haven't grew their volume to begin with.


brody

They haven't grew their volume to begin with.

a year ago

That’s odd, I replicated the same thing and it worked for me. The volume was increased.

Then maybe it’s a hobby plan limitation.


testuser123

That’s odd, I replicated the same thing and it worked for me. The volume was increased. Then maybe it’s a hobby plan limitation.

a year ago

They have not attempted to grow their volume at all, they have not even pressed the button.


a year ago

Ouch 😂. Bro said he increased the space, which I presumed he meant the volume.


1topby
HOBBYOP

a year ago

Thank you for the answers.

Apparently, I misled you initially. I increased the RAM and CPU that were originally limited for the Postgress node (not DISK space).

A few questions. Please help me understand.

  1. I only have a button in Postgres to increase from 500 MB to 250 GB. Why do I need that much? I understand it is a Hobbie plan limitation?

  2. Why am I suddenly running out of space for the Postgres node? Although previously 2 months was enough for my several Workflows.

  3. How can I remove unnecessary stuff in it, optimize it? And what and how in n8n is taking up space in Postgres?


1topby
HOBBYOP

a year ago

Screenshot in Settings.

Attachments


1topby
HOBBYOP

a year ago

Another one. When I tried to push "Grow" button to resize maximum 500 MB to 1 GB there is an error.


a year ago

That's likely related to the current outage. Wait to troubleshoot until it's resolved.


1topby
HOBBYOP

a year ago

And what means 10$ bounty in my topic? I have contacted community support before. There were no rewards for answers.


1topby

And what means 10$ bounty in my topic? I have contacted community support before. There were no rewards for answers.

a year ago

Railway pays the bounty. Not you.


samgordon

Railway pays the bounty. Not you.

1topby
HOBBYOP

a year ago

I see. Thanks. Now the maximum disk space size has increased from 500 MB to 1 GB. But Postgres has such an inscription about pause in deployments. Is it some kind of work on the server?


1topby
HOBBYOP

a year ago

Guys, tell me please, what I need to do with Postgres in order not to delete my database? In N8N Primary, Work and Redis restarted and deployed after servers fall. Here is the screenshots.


1topby

Guys, tell me please, what I need to do with Postgres in order not to delete my database? In N8N Primary, Work and Redis restarted and deployed after servers fall. Here is the screenshots.

a year ago

Your database is safe, don’t worry.

I recommend you upgrade to Pro so you can have backups. It’s really important.

Also, try rolling back to the latest version that you remember was working (just go to that deploy and click the rollback button)


testuser123

Your database is safe, don’t worry. I recommend you upgrade to Pro so you can have backups. It’s really important. Also, try rolling back to the latest version that you remember was working (just go to that deploy and click the rollback button)

1topby
HOBBYOP

a year ago

You mean last version deploy in Postgress settings?


a year ago

Can be, but also the primary and worker.


testuser123

Can be, but also the primary and worker.

1topby
HOBBYOP

a year ago

Maybe you know some issues?

Why am I running out of space for the Postgres node? Although previously 2 months was enough for my several Workflows. What does the Postgres database space footprint depend on?

How can I remove unnecessary stuff in it, optimize Postgres database? And what and how in n8n is taking up space in Postgres?


1topby
HOBBYOP

a year ago

Screen

Attachments


a year ago

To reduce postgres size you’ll have to adjust or add some of the following variables:

https://docs.n8n.io/hosting/configuration/environment-variables/executions/

Basically have the data prune enabled and reduce the total time to delete or the number of executions or both.


1topby
HOBBYOP

a year ago

It works. Thanks for both advices (redeployment previous versions + adding some variables to Postgres.


Status changed to Solved chandrika about 1 year ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...