A.78. Release 3.6.7

A.78.1. Bug fixes

• Add different pgpool.sysconfig file for RHEL6 and RHEL7. (bug 343) (Bo Peng)

  In RHEL6, the "-n" option is needed to redirect log.

• Fixing an issue in the handling of pg_terminate_backend(). (Muhammad Usama)

  In some cases pg_terminate_backend() can cause failover even when the call is properly issued through Pgpool-II.

• Fix for bug in watchdog where sometime failover is not reliably performed. (Muhammad Usama)

  Currently watchdog process only considers the node's watchdog state before deciding if it can handle the failover and failover-locking requests.

  But the problem with this technique is that, for the instance when the node has announced itself as a master/coordinator of the cluster and is waiting for the standby nodes to recognise it as a Master node. For that period of time the watchdog state of the node is Master/coordinator, but it is yet not fully capable of handling the failover and failover-locking requests.

  So sometimes this leads to a situation where a failover is not reliably performed in case when the failover request arrives while watchdog cluster is in the process of electing a leader.

  The fix for the above situation is to make sure that the node has fully acquired the Master status before accepting the failover and failover-locking requests.

• Fix bug with handling of 'H' (flush) message in streaming replication mode. (bug 345) (Tatsuo Ishii)

  If user expects to read response right after 'H', Pgpool-II hangs. The cause was, when 'H' received, extended query mode was reset and pending message was not used.

• Doc: Fix pcp_node_info documents. (Tatsuo Ishii)

• Fix bug mistakenly overriding global backend status right after failover. (Tatsuo Ishii)

  See [pgpool-general: 5728] for more details.

• Fix exit signal handlers to not call ereport. (Tatsuo Ishii)

  See [pgpool-hackers: 2545] for more details.

• Deal with OpenSSL 1.1. (Tatsuo Ishii, Muhammad Usama)

• Doc: Fix table about replicate_select behavior (Yugo Nagata)