Release 4.0.7

A.39.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)