fly postgres db stop and don't restart alone

Questions / Help
1

Hi,
I do have a postgres database (created with “fly pg”).
flyio/postgres-flex:15.6@sha256:92917e5770cef6666dddbf17061c2f95b9e19b8155be9a8ce8c35e09e5381167
The machine is regularly stoping and not able to restart alone.
here are the logs :

2024-04-29T19:32:37.058 app[9185e769b95583] cdg [info] repmgrd | [2024-04-29 19:32:37] [INFO] monitoring primary node "fdaa:3:xxx (ID: 237618704) in normal state

2024-04-29T19:37:17.259 app[9185e769b95583] cdg [info] monitor | Voting member(s): 1, Active: 1, Inactive: 0, Conflicts: 0

2024-04-29T19:37:37.907 app[9185e769b95583] cdg [info] repmgrd | [2024-04-29 19:37:37] [INFO] monitoring primary node "fdaa:3:xxx" (ID: 237618704) in normal state

2024-04-29T19:42:17.174 app[9185e769b95583] cdg [info] Current connection count is 1

2024-04-29T19:42:18.055 app[9185e769b95583] cdg [info] INFO Main child exited normally with code: 0

2024-04-29T19:42:18.056 app[9185e769b95583] cdg [info] WARN Reaped child process with pid: 344 and signal: SIGKILL, core dumped? false

2024-04-29T19:42:18.057 app[9185e769b95583] cdg [info] WARN Reaped child process with pid: 347 and signal: SIGKILL, core dumped? false

2024-04-29T19:42:18.058 app[9185e769b95583] cdg [info] WARN Reaped child process with pid: 350 and signal: SIGKILL, core dumped? false

2024-04-29T19:42:18.059 app[9185e769b95583] cdg [info] WARN Reaped child process with pid: 399 and signal: SIGKILL, core dumped? false

2024-04-29T19:42:18.067 app[9185e769b95583] cdg [info] INFO Starting clean up.

2024-04-29T19:42:18.078 app[9185e769b95583] cdg [info] INFO Umounting /dev/vdc from /data

2024-04-29T19:42:18.079 app[9185e769b95583] cdg [info] ERROR error umounting /data: EBUSY: Device or resource busy, retrying in a bit

2024-04-29T19:42:18.080 app[9185e769b95583] cdg [info] WARN hallpass exited, pid: 322, status: signal: 15 (SIGTERM)

2024-04-29T19:42:18.090 app[9185e769b95583] cdg [info] 2024/04/29 19:42:18 listening on [fdaa:3:xxx]:22 (DNS: [fdaa::3]:53)

2024-04-29T19:42:18.834 app[9185e769b95583] cdg [info] WARN could not unmount /rootfs: EINVAL: Invalid argument

2024-04-29T19:42:18.834 app[9185e769b95583] cdg [info] [ 3602.229246] reboot: Restarting system

2024-04-29T19:42:18.955 runner[9185e769b95583] cdg [info] machine exited with exit code 0, not restarting

does sb have an idea what can I try to solve the issue ?

2

Hey there,

It looks like you have FLY_SCALE_TO_ZERO=1h set, which may explain why your Machine is regularly stopping. Was this intentionally configured?

1 Like
3

indeed, thank you very much !
It was not intended.

1 Like
4

do you know how can I modify this ?
As I don’t have access to the toml file, I am a bit lost ^^

Do we have a command like “flyctl config unset FLY_SCALE_TO_ZERO”

5

solution found here

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.