[pkgsrc/trunk]: pkgsrc/databases/pgpool2 Update databases/pgpool2 to 3.6.5, b...

[fhajny <fhajny%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/e92a3b1fc68b
branches:  trunk
changeset: 366760:e92a3b1fc68b
user:      fhajny <fhajny%pkgsrc.org@localhost>
date:      Thu Aug 17 07:46:05 2017 +0000

description:
Update databases/pgpool2 to 3.6.5, based on patches by Mustafa Dogan.
Fixes pkg/52488.

Release 3.6.5
- Fix for [pgpool-hackers: 2400] Garbage output
- Importing the latest changes in the MemoryManager API from PostgreSQL
  code.
- Fixing 0000306: Pgpool steals back MASTER status.
- Fixing [pgpool-hackers: 2390]Problems with the relative paths in
  daemon mode
- Adjust function name change in PostgreSQL 10 dev head.
- Fix a posible hang with streaming replication and extended protocol.
- Fix Pgpool-II hang when used by erlang applications.
- Fix bug with sending bind message to wrong target node.
- Fix query cache hang when used by node.js.
- Deal with PostgreSQL 10 in streaming replication delay checking.
- Fix query cache memory leak.
- Fix extended query hang in certain case.
- Fix for [pgpool-hackers: 2354] segfault with pg_md5.
- Fix descriptions of white/black_memcache_table_list.
- Fix corner case bug in Pgpool-II starting up.

Release 3.6.4
- Fixing a few corner cases in the failover request handling of the
  watchdog.
- Tightening up the watchdog cluster membership criteria.
- Enhance document for load balancing.
- Add node 0 failover test.
- Fix Pgpool-II child process segfault reported in [pgpool-hackers:
  2312].

Release 3.6.3
- Fix "show pool_cache" segfault when memcached is used.
- Fix for some more code warnings.
- Fixing some annoying compiler warnings.
- Removing the function defined but not used warnings from
  pool_config_vatiable.c
- Removing the references of obsolete debug_level configuration
  parameter.
- Fixing a mistake in the watchdog code.
- Fix for 0000299: Errors on the reloading of configuration.
- Add pgpool_adm English and Japanese docs.
- Fix document indentation.
- Fix for 0000289: Inconsistent backend state.
- Enhancing the handling of split-brain scenario by the watchdog.
- Enhancing the watchdog internal command mechanism to handle multiple
  concurrent commands.
- Fix compiler warnings.
- Comment out unsupported Java method in new JDBC drivers to prevent
  regression failure.
- Downgrade parse before bind log message to debug1.
- Fix coverity warnings.
- Fix for [pgpool-general: 5396] pam ldap failure.
- Mention that SQL type commands cannot be used in extended query mode.
- Consider SHOW command as kind of a read query.
- Fix memory leak problem caused by commit adcb636.
- Mega patch to fix "kind mismatch" (or derived) errors in streaming
  replication mode.
- Fix for 0000296: PGPool v3.6.2 terminated by systemd because the
  service Type has been set to 'forking'.

Release 3.6.2
- Add "Wants=network.target" to pgpool.service file.
- Fix pcp_promote_node bug that fails promoting node 0.
- Fix document error.
- Pgpool-IIshould not perform ping test after bringing down the VIP.
- Fix to release shared memory segments when Pgpool-IIexits.
- Fix for [pgpool-general: 5315] pg_terminate_backend
- Adding the missing ExecStop and ExecReload commands to the systemd
  service configuration file.
- Fix for 281: "segmentation fault" when execute pcp_attach_node.
- Fix load balancing bug in streaming replication mode.
- Fix yet another kind mismatch error in streaming replication mode.
- Fix do_query()hangs after close message.
- Fixing stack smashing detected.
- Fixing the issue with the watchdog process restart.
- Fix query cache bug reported in pgpool-general-jp:1441.
- Remove elog/ereport calls from signal handlers.
- Fix bug failed to create INET domain socket in FreeBSD if
  listen_addresses = '*'.
- Fix for 0000249: watchdog sometimes fails de-escalation.
- Fix connection_life_time broken by authentication_timeout.
- Fix authentication timeout that can occur right after client
  connecttions.

Release 3.6.1
- Tightening up the watchdog security.
- Add pgpool_adm extension in Pgpool-II RPM.
- Fix occasional segfault when query cache is enabled.
- Fix packet kind does not match error in extended protocol.
- Fix a race condition in a signal handler.
- Fix wrong minimum configuration value for
  client_idle_limit_in_recovery.
- Allow to execute "make xslthtml" under doc.ja.

diffstat:

 databases/pgpool2/Makefile                                    |   4 +-
 databases/pgpool2/distinfo                                    |  14 +++++-----
 databases/pgpool2/patches/patch-configure                     |   8 +++---
 databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample |  11 +++++---
 4 files changed, 20 insertions(+), 17 deletions(-)

diffs (91 lines):

diff -r bce637b7c3c8 -r e92a3b1fc68b databases/pgpool2/Makefile
--- a/databases/pgpool2/Makefile        Thu Aug 17 07:33:39 2017 +0000
+++ b/databases/pgpool2/Makefile        Thu Aug 17 07:46:05 2017 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.3 2016/11/24 12:52:47 fhajny Exp $
+# $NetBSD: Makefile,v 1.4 2017/08/17 07:46:05 fhajny Exp $
 #
 
-DISTNAME=      pgpool-II-3.6.0
+DISTNAME=      pgpool-II-3.6.5
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME:S/pgpool-II/pgpool2/}
 CATEGORIES=    databases
 MASTER_SITES=  http://www.pgpool.net/mediawiki/images/
