[pgpool-general: 8243] Re: pcp_recovery_node command fails
todd.stein at microfocus.com
Fri Jun 24 05:07:34 JST 2022
This is the stdout:
ERROR: executing recovery, execution of command failed at "1st stage"
The pgpool logs don't have much useful info. Even when I set them to debug, it's not very helpful.
This seems to be a pretty common issue, lots of people post about the issue, but I've not seen a resolution to it yet.
the postgres log is actually more useful:
ERROR: function pgpool_recovery(unknown, unknown, unknown, unknown, integer, unknown, unknown) does not exist at character 8
2022-06-23 16:03:53.740 EDT  HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-06-23 16:03:53.740 EDT  STATEMENT: SELECT pgpool_recovery('recovery_1st_stage', 'nodea', '/var/lib/pgsql/12/data', '5432', 0, '5432', 'nodeb')
From: pgpool-general <pgpool-general-bounces at pgpool.net> On Behalf Of Jon SCHEWE
Sent: Thursday, June 23, 2022 3:34 PM
To: Todd Stein <todd.stein at microfocus.com>; pgpool-general at pgpool.net
Subject: [pgpool-general: 8242] Re: pcp_recovery_node command fails
> I'm trying to use pcp_recovery_node for online recovery in a pgpool/postgresql-12 cluster.
> My cluster has PostgreSQL 12.8 and pgpool 4.3.2 running on CentOS 7.9 linux.
> I've tried so many things, I'll not go into those details just yet.
> To start with, here is the output of the pcp_recovery_node command:
> pcp_recovery_node -U postgres -h <VIP> -p 9898 -n 0
> ERROR: executing recovery, execution of command failed at "1st stage"
> DETAIL: command:"recovery_1st_stage"
Do you see anything in your logs about the errors? Usually this is either on stdout from the service or in /var/log/pgpool...
I'm guessing that your recovery_1st_stage script either isn't defined or isn't doing what you expect.
pgpool-general mailing list
pgpool-general at pgpool.net
More information about the pgpool-general