n8n Crashed
1topby
HOBBYOP

9 months 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

9 months 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

9 months ago


9 months 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?

9 months ago

They haven't grew their volume to begin with.


brody

They haven't grew their volume to begin with.

9 months 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.

9 months ago

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


9 months ago

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


1topby
HOBBYOP

9 months 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

9 months ago

Screenshot in Settings.

Attachments


1topby
HOBBYOP

9 months ago

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


9 months ago

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


1topby
HOBBYOP

9 months 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.

9 months ago

Railway pays the bounty. Not you.


samgordon

Railway pays the bounty. Not you.

1topby
HOBBYOP

9 months 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

9 months 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.

9 months 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

9 months ago

You mean last version deploy in Postgress settings?


9 months ago

Can be, but also the primary and worker.


testuser123

Can be, but also the primary and worker.

1topby
HOBBYOP

9 months 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

9 months ago

Screen

Attachments


9 months 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

9 months ago

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


Status changed to Solved chandrika 9 months ago


Loading...