[pgpool-general: 7386] Re: ERROR: executing recovery, execution of command failed at "1st stage"

[Murat K]

template1=# exit
-bash-4.2$ psql template1 -c "CREATE EXTENSION pgpool_recovery"
ERROR:  extension "pgpool_recovery" already exists
-bash-4.2$


[root at zile ~]#  pcp_recovery_node -h 192.168.vip.vip -p 5432 -U pgpool -n 1
Password:
ERROR: unable to read data from socket.

[root at zile ~]# tail -10 /var/lib/pgsql/13/data/log/postgresql-Wed.log
2021-01-06 08:54:25.465 +03 [29639] FATAL:  the database system is shutting
down
2021-01-06 08:54:25.470 +03 [1446] LOG:  database system is shut down
2021-01-06 08:54:47.739 +03 [1094] LOG:  starting PostgreSQL 13.1 on
x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
4.8.5-44), 64-bit
2021-01-06 08:54:47.739 +03 [1094] LOG:  listening on IPv4 address
"0.0.0.0", port 5432
2021-01-06 08:54:47.739 +03 [1094] LOG:  listening on IPv6 address "::",
port 5432
2021-01-06 08:54:47.739 +03 [1094] LOG:  listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5432"
2021-01-06 08:54:47.740 +03 [1094] LOG:  listening on Unix socket
"/tmp/.s.PGSQL.5432"
2021-01-06 08:54:47.786 +03 [1292] LOG:  database system was shut down at
2021-01-06 08:54:25 +03
2021-01-06 08:54:47.913 +03 [1094] LOG:  database system is ready to accept
connections
2021-01-06 09:01:14.477 +03 [1809] LOG:  invalid length of startup packet

[root at zile ~]# tail -10 /var/log/pgpool_log/pgpool-2021-01-06_085447.log
2021-01-06 08:54:59: pid 1148: LOG:  new IPC connection received
2021-01-06 08:54:59: pid 1088: LOG:  watchdog cluster now holds the quorum
2021-01-06 08:54:59: pid 1088: DETAIL:  updating the state of quarantine
backend nodes
2021-01-06 08:54:59: pid 1148: LOG:  new IPC connection received
2021-01-06 08:55:03: pid 1399: LOG:  successfully acquired the delegate
IP:"192.168.vip.vip"
2021-01-06 08:55:03: pid 1399: DETAIL:  'if_up_cmd' returned with success
2021-01-06 08:55:03: pid 1148: LOG:  watchdog escalation process with pid:
1399 exit with SUCCESS.
2021-01-06 08:55:04: pid 1148: LOG:  new outbound connection to turhal:9000
2021-01-06 08:55:04: pid 1148: LOG:  new outbound connection to niksar:9000
2021-01-06 08:56:38: pid 1354: LOG:  watchdog: lifecheck started
[root at zile ~]#

Thanks

On Wed, Jan 6, 2021 at 4:15 AM Bo Peng <pengbo at sraoss.co.jp> wrote:

> Hi,
>
> On Tue, 5 Jan 2021 18:02:26 +0300
> Murat K <srvrmurat at gmail.com> wrote:
>
> > Hi All,
> >
> > I am implementing Pgpool-II + Watchdog Setup Example
> > <https://www.pgpool.net/docs/42/en/html/example-cluster.html> . I
> managed
> > to install pgpool 4.2.1  and run but having problems with online recovery
> > (pcp_recovery_node) and switchover/failover scenarios.
> >
> > # pcp_recovery_node -h vip.vip.vip.vip -p 9898 -U pgpool -n 1
> > Password:
> > ERROR:  executing recovery, execution of command failed at "1st stage"
> > DETAIL:  command:"recovery_1st_stage"
> >
> > I reviewed failover, follow primary, recovery_1st_stage scripts but could
> > not make it work.
> > Can somebody shed some light?
>
> Did you execute "CREATE EXTENSION ..." following this section?
>
>
> https://www.pgpool.net/docs/42/en/html/example-cluster.html#EXAMPLE-CLUSTER-PGPOOL-CONFIG-ONLINE-RECOVERY
>
> If you could share the pgpool log, I may figure out the cause.
>
> > Regards,
> > murat
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20210106/4cba78d5/attachment.htm>