[pgpool-general: 8858] pgpool cannot work inside systemd daemon service

[Zhaoxun Yan]

Hi guys!

I want systemd to monitor pgpool and restart another once it found it is
dead. So here is this simple service named as auto_pgpool.service

[Unit]
Description=run pgpool after auto_pgha service ## <-change run_XXX.sh

[Service]
Type=simple
ExecStart=/usr/bin/pgpool ## <-change run_XXX.sh
Restart=on-failure
RestartSec=3
## systemd bears daemon duty

[Install]
WantedBy=multi-user.target

But it always failed and caused systemd to restart it again and again - *is
it a false positive? and how can I avoid it?*

Jun 30 14:48:13 yzx1 systemd[1]: Started run pgpool after auto_pgha service
## <-change run_XXX.sh.
░░ Subject: A start job for unit auto_pgpool.service has finished
successfully
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ A start job for unit auto_pgpool.service has finished successfully.
░░
░░ The job identifier is 10863.
Jun 30 14:48:13 yzx1 pgpool[5575]: pgpool-II version 4.4.3 (nurikoboshi),
Jun 30 14:48:13 yzx1 pgpool[5575]:   A generic connection
pool/replication/load balance server for PostgreSQL
Jun 30 14:48:13 yzx1 pgpool[5575]: Usage:
Jun 30 14:48:13 yzx1 pgpool[5575]:   pgpool [ -c] [ -f CONFIG_FILE ] [ -F
PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ]
Jun 30 14:48:13 yzx1 pgpool[5575]:          [ -n ] [ -D ] [ -d ]
Jun 30 14:48:13 yzx1 pgpool[5575]:   pgpool [ -f CONFIG_FILE ] [ -F
PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ]
Jun 30 14:48:13 yzx1 pgpool[5575]:          [ -m SHUTDOWN-MODE ] stop
Jun 30 14:48:13 yzx1 pgpool[5575]:   pgpool [ -f CONFIG_FILE ] [ -F
PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ] reload
Jun 30 14:48:13 yzx1 pgpool[5575]: Common options:
Jun 30 14:48:13 yzx1 pgpool[5575]:   -a, --hba-file=HBA_CONFIG_FILE
Jun 30 14:48:13 yzx1 pgpool[5575]:                       Set the path to
the pool_hba.conf configuration file
Jun 30 14:48:13 yzx1 pgpool[5575]:                       (default:
/usr/etc/pool_hba.conf)
Jun 30 14:48:13 yzx1 pgpool[5575]:   -f, --config-file=CONFIG_FILE
Jun 30 14:48:13 yzx1 pgpool[5575]:                       Set the path to
the pgpool.conf configuration file
Jun 30 14:48:13 yzx1 pgpool[5575]:                       (default:
/usr/etc/pgpool.conf)
Jun 30 14:48:13 yzx1 pgpool[5575]:   -k, --key-file=KEY_FILE
Jun 30 14:48:13 yzx1 pgpool[5575]:                       Set the path to
the pgpool key file
Jun 30 14:48:13 yzx1 pgpool[5575]:                       (default:
/root/.pgpoolkey)
Jun 30 14:48:13 yzx1 pgpool[5575]:                       can be over ridden
by PGPOOLKEYFILE environment variable
Jun 30 14:48:13 yzx1 pgpool[5575]:   -F, --pcp-file=PCP_CONFIG_FILE
Jun 30 14:48:13 yzx1 pgpool[5575]:                       Set the path to
the pcp.conf configuration file
Jun 30 14:48:13 yzx1 pgpool[5575]:                       (default:
/usr/etc/pcp.conf)
Jun 30 14:48:13 yzx1 pgpool[5575]:   -h, --help          Print this help
Jun 30 14:48:13 yzx1 pgpool[5575]: Start options:
Jun 30 14:48:13 yzx1 pgpool[5575]:   -C, --clear-oidmaps Clear query cache
oidmaps when memqcache_method is memcached
Jun 30 14:48:13 yzx1 pgpool[5575]:                       (If shmem,
discards whenever pgpool starts.)
Jun 30 14:48:13 yzx1 pgpool[5575]:   -n, --dont-detach   Don't run in
daemon mode, does not detach control tty
Jun 30 14:48:13 yzx1 pgpool[5575]:   -x, --debug-assertions   Turns on
various assertion checks, This is a debugging aid
Jun 30 14:48:13 yzx1 pgpool[5575]:   -D, --discard-status Discard
pgpool_status file and do not restore previous status
Jun 30 14:48:13 yzx1 pgpool[5575]:   -d, --debug         Debug mode
Jun 30 14:48:13 yzx1 pgpool[5575]: Stop options:
Jun 30 14:48:13 yzx1 pgpool[5575]:   -m, --mode=SHUTDOWN-MODE
Jun 30 14:48:13 yzx1 pgpool[5575]:                       Can be "smart",
"fast", or "immediate"
Jun 30 14:48:13 yzx1 pgpool[5575]: Shutdown modes are:
Jun 30 14:48:13 yzx1 pgpool[5575]:   smart       quit after all clients
have disconnected
Jun 30 14:48:13 yzx1 pgpool[5575]:   fast        quit directly, with proper
shutdown
Jun 30 14:48:13 yzx1 pgpool[5575]:   immediate   the same mode as fast
*Jun 30 14:48:13 yzx1 systemd[1]: auto_pgpool.service: Main process exited,
code=exited, status=1/FAILURE*
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ An ExecStart= process belonging to unit auto_pgpool.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Jun 30 14:48:13 yzx1 systemd[1]: auto_pgpool.service: Failed with result
'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ The unit auto_pgpool.service has entered the 'failed' state with result
'exit-code'.
Jun 30 14:48:16 yzx1 systemd[1]: auto_pgpool.service: Scheduled restart
job, restart counter is at 167.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230630/b482f509/attachment.htm>