Thu Aug 17 07:46:05 2017 UTC ()
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.


(fhajny)
diff -r1.3 -r1.4 pkgsrc/databases/pgpool2/Makefile
diff -r1.2 -r1.3 pkgsrc/databases/pgpool2/distinfo
diff -r1.2 -r1.3 pkgsrc/databases/pgpool2/patches/patch-configure
diff -r1.1 -r1.2 pkgsrc/databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample

cvs diff -r1.3 -r1.4 pkgsrc/databases/pgpool2/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/pgpool2/Makefile 2016/11/24 12:52:47 1.3
+++ pkgsrc/databases/pgpool2/Makefile 2017/08/17 07:46:05 1.4
@@ -1,17 +1,17 @@ @@ -1,17 +1,17 @@
1# $NetBSD: Makefile,v 1.3 2016/11/24 12:52:47 fhajny Exp $ 1# $NetBSD: Makefile,v 1.4 2017/08/17 07:46:05 fhajny Exp $
2# 2#
3 3
4DISTNAME= pgpool-II-3.6.0 4DISTNAME= pgpool-II-3.6.5
5PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME:S/pgpool-II/pgpool2/} 5PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME:S/pgpool-II/pgpool2/}
6CATEGORIES= databases 6CATEGORIES= databases
7MASTER_SITES= http://www.pgpool.net/mediawiki/images/ 7MASTER_SITES= http://www.pgpool.net/mediawiki/images/
8 8
9MAINTAINER= filip@joyent.com 9MAINTAINER= filip@joyent.com
10HOMEPAGE= http://www.pgpool.net/mediawiki/ 10HOMEPAGE= http://www.pgpool.net/mediawiki/
11COMMENT= Middleware between PostgreSQL servers and a PostgreSQL database client 11COMMENT= Middleware between PostgreSQL servers and a PostgreSQL database client
12LICENSE= modified-bsd 12LICENSE= modified-bsd
13 13
14DEPENDS+= postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server 14DEPENDS+= postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server
15 15
16GNU_CONFIGURE= yes 16GNU_CONFIGURE= yes
17USE_LIBTOOL= yes 17USE_LIBTOOL= yes

cvs diff -r1.2 -r1.3 pkgsrc/databases/pgpool2/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/pgpool2/distinfo 2016/11/24 12:52:47 1.2
+++ pkgsrc/databases/pgpool2/distinfo 2017/08/17 07:46:05 1.3
@@ -1,10 +1,10 @@ @@ -1,10 +1,10 @@
1$NetBSD: distinfo,v 1.2 2016/11/24 12:52:47 fhajny Exp $ 1$NetBSD: distinfo,v 1.3 2017/08/17 07:46:05 fhajny Exp $
2 2
3SHA1 (pgpool-II-3.6.0.tar.gz) = 50606dda740846b814ffa3571a243b619e2515ab 3SHA1 (pgpool-II-3.6.5.tar.gz) = 573e5f80691330632ed23648a24c502221175a31
4RMD160 (pgpool-II-3.6.0.tar.gz) = 7576b2a212c9d0ff5f9ad0534b2a697f111cca45 4RMD160 (pgpool-II-3.6.5.tar.gz) = 83b2e8f86bcb7b3fceb57ed6ef485181b43325f9
5SHA512 (pgpool-II-3.6.0.tar.gz) = 2d44331c509e6672ae86ed51b1d32ba6b367c03bbc5cf28776d6a0c2a80cae5ce3c1f0a323b391e163e5753eb97acae56aa0c1ebb964aa26f94b388d0d84acb1 5SHA512 (pgpool-II-3.6.5.tar.gz) = 12247730f202859c76b0a11ccc485de786e53df7b8e08ffd76d7653c25633d79387f027e7c9d804bf19cd89b9db047b7ca0cf1cf5e914ee74c6efc0b6660eb1d
6Size (pgpool-II-3.6.0.tar.gz) = 2511790 bytes 6Size (pgpool-II-3.6.5.tar.gz) = 2651330 bytes
7SHA1 (patch-configure) = 8fb3a30fade036b82171ee9a57e02c915f27909d 7SHA1 (patch-configure) = ed04280cf2c02f5491aa20d3478f026a92885f19
8SHA1 (patch-src_include_pool.h) = 74409384d735695d44466468833088959753d9d2 8SHA1 (patch-src_include_pool.h) = 74409384d735695d44466468833088959753d9d2
9SHA1 (patch-src_sample_pgpool.conf.sample) = db3f6e280d3b02dd6c5abab9aba087ce30acbaa5 9SHA1 (patch-src_sample_pgpool.conf.sample) = 43f9e481ba3630984c165c609d2aac3d4bbf7c18
10SHA1 (patch-src_watchdog_wd__escalation.c) = 63ac5ea3f8853eb953707e79f351ae1eea3a8b25 10SHA1 (patch-src_watchdog_wd__escalation.c) = 63ac5ea3f8853eb953707e79f351ae1eea3a8b25

