Release 4.1.8

Release Date: 2021-08-05

A.17.1. Changes

  • Fix maximum length of hostnames including domain name. (Tatsuo Ishii)

    The maximum length of hostnames was 128, but the correct value is 254. Discussion: [pgpool-hackers: 3903]

A.17.2. Bug fixes

  • Fix query cache to not cache SQLValueFunctions . (Tatsuo Ishii)

    The list of SQLValueFunctions is follow.

    • CURRENT_DATE

    • CURRENT_TIME

    • CURRENT_TIMESTAMP

    • LOCALTIME

    • LOCALTIMESTAMP

    • CURRENT_ROLE

    • CURRENT_USER

    • SESSION_USER

    • USER

    • CURRENT_CATALOG

    • CURRENT_SCHEMA

  • Fix client side hang when describe message is followed by NoData response. (Tatsuo Ishii)

    Problem reported and patch provided by Daniel van de Giessen. Discussion: [pgpool-hackers: 3950]

  • Fix sending invalid message in SI mode. (Tatsuo Ishii)

    When a query is aborted by specific reason like serialization error, Pgpool-II sends error query to abort transactions running on non main nodes. The message length of the query was incorrect and it caused "invalid string in message" error on backend.

  • Fix orphan process is left when pgpool is going down. (Tatsuo Ishii)

    When pgpool is going down while follow primary command is ongoing, some process started by follow primary child process could be left.

  • Fix pcp_detach_node leaves down node. (Tatsuo Ishii)

    As detaching primary node using pcp_detach_node , a standby node is kept down status after follow primary command was executed. Discussion: [pgpool-hackers: 3915]

  • Fix backend_application_name cannot be changed by reloading. (Tatsuo Ishii)

  • Fix watchdog communication race condition. (Tatsuo Ishii)

    When watchdog notifies the new message to main process while main process is executing the process notified by watchdog process, there was a significant delay before the new message was processing. Discussion: [pgpool-hackers: 3900]

  • Fix watchdog node status not updating after rebooting. ( bug 684 ) (Muhammad Usama)

A.17.3. Documents

  • Doc: add more explanation about backend_application_name . (Tatsuo Ishii)

  • Doc: fix documentation typos. (Bo Peng)

  • Doc: fix typo in in memory query cache document. (Tatsuo Ishii)

  • Doc: fix wd_life_point description (Masaya Kawamoto)

A.17.4. Test tools

  • Fix pgpool_setup to generate portable follow_primary.sh . (Tatsuo Ishii)

  • Fix rsync parameter in pgpool_setup . (Tatsuo Ishii)

  • Fix pgpool_setup in creating base backup script. (Tatsuo Ishii)

  • Enhance watchdog_setup script. (Tatsuo Ishii)

    shutdownall script generated by watchdog_setup caused failover event which is not necessary in the whole shutdown sequence.

A.17.5. Regression tests

  • Fix 075.detach_primary_left_down_node. (Tatsuo Ishii)

  • Fix 031.connection_life_time. (Tatsuo Ishii)

  • Fix 018.detach_primary error in the log. (Tatsuo Ishii)

  • Fix occasional failure of 028.watchdog_enable_consensus_with_half_votes test. (Tatsuo Ishii)

  • Fix occasional regression test 018.detach_primary error. (Tatsuo Ishii)