pgpool-II 3.4.2, 3.3.6, 3.2.11, 3.1.14, and 3.0.17 released

Pgpool Global Development Group is pleased to announce the availability
of pgpool-II 3.4.2, 3.3.6, 3.2.11, 3.1.14, and 3.0,18. These are the
latest stable minor versions of each major versions of pgpool-II.

You can download them from:
http://pgpool.net/mediawiki/index.php/Downloads

===============================================================================

3.4.2 (tataraboshi) 2015/04/08

* Version 3.4.2

This is a bugfix release against pgpool-II 3.4.1.

__________________________________________________________________

* Bug fixes

- rpm: Fix %tmpfiles_create to not be executed in RHEL/CentOS 6
(Nozomi Anzai)

- Fix to reset on_exit call back functions in exec_if_cmd and exec_ping
worker processes (Muhammad Usama)

exec_if and exec_ping child processes were inheriting the parent exit
callback functions which could result in undesired behavior if one of
these commands fails. Fixed by adding on_exit_reset() at child start-up
in both processes.

- Fix to use void * type for receiving return value of thread function
(Yugo Nagata)

Previously int type was used and this could occur stack buffer
overflow. This caused an infinity loop of ping error at bringing
up or down VIP.

- Fix to set SIGCHLD to SIG_DFL instead of SIG_IGN in watchdog processes
(Yugo Nagata)

When using waitpid, it isn't necessary to set SIGCHLD to SIG_IGN.
Rather, it is harmful, and due to this it was regarded that ping
command exited abnormally in error even when this succeeded.

- Fix to use waitpid instead of wait in exec_ifconifg (Yugo Nagata)

- Remove an unnecessary include directive (Yugo Nagata)

- Enlarge POOLCONFIG_MAXDESCLEN to 80 (Tatsuo Ishii)

This is used in show pool_status command and limits the length of
parameter description. Unfortunately recovery_timeout description is
64 chars, which is 1 byte longer than former definition of the macro.

- doc: Update document of condition for load balancig (Yugo Nagata)

Load balancing is possible in an explicit transaction block
even in replication mode since 3.3.0.

- Support SSL certificate chains in the certificate file for incoming
frontend connections (Muhammad Usama)

- Use to_regclass if available in time stamp rewriting in replication
mode (Tatsuo Ishii)

- Fix to not emits a fatal error message when clear text password auth
is used (Muhammad Usama)

The problem was introduced in pgpool-II after inclusion of exception
manager. EOF on the frontend connection during client authentication
should not be treated as an error when the password authentication
method is used. psql disconnects from the server in such case to get
the password from the terminal, reconnects and sends the read password
to server.

- previous session for the same child had exited because of some ERROR.
(Muhammad Usama)

- Fix a hang when an error occurs in a transaction block with
replication mode (Yugo Nagata)

When an error occurs at a backend node in a transaction block with
replication mode, pgpool-II sends an invalid query to other
backends to sync transaction states. However, previously, this was
not sent to master node, and pgpool-II was waiting for master's
response forever.

- Fix a problem with pcp_detach_node about graceful node detach (Muhammad Usama)

When graceful node detach is requested gracefully, pcp_detach_node should
check if it is allowed to process detach_node command on the particular
node before blocking the incoming connections and closing the existing
connections.

- doc: Update table and flowchart of where a query should be sent to
(Yugo Nagata)

- rpm: pgpool.spec is required only in RHEL/CentOS 7 (Nozomi Anzai)

- Fix a compilation issue about sighandler_t type on BSD variants
(Muhammad Usama)

===============================================================================

3.3.6 (tokakiboshi) 2015/04/08

* Version 3.3.6

This is a bugfix release against pgpool-II 3.3.5.

__________________________________________________________________

* Bug fixes

- rpm: Fix %tmpfiles_create to not be executed in RHEL/CentOS 6
(Nozomi Anzai)

- Fix to use void * type for receiving return value of thread function
(Yugo Nagata)

Previously int type was used and this could occur stack buffer
overflow. This caused an infinity loop of ping error at bringing
up or down VIP.

- Fix to set SIGCHLD to SIG_DFL instead of SIG_IGN in watchdog processes
(Yugo Nagata)

When using waitpid, it isn't necessary to set SIGCHLD to SIG_IGN.
Rather, it is harmful, and due to this it was regarded that ping
command exited abnormally in error even when this succeeded.

