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

[Tatsuo Ishii]

> 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