A.37. Release 3.7.20

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]

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)

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)

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.

Fix 031.connection_life_time. (Tatsuo Ishii)