rgmvisser Posts - Answer Overflow

rgmvisser

•Created by rgmvisser on 10/27/2023 in #✋｜help

Should I switch to the new way of deploying Postgres & Redis?

I am still using the Postgres and Redis plugins, is it recommended to move them over to the new way of deploying services with a mounted volume? Project 9e28999f-05b9-4b5c-9caf-7a1d7bd55312

5 replies

RRailway

•Created by rgmvisser on 8/12/2023 in #✋｜help

idle_in_transaction_session_timeout for idle connections

I have the following problem where some of my DB connections become IDLE and prisma is not cleaning them up nicely for some reason. I want to set SET SESSION idle_in_transaction_session_timeout = '5min'; in postgres to automatically clean these up in case they get stale. Any reason why I should not change this session timeout from unlimited (0) to 5 min?

4 replies

RRailway

•Created by rgmvisser on 7/3/2023 in #✋｜help

Catch Sigterm NodeJS

When deploying a new version, I see the following in my console:

npm ERR! path /myapp
npm ERR! command failed
npm ERR! signal SIGTERM
npm ERR! command sh -c -- npx prisma migrate deploy && npm run start
npm ERR! A complete log of this run can be found in:
npm ERR!     /root/.npm/_logs/2023-06-30T16_08_55_359Z-debug-0.log

npm ERR! path /myapp
npm ERR! command failed
npm ERR! signal SIGTERM
npm ERR! command sh -c -- npx prisma migrate deploy && npm run start
npm ERR! A complete log of this run can be found in:
npm ERR!     /root/.npm/_logs/2023-06-30T16_08_55_359Z-debug-0.log

I would like to catch this signal to make sure I gracefully shutdown the service. However, when I try to catch the SIGTERM it doesn't seem to get fired in my process (log line doesn't show up)?

process.on("SIGTERM", () => {
  console.log("Shutting down!");
});

process.on("SIGTERM", () => {
  console.log("Shutting down!");
});

Is there something else I am missing? Project id: 9e28999f-05b9-4b5c-9caf-7a1d7bd55312

10 replies

RRailway

•Created by rgmvisser on 7/3/2023 in #✋｜help

Metrics not showing Postgres and Redis plugin

7 replies

RRailway

•Created by rgmvisser on 1/29/2023 in #✋｜help

Redis maxmemory-policy setting

Hi! Is it possible for me to change the Redis "maxmemory-policy" setting? For BullMQ I need to set this to "noeviction" to make sure the queue works properly. Is this possible? Thanks in advance! Cheers, Ruud

7 replies

Gaming

Programming