pgpool-II 4.6.0 Documentation
Prev | Up | Appendix A. Release Notes | Next

# A.175. Release 3.5.17

> Release Date: 2018-10-31

## A.175.1. Changes

- Allow `PCP[attach/detach/promote]` commands during failover. (Muhammad Usama)

- Change `pgpool.spec` file to install extension to DB server which supports LLVM JIT. (Bo Peng)

- Test: Add regression test for SSL connection. (Tatsuo Ishii)

- Test: Add definition of PGLIB in `regress.sh`. (Bo Peng)

  Patch provided by Jesper Pedersen.

## A.175.2. Bug fixes

- Fix typo in `child_max_connections` description of `SHOW POOL_STATUS` output. (Tatsuo Ishii)

  Patch provided by Phil Ramirez.

- Fix segmentation fault when error query and Sync message are sent in native replication mode. (bug 434) (Takuma Hoshiai)

  In native replication mode, segmentation fault occurs when Sync messages is sent just after a query error.

- Fix syntax error when queries including time functions and `IN (SELECT ...)` in `WHERE` clause in native replication mode. (bug 433) (Bo Peng)

  In native replication mode, queries including time functions (e.g. `now()`, `CURRENT_TIMESTAMP` etc.) are rewritten to a timestamp constant value. However, Pgpool-II doesn't support queries including time functions and `IN (SELECT ...)` in `WHERE` clause.

- Fix occasional less data returned to frontend with extended protocol. (bug432) (Tatsuo Ishii)

  The idea for fix is, use pending message data list. It records messages from frontend, and it is expected that we will receive same number of messages.

  Initial patch is created by Yugo Nagata and fixed by Tatsuo Ishii.

- Fix memory leak in `trigger_failover_command()`. (Tatsuo Ishii)

- Fix memory leak when query cache enabled in streaming replication mode + extended query case. (Tatsuo Ishii)

- Fix memory leak when memory_cache_enabled = on and write SQLs are sent. (Bo Peng)

  In a explicit transaction, the `SELECT` results are cached in temporary buffer. If a write SQL is sent which modifies the table, the temporary buffer should be reset.

- Fix occasional failure in regression 065.bug152. (Tatsuo Ishii)

- Test: Add `EXECUTE/DEALLOCATE` regression test. (Takuma Hoshiai)

- Add missing `pgpool_recovery--1.0--1.1.sql` file to update `pgpool_recovery()` function version to 1.1. (Bo Peng)

- Fix kind mismatch error when `DEALLOCATE` statement is issued. (Bo Peng)

  `PREPARE` should be add to pool_add_sent_message, so that `EXECUTE` and `DEALLOCATE` can be sent to the same node as `PREPARE`.

  See [pgpool-general: 6226] for more details.

- Do not update pool_passwd if the password length is incorrect. (bug 419) (Takuma Hoshiai, Tatsuo Ishii)

  For Pgpool-II 3.7 or before, the password stored in pool_passwd is `MD5` password only. So check the correctness of pool_passwd by scanning entire file.

- Test: Update `clean.sh` which clean up regression test results. (Bo Peng)

  Patch provided by Jesper Pedersen.

- Add .gitignore files. (Bo Peng)

  Patch provided by Jesper Pedersen.

- Fix segfault when node 0 is in down status in case of both health check and failover_on_backend_error are disabled. (Tatsuo Ishii)

Prev | Home | Next
Release 3.5.18 | Up | Release 3.5.16