[pgpool-general: 8867] Re: pgpool cannot work inside systemd daemon service
Bo Peng
pengbo at sraoss.co.jp
Wed Jul 5 13:43:54 JST 2023
Hi,
> And here is the running result (automatically killed by systemd):
>
> Jul 03 17:36:48 yzx1 systemd[1]: Started run pgpool.
> Jul 03 17:36:48 yzx1 systemd[1]: auto_pgpool.service: Deactivated
> successfully.
Could you run the script directly to start Pgpool-II without using systemd?
On Mon, 3 Jul 2023 17:42:19 +0800
Zhaoxun Yan <yan.zhaoxun at gmail.com> wrote:
> [Unit]
> Description=run pgpool
>
> [Service]
> After=network.service
> Type=simple
> ExecStart=/bin/bash /root/pgpool.sh ## <-change run_XXX.sh
> Restart=on-failure
> RestartSec=3
> ## systemd bears daemon duty
>
> [Install]
> WantedBy=multi-user.target
>
> /root/pgpool.sh
> /usr/bin/pgpool
>
>
> And here is the running result (automatically killed by systemd):
>
> Jul 03 17:36:48 yzx1 systemd[1]: Started run pgpool.
> Jul 03 17:36:48 yzx1 systemd[1]: auto_pgpool.service: Deactivated
> successfully.
> Jul 03 17:36:51 yzx1 sshd[4558]: Invalid user shinken from 180.168.95.234
> port 57152
> Jul 03 17:36:51 yzx1 sshd[4558]: Received disconnect from 180.168.95.234
> port 57152:11: Bye Bye [pr>
> Jul 03 17:36:51 yzx1 sshd[4558]: Disconnected from invalid user shinken
> 180.168.95.234 port 57152 [>
> Jul 03 17:37:28 yzx1 sshd[4561]: Invalid user admin from 43.154.95.120 port
> 60548
> Jul 03 17:37:28 yzx1 sshd[4561]: Received disconnect from 43.154.95.120
> port 60548:11: Bye Bye [pre>
> Jul 03 17:37:28 yzx1 sshd[4561]: Disconnected from invalid user admin
> 43.154.95.120 port 60548 [pre>
>
> On Mon, Jul 3, 2023 at 4:35 PM Bo Peng <pengbo at sraoss.co.jp> wrote:
>
> > Hi,
> >
> > On Fri, 30 Jun 2023 15:02:56 +0800
> > Zhaoxun Yan <yan.zhaoxun at gmail.com> wrote:
> >
> > > 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*
> >
> > It seems "pgpool" command failed.
> > Could you run run_XXX.sh script to start pgpool?
> >
> > > ░░ 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.
> >
> >
> > --
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS LLC
> > TEL: 03-5979-2701 FAX: 03-5979-2702
> > URL: https://www.sraoss.co.jp/
> >
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/
More information about the pgpool-general
mailing list