- Remove an unnecessary include directive (Yugo Nagata)

- Enlarge POOLCONFIG_MAXDESCLEN to 80 (Tatsuo Ishii)

This is used in show pool_status command and limits the length of
parameter description. Unfortunately recovery_timeout description is
64 chars, which is 1 byte longer than former definition of the macro.

- doc: Update document of condition for load balancig (Yugo Nagata)

Load balancing is possible in an explicit transaction block
even in replication mode since 3.3.0.

- Support SSL certificate chains in the certificate file for incoming
frontend connections (Muhammad Usama)

- Use to_regclass if available in time stamp rewriting in replication
mode (Tatsuo Ishii)

- Fix a hang when an error occurs in a transaction block with
replication mode (Yugo Nagata)

When an error occurs at a backend node in a transaction block with
replication mode, pgpool-II sends an invalid query to other
backends to sync transaction states. However, previously, this was
not sent to master node, and pgpool-II was waiting for master's
response forever.

- Fix a problem with pcp_detach_node about graceful node detach (Muhammad Usama)

When graceful node detach is requested gracefully, pcp_detach_node should
check if it is allowed to process detach_node command on the particular
node before blocking the incoming connections and closing the existing
connections.

- doc: Update table and flowchart of where a query should be sent to
(Yugo Nagata)

- rpm: pgpool.service is required only in RHEL/CentOS 7 (Nozomi Anzai)

===============================================================================

3.2.11 (namameboshi) 2015/04/08

* Version 3.2.11

This is a bugfix release against pgpool-II 3.2.10.

__________________________________________________________________

* Bug fixes

- Fix to use void * type for receiving return value of thread function
(Yugo Nagata)

Previously int type was used and this could occur stack buffer
overflow. This caused an infinity loop of ping error at bringing
up or down VIP.

- Fix to set SIGCHLD to SIG_DFL instead of SIG_IGN in watchdog processes
(Yugo Nagata)

When using waitpid, it isn't necessary to set SIGCHLD to SIG_IGN.
Rather, it is harmful, and due to this it was regarded that ping
command exited abnormally in error even when this succeeded.

- Remove an unnecessary include directive (Yugo Nagata)

- Enlarge POOLCONFIG_MAXDESCLEN to 80 (Tatsuo Ishii)

This is used in show pool_status command and limits the length of
parameter description. Unfortunately recovery_timeout description is
64 chars, which is 1 byte longer than former definition of the macro.

- Support SSL certificate chains in the certificate file for incoming
frontend connections (Muhammad Usama)

- Fix a problem with pcp_detach_node about graceful node detach (Muhammad Usama)

When graceful node detach is requested gracefully, pcp_detach_node should
check if it is allowed to process detach_node command on the particular
node before blocking the incoming connections and closing the existing
connections.

===============================================================================

3.1.14 (hatsuiboshi) 2015/04/08

* Version 3.1.14

This is a bugfix release against pgpool-II 3.1.13.

__________________________________________________________________

* Bug fixes

- Enlarge POOLCONFIG_MAXDESCLEN to 80 (Tatsuo Ishii)

This is used in show pool_status command and limits the length of
parameter description. Unfortunately recovery_timeout description is
64 chars, which is 1 byte longer than former definition of the macro.

- Support SSL certificate chains in the certificate file for incoming
frontend connections (Muhammad Usama)

- Fix a problem with pcp_detach_node about graceful node detach (Muhammad Usama)

When graceful node detach is requested gracefully, pcp_detach_node should
check if it is allowed to process detach_node command on the particular
node before blocking the incoming connections and closing the existing
connections.

===============================================================================

3.0.18 (umiyameboshi) 2015/04/08

* Version 3.0.18

This is a bugfix release against pgpool-II 3.0.17.

__________________________________________________________________

* Bug fixes

- Enlarge POOLCONFIG_MAXDESCLEN to 80 (Tatsuo Ishii)

This is used in show pool_status command and limits the length of
parameter description. Unfortunately recovery_timeout description is
64 chars, which is 1 byte longer than former definition of the macro.

- Support SSL certificate chains in the certificate file for incoming
frontend connections (Muhammad Usama)

- Fix a problem with pcp_detach_node about graceful node detach (Muhammad Usama)

When graceful node detach is requested gracefully, pcp_detach_node should
check if it is allowed to process detach_node command on the particular
node before blocking the incoming connections and closing the existing
connections.

===============================================================================

--
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>