App won't start in engine unix when using node-postgres

[janliska]

Hi guys,

I'm having issues starting application when using nginx unit.
Container starts but it ends in loop of /usr/local/bin/docker-entrypoint.sh: Waiting for control socket to be removed... and it never finishes.
When I remove the postgres client all works well. I've tried to close the client connection on sigterm but with no luck.

Did anybody meet the same issue?

I've prepared simple demo app to reproduce the issue: https://github.com/janliska/pgsql-nginx-unit-issue

[brianc]

looks like your app (in your example repo at least) is establishing a single postgres connection & never closing it.

you might want to try passing allowExitOnIdle to the pool:

const pool = new pg.Pool({ allowExitOnIdle: true })

or set a very short idleTimeoutMillis on the pool & use a connection pool for this. That way connections will be closed gracefully if they're not in use, allowing for a "clean" exit.

[janliska]

I've tried to close the client connection on sigterm (actually not only sigterm, also signint, exit and bunch of others), but it didn't help. It is not in the repo, but I tried something like process.on('SIGTERM', () => client.close());.

But I'll try the pool, thanks for tip :-)

[brianc]

@rightaway brianc/node-postgres-docs#151

[brianc]

closing unless I hear something else - @janliska hope you got everything worked out on your end!