[pgpool-committers: 6196] Re: pgpool: Adding new wd_cli utility
Muhammad Usama
m.usama at gmail.com
Tue Sep 24 15:20:36 JST 2019
Hi Tatsuo
I have not changed/removed the 'lifecheck started" message and I am getting
clean
regression including this test case.
testing 028.watchdog_enable_consensus_with_half_votes...ok.
out of 1 ok:1 failed:0 timeout:0
Can you send me the pgpool.log for a failed test case? It could be some
other issue that was
preventing the pgpool-II to start up in time.
Thanks
Best Regards
Muhammad Usama
On Tue, Sep 24, 2019 at 6:41 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> Hi Usama,
>
> After this commit regresson 028 keeps on failing:
>
> testing 028.watchdog_enable_consensus_with_half_votes...timeout.
>
> in the regression log:
>
> waiting for watchdog node 0 starting up...
>
> The test script looks for a particular message:
>
> grep "lifecheck started" $log >/dev/null
>
> Have changed or removed the log message in your commit?
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> From: Muhammad Usama <m.usama at gmail.com>
> Subject: [pgpool-committers: 6193] pgpool: Adding new wd_cli utility
> Date: Mon, 23 Sep 2019 20:43:21 +0000
> Message-ID: <E1iCVB3-0007dP-8Q at gothos.postgresql.org>
>
> > Adding new wd_cli utility
> >
> > wd_cli makes it easier to integrate the external health check systems
> with the
> > Pgpool-II. It provides a very convenient and easy to use interface to
> interact with
> > watchdog and perform health check related node operations.
> >
> > For example:
> > If some external health-check system monitoring the health of the
> watchdog
> > cluster detects the remote node failure. It can use wd_cli utility to
> inform
> > Pgpool-II about that node failure
> >
> > $wd_cli --inform DEAD -N 'Remote watchdog name' -p 9001 -m 'node 1
> failed'
> >
> > Similarly when the node becomes reachable again
> >
> > $wd_cli --inform ALIVE -N 'Remote watchdog name' -p 9001 -m 'node
> 1 found'
> >
> > This utility can also be used to get the live information of all nodes.
> >
> > $wd_cli -f simple_conf/watchdog/pgpool_wd1.conf --info -v --all
> >
> > Total Watchdog nodes configured for lifecheck: 2
> > *****************
> > Node ID: 0
> > Node Status code 4
> > Node Status: MASTER
> > Node Name: localhost:9991 Linux localhost.localdomain
> > Node Host: localhost
> > Node WD Port: 9001
> > Node Pgpool Port: 9991
> >
> > Node ID: 1
> > Node Status code 7
> > Node Status: STANDBY
> > Node Name: localhost:9992 Linux localhost.localdomain
> > Node Host: localhost
> > Node WD Port: 9002
> > Node Pgpool Port: 9992
> >
> > wd_cli provides many options for node search criteria.
> > See wd_cli --help for complete list of options.
> >
> > The commit also re-arrange the code related to socket communication and
> > watchdog IPC commands and separates the internal and external watchdog
> > commands to make the code structure more modular.
> >
> > The regression tests and documentation updates are not part of this
> commit
> > and will be taken care of separately.
> >
> > Branch
> > ------
> > master
> >
> > Details
> > -------
> >
> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=6156534a7073bc6446b9bcccc1ed4a846fa82f34
> >
> > Modified Files
> > --------------
> > configure | 3 +-
> > configure.ac | 2 +-
> > src/Makefile.am | 1 +
> > src/Makefile.in | 17 +-
> > src/include/utils/fe_ports.h | 13 +-
> > src/include/utils/json_writer.h | 2 +-
> > src/include/utils/pool_stream.h | 7 +-
> > src/include/utils/socket_stream.h | 36 +
> > src/include/watchdog/wd_commands.h | 66 ++
> > .../{wd_ipc_commands.h => wd_internal_commands.h} | 66 +-
> > src/include/watchdog/wd_ipc_conn.h | 57 ++
> > src/include/watchdog/wd_ipc_defines.h | 2 +-
> > src/include/watchdog/wd_json_data.h | 14 -
> > src/include/watchdog/wd_lifecheck.h | 4 +-
> > src/main/pgpool_main.c | 10 +-
> > src/pcp_con/pcp_worker.c | 4 +-
> > src/pcp_con/recovery.c | 2 +-
> > src/protocol/child.c | 16 +-
> > src/protocol/pool_connection_pool.c | 4 +-
> > src/protocol/pool_process_query.c | 8 +-
> > src/tools/Makefile.am | 7 +-
> > src/tools/Makefile.in | 7 +-
> > src/tools/watchdog/Makefile.am | 74 ++
> > src/tools/watchdog/Makefile.in | 771
> +++++++++++++++++++++
> > src/tools/watchdog/wd_cli.c | 749
> ++++++++++++++++++++
> > src/utils/pool_stream.c | 138 +---
> > src/utils/psprintf.c | 4 +-
> > src/utils/socket_stream.c | 195 ++++++
> > src/watchdog/Makefile.am | 2 +
> > src/watchdog/Makefile.in | 3 +
> > src/watchdog/watchdog.c | 14 +-
> > src/watchdog/wd_commands.c | 757
> ++++----------------
> > src/watchdog/wd_internal_commands.c | 496 +++++++++++++
> > src/watchdog/wd_ipc_conn.c | 282 ++++++++
> > src/watchdog/wd_json_data.c | 86 ---
> > src/watchdog/wd_lifecheck.c | 12 +-
> > 36 files changed, 2946 insertions(+), 985 deletions(-)
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-committers/attachments/20190924/22fbc817/attachment.html>
More information about the pgpool-committers
mailing list