[pgpool-committers: 3152] pgpool: Minimize the chance of session disconnection while failover

Tatsuo Ishii ishii at postgresql.org
Thu Apr 21 11:03:52 JST 2016


Minimize the chance of session disconnection while failover

In addition to pcp_detach_node case, now in admin shutdown and general
error cases are treated same as pcp_detach_node, except the health
check timeout case (retry over case is treated same as normal error
cases). The health check time case is not tested yet though.

For user's convenience, now "show pool_nodes" command shows the
session local load balance node info since this is important for users
in case of failover. If load balance node is not the failed node, the
session will not be affected by failover.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=9cc243a625ad17632c496bad8eb8a19e243f7385

Modified Files
--------------
doc/pgpool-en.html                                 | 10 ++--
doc/pgpool-ja.html                                 | 10 ++--
src/include/pcp/libpcp_ext.h                       |  1 +
src/include/pool.h                                 |  2 +-
src/main/pgpool_main.c                             | 70 +++++-----------------
src/protocol/pool_connection_pool.c                |  2 +-
src/protocol/pool_process_query.c                  | 29 +++++++--
.../tests/003.failover/create_expected.sql         | 11 ++--
src/test/regression/tests/003.failover/test.sh     |  2 +-
src/utils/pool_process_reporting.c                 | 15 ++++-
src/utils/pool_ssl.c                               |  6 +-
src/utils/pool_stream.c                            | 14 ++---
12 files changed, 83 insertions(+), 89 deletions(-)



More information about the pgpool-committers mailing list