[pgpool-general: 8858] pgpool cannot work inside systemd daemon service
Zhaoxun Yan
yan.zhaoxun at gmail.com
Fri Jun 30 16:02:56 JST 2023
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>
More information about the pgpool-general
mailing list