diff -r bce637b7c3c8 -r e92a3b1fc68b databases/pgpool2/distinfo
--- a/databases/pgpool2/distinfo        Thu Aug 17 07:33:39 2017 +0000
+++ b/databases/pgpool2/distinfo        Thu Aug 17 07:46:05 2017 +0000
@@ -1,10 +1,10 @@
-$NetBSD: distinfo,v 1.2 2016/11/24 12:52:47 fhajny Exp $
+$NetBSD: distinfo,v 1.3 2017/08/17 07:46:05 fhajny Exp $
 
-SHA1 (pgpool-II-3.6.0.tar.gz) = 50606dda740846b814ffa3571a243b619e2515ab
-RMD160 (pgpool-II-3.6.0.tar.gz) = 7576b2a212c9d0ff5f9ad0534b2a697f111cca45
-SHA512 (pgpool-II-3.6.0.tar.gz) = 2d44331c509e6672ae86ed51b1d32ba6b367c03bbc5cf28776d6a0c2a80cae5ce3c1f0a323b391e163e5753eb97acae56aa0c1ebb964aa26f94b388d0d84acb1
-Size (pgpool-II-3.6.0.tar.gz) = 2511790 bytes
-SHA1 (patch-configure) = 8fb3a30fade036b82171ee9a57e02c915f27909d
+SHA1 (pgpool-II-3.6.5.tar.gz) = 573e5f80691330632ed23648a24c502221175a31
+RMD160 (pgpool-II-3.6.5.tar.gz) = 83b2e8f86bcb7b3fceb57ed6ef485181b43325f9
+SHA512 (pgpool-II-3.6.5.tar.gz) = 12247730f202859c76b0a11ccc485de786e53df7b8e08ffd76d7653c25633d79387f027e7c9d804bf19cd89b9db047b7ca0cf1cf5e914ee74c6efc0b6660eb1d
+Size (pgpool-II-3.6.5.tar.gz) = 2651330 bytes
+SHA1 (patch-configure) = ed04280cf2c02f5491aa20d3478f026a92885f19
 SHA1 (patch-src_include_pool.h) = 74409384d735695d44466468833088959753d9d2
-SHA1 (patch-src_sample_pgpool.conf.sample) = db3f6e280d3b02dd6c5abab9aba087ce30acbaa5
+SHA1 (patch-src_sample_pgpool.conf.sample) = 43f9e481ba3630984c165c609d2aac3d4bbf7c18
 SHA1 (patch-src_watchdog_wd__escalation.c) = 63ac5ea3f8853eb953707e79f351ae1eea3a8b25
diff -r bce637b7c3c8 -r e92a3b1fc68b databases/pgpool2/patches/patch-configure
--- a/databases/pgpool2/patches/patch-configure Thu Aug 17 07:33:39 2017 +0000
+++ b/databases/pgpool2/patches/patch-configure Thu Aug 17 07:46:05 2017 +0000
@@ -1,15 +1,15 @@
-$NetBSD: patch-configure,v 1.2 2016/11/24 12:52:47 fhajny Exp $
+$NetBSD: patch-configure,v 1.3 2017/08/17 07:46:05 fhajny Exp $
 
 Pick a better name for the package.
 
---- configure.orig     2016-02-10 08:53:31.000000000 +0000
+--- configure.orig     2017-07-10 08:56:18.000000000 +0000
 +++ configure
-@@ -3979,7 +3979,7 @@ fi
+@@ -3999,7 +3999,7 @@ fi
  
  
  # Define the identity of the package.
 - PACKAGE='pgpool-II'
 + PACKAGE='pgpool2'
-  VERSION='3.6.0'
+  VERSION='3.6.5'
  
  
diff -r bce637b7c3c8 -r e92a3b1fc68b databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample
--- a/databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample     Thu Aug 17 07:33:39 2017 +0000
+++ b/databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample     Thu Aug 17 07:46:05 2017 +0000
@@ -1,23 +1,26 @@
-$NetBSD: patch-src_sample_pgpool.conf.sample,v 1.1 2016/03/11 21:30:55 fhajny Exp $
+$NetBSD: patch-src_sample_pgpool.conf.sample,v 1.2 2017/08/17 07:46:05 fhajny Exp $
 
 Default pid file location.
 
---- src/sample/pgpool.conf.sample.orig 2015-04-08 07:58:44.000000000 +0000
+--- src/sample/pgpool.conf.sample.orig 2017-07-10 08:56:18.000000000 +0000
 +++ src/sample/pgpool.conf.sample
-@@ -211,10 +211,10 @@ debug_level = 0
+@@ -210,13 +210,13 @@ syslog_ident = 'pgpool'
  # FILE LOCATIONS
  #------------------------------------------------------------------------------
  
 -pid_file_name = '/var/run/pgpool/pgpool.pid'
 +pid_file_name = '@PGPOOL_PIDDIR@/pgpool.pid'
                                     # PID file name
+                                    # Can be specified as relative to the"
+                                    # location of pgpool.conf file or
+                                    # as an absolute path
                                     # (change requires restart)
 -logdir = '/var/log/pgpool'
 +logdir = '@PGPOOL_LOGDIR@'
                                     # Directory of pgPool status file
                                     # (change requires restart)
  
-@@ -682,7 +682,7 @@ memqcache_cache_block_size = 1048576
+@@ -709,7 +709,7 @@ memqcache_cache_block_size = 1048576
                                                                   # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
                                                                   # Defaults to 1MB.
                                     # (change requires restart)