Release 3.7.20

Release Date: 2021-08-05

A.52.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.52.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 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 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.52.3. Documents

  • 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.52.4. Test tools

  • 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.52.5. Regression tests

  • Fix 031.connection_life_time. (Tatsuo Ishii)