Release 4.0.7

Release Date: 2019-10-31

A.28.1. Bug fixes

  • Fix incorrect query rewrite in replication mode. (Bo Peng)

  • Fix that health check timeout does work in certain case. (Tatsuo Ishii)

    Discussion: [pgpool-hackers: 3458] , [pgpool-hackers: 3459]

  • Doc: add failover_command description when all standby nodes are down. (Takuma Hoshiai)

  • Doc: add note not to assign PostgreSQL servers to trusted_servers . (Tatsuo Ishii)

  • Fix for miscellaneous watchdog issues. (Muhammad Usama)

    The lost nodes reported by life-check are treated as hard failures even when the node is reachable from the watchdog core.

    In the case of network partitioning or partial life-check failure, the kicked out standby node was too aggressive in trying to connect to the master or become a master itself so that potentially put the unnecessary burden on the network and the cluster nodes. Fix is to make the isolated node a bit calm and wait between trying to connect to master or become a master.

    See details: ( bug 547 ), [pgpool-general: 6672]

  • Fix assorted ancient v2 protocol bugs. (Tatsuo Ishii)

  • Fix problem that syslog_facility doesn't change by reload. ( bug 548 ) (Takuma Hoshiai)

  • Fix Pgpool-II shutdown failed in certain case. (Tatsuo Ishii)

  • Allow the lost standby node to rejoin the master watchdog node when it gets rediscovered by the lifecheck. ( bug 545 ) (Muhammad Usama)

  • Overhaul health check debug facility. (Tatsuo Ishii)

  • Fix segfault when executing an erroneous query after DEALLOCATE a named statement. ( bug 546 ) (Tatsuo Ishii)

  • Doc: clarify that certificate authentication works between only client and Pgpool-II . (Tatsuo Ishii)

  • Doc: update configuration Examples "Pgpool-II + Watchdog Setup Example". (Bo Peng)

  • Doc: mention that VIP will not be brought up if quorum does not exist. (Tatsuo Ishii)

  • Fix pgpool_setup to deal with PostgreSQL 9.1. (Tatsuo Ishii)

  • Fix for password authentication does not work when the password for the connecting user is not found in the pool_passwd file. ( bug 534 ) (Muhammad Usama)

  • Add "-I" option to arping_cmd command default setting. (Bo Peng)