<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div><span><div>Hi,</div><div><br></div><div>I have a problem with pgpool 3.7.2 and pgpool 3.7.3, but not with pgpool 3.7.1 so it might be a bug.</div><div><br></div><div>When there is a failover from node 1 to node 0 then the parameter %P (old primary id) which is passed to the failover script is incorrect. It says 0 instead of 1. I encounter the error systematically when I do a first failover from node 0 to node 1, then a recovery of node 0, then a new failover from node 1 to node 0. In this new failover - from node 1 to node 0 - the parameter old_primary_id is not correctly passed.</div><div><br></div><div>I have reverted back to pgpool 3.7.1 and the problem has disappeared.</div><div><br></div><div>My config, for failover_command, is:</div><div><br></div><div><span><div>failover_command = '/scripts/failover.sh %d %h %p %D %m %H %M %P %r %R'</div><div> # Executes this command at failover</div><div> # Special values:</div><div> # %d = node id</div><div> # %h = host name</div><div> # %p = port number</div><div> # %D = database cluster path</div><div> # %m = new master node id</div><div> # %H = hostname of the new master node</div><div> # %M = old master node id</div><div> # %P = old primary node id</div><div> # %r = new master port number</div><div><br></div></span>and in the log I see that the parameter %P is incorrect with pgpool 3.7.3 and pgpool 3.7.2 but that it is correct with pgpool 3.7.1</div><div><br></div><div>I can provide more logs and configuration if needed</div><div><br></div></span>Kind regards, </div><div><br></div><div class="ydp7ab1edefsignature">Pierre</div></div>
<div><br></div><div><br></div>
<div id="ydpc09d519byahoo_quoted_6723827679" class="ydpc09d519byahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div><br></div>
</div>
</div></div></body></html>