cvs diff -r1.2 -r1.3 pkgsrc/databases/pgpool2/patches/patch-configure (expand / switch to unified diff)

--- pkgsrc/databases/pgpool2/patches/patch-configure 2016/11/24 12:52:47 1.2
+++ pkgsrc/databases/pgpool2/patches/patch-configure 2017/08/17 07:46:05 1.3
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1$NetBSD: patch-configure,v 1.2 2016/11/24 12:52:47 fhajny Exp $ 1$NetBSD: patch-configure,v 1.3 2017/08/17 07:46:05 fhajny Exp $
2 2
3Pick a better name for the package. 3Pick a better name for the package.
4 4
5--- configure.orig 2016-02-10 08:53:31.000000000 +0000 5--- configure.orig 2017-07-10 08:56:18.000000000 +0000
6+++ configure 6+++ configure
7@@ -3979,7 +3979,7 @@ fi 7@@ -3999,7 +3999,7 @@ fi
8  8
9  9
10 # Define the identity of the package. 10 # Define the identity of the package.
11- PACKAGE='pgpool-II' 11- PACKAGE='pgpool-II'
12+ PACKAGE='pgpool2' 12+ PACKAGE='pgpool2'
13 VERSION='3.6.0' 13 VERSION='3.6.5'
14  14
15  15

cvs diff -r1.1 -r1.2 pkgsrc/databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample (expand / switch to unified diff)

--- pkgsrc/databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample 2016/03/11 21:30:55 1.1
+++ pkgsrc/databases/pgpool2/patches/patch-src_sample_pgpool.conf.sample 2017/08/17 07:46:05 1.2
@@ -1,28 +1,31 @@ @@ -1,28 +1,31 @@
1$NetBSD: patch-src_sample_pgpool.conf.sample,v 1.1 2016/03/11 21:30:55 fhajny Exp $ 1$NetBSD: patch-src_sample_pgpool.conf.sample,v 1.2 2017/08/17 07:46:05 fhajny Exp $
2 2
3Default pid file location. 3Default pid file location.
4 4
5--- src/sample/pgpool.conf.sample.orig 2015-04-08 07:58:44.000000000 +0000 5--- src/sample/pgpool.conf.sample.orig 2017-07-10 08:56:18.000000000 +0000
6+++ src/sample/pgpool.conf.sample 6+++ src/sample/pgpool.conf.sample
7@@ -211,10 +211,10 @@ debug_level = 0 7@@ -210,13 +210,13 @@ syslog_ident = 'pgpool'
8 # FILE LOCATIONS 8 # FILE LOCATIONS
9 #------------------------------------------------------------------------------ 9 #------------------------------------------------------------------------------
10  10
11-pid_file_name = '/var/run/pgpool/pgpool.pid' 11-pid_file_name = '/var/run/pgpool/pgpool.pid'
12+pid_file_name = '@PGPOOL_PIDDIR@/pgpool.pid' 12+pid_file_name = '@PGPOOL_PIDDIR@/pgpool.pid'
13 # PID file name 13 # PID file name
 14 # Can be specified as relative to the"
 15 # location of pgpool.conf file or
 16 # as an absolute path
14 # (change requires restart) 17 # (change requires restart)
15-logdir = '/var/log/pgpool' 18-logdir = '/var/log/pgpool'
16+logdir = '@PGPOOL_LOGDIR@' 19+logdir = '@PGPOOL_LOGDIR@'
17 # Directory of pgPool status file 20 # Directory of pgPool status file
18 # (change requires restart) 21 # (change requires restart)
19  22
20@@ -682,7 +682,7 @@ memqcache_cache_block_size = 1048576 23@@ -709,7 +709,7 @@ memqcache_cache_block_size = 1048576
21 # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'. 24 # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
22 # Defaults to 1MB. 25 # Defaults to 1MB.
23 # (change requires restart) 26 # (change requires restart)
24-memqcache_oiddir = '/var/log/pgpool/oiddir' 27-memqcache_oiddir = '/var/log/pgpool/oiddir'
25+memqcache_oiddir = '@PGPOOL_LOGDIR@/oiddir' 28+memqcache_oiddir = '@PGPOOL_LOGDIR@/oiddir'
26 # Temporary work directory to record table oids 29 # Temporary work directory to record table oids
27 # (change requires restart) 30 # (change requires restart)
28 white_memqcache_table_list = '' 31 white_memqcache_table_list = ''