[pgpool-general: 9332] Re: error in first stage of recovery

[Adam Blomeke]

I can spit out all the functions if you really need them (there's a LOT) but here are the ones for pgpool_recovery:

                                                                                                                                                         | func
 public | pgpool_recovery                           | boolean             | script_name text, remote_host text, remote_data_directory text
                                                                                                                                                         | func
 public | pgpool_recovery                           | boolean             | script_name text, remote_host text, remote_data_directory text, primary_port text
                                                                                                                                                         | func
 public | pgpool_recovery                           | boolean             | script_name text, remote_host text, remote_data_directory text, primary_port text, remote_node integer
                                                                                                                                                         | func
 public | pgpool_recovery                           | boolean             | script_name text, remote_host text, remote_data_directory text, primary_port text, remote_node integer, remote_port text
                                                                                                                                                         | func
 public | pgpool_recovery                           | boolean             | script_name text, remote_host text, remote_data_directory text, primary_port text, remote_node integer, remote_port text, primary_host text
                                                                                                                                                         | func


-----Original Message-----
From: Tatsuo Ishii <ishii at postgresql.org> 
Sent: Tuesday, February 4, 2025 20:17
To: Adam Blomeke <adam.blomeke at volanno.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 9330] error in first stage of recovery

[You don't often get email from ishii at postgresql.org. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

> I am working on setting up a new pgpool cluster. I've gotten load balancing working well and am now trying to implement failover and recovery.   I have a two-node cluster running pg15 and using streaming replication. To start with I am merely attempting shut off my secondary server and fail it back. I can manually reattach the node using pcp_attach_node and that works successfully. When I run the pcp_recovery_node command, however, I get the helpful error of:
>
> ERROR: executing recovery, execution of command failed at "1st stage"
> DETAIL: command:"/etc/pgpool-II/scripts/replication_mode_recovery_1st_stage.sh"
>
> I figured out that I need to look at my primary server's postgres logs and there I found this:
> < usr:repl host:10.6.1.191 time:2025-02-03 16:49:20.627 EST 42883 
> pid:2098668 >ERROR: function pgpool_recovery(unknown, unknown, unknown, unknown, integer, unknown, unknown) does not exist at character 8 < usr:repl host:10.6.1.191 time:2025-02-03 16:49:20.627 EST 42883 pid:2098668 >HINT: No function matches the given name and argument types. You might need to add explicit type casts.
> < usr:repl host:10.6.1.191 time:2025-02-03 16:49:20.627 EST 42883 
> pid:2098668 >STATEMENT: SELECT 
> pgpool_recovery('/etc/pgpool-II/scripts/replication_mode_recovery_1st_
> stage.sh, '10.6.1.131', '/opt/data/data15_new', '5433', 1, '5433', 
> '10.6.1.129')
>
> Looking at a prior email chain that went unresolved, I checked my versions and there might be a mismatch:
>
> nasdw_apps=# \dx pgpool_recovery
> List of installed extensions
> Name | Version | Schema | Description
> -----------------+---------+--------+---------------------------------
> -----------------+---------+--------+----------
> pgpool_recovery | 1.4 | public | recovery functions for pgpool-II for 
> V4.3
> (1 row)
>
> If that's the case, I don't know how. It installed version 4.5 when I ran dnf:

That's normal. It means the extention can be used for V4.3 or later, including 4.5.

> Let me know if there's anything else that I should submit. I'm using 
> the sample replication_mode_recovery_1st_stage script with variables 
> set for my local DB instances.

Can you share the output of "\df" command?